Sumit Kumar Email & Phone Number

Delhi, India

Gurugram, Haryana, India

Gurugram, Haryana, India

Led data engineering and analytics team at one of the largest hotel chains in India to:-Develop a data warehouse to generate comprehensive business reports from 10 different PMS, POS, finance, and accounting systems for over 100 hotels.-Migrate all systems to the cloud using AWS and create a data lake with over 21,000 tables.-Use Big Data technologies, such as Spark, to process large amounts of data.-Create a fluent pipeline using DMS, Lambda, S3, Glue and Redshift to automate the data processing process.-Develop one view to track the migration status of all the systems.

Worked as consultant with expertise in problem-solving, team coordination, and data-driven decision-making.Worked as a consultant, handling problem requests and coordinating team efforts to:-Leveraged machine learning techniques, specifically the Decision Tree model in Python, to predict customer churn and proactively address customer retention strategies.-Conducted in-depth customer and restaurant-level analysis to unravel customer order patterns and inform targeted marketing campaigns, contributing to enhanced customer retention rates.-Performed comprehensive marketing analysis to evaluate the effectiveness of marketing campaigns, providing valuable insights to guide strategic decision-making.-Developed Python scripts to automate the cleaning and consolidation of files, streamlining data analysis and audit processes.-Prepared insightful monthly reports in PowerPoint and PowerBI, effectively communicating critical findings and driving actionable insights.