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
Mumbai01.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
Similar Profiles
ONKAR BELGAMWARONKAR BELGAMWAR
Architect at Fractal Analytics, Formerly Neal AnalyticsArchitect at Fractal Analytics, Formerly Neal Analytics
Abhishek Kumar YadavAbhishek Kumar Yadav
Consultant at Fractal AnalyticsConsultant at Fractal Analytics
Bhavesh VarodiaBhavesh Varodia
Cloud Database Engineer at Fractal AnalyticsCloud Database Engineer at Fractal Analytics
Tamanna AgarwalTamanna Agarwal
Consultant Specialist at HSBCConsultant Specialist at HSBC
Bhoomi KumbhaniBhoomi Kumbhani
Clinical Physiotherapist at Umiya Physiotherapy ClinicClinical Physiotherapist at Umiya Physiotherapy Clinic