Rajat Kumar
Gurugram
Summary
Results-driven Senior Data Analyst with 5+ years of experience delivering financial, operational, and sales analytics across mining, services, and global campaign operations. Microsoft Fabric Analytics Engineer Associate (DP-600) with hands-on expertise in Lakehouse architecture, ELT pipelines, enterprise data modeling, Power BI, DAX, SQL, and Python. Proven team lead with a strong record of automating reporting, improving data quality, and enabling executive decision-making.
Overview
6
6
years of professional experience
Work History
Reporting Analyst
THIESS INDIA PVT LTD
Gurugram, Haryana, India
03.2024 - Current
- Led and mentored a team of 3 data analysts; optimized ELT pipelines in Microsoft Fabric, reducing data integration latency by 40%.
- Partnered with finance and operations stakeholders to define KPIs and standardize enterprise reporting across mining operations.
- Optimized workforce productivity and processes with BI tools, cutting costs by 15%.
Data Performance Analyst
Webhelp India
Gurugram, Haryana, India
08.2022 - 03.2024
- Analyzed global marketing campaign performance using SQL and Power BI dashboards, improving conversion rates by 18% and reducing customer acquisition cost by 22%.
- Streamlined billing analysis (Excel, Python) → 50K+ records, −65% manual effort, +30% accuracy.
- Streamlined reporting pipelines (Power Query, Excel) → −70% cycle time, real-time executive insights.
Data Analyst
Aranya Consultancy
Gurugram, Haryana, India
02.2020 - 07.2022
- Performed inventory optimization using segmentation and Pareto analysis in Excel and SQL, reducing stock redundancy by 25%.
- Built predictive churn models → +12% retention, supporting data-driven strategy.
- Developed interactive Excel dashboards with PivotTables, slicers, and KPIs, improving visibility and cutting manual reporting by 50%.
Education
Master of Science - Computer Science
South Asian University
New Delhi06-2019
Bachelors of Computer Applications - Computer And Information Sciences
Doon University
Dehradun, India07-2017
Skills
- Data & Analytics: SQL (T-SQL, CTEs), DAX, Data Modeling, Data Analysis, ELT/ETL
- BI & Visualization: Microsoft Power BI, Power Pivot, Advanced Excel, KPI Dashboards
- Data Engineering & Platforms: Microsoft Fabric, Lakehouse, Data Pipelines, Dataflows Gen2
- Oracle HCM
- Programming: Python (Pandas, NumPy, Matplotlib)
Accomplishments
Microsoft Fabric Analytics Engineer Associate (DP-600) | Microsoft | Valid: 2025–2026
Languages
English
Hindi
Timeline
Reporting Analyst
THIESS INDIA PVT LTD
03.2024 - Current
Data Performance Analyst
Webhelp India
08.2022 - 03.2024
Data Analyst
Aranya Consultancy
02.2020 - 07.2022
Master of Science - Computer Science
South Asian University
Bachelors of Computer Applications - Computer And Information Sciences
Doon University
Interests
- Badminton
- Table Tennis
- Photography
- Puzzle Solving