Summary
Overview
Work History
Education
Skills
Websites
Projects
Timeline
Generic
MANOJ KHATUA

MANOJ KHATUA

Lead Data Analyst
Kolkata

Summary

Senior Data Analyst with 10+ years of experience in data analytics, BI development, ETL testing, and workflow automation across retail, logistics, and BFSI domains. Currently driving supply chain and replenishment reporting for Albertsons, building Power BI and Google BigQuery solutions for exception management, out-of-stock and excess inventory analysis, and AI-ready data modeling using GCP Vertex AI, Ontology, and Knowledge Graph. Skilled across Power BI, DAX, SQL, Azure Synapse, Azure Databricks, BigQuery, and Microsoft Fabric, with a consistent record of reducing reporting time by 50%, cutting infrastructure costs by 40%, and automating over 1,000 paginated reports daily. Passionate about turning complex datasets into actionable insights that drive business growth and strategic decision-making.

Overview

12
12
years of professional experience

Work History

Lead Data Analyst

UST
Kolkata
04.2025 - Current

Client - Albertsons

  • Designed and delivered Power BI reports and dashboards to support supply chain visibility, inventory replenishment, and warehouse operations.
  • Built and optimized SQL and DAX queries for complex business metrics across large-scale retail datasets.
  • Leveraged Azure Databricks and Google BigQuery for data transformation, pipeline support, and report-ready data modelling.
  • Collaborated with business stakeholders to translate operational requirements into actionable BI solutions.
  • Prepared data for Agent development using GCP Vertex AI, Ontology and Knowledge Graph based on master Power BI semantic model.
  • Created standardized datasets to reduce report count and infrastructure cost by 40%.
  • Built the Morning Exception Out-of-Stock and Excess Inventory Analysis, delivering actionable insights for buyers and reducing manual efforts by 50%.
  • Working with Albertsons (retail domain) as part of the Supply Chain, Replenishment & Warehousing Reporting team, engaged via UST

Senior Data Analyst

TestingXperts
Noida
04.2023 - 04.2025

Client - Vaultex UK

  • Performed data validation and ETL pipeline logic validation across Azure Synapse data flows, ensuring accurate integration and loading of source data into the data warehouse.
  • Validated Power BI reports and datasets against source systems to ensure data accuracy, completeness, and alignment with business requirements.
  • Migrated SSRS reports to Power BI Paginated Reports, creating 50+ reports and publishing to Power BI Service for scheduled distribution.
  • Contributed to the design of Azure Synapse ETL pipeline processes to efficiently integrate and load source data into the data warehouse.
  • Automated Power BI paginated report distribution using Logic Apps and Power Automate, reducing manual effort and improving operational efficiency.
  • Implemented row-level security to ensure compliance and protect sensitive customer data.
  • Leading cash management company in the UK, engaged via TestingXperts

Senior Data Analyst

TestingXperts
Noida
10.2020 - 03.2023

Client - FarEye

  • Developed and deployed interactive dashboards using Power BI, SQL, and Excel, focusing on critical logistics metrics like Pickup, Delivery, and Last Mile driver performance to drive visibility and informed decision-making.
  • Created customized dashboard visualizations to meet varying customer requirements, improving KPI insights and driving operational efficiency.
  • Analyzed large datasets to uncover trends and provide actionable insights, enabling data-driven decisions and supporting process optimization.
  • Streamlined ETL processes boosting data accuracy and significantly reducing manual efforts.
  • Intelligent Delivery Management Platform, engaged via TestingXperts

Senior Software Engineer

Tech Mahindra
Chandigarh
11.2014 - 09.2020

Client - AT&T

  • Led ETL and data warehouse testing using Informatica, SQL Server, and Oracle, while developing and validating Power BI reports for accurate and efficient reporting.
  • Leading Telecommunications Company in the USA, engaged via Tech Mahindra

Education

B.Tech - Computer Science

Jalpaiguri Government Engineering College
01.2014

Skills

  • Power BI
  • DAX
  • SSRS
  • SSAS
  • SQL Server
  • MySQL
  • Power Query
  • Azure Synapse
  • ETL
  • Python
  • Advanced Excel
  • Microsoft Fabric
  • Azure Logic Apps
  • Power Automate
  • Data Modeling
  • Paginated Reports
  • Google BigQuery
  • Azure Databricks
  • DB2
  • Gemini
  • Vertex AI

Projects

  • Lead Data Analyst, Albertsons, 2025-04-01, Kolkata, West Bengal, India, Working with Albertsons (retail domain) as part of the Supply Chain, Replenishment & Warehousing Reporting team, engaged via UST, Designed and delivered Power BI reports and dashboards to support supply chain visibility, inventory replenishment, and warehouse operations., Built and optimized SQL and DAX queries for complex business metrics across large-scale retail datasets., Leveraged Azure Databricks and Google BigQuery for data transformation, pipeline support, and report-ready data modelling., Collaborated with business stakeholders to translate operational requirements into actionable BI solutions., Prepared data for Agent development using GCP Vertex AI, Ontology and Knowledge Graph based on master Power BI semantic model., Created standardized datasets to reduce report count and infrastructure cost by 40%., Built the Morning Exception Out-of-Stock and Excess Inventory Analysis, delivering actionable insights for buyers and reducing manual efforts by 50%.
  • Senior Data Analyst, Vaultex, 2023-04-01, Noida, Uttar Pradesh, India, Leading cash management company in the UK, engaged via TestingXperts, Performed data validation and ETL pipeline logic validation across Azure Synapse data flows, ensuring accurate integration and loading of source data into the data warehouse., Validated Power BI reports and datasets against source systems to ensure data accuracy, completeness, and alignment with business requirements., Migrated SSRS reports to Power BI Paginated Reports, creating 50+ reports and publishing to Power BI Service for scheduled distribution., Contributed to the design of Azure Synapse ETL pipeline processes to efficiently integrate and load source data into the data warehouse., Automated Power BI paginated report distribution using Logic Apps and Power Automate, reducing manual effort and improving operational efficiency., Implemented row-level security to ensure compliance and protect sensitive customer data.
  • Senior Data Analyst, FarEye, 2020-10-01, 2023-03-31, Noida, Uttar Pradesh, India, Intelligent Delivery Management Platform, engaged via TestingXperts, Developed and deployed interactive dashboards using Power BI, SQL, and Excel, focusing on critical logistics metrics like Pickup, Delivery, and Last Mile driver performance to drive visibility and informed decision-making., Created customized dashboard visualizations to meet varying customer requirements, improving KPI insights and driving operational efficiency., Analyzed large datasets to uncover trends and provide actionable insights, enabling data-driven decisions and supporting process optimization., Streamlined ETL processes boosting data accuracy and significantly reducing manual efforts.
  • Senior Software Engineer, AT&T, 2014-11-01, 2020-09-30, Chandigarh, Chandigarh, India, Leading Telecommunications Company in the USA, engaged via Tech Mahindra, Led ETL and data warehouse testing using Informatica, SQL Server, and Oracle, while developing and validating Power BI reports for accurate and efficient reporting.

Timeline

Lead Data Analyst

UST
04.2025 - Current

Senior Data Analyst

TestingXperts
04.2023 - 04.2025

Senior Data Analyst

TestingXperts
10.2020 - 03.2023

Senior Software Engineer

Tech Mahindra
11.2014 - 09.2020

B.Tech - Computer Science

Jalpaiguri Government Engineering College
MANOJ KHATUALead Data Analyst