Summary
Overview
Work History
Education
Skills
Achievements
Others
Timeline
Generic

Mehul Agarwal

Guwahati

Summary

Experienced with conducting comprehensive data analysis to uncover meaningful patterns and trends. Track record of effective communication and collaboration with cross-functional teams to drive data-driven results.

MBA in Business Analytics with 5+ years of total experience in analytics, storytelling and project management for industries including Retail, Manufacturing and BFSI.

Strong technical proficiency in Python, MS Excel, MS Power Platform.

Overview

8
8
years of professional experience

Work History

Freelancer

LA Company
07.2023 - 06.2024
  • Developed custom analytics reports, dashboards using MS Power BI for cash-management, lead-tracking & sales to improve data visibility & security for a B2C business.
  • Developed & built proof-of-concept Regression model using Python libraries for study of Metal Loss during continuous casting process for a Manufacturing client.

Senior Analyst, SC Analytics

Ecolab
04.2021 - 06.2023
  • Led a team of 06 associates driving Analytics Projects across Supply Chain functions accelerating digital transformation journey
  • Developed multiple Python scripts, MS Power BI reports & dashboards, low-code applications catering to business requirements for data modelling, and to improve data access, visibility & security
  • Project: Demand Planning Forecasts - Time Series Forecasting - ARIMA model (Data Science)
  • Technologies: Python - pandas, matplotlib, sci-kit learn
  • Contribution: Data analysis, development of predictive ARIMA model, deployment through FastAPI & Docker
  • Summary: Improved demand forecasts through time-series analysis on historical SKU data for Demand Planners
  • Payoff: A projected ~2% reduction in inventory carrying costs across LATAM; help identify low-performing SKUs
  • Project: Legacy Platform Migration
  • Technologies: MS PowerApps, Azure SQL DB, Azure Data Factory, MS Power BI
  • Contribution: Project architect, development of ADF pipelines, creation of front-end application
  • Summary: Developed end-to-end migration of legacy DB to cloud-based solution with reporting capabilities
  • Payoff: Achieved 2.5x system uptime; reduced downtime by ~108 hours per week, projected annual savings of 40k GBP
  • Project: Stock Reconciliation & Settlement Process
  • Technologies: Python, MS Azure Logic Apps, GraphQL API, MS Power BI
  • Summary: Improved stock reconciliation & settlement process for NA DCs through zero-touch data refresh
  • Payoff: Reduced manual efforts by ~1 FTE
  • Provided mentorship, training sessions for new associates, involved in hiring interviews & initiated cross-team training process

Application Development Analyst

Accenture
11.2016 - 04.2019
  • Worked as an analyst in pricing & promotions team supporting global supply chain team for a North American retailer.
  • Developed multiple Python scripts to automate data scraping from various sources such as web-based ERPs, MS Excel sheets, CSVs, etc.; performed incident analysis & resolution, creation of reports for CXO execs, release management activities, creation of defect documentation & conducting KT sessions for cross-team trainings.

Education

MBA - Business Analytics

Symbiosis Centre For Management & Human Resource Development (SCMHRD), SIU
Pune, India
04-2021

Jadavpur University
Kolkata, India
06-2016

Skills

  • Project Management
  • Python
  • Power BI
  • Machine Learning
  • Azure SQL
  • MS Excel
  • Power Query

Achievements

  • Twice awarded Certificate of Recognition - Ecolab, Pune
  • Awarded Certificate of Recognition - Accenture, Bengaluru
  • National finalist - GAVS Data Challenge, IIT-M
  • 6 Degrees, IIM - Trichy

Others

  • Lean Six Sigma Certification by KPMG
  • Data Science Specialization by IBM on Coursera

Timeline

Freelancer

LA Company
07.2023 - 06.2024

Senior Analyst, SC Analytics

Ecolab
04.2021 - 06.2023

Application Development Analyst

Accenture
11.2016 - 04.2019

MBA - Business Analytics

Symbiosis Centre For Management & Human Resource Development (SCMHRD), SIU

Jadavpur University

Similar Profiles

CREATE PROFILE
Mehul Agarwal