Kulwant Rathi
Technical Lead – Data Engineering & Analytics
Gurgaon
Summary
Data Engineering and Analytics professional with 7+ years of experience building scalable data platforms, automated ETL pipelines, and analytics systems supporting product and business decision-making. Experienced in designing high-performance data architectures processing 100M+ records per pipeline and managing 500GB+ monthly datasets per client. Proven record of delivering automation, enabling self-service analytics, and translating complex business problems into scalable data solutions.
Overview
8
8
years of professional experience
Work History
Technical Lead – Data Engineering & Analytics
Ernst & Young
09.2021 - Current
- Architected scalable data pipelines processing over 100 million records per workflow, integrating internal and external datasets to power analytics, reporting, and operational decision-making.
- Designed and deployed automated ETL pipelines using Alteryx and Azure, improving operational efficiency by 5× and increasing data processing speed by 3×.
- Built analytics utilities and reusable data frameworks, enabling self-service analytics across global audit teams and clients.
- Developed standardized datasets and curated data models, powering enterprise dashboards used by audit clients worldwide.
- Managed large-scale datasets (~500 GB per client per month) supporting financial analytics, reporting automation, and operational insights.
- Led a team of five data engineers and analytics specialists, delivering automation and scalable data infrastructure solutions.
- Partnered with business, finance, and audit stakeholders to convert complex analytical questions into data products and decision-support systems.
- Delivered automation solutions that eliminated manual data preparation and reporting for global audit clients, significantly improving reporting reliability and turnaround time.
Senior Data Engineer – Data Engineering & Analytic
Ernst & Young
09.2021 - 03.2022
- Built automated data workflows supporting product launches and operational analytics initiatives.
- Reduced execution time of recurring analytics workflows by 8× through pipeline automation and workflow optimization.
- Replaced manual data preparation processes with scalable ETL pipelines, saving approximately 100 analyst hours per quarter.
- Improved data accuracy and reporting reliability through standardized data validation and transformation frameworks.
Senior Analytics & Reporting Analyst
EXL Service
03.2020 - 09.2021
- Designed and maintained 10+ business intelligence dashboards enabling leadership teams to monitor operational KPIs and performance metrics.
- Built reporting datasets and analytical models supporting data-driven decision-making across sales, marketing, finance, and HR.
- Conducted exploratory analysis and trend modeling to identify key business drivers and performance insights.
Data Executive – Analytics
Cognizant Technologies Solutions
07.2018 - 02.2020
- Managed 20+ dashboards and reporting solutions supporting executive decision-making and performance monitoring.
- Analyzed marketing and product datasets to generate actionable insights and performance recommendations.
- Produced recurring performance reports tracking usage metrics, campaign performance, and operational KPIs.
Education
MBA - Executive MBA
Faculty of Management Studies
New Delhi, India 04.2001 -
B.Tech - Computer Science & Engineering
Maharishi Dayanand University
Rohtak, India 04.2001 -
Skills
- Project coordination
- Agile development practices
- Project lifecycle coordination
- Data-driven analysis
- Data Engineering:
ETL Pipelines, Data Modeling, Data Warehousing, Data Architecture
- Analytics & BI:
Power BI, Tableau, Dashboard Development, Data Storytelling - Technologies:
SQL, PL/SQL, Alteryx, Databricks, Azure Data Factory, SSMS, SSRS - Platforms:
Azure Cloud, Data Platforms, Analytics Infrastructure - Operational Excellence:
Six Sigma Process Improvement, Workflow Optimization, Automation
Timeline
Technical Lead – Data Engineering & Analytics
Ernst & Young
09.2021 - Current
Senior Data Engineer – Data Engineering & Analytic
Ernst & Young
09.2021 - 03.2022
Senior Analytics & Reporting Analyst
EXL Service
03.2020 - 09.2021
Data Executive – Analytics
Cognizant Technologies Solutions
07.2018 - 02.2020
MBA - Executive MBA
Faculty of Management Studies
04.2001 -
B.Tech - Computer Science & Engineering
Maharishi Dayanand University
04.2001 -