Tarek Tarabulsi
Commercial (Demand) Planner · Al Ahram Beverages - Heineken Egypt
CairoIn My Own Words
My name is Tarek Tarabulsi, from Egypt.
I worked for ABC - Heineken Egypt for almost 19 years covering the E2E business and mastering the performance management and development.
I started my career in the Supply Chain technical scope as an Installation Engineer in non-alcoholic Plant moving onto Packaging/Production Engineer then Supervisor, moved on to the alcoholic sector as Logistics Supervisor followed by Industrial Operational Support & Performance Analysts (Responsible for TPM, BCS, PCM, OPI's, Losses, Utilization, Optimization,...etc.).
I made a career shift in 2016 going upstream reaching out to the commercial edge starting by being the Commercial Reporting and Analytics Manager in Sales Support which in turn I embedded the "Data Driven" approach and constructed the 360 degrees reporting system that communicates needed data for concerned decision makers, additionally to Commercial business optimization projects. Nevertheless, I moved on to Demand Planning and Forecasting along with Market Acumens to cover the full S&OP Scope.
I do have a lovely family that I take care of (Wife and 3 kids).
I'm very flexible to relocate and travel frequently
Hope to hear from you soon.
Regards
Work Experience
Commercial (Demand) Planner
Al Ahram Beverages - Heineken Egypt2020 – 2022
Scope of Work: Key player in sales and operations planning (S&OP) process along with other integrated business planning functions in the organization. Converting Quantitative data by mining acumens from field sales force and converting the data into quantitative data for enriching the statistical data forecast (Baseline) and could extend to remodeling and calibrating the statistical model. Job responsibilities: ? Conduct BBMs (Business Building Meeting) with the field sales heads to review their performance vs current plan and collect acumens of existing market dynamics on Bi-Weekly frequency (For the Agility purpose) ? Deep dive into the Market Actual selling Data to analyze and emerge with changes in market trends, mainly due to OOS, Price Change, Touristic Drop, Market Players (Competitors) activities, Market Share change, etc. ? Collaborate with Trade Marketing for implementing any promotional activities and converting them into incremental volume which is reflected into the Demand Plan. ? Reflecting the market changes in FuturMaster (S&OP Core) by enriching the volume baseline with new trends or activities for both Long Term (Monthly) and Short Term (Weekly) ? Distributing the Long term forecasted volume weights by conducting the Weekly coefficient modules. ? Measuring the Short-term forecast accuracy (ST FCST Accuracy) by W-1 and W-4 & FCST Bias ? Measuring the Long-term forecast accuracy (LT FCST Accuracy) by M-1 and M-3 & FCST Bias ? Prepare the Demand Review meeting with stakeholders to sign off the updated demand figures ? Prepare for the S&OP Alignment meeting. ? Conduct SP (Strategic Plan), AP (Annual Plan), 10 Years Plan. ? HeiCore (S&OP) implementation ? Stocks Monitor Report and measuring the Stocks level against Demand and Average MTD Actual Sales for ensuring the availability of stocks and paying attention to safety stocks level. ? Calculating the DOH (Days on Hand) of stock level. ? Distributors Performance Monitoring and Commission Payout ? Sales Team Commission payout reengineering. ? RtM (Rout to Market) & RtC (Rout to Consumer) optimization.
Commercial Reporting and Analytics Manager
Al Ahram Beverages - Heineken Egypt2016 – 2020
Scope of Work: Responsible for all the commercial reporting systems, advanced & Adhoc analysis, Market insights for Domestic and Export Markets versus Competitors as well as strategizing the KPIs – STI’s setting to evaluate the company & the sales team performance in order to the business & to improve the decision making at the senior management level. Job responsibilities: ? Responsible for all commercial reporting systems, responsibility includes identifying new reporting scope. ? Responsible for all Markets insights (4 Domestic Markets + 1 Export Market) for own and competitors. ? Efficiencies and Improvement Projects. ? Analyze results & provide Commercial Dashboards summarizing the respective key findings, market trends, Qualitative & Quantitative Market Insights. ? Provide customized reporting & recommendation in support of ongoing business decisions or initiatives ? Responsible for all global commercial reporting to Heineken Amsterdam. ? Conduct regular meetings with Commercial Management teams to discuss business insights & key findings. ? Lead the Reporting aspect/requirement setting of new commercial systems. ? Strategize the commercial KPIs Setting and evaluating the company’s performance in order to enhance the understanding of the business & to improve the decision making at the Top management level. ? Responsible for Setting Commission Standards and Dynamic Criteria\Parameters change to align market trends ? Responsible for the calculation of the salesforce Execution KPIs in the salesman commission. ? Manage, review & sign-off all the Sales Force & Customers commission payout. ? Market Insights and Analysis