Summary
Overview
Work History
Education
Skills
Timeline
Generic

ROHAN PATELL

Orlando,USA

Summary

Possesses versatile skills in project management, problem-solving, and collaboration. Brings fresh perspective and strong commitment to quality and success. Recognized for adaptability and proactive approach in delivering effective solutions.

Overview

4
4
years of professional experience

Work History

Senior Strategic Planning Analyst

CHEP USA
08.2023 - Current
  • Achieved an average quarterly forecast accuracy of above 90% for 10,000 individual customer locations and the overall territorial forecasts using market intelligence from sales and data from PowerBI reports flowing in from SAP, Salesforce and the Nielsen platform.
  • Utilised algorithms in JDA to maintain and improve forecasts by tuning parameters to better account for execution challenges and sudden changes in consumption patterns due to weather or other economic circumstances.
  • Increased the efficiency of communication from the team to external stakeholders by becoming a subject matter expert on automation, PowerBI tools and creating automated reports to increase collaboration and data visibility without adding clicks for analysts.
  • Ensured a smooth and efficient medium-long term plan to help finance recognise the risk in their budget assumptions for the fiscal year by closely working with the execution and sales teams to maintain a sales funnel recognising possible wins and losses of volume and how that will impact service as well as developing a tool that can provide actionable forecasting insights using Nielsen market performance data using Python and PowerBI.

Data Analytics Intern

06.2022 - 08.2022
  • Designed and deployed a SharePoint environment, improving team data-sharing efficiency and security by 20%.
  • Authored detailed documentation for Microsoft Visual Studio data packages, reducing onboarding time for new hires by 30%.
  • Conducted forecast accuracy analysis using Python, improving precision by 10% on JDA and SAP datasets.
  • Created a PowerBI dashboard to flag out-of-bound forecast values, increasing demand planning team efficiency by 15%.

Regional Planning Intern

06.2021 - 08.2021
  • Improved visibility and reduced inefficient movement of pallets within the supply chain network for 300 stakeholders in 4 departments by developing and automating 5 reports using Python and PowerBI.
  • Led a team of 8 in charge of inventory strategy, distribution, chargebacks, and strategic guidance for “Multi-coloured Pallet” mapping using SQL and SAP in 4,364 Walmart and 645 Sam’s locations in the United States.
  • Increased client CES scores by 15% through enhanced reporting with Excel Macros and Tableau, optimizing plant capacity utilization.

Education

Bachelor of Science (BS) - Industrial Engineering

Purdue University
08.2023

Skills

  • Microsoft Excel proficiency

  • Problem-solving abilities

  • Trend analysis

  • Quantitative skills

  • Strategic thinking

  • Data analytics

  • PowerBI

  • SAP

  • SQL

  • Power Automate

  • JDA

  • Salesforce

  • Demand and Supply planning

  • Communication and presentation

Timeline

Senior Strategic Planning Analyst

CHEP USA
08.2023 - Current

Data Analytics Intern

06.2022 - 08.2022

Regional Planning Intern

06.2021 - 08.2021

Bachelor of Science (BS) - Industrial Engineering

Purdue University

Similar Profiles

CREATE PROFILE
ROHAN PATELL