profile-img

Sagy Mohamed Ali-Eldin Shehata Mohamed Ali

Demand & Supply Planner

New Cairo, Cairo, Egypt

Work Experience

  • Supply PlannerFull Time

    Capgemini

    Jan 2023 - Present -2 yrs, 5 months

    Egypt , Cairo

    • Job Details:• Responsible for short, mid and long-term capacity planning. • Developing production schedules based on demand forecasts and capacity constraints. • Coordinating materials and equipment to ensure that production runs smoothly. • Monitoring production progress and adjusting schedules as necessary. • Troubleshooting and resolving any production issues in a timely manner. • Communicating with cross-functional teams to ensure that business goals are met.
  • Supply Chain AnalystFull Time

    Capgemini

    Jun 2022 - Jan 2023 -7 months

    Egypt , Cairo

    • Job Details:• Back-orders causal root analysis on weekly basis to solve any issue related to regional supply chain operations as (material shortage, capacity constraints, master data, logistics, forecast accuracy, etc...). • Build Power Bi dashboard to visualize better the KPIs of supply chain operation teams, and the statues of each SKU within Gulf region. • Initiated the first collaborative forecasting activities with the top modern trade customers in Gulf area like (Carrefour, LULU, Spinneys).
  • Easy Group For Health And Beauty Care

    • Demand & Supply PlannerFull Time

      Sep 2021 - Present -3 yrs, 9 months

      • Job Details:Responsibilities: • Optimizing inventory levels across the supply chain network (DIO) parallel to targeted customer service levels (OTIF%), levels of forecast accuracy (MAPE%). • Responsible for managing the working capital and continuously review the FG and R&P materials stocks and setting the suitable inventory replenishment polices for each SKU. • Translate the forecast generated by the sales department into feasible production plans after aligning with the S&OP. • Following up on production teams on weekly basis monitoring the adherence to plan %. • Long term capacity planning to determine any potential bottlenecks. • Monitoring and evaluating the demand plans according to the historical data and the statistical forecasting. • Generate periodic predictions based on historical information, applying statistical models to the behavior of each SKU in order to ensure the level of detail needed for decision making. • Maintain updated activity overview promotions, marketing plans and launching new products. • Responsible for order management and dispatching plans on daily basis.
    • Supply Chain Planning EngineerPart Time

      Jul 2020 - Sep 2021 -1 yr, 2 months

      Egypt , Alexandria

      • Job Details:• Responsible for translating the monthly forecast into feasible MPS and weekly production plans according to the RCCP. • Following up on the production team on daily basis OPS meeting measuring the adherence to plan % and monitoring the OEE. • Driving the MRP to make sure the availability of the raw and packing materials. • Monitoring FG and R&P materials stocks by assigning the suitable inventory replenishment policy for each SKU. • Long term capacity planning to determine any potential bottlenecks.

    Education

    • B.Sc. Production Engineering in Mechaincal

      Alexandria University (ALEXU)

      Jan 2016 - Jan 2021 - 5 yr

    Achievements

    o Setting inventory policies for each family of the portfolio according to its behavior. o Keeping the cycle service level >95% (OTIF%>98%). o DIO reduction by 33%. o Non-preforming finished goods reduction by 50%. o Fresh stock reduction by 39%

    Skills

    • Inventory Management
    • Demand Planning
    • MRP
    • Production Planning
    • Data Analysis
    • Microsoft Power BI

    Languages

    • Arabic

      Fluent
    • English

      Advanced

    Training & Certifications

    • Micro master Credentials in Supply Chain Management

      MIT·2020
    • The Quest

      Unilever·2017
    Share this Profile