AVIJIT MANDAL

Experience

• 

  TrueAdvantage Software & Development Centre Pvt. Ltd.

  Aug 2005 - Nov 2007

  Content Specialist

  1) Generating Smart Triggers/Smart News2) QC and Uploading of Produced Triggers3) Maintaining Various Reports Related to Team4) Interacting with Software Team for developing Tools5) Creating Small Excel Templates using formulas to automate the process6) Coding Simple Macro in Access using Visual Basic to automate the process7) Working with other teams, like sending request to Build New Company or make any changes in Company Profile to Intelliquest Team (involved in Building and maintaining Company Database)8) Testing the Import Tool used for uploading Triggers, whenever there is a change in format or addition of features and detects Bugs9) Data Analysis for improvement in Input Received and Improvement or changes in product delivery Show less

• 

  Emptoris Technologies (I) Private Limited

  Jan 2008 - Jun 2012

  Senior Consultant - Spend Data Management

  1. Responsible for hands-on execution of one or more project and daily communication with Lead and/or Spend Data Consultant and/or Engagement Manager.2. Keep track of execution in terms of KPIs, Time and Project Status.3. Work with Operations Lead, Tech Team, Spend Data Consultants and Program Manger for New Projects, custom requests, change request, customer queries management.4. Train and develop backup and support resources for all the assigned projects.5. Improve Refresh process and reduce cycle time.6. Resolve issues. Forecast technical feasibilities/infeasibilities and do the needful.7. Work on data enrichment as required.8. Work as a mentor and guide for other junior team members and help in their executions. Show less

• 

  IBM

  Jul 2012 - now

  BTDP1) Team Lead for the Run team for Supply Chain Area2) Handle Incident, Problem and Change Management3) Ensure Data Freshness and Quality by implementing Monitoring and Data Quality Checks4) Data preparation and Transformation in BigQuery for PowerBI5) Mentor Junior team members Project - Catalyst1) Gather data requirement from Kibana developer2) Identify Data source in Catalyst PostgreSQL database and create required views3) Create Logstash pipeline to read and push data to Elasticsearch and deploy to IBM cloud K8 using GIT operations4) Maintain, track and handle all Kibana related views/Logstash pipelines and Data Quality issue using JIRA5) Develop Logstash Pipelines for Data Ingestion Project AIOPS - Data Quality1) Data Quality & Governance using IA & IGC2) Develop Business Glossary – Category, Term, Business Policy3) UAT with clients on the Analytical Solution4) Debug and RCA of Data Issue using Data lineage in IGC5) POT using File Beat to read logs, parse and extract required relevant information6) Worked on Data Redaction and Anonymization using Elastic Ingest Pipelines DemandTec Price Optimization - Team Lead1) Auditing, Analysing, Refining & Mapping Client data as per Platform data requirements2) Write Shell/Python script to fill gap between source input and Application needs3) Manage & Distribute tickets in Parature/Salesforce4) Resolve all Data loading issues Emptoris Spend Data Analytics - Technical Solution Expert1) Project Migration from legacy SQL/PLSQL process to DataStage ETL2) Contribute to Emptoris Product Spend Analyser development3) Assist in implementation of new feature and functionality in Spend Delivery4) Handling Data Centre Operations and Server Housekeeping5) Automation & Tool development to fill gaps in process and reduce manual operations

  • Team Lead - Run Team

    Jan 2023 - now

  • Data Engineer - ELK Developer

    Jan 2020 - Dec 2022

  • Data Quality Analyst

    Jan 2018 - Dec 2019

  • Data Integration Lead

    Dec 2016 - Dec 2018

  • Technical Solution Expert - Spend Analytics

    Jul 2012 - Dec 2016