Summary
Overview
Work History
Education
Skills
Certification
Accomplishments
Timeline
Generic

Abhishek Mahajan

New Delhi

Summary

Dynamic Data and Analytics Leader with 11+ years of experience delivering end-to-end analytics, GenAI, and data engineering solutions for Fortune 500 clients, including GM, Microsoft, and PepsiCo. Expertise in building agentic AI systems, ML models, ETL pipelines, and cloud data architectures (Azure, Databricks). Proven leadership in managing global teams (India, US, UK, Mexico), and driving measurable business outcomes.

Overview

13
13
years of professional experience
1
1
Certification

Work History

Project Manager

EXL Analytics
Gurgaon
06.2021 - Current
  • Strong delivery experience in ETL using Python, and in creating direct BIs or multi-dimensional summary layer cubes
  • Led a team of six to build an agentic AI bot that enables customers to view or request the deletion of telemetry data. This pipeline automated 800+ daily ticket resolutions with 99% accuracy
  • Led a team of 7 to build near real-time (15-min SLA) Databricks data products for OnStar, delivering critical assets powering 10 top-management marketing quality reports through optimized Bronze-Silver-Gold pipelines, Azure Blob integration, and automated IBM Sterling email delivery
  • Led a team of 14 to migrate over 120 OnStar subscription reports from Oracle BIS (OLTP) to Hive (OLAP) using PySpark, Oozie, and Cloudera, designing ETL pipelines, incremental loads, and BI layer migration
  • Managed 10+ clients in a span of 48+ months, and I have worked with giants like GM, Microsoft, and Pepsi
  • Created RFPs and delivered client presentations for upsell and cross-sell activities
  • Spearheaded the development of MVPs and POCs to secure new client accounts and drive project acquisition
  • Conducted interviews at top IIMs to drive COE hiring initiatives and talent acquisition within the organization

Data Scientist

Mahindra Automobile
Mumbai
02.2020 - 06.2021
  • Led a team of three to automate third-party file delivery for Mahindra using Databricks pipelines, designing architecture, consolidating source/target metadata, and building triggered, validated pipelines
  • Have been a part of CFO Rajeev Goyal’s team in Mahindra strategy and have worked closely with him on investor presentations
  • Led a team of three to analyze price elasticity and competitor behavior for the Mahindra Scorpio, using regression models to determine the optimal pricing adopted for the base model
  • Led a team of 2 to devise ways through which cannabalization rate can be detected using research principles
  • Created automated Power BI dashboards for the CFO's office, enabling real-time process updates

Associate Project Manager

MAQ Software
Mumbai
03.2019 - 02.2020
  • Built and managed Databricks pipelines for Microsoft to transform event registration and social data into BI-ready multi-dimensional models using a medallion architecture
  • Analyzed IBM SPSS to design an R Shiny-based analytics product for MAQ, creating wireframes and improvement plans to guide developers for market launch
  • Created process workflow automations in Microsoft Power Automate to capture data in real time from D365 applications
  • Led an MVP for PepsiCo, spearheading the migration of 20 Tableau report backends from Oracle to Azure Data Lake.

Senior Software Engineer

Infosys
Chandigarh
08.2012 - 06.2017
  • Migrated ETL pipelines from on-prem to cloud for a large hedge fund, developing Alteryx workflows, validating dependencies, and ensuring data integrity for large-scale consumption
  • Built a Flask-based webapp with Azure SQL and Redis for a London university, developing ETL workflows, cleaning data with R MICE, and delivering Power BI dashboards for visitor tracking

Education

MBA - Finance & Analytics

Indian Institute of Management
Kashipur
01-2019

B.Tech - MAE

Maharaja Agarsen Institute Of Technology
MAIT (GGSIPU)
01-2012

Skills

  • Python programming
  • Machine learning
  • ETL development
  • Project management
  • Power BI development
  • Databricks pipelines
  • Cloud migration
  • Client management
  • Financial modeling
  • PySpark
  • Process automation

Certification

  • Data bricks associate data engineer certification, certified by Data-Bricks
  • DP 900 introduction to Azure by Microsoft
  • Have solved 70+ question on Leet Code regarding python and SQL
  • Six Sigma green belt from Indian statistical institute, Pune

Accomplishments

  • R&R award in 2024 for best creating a general-purpose script for table-level PI identification
  • Received ‘Best Newcomer’ award for successfully migrating 120 report backend tables in 2021

Timeline

Project Manager

EXL Analytics
06.2021 - Current

Data Scientist

Mahindra Automobile
02.2020 - 06.2021

Associate Project Manager

MAQ Software
03.2019 - 02.2020

Senior Software Engineer

Infosys
08.2012 - 06.2017

MBA - Finance & Analytics

Indian Institute of Management

B.Tech - MAE

Maharaja Agarsen Institute Of Technology

Similar Profiles

CREATE PROFILE
Abhishek Mahajan