Mehran A. Email & Phone Number

Sydney, New South Wales, Australia

Sydney, New South Wales, Australia

Sales forecast & Demand Planning (JDA) resulted in increasing FA from 62% to 81%leading S&OP Meeting Inventory control & Ordering (JDE) resulting in decreasing stock level by 12% and E&O Reduction by 7% (5 projects)Expediting back orders & open transfer orders resulted in increasing service level from 98.5 to 99.8%Logistic planning and converting Air to.

Sydney, New South Wales, Australia

Sales forecast & Demand Planning (SAP APO)leading S&OP Meeting Inventory control & Ordering (SAP ECC)Master material maintenance and update(SAP ECC)Expediting back orders & open transfer ordersPower Bi dashboards & Excel reporting

• Planning functions include Demand Planning, Material Requirement Planning, Master Production Scheduling, Inventory Optimization, and Production/Capacity planning
• Creating & managing Demand Planning based on historical data on R & Python by the implementation of Arima, Holt winter, regression, and other statistical models as well as leading the S&OP procedure
• Creating an optimized replenishment plan for FG through accurate inventory planning of 800 item codes in a total of 2 brands
• Develop an online dashboard on Power BI to calculate SS&ROP for raw materials based on the average and standard deviation of historical data of consumption and lead time. Also, apply Kraljic Matrix adjust the service.
• Price analysis & production cost optimization
• Define and measure KPIs & KRIs, such as inventory turn rate ITR, Total Supply Chain Cost TSCC, out-of-stock OOS, Days of supply/inventory DOI, Overstock & obsolete stock rate, Demand planning/forecast accuracy.

• My achievements:
• Reducing the value of inventory by half (49% Reduction)
• Online inventory control dashboard on Power BI (updatable SS&ROP)
• Applying Kraljic matrix as a basis for adjusting service level Responsibilities
• Demand Planning 12-24 Months Horizon (SOP procedure)
• Sales planning & budgeting

Tehran, Iran

• Keep HQ & customers happy through on time in full supply!
• Contract negotiations with chemical material in Iran such as Price, Payment terms, Legal issues, Delivery schedule, and shipment planning
• Market analysis based on available Korean technologies/parts/material or required raw material
• Develop Technology Transfer projects such as Electric-Vehicle (LG Electronic powertrain on Iranian cars platform) and auto parts/systems.My achievements:-Establishing and Developing Chemical material business in the.

Tehran, Iran

Sapco sales Dep. take care of after-market demands for auto parts. In this regard, -Demand forecasting & Supply chain planning for aftermarket (forecasting future demands based on historical data of sold parts and produced cars figures)-Analyzing data and providing reports for analyzing the sales status and enhancing the sales.-Designing local database by.

As a planner not only did control inventory but also developed a comprehensive prediction system in raja which enabled this company to minimize its safety stock and reduce ordering cost through batch ordering.ABC analysis for categorizing parts and deciding service level based on the value of partsusing Ms. Access & Excel, analyzed inventory and.

Bachelor'S Degree, Industrial Engineering

industrial engineering

Master'S Degree, Engineering/Industrial Management

Industrial management

Education record