Worked with various stakeholders to set up AWS Data Analytics Infrastructure for Sector Transformation Group.Extracted data from multiple sources (Big Query, Vault etc.) using APIs, and loaded it into AWS S3 for data transformation processes.Worked with stakeholders to identify and remove waste in processes, and automated reports using AWS Glue + Python, saving 30 hours per month.Analyzed user behavioral data after extracting and loading it from BigQuery to AWS, providing insights into user behavior and optimizing performance metrics.

Nominated(Individual Award) for FY2023 Star Performer Award under Planning FTW/Packs department. (Total of 7 Nominees) Wrote various ETL scripts via KNIME + Python. This saved an estimated 70-100 hours/month. Mapped various processes and determined wastes. Once waste have been determined, Work with various stakeholders to optimize processes and reduce waste.Exploded Bill of Materials using SQL recursive CTES, visualized and analyzed financial impact of raw materials based on certain base casesBuilt various dashboards via Tableau with the agenda of answering Management’s Key Business Questions. (OTP, delays in CRDs, changes in FOB etc.)

Exploded Bill of Materials using recursive CTEs via SQL. visualized and analyzed single part CO2 emission data for Environmental, social, and governance (ESG) reporting requirements and cost optimization purposes.Exploded Bill of Materials using recursive CTEs via SQL, visualized and analysed financial impact of raw materials due to various macroeconomic situations. This project gave the board of directors visibility on the COGS impact on the various products and was used for price adjustment.Worked with various cross functional teams to build dashboard with the agenda of visualizing business continuity processes. This project gave the senior management visibility of the various supply chain functions.Collaborated with IOT engineers to ensure data integrity from various systems. Built flow chart for SOP process flow and visualized potential erroneous data + outliers. Erroneous data was flagged out to the various stakeholdersCollaborated with the Data Analytics Team and HOD to plan the Data Analytics Team's Vision, Mission and Roadmap towards Regional Digital Transformation. Presented Roadmap to Senior Management