Ahmed Abdelbary, Regional Supply And Demand Planner

Ahmed Abdelbary

Regional Supply And Demand Planner

MAGRABi Retail

Location
Egypt
Education
Bachelor's degree, Mechanical Engineering
Experience
4 years, 10 Months

Share My Profile

Block User


Work Experience

Total years of experience :4 years, 10 Months

Regional Supply And Demand Planner at MAGRABi Retail
  • Egypt - Cairo
  • My current job since August 2021

Provide analytical support through analyzing data relating to market trends, vendor and supply management, procurement status
and activities, and other data required to ensure the department and internal customers are well informed.
• Provide Supply planning Analysis, Replenishment on SKU level and confirming their availability and ETA with the vendor.
• Maintain Minimum - Maximum stock level & the Re-order point across countries & stores.
• Own, plan and execute purchasing planning and replenishment process for the relevant category in line with category guidance and agreed policies to ensure best product availability in the stores respecting stock targets agreed.
• Manage the product aspect of marketing activities including launches, relaunches, visibility as well as analysis of performance to ensure relevant activities achieve the intended ROI.
• Manage with the guidance of category teams phasing in and out of products and brands to achieve a fast and smooth transition and maintain stores profile updated.
• Develop reporting structure for relevant area according to prescribed formats and schedules, so that information is provided to enable analysis of the assigned function’s performance and to support senior management decision-making.
• Manage Inventory levels and ensure that the business has a steady flow of stock without overcapitalizing on materials.
• Develop new budget or modify existing budgets to meet changing business needs.

Maintnance Planning and Scheduling Engineer at LafargeHolcim
  • Egypt - Cairo
  • February 2021 to July 2022

Shutdown management for Raw Mill, Pre-Heater, Kiln, Cooler and Filter areas (Planning, Scheduling and Coordination).
• Preparing maintenance planning and scheduling activities required for Preventive, corrective and predictive for the Daily, weekly, Monthly maintenance and overhaul shutdown, including job tasks, durations, manpower and spare parts.
• Coordinate daily as well as weekly planning meetings related with maintenance.
• Plan and create work orders by describing basic job steps in proper sequence and specifying crafts manpower and hours, materials, special tools, and equipment needed for each step.
• Collect drawings, manuals, and other documents to assist contractor and maintenance repairs or modifications.
• Control and Follow-Up Spare Parts Stock Plan starting from purchasing cycle till consumption, Regular follow up for Stock on hand, Over Stock, Under Stock, and Stagnated Stock.
• Inspect and follow up the coming spares to confirm the quality and specification
• Study and support the procurement team to find a local supplier as alternate for the foreign one which will impact the spare parts cost and delivery time.
• Preparing for Turnaround & Shutdowns, planning and scheduling, providing a work package for each task to make sure that all shutdown activities are achieved safely and in the given time, maintain the master shutdown schedule and preparing daily performance progress report, submit Close out report at the end of shutdown.
• Plan and Control Division Annual Budget including outsource needs and spare parts requested starting from Bid Document Preparation till receiving requested demands.
• Provide assistance to for spare parts preparation and PM Lists for new equipment.

Material Requirement Planning (MRP) Engineer at LafargeHolcim
  • Egypt - Cairo
  • January 2020 to January 2021

• Mechanical Engineer in the MRP Project.
• Monitoring and Manage Stock Level.
• Create Purchasing Requisitions for Spare Parts with the Required Quantities.
• Evaluate Technically the Received Offers and Communicate with Suppliers.
• Follow up the Purchasing Orders with Procurement Department.
• Inspection for Delivered Spare Parts.
• Forecasting the Quantity Needed for Consumable Spare Parts in Overhaul and Ensure Availability Before Overhaul.
• Coordinate and Execute Scheduling Activities for Assigned Parts Using ERP (SAP)Systems.
• Act as a Focal Point and Monitor Assigned Areas to Ensure Material Delivery Meet Maintenance Needs.
• Interface with Stakeholders within LCE to Identify and Coordinate the Disposition of Obsolete, Non- Conforming, and
Excess Materials.
• Update SAP Material Master Data and Parameters.
• Optimizing and Reducing the Inventory
• Design and Implement the Preventive Maintenance Routine for Warehouse

Procurement Engineer at 2N Company for Trading and Agencies
  • Egypt - Cairo
  • July 2019 to December 2019

• Receive purchase requests, prepare purchase orders, and send copies to suppliers and to departments originating
requests.
• Review requisition orders in order to verify accuracy, terminology, and specifications.
• Compare prices, specifications, and delivery dates in order to determine the best bid among potential suppliers.
• Contact suppliers in order to schedule and expedite deliveries and to resolve shortages, missed or late deliveries, and
other related problems.
• Research and evaluate suppliers based on prices, quality, services, support, availability, reliability, production and
distribution capabilities, and the supplier's reputation and history and always update the supplier's list.
• Process, verify, maintain, and review computerized or manual records of items purchased, costs, deliveries, product
performance, and inventories.

Education

Bachelor's degree, Mechanical Engineering
  • at The British University In Egypt
  • July 2019

Summary of Academic Projects • Computer Aided Design Project Using SolidWorks (3 Cylinder Car Motor) (2015-2016) • Air Balance System Design and Manufacturing for an Airfoil (2016-2017) • Full Design of a Rolling Mill (2016-2017) • Design and Manufacturing a Thermal Collector for an Educational Purpose (2017-2018) • Product Design for a Waste Sorting Machine Mechanism for Household Waste (2017-2018) • CFD-Analysis on a 2-Dimensional Flow Around an Airfoil Cascade (2018-2019) • Air Conditioning System Full Design for an Emergency Hospital (Cooling load calculations, Chillers Selection, Air handling Units & Fans Coils Selection, Duct Design & Sizing) (2018-2019) • Water Pump Station Design for Residential Area (2018-2019) • Power Plant Design and Load Estimation for Touristic City (2018-2019) • Shell and Tube Heat Exchanger Design and Calculations (2018-2019)

Specialties & Skills

AutoCAD
Microsoft Office
Solidworks
Mini Tab
Microsoft Office
Design Expert
AutoCad
SolidWorks

Social Profiles

Personal Website
Personal Website

URL removed due to policy violation. Please contact support for further information.

Languages

Arabic
Native Speaker
English
Expert
German
Beginner

Training and Certifications

Oil & Gas Industry Operations and Markets (Certificate)
Supply Chain Logistics (Certificate)
Engineering Project Management Specialization (Certificate)
Six Sigma Green Belt Specialization (Certificate)
Global Procurement and Sourcing Specialization (Certificate)
Supply Chain Principles (Certificate)
Fundamentals of Project Planning and Management (Certificate)

Hobbies

  • Soccer
    Big fan for The Big AC Milan.
  • Watching Movies