Shubham Kathuria

• Worked with business intelligence software and various reports to glean insights into trends and prospects.
• Integrated multiple sources of disparate data into cohesive datasets using ETL processes, improving overall analytic capabilities.
• Done Various Preprocessing tasks using Python.
• Utilized data visualization techniques to present and explain complex data sets.

Projects: -
Defection Correlation and Prediction for Maruti Suzuki:-

•Collaborated with cross-functional teams to gather requirements and deliver actionable insights.
•Designed and implemented ETL processes to extract data from various sources and load it into a data warehouse.
•Built and maintained data infrastructure on AWS platform.
•Developed end-to-end dashboards, from SQL querying Athena tables to data preprocessing in Glue and uploading data to Redshift.
•Utilized SQL for complex data querying and transformation tasks.
•Developed data pipelines using Apache Spark to process large-scale datasets efficiently.
•Created Multiple Glue Scripts for the Preprocessing as well as the Redshift Transfer of data.
•Presented findings and recommendations to stakeholders through intuitive Power BI dashboards.

LSM Dashboard for McKinsey & Company: -

•Collaborated with cross-functional teams to gather requirements and deliver actionable insights.
•Analyzed market trends and competitor data to provide insights for strategic decision-making.
•Created and deployed two dashboards namely Brand Price Architecture and Price Index.