Summary
Overview
Work History
Education
Skills
Accomplishments
Timeline
Generic

Mudit Bhardwaj

Data Analyst
Delhi

Summary

Data Analyst with 5+ years of experience architecting scalable data solutions for high-transaction environments ( 75M+/day ). Expert in SQL optimization, ETL automation (Python), and actionable insights (Power BI/Kibana). Proven success in boosting system efficiency by 45%+ , migrating 10M+ records , and designing real-time dashboards that drive business decisions.

Overview

6
6
years of professional experience
4
4
years of post-secondary education

Work History

Data Analyst

Ecom Express
01.2024 - Current
  • Architected MySQL database for e-commerce platform, reducing data latency by 30% through indexing and normalization
  • Optimized 20+ critical SQL queries, cutting average execution time by 45% and saving $12K/month in compute costs
  • Developed Python ETL pipelines to extract/pre-aggregate 10M+ records from MySQL to MongoDB, accelerating reporting by 6 hours daily
  • Reduced report refresh time by 40% using optimized DAX measures, indexed SQL views, and by minimizing cardinality in model tables and removing unnecessary columns.
  • Automated SQL-to-Power BI pipelines fetching real-time KPIs from multiple data sources.

Associate Consultant (Data Analysis)

Capgemini
10.2021 - 01.2024
  • Redesigned SQL schemas for client applications, improving query performance by 35% and reducing report generation time by 50%
  • Automated data validation via Python scripts, eliminating 15+ hours/week of manual checks
  • Developed dynamic date slicers, and conditional formatting for business ops dashboards.
  • Migrated Excel-based reports to Power BI; implemented reusable dataflows for sales analytics.

SQL Developer (Data Analysis)

Applicate AI
08.2019 - 10.2021
  • Developed ClickHouse SQL schema and Queries for Ambuja Cements sales bot (Dialogflow), processing 1M+ data monthly
  • Delivered real-time sales reports for Marico, reducing insight latency by 60%
  • Built sales analytics dashboards on Kibana for Reckitt and Mars, enabling faster decision-making for stakeholders

Education

B.Tech - Computer Science & Engineering

SRM University
Delhi, NCR
01.2015 - 01.2019

Skills

  • Visualization: Power BI, DAX, Power Query, Looker Studio
  • Languages: SQL, Python (Pandas, NumPy), DAX
  • Databases: MySQL, ClickHouse, SQL Server
  • Tools:JIRA,Git,Excel

Accomplishments

Gladiator Award (Peak Season Performance)
Recognition Award (Scalable DB Architecture)
Customer Delight Award (Database Optimization)
Spot Award (Marico Project)
Rising Developer Award

Timeline

Data Analyst

Ecom Express
01.2024 - Current

Associate Consultant (Data Analysis)

Capgemini
10.2021 - 01.2024

SQL Developer (Data Analysis)

Applicate AI
08.2019 - 10.2021

B.Tech - Computer Science & Engineering

SRM University
01.2015 - 01.2019

Similar Profiles

CREATE PROFILE
Mudit BhardwajData Analyst