Summary
Overview
Work History
Education
Skills
Project Highlights
Timeline
Generic

Chirag Arora

Ahmedabad

Summary

Analytics professional with over 8 years of experience in global CPG firms such as Kraft Heinz and PepsiCo. Expertise in advanced analytics, predictive modeling, and process automation, leading to optimized operations and significant cost savings. Proficient in Python, SQL, Power BI, and Excel, with a solid foundation in data science and machine learning applications.

Overview

9
9
years of professional experience

Work History

Senior Analyst, Global Supply Chain Finance

Kraft Heinz
11.2023 - Current
  • Designed and deployed a Weighted Average Payment Terms (WAPT) Dashboard in Power BI to track global contract terms and payment behavior, integrating supplier hierarchy, business units, and material categories.
  • Collaborated with procurement to identify negotiation levers using WAPT insights, driving working capital optimization.
  • Created a dynamic simulation tool to assess financial impact of extending supplier terms across categories.
  • Built an anomaly detection script for high-spend transactions.

Associate Manager, Sales & Marketing Analytics

PepsiCo
06.2022 - 11.2023
  • Led NLP-based Sentiment Analysis project for Walmart product reviews using Python (NLTK, TextBlob, WordCloud) and visualized key drivers in Power BI.
  • Built sales forecasting models using time-series (ARIMA, SARIMA) to inform commercial planning.
  • Developed OOS (Out-of-Stock) Forecasting models using Python.
  • Partnered with category and field sales teams to deliver granular regional insights and promotional effectiveness dashboards.

Data Analyst

Accenture (Avanade)
06.2020 - 07.2022
  • Created Power BI dashboards for operational and strategic insights.
  • Developed standard operating procedures to enhance data-driven processes.
  • Regularly communicated analytical insights to senior management.

Data Analyst

Tata Consultancy Services
08.2018 - 05.2020
  • Automated and migrated reporting from SQL-based processes to R.
  • Enhanced ETL processes to streamline data analytics workflows.
  • Collaborated across teams to optimize reporting databases and efficiency.

Associate

Convergys India
05.2016 - 05.2018
  • Supported data preparation and variance analysis for a global consumer goods client.

Education

PGDM - Business Analytics

IMT
Ghaziabad

Skills

  • Python and SQL
  • Data visualization tools
  • Excel and Power BI
  • Predictive modeling techniques
  • Demand forecasting strategies
  • Inventory optimization methods
  • Risk and root cause analysis
  • Statistical regression and classification
  • Time series analysis
  • Clustering algorithms
  • Pandas and Numpy libraries
  • Scikit-learn and SpaCy frameworks
  • Web scraping with BeautifulSoup
  • Data visualization with Matplotlib and Seaborn

Project Highlights

  • WAPT Analytics & Automation, Kraft Heinz, Power BI, Excel, SQL, DAX, Developed an enterprise-level dashboard tracking Weighted Average Payment Terms across commodities, regions, and business units. Integrated terms from contracts and invoice behavior to expose negotiation gaps. Created simulations for 'What-if' term extensions and visualized potential savings.
  • OOS Forecasting & Early Warning System, PepsiCo, Python (Prophet, XGBoost), Power BI, SQL, Trained forecasting models to predict OOS risks by SKU-week using historic fill rates, lead times, and sales velocity. Deployed alerts and trend visuals for proactive replenishment.
  • Sentiment Analysis for Product Reviews, PepsiCo, Python (NLTK, WordCloud, TextBlob), Power BI, Scraped and analyzed thousands of customer reviews from Walmart.com to extract satisfaction trends. Presented findings to brand team to enhance product features and address complaints.

Timeline

Senior Analyst, Global Supply Chain Finance

Kraft Heinz
11.2023 - Current

Associate Manager, Sales & Marketing Analytics

PepsiCo
06.2022 - 11.2023

Data Analyst

Accenture (Avanade)
06.2020 - 07.2022

Data Analyst

Tata Consultancy Services
08.2018 - 05.2020

Associate

Convergys India
05.2016 - 05.2018

PGDM - Business Analytics

IMT

Similar Profiles

CREATE PROFILE
Chirag Arora