Sumit Agarwal Email & Phone Number

Led the analysis and organization of diverse data sets on Azure cloud from multiple vendors, employing transformation processes to render meaningful formats. Executed comprehensive CARS (Category Growth, Assortment, Rating & Reviews, Share of Market) analyses spanning AMA (Asia, Middle East, Africa) countries. - Oversaw the intricacies of in-store and inter-store freight calculations, ensuring precision in KPIs and optimizing logistics operations for enhanced efficiency. Calculated Finance KPIs such as Sales Revenue, COGS, Freight costs, ROI, and other critical metrics, thereby contributing to informed decision-making and the optimization of financial performance. - Collaborated with clients to analyze KPIs through Dashboard interpretation and facilitated delivery of project requirements by meticulously planning sprints within an agile methodology-driven team

- Played a pivotal role in requirements gathering and spearheaded sprint planning for the project, ensuring alignment with project goals and timelines. Orchestrated the analysis of data, encompassing both self organization and third-party vendors such as Nielsen. - Directed comprehensive analyses of Revenue, COGS, and profit share at various levels, including product, category, and country/geography, conducting evaluations on a regular basis, be it monthly, quarterly, annually, or as required. - Established effective communication channels with the client through weekly and timely connects, facilitating collaborative discussions to analyze project outcomes, assess work completion status, and plan for the next phases of the project. This approach ensured ongoing alignment with client expectations and allowed for agile adjustments to optimize project outcomes.

Noida, Uttar Pradesh, India

- Work experience as Python Developer creating Timeseries forecasting models to predictthe future patterns of server utilization so that CPU load can beshared beforehand using AWS EC2 service.Tech Stack: Python, SciKit Learn, MatplotLib, NumPy, Power BI, Tableau- Work experience in a Data Analytics role to create and visualize the reports using Power BI for an application hosted on AWS and specially designed to monitor COVID-19 patients.Tech Stack: Python, Power BI, Basics of AWS Cloud- Work experience as DataBase Developer using MySQL and Tableau in the Life-Sciences domain.Tech Stack: MySQL, Tableau

Noida, Uttar Pradesh, India

Worked as Data Analyst for a Pharma client. I was dealing with source data cleaning using SQL and designing the ER Diagram to showcase the relationship among multiple tables.

Washington Dc

BECAM - Brainwaves & Eyeball Controlled Automatic Machine

Bhilai Area, India

- Training on IS/IT Audit and ITIL processes followed byworkshops during machine operations- Gained an understanding of IS/IT protocols followed in the corporate world- Got to know about the SOC reports published (SOC1, SOC2, etc.)

Bangalore

- Worked on developing Autonomous & Semi-Autonomous robots to perform a given task usingPython & Matlab- Used Tableau to visualize graphical view of variousparameters in the resultset

Master Of Business Administration - Mba, Business Analytics, A+

Bachelor Of Technology - Btech, Electrical And Electronics Engineering

Activities and Societies: Former UG President at ENFUSE Club, Leading member at BECAM