Saurav Kumar
Gurugram
Summary
Dynamic and results-driven Senior Data Analyst with over 6 years of experience in ETL processes, data analysis, data visualization, and predictive modeling. Adept at leveraging Python, SQL, R, and Tableau to drive insightful data-driven decisions. Skilled in machine learning, statistical analysis, and RPA development, with a commitment to continuous learning and professional growth.
Overview
7
7
years of professional experience
1
1
Certification
Work History
Senior Data Analyst
Deutsche Telekom Digital Labs
Gurugram
2022.03 - Current
- Digitalising the telecom to make the users' experience happier than ever by utilising the cutting edge technologies
- Helped to setup first time modern data ware house Gold Layer, Silver Layer and did the data validation for more than 200 tables
- Built the Tableau Dashboard for top management listing 200+ KPIs from Marketing, Monetisation, Acquisition and Retention to bring data transparency and easy accessibility across 12 countries in Europe
- Performed various campaign and marketing analytics and helped to improve the customer experience and bring higher conversion rate of Greenfield and Brownfield customers
- Analysed customer journey, sharing insights and recommendations, marketing campaign Analytics, building dashboards for the key metrics for Telekom helping to drive the business effectively and helping to grow the business
- Supported key features and launches across 12 countries in Europe like Customer Onboarding, Tariff Change, Acquisition which helped to grow 10 Mn + customers in 3 years and 4Bn+ Revenue through digital app
- Worked with product and development teams to optimise the features and journey in the app to make the customer journey more smoother which helped to achieve a record breaking NPS for the app
- Published monthly digital reports with quarterly roadmaps for central product and data journey with key KPIs and Spotlight of the month with the top management (Reaching more than 400 readers)
- Helped to build Data Analytics team from scratch, supported in recruitment, training and onboarding
- Performed various training sessions for the data tools to the stakeholders.
Reporting and Data Analyst
Optum
Gurugram
2021.06 - 2022.03
- Helped to clean and build structured Data Warehouse, setup the data governance and process for 400+ tables
- Brought Tableau as BI tool to replace the legacy SSRS and helped to migrate the 50+ reports from SSRS to Tableau which are more optimised, better end user experience and attractive
- Led several Automation projects to convert the excel report to Tableau report and prepared data catalogue and SQL queries for operational usage saving 50-60% time of the L1 associates.
Consultant- Application (Data Science, RPA, Web Application)
ArcelorMittal Nippon Steel India
Surat
2021.01 - 2021.05
- Digital Transformation Consultant for application development- Data Science, Reporting, RPA, Web Development and Automation.
Data Scientist
ArcelorMittal Nippon Steel India
Surat
2017.11 - 2020.12
- Led the Tableau Dashboard projects for Costing, Finance, Sales department
- Designed and built the data pipelines, dashboards from scratch for Top Management and CXOs
- Analysed the sales pattern and built advanced forecasting models using MA and ARIMA models
- Helped to analyse and set a better pricing models for different customer cohorts resulting into higher revenue and profit growth
- Delivered 4 ML and Deep Learning based predictive models in the various plants and operations
- Blast Furnace Prediction Model, Steel Melting Plant Energy Optimisation Model, Raw Material and Composite Recommendation Model for desired quality of the output, Silicon Prediction Model for Corex plant
- All these models were very critical and useful and saved millions of dollars by reduction in wastage, optimised use of Energy and Predicting the health of the furnace before the damage could occur.
Data Science Intern
ArcelorMittal Nippon Steel India
Hazira, Surat
2017.06 - 2017.10
Mentor (MBA|BBA)- Distance Center (Surat)
Dayalbagh Educational Institute
Surat Area
2017.08 - 2020.12
- DEI-DEP Surat is the distance program run and organised by Dayalbagh Educational Institute (Deemed University), Agra
- Managing, teaching and guiding MBA students with all streams Finance, HR and Marketing as voluntary service.
Education
Bachelor of Science - Data
Indian Institute of Technology, Madras
2024-09
Master of Business Administration (M.B.A.) - Finance and Financial Management Services
Dayalbagh Educational Institute
01.2017
Bachelor's Degree - Business/Commerce, General
Dayalbagh Educational Institute
01.2015
Diploma in Financial Accounting - Computer Accounting
Alpha Plus Computer Education
01.2012
Skills
- Data Analytics
- Team Management
- Reporting and Dashboards
- Tableau
- SQL
- AWS
- Python
- Machine Learning
- Jira
- Confluence
- Storytelling
- Campaign and Marketing Analytics
- Predictive analysis
- Advanced Excel
- Data Warehousing
- Project Management
- Data Modeling
Certification
- RPA Developer Foundation
- Coursera Certificate: Introduction to Data Science in Python
- SQL Server: Reporting Services
- Foundation of Artificial Intelligence (AI)
- Tableau Desktop Certified Professional Certification
- A/B testing from Udemy
Accomplishments
- Gold Medalist (Senior Secondary Examination) State Level
- Certificate of appreciation by CIO
- 3 times Recipient of "Get Things Done" Reward at Deutsch Telekom
Timeline
Senior Data Analyst
Deutsche Telekom Digital Labs
2022.03 - Current
Reporting and Data Analyst
Optum
2021.06 - 2022.03
Consultant- Application (Data Science, RPA, Web Application)
ArcelorMittal Nippon Steel India
2021.01 - 2021.05
Data Scientist
ArcelorMittal Nippon Steel India
2017.11 - 2020.12
Mentor (MBA|BBA)- Distance Center (Surat)
Dayalbagh Educational Institute
2017.08 - 2020.12
Data Science Intern
ArcelorMittal Nippon Steel India
2017.06 - 2017.10
Bachelor of Science - Data
Indian Institute of Technology, Madras
Master of Business Administration (M.B.A.) - Finance and Financial Management Services
Dayalbagh Educational Institute
Bachelor's Degree - Business/Commerce, General
Dayalbagh Educational Institute
Diploma in Financial Accounting - Computer Accounting
Alpha Plus Computer Education
- RPA Developer Foundation
- Coursera Certificate: Introduction to Data Science in Python
- SQL Server: Reporting Services
- Foundation of Artificial Intelligence (AI)
- Tableau Desktop Certified Professional Certification
- A/B testing from Udemy
Similar Profiles
MAYANK KHANDELWALMAYANK KHANDELWAL
SDET II at Deutsche Telekom Digital Labs(DTDL)SDET II at Deutsche Telekom Digital Labs(DTDL)
Aman MohanAman Mohan
Sr SDET at Deutsche Telekom Digital LabsSr SDET at Deutsche Telekom Digital Labs
Nitesh AgarwalNitesh Agarwal
Senior SDET Engineer at Deutsche Telekom Digital LabsSenior SDET Engineer at Deutsche Telekom Digital Labs