Abdelrahman Elshorbagy
Sugar Land,USA
Summary
Ambitious Planning Manager with 7+ years leading organizational planning functions in support of overall business strategy and goal achievement. Knowledgeable industry veteran with background analyzing report data, controlling inventory and forecasting. Innovative with history crafting new strategies for planning process and tactics to boost sales.
Overview
7
7
years of professional experience
Work History
Demand Planning Manager
L’Occitane
12.2020 - 03.2024
- Effectively predicted and met sales revenue and product mix goals for prominent skincare brands, totaling $55 million, while maintaining demand key performance indicators (KPIs) with forecast accuracy of within +/- 5%
- Implemented S&OP (Sales and Operations Planning) process throughout Middle East region, aiming to systematically anticipate risks, capitalize on opportunities, and address discrepancies compared to financial objectives
- Proficiently supervised team of nine individuals to manage end-to-end supply chain tasks, including Demand and Supply Planning, Customer Service, Order Management, and Registration
- Led design and implementation for newly introduced ERP system slim4
- Introduced initiative to implement demand planning workflows by utilizing blend of Advanced Excel (Automation), Oracle BI, Power BI, and Slim4
- Revolutionized time-consuming tasks by automating daily repetitive work on excel
- Oversaw replenishment of over 3000 SKUs to 58 stores spanning across 6 countries
- Facilitated monthly business reviews with Travel Retail and B2B commercial teams to establish new strategies for future expansion plans
- Guided monthly business operation planning sessions aimed at generating 18-month rolling unbiased forecast for over 3000 SKUs.
Demand Planner
Coty, Inc.
06.2017 - 11.2020
- Accurately projected and met sales revenue and product mix goals for significant perfume brands, amounting to $240 million, while achieving demand KPIs with forecast accuracy within +/- 5%
- Serving as Single Point of Contact (SPOC) for S&OP leadership, responsible for preparing monthly presentations for General Management and Global connections
- Led transformation from traditional S&OP to enhanced S&OP+ model, collaborating with MFT (Multi-Functional Teams) to achieve operational excellence in supply chain
- Directed Forecasting and Replenishment Automation project within broader KSA Go-To-Market Change Program, which involved transitioning sales strategy from distribution channels to direct sales
- Developed comprehensive Innovation Tracker (IT) to assess performance of new innovations, providing valuable input for monthly updates on connections and forecasts
- Took charge of holistic collaboration with commercial team and distributors to implement strategies, with aim of achieving P&L objectives and maximizing Net Revenue
- Headed monthly operational planning sessions to produce 18-month rolling unbiased forecast for over 2000 SKUs
- Achieved year-over-year decrease of 4% in Excess & Obsolete inventory.
Education
M.S in Chemical Engineering -
Texas A&M University
Qatar12.2017
B.S in Mechanical Engineering -
United Arab Emirates University
Abu Dhabi06.2016
Skills
- MS Office (Advanced, Power BI, ERP Systems (JDA,SAP), Slim4
- Forecasting Accuracy, Demand Analysis, Sales and operations planning, Demand forecasting
- Excellent Communication, Inventory analysis, Team Collaboration, Time Management
- Analytical Skills, Teamwork and Collaboration, Task Prioritization, Problem-solving abilities
- Self Motivation, Continuous Improvement, Decision-Making, Multitasking
Residency Status
US Citizen
Timeline
Demand Planning Manager
L’Occitane
12.2020 - 03.2024
Demand Planner
Coty, Inc.
06.2017 - 11.2020
M.S in Chemical Engineering -
Texas A&M University
B.S in Mechanical Engineering -
United Arab Emirates University
Similar Profiles
Luna KhalifehLuna Khalifeh
beauty Advisor at L’Occitanebeauty Advisor at L’Occitane
Mehwish KhanMehwish Khan
Skincare Sales and Eduction Specialist at L’OccitaneSkincare Sales and Eduction Specialist at L’Occitane
Hung My Tien TranHung My Tien Tran
Assistant Store Manager at L’Occitane En ProvenceAssistant Store Manager at L’Occitane En Provence