MA

Mohammed Abdo

Demand Planner & Supply Chain MENASA · Sharaf DG


In My Own Words

Industrious Supply Chain Executive in a leading retail company across the Middle
East and Egypt with a bachelor's degree of Industrial Engineering from the
American University of Sharjah. My field of expertise relies mainly in
Supply/Demand Planning, vendor management, inventory planning and
management, logistics operations, and retail.

Work Experience

Supply Chain Management Executive

Sharaf DG

2021 – Present

UAE

? Operating the entire Supply Chain planning operations (Demand forecast planning/Inventory management for 2 retail outlets, Ecommerce website and centralized warehouse in Egypt.

? Expert in Excel, BI, SAP, SAP-IBP, OMS, and VYOM. Utilizing these tools frequently to analyze day-wise, department-wise and vendor-wise stores parameters and performances, margins, stocks availability, replenishments, forecast monthly quantity and sales demand to create targets, validate supplier commitment and validate inventory balancing, and month Forecast and sales Comparisons.

? Assortment gap analysis and monthly replenishments planning for POs referred to all storage locations. ? Achieving Monthly reduction of 5% of the total ageing stocks to keep 95% of overall inventory to be under non-ageing slab. This led to cost reduction in our holding cost, maximized our storage capacity, and increased our focus on top selling and fast-moving items.

? Monthly increase of 10% of fill rates and maintained the target to be 90%

? Enhanced products visibility on the online website to 85% by creating a physical area in a storage location separated from the store's stocks and automated the availability if stocks on the website which lead to an increase in our product view and sales.

? Direct Communication with suppliers for new price updates, promotions, stocks availability, and commercial agreements and creating local and consignment POs, closing pending invoices, Price and Promotions updates, margins updates and display, STO, and stocks management in SAP.

Demand Planner & Supply Chain MENASA

American Garden

2022 – Present

UAE.

? Validating and developing effective forecast models for more than 300 SKUS for the "American Garden" brand based on industry trend and demand patterns using Aver-cast Forecasting tool and Demand planning models for MENASA region.

? Enhancing forecast accuracy by analyzing gaps between actual shipments and sales vs forecasted shipments and plan using MAPE error technique to identify key improvement areas.

? Analyzing lead time standards by suppliers vs their Lead time Actuals and identifying any delay reasons and following up to enhance the delivery process.

? Managing and updating the item master file to ensure correct data and reconciling closing stocks for more than 10 distributors to analyze their stocks cover

? Closely monitoring SKU availability, ensuring to maintain below 5% OOS.

? Ensuring placement of orders to be placed in the beginning of each month for each country to avoid any out of stocks and delays cases.

? Maintaining forecast accuracy, define safety stock levels, optimal order quantities to achieve high inventory levels.

? Experienced in MIS tools such as OBIEE and EBS where these tools are helpful to analyze our sales data and pending orders and to provide our stakeholders with Shipped order List, Pending orders list, Price monitoring, orders on water, customer specific order status.

Retail Assistant

Noon E-commerce

2021 – 2021

Supply/demand Planning operations in the fragrance and beauty category, such as creation of POs, delivery slot bookings, and inventory management, ASN creation.

• Utilized SQL/BigQuery to run data and convert barcodes to SKUs.

• Coordinating with fulfilment operations to manage vendors deliveries and stocks

• Reporting suspicious sellers on the portal to ensure healthy buying processes.

Logistics and Supply Chain Intern

Aramex

2020 – 2020

Eliminated Non-value added services in the logistics operations using data and motion study analysis for major clients by using a time and motion analysis by building a value-stream map using Visio to track resources time of tasks completion.

• Suggested new cutting cost methods such as using Cross Docking Process and an automated facility layout to improve Logistics operations.

• Worked in a project called Hands-Free project to help in data assemble using excel pivot tables and customers data.

Data Analyst trainee

ADCB

2019 – 2019

Used different methods of queuing theory and forecasting software to optimize call center performance.

• Developed a simulation model using Arena for the current and optimized state of call center performance.

• Issued a report regarding the scientific and technical methods used to optimize the handling the workload volume the call center agents for my senior design project.

Education

Bachelor of Science

American University of Sharjah

2020

Bachelor of Science