Summary
Overview
Work History
Education
Skills
Courses
Timeline
Generic

GAURAV RAJPAL

Mumbai

Summary

A Power BI professional / Data Analytics professional with 8 years of experience in Analytics Consulting. Expertise in designing and developing data driven strategies and solutions using analytical tools like SQL, Python, Power BI to extract actionable insights for business.

Overview

8
8
years of professional experience

Work History

Senior Consultant

Fractal Analytics
09.2024 - 07.2025
  • Designed and developed landing pages for various reports in Power BI using bookmarks, edit interactions and various other features.
  • Utilized Tabular Editor and SQL Server Management Studio (SSMS) to optimize the Power BI semantic model, improving performance and minimizing downtime during deployment.
  • Optimized complex DAX measures to enhance report responsiveness and significantly reduce visual load times, resulting in a smoother end-user experience.
  • Lead a team of 4 members, demonstrating strong leadership and team management skills

Senior Consultant

Ernst & Young
08.2023 - 08.2024
  • Designed and developed a Master Data Table by integrating data from 10+ relational tables.
  • Migrated 15+ Excel-based dashboards to Power BI, leading a team of 2 analysts and ensuring zero downtime, improved scalability, and centralized data access.
  • Automated manual Excel reports using Power BI, reducing operational effort by over 90% and significantly accelerating business processes and reporting cycles.
  • Applied Python (Pandas, NumPy) for data cleansing and transformation, resulting in a 15% improvement in data accuracy and consistency across models and reports.

Senior Associate Analytics Consultant

Axtria – Ingenious Insights
06.2022 - 07.2023
  • Designed and automated the existing SQL code in Python.
  • Implemented drug sales dashboard in Power BI, enabling deep data exploration and increasing data insights utility by 50%.
  • Client management and stakeholder relationship for successful delivery

Senior Associate Analytics Consultant

TheMathCompany
12.2020 - 06.2022
  • Designed and implemented ETL pipeline to extract the data from Amazon Vendor Central.
  • Develop Power BI dashboard to analyze the KPIs for the German Pet Food Industry
  • Performed data processing task for France, Germany, Poland & UK regions

Associate Consultant

Capgemini India Pvt Ltd
04.2017 - 11.2020
  • Served as Oracle DBA, executing daily DBA activities
  • IT performance analysis Dashboard evaluating metrics like nos of issues resolved, pending tickets, SLA breached, and Avg TAT.

Education

B.Tech - Computer Engineering

Mumbai University
Mumbai
01.2016

Skills

  • Python
  • SQL
  • Power BI
  • Excel
  • SSMS
  • Tabular Editor
  • Azure Databricks
  • Power Query
  • Power Pivot
  • Data Analytical Expression (DAX)
  • Apache Superset

Courses

  • Data Analytics – Introduction to SQL
  • Data Analysis with Python – Numpy & Pandas Microsoft Power BI

Timeline

Senior Consultant

Fractal Analytics
09.2024 - 07.2025

Senior Consultant

Ernst & Young
08.2023 - 08.2024

Senior Associate Analytics Consultant

Axtria – Ingenious Insights
06.2022 - 07.2023

Senior Associate Analytics Consultant

TheMathCompany
12.2020 - 06.2022

Associate Consultant

Capgemini India Pvt Ltd
04.2017 - 11.2020

B.Tech - Computer Engineering

Mumbai University
GAURAV RAJPAL