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 ocean shipment on 70% of productsMaster material maintenance and update(ePAC)Power Bi dashboards & Excel reporting

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 level based on supply risk and value•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, forecast value-added FVA•Reduce OOS through accurate material planning, optimized scheduling, and improving demand plan accuracy (case fill rate CFR increase from 40% to 90% in 1 year) while minimizing the cost•Reduce obsolete and slow-moving inventory value which resulted from accurate planning and online inventory visibility as well as taking actions in S&OP meetings•Developing several dashboards through Power BI: sales, Inventory control, SCM KPIs dashboards •Developing a dashboard for cost analysis of products as a basis for P&L online calculationMy achievements:-Reduce production cost by 1.8% through production planning optimization-Reducing the value of raw material inventory by half (50%) while increasing sales figures by 25%!-Developing online dashboards through Connecting Power BI to Microsoft CRM database, SQL (Data Warehouse), Excel, and share point as well as OLEDB data sources-Design mega excel for planning functions and make it online using power query and VBA

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● MPS & MRP● Inventory control (service level, safety stock, reorder point)

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 Iran market with an annualvalue of over 10 M $, including NACN, Flocculants … including supply planning and logisticsactivities-Developing an Electric vehicle project in Iran with the government (MIMT, IDRO, DOE,….)-Establishing Lent Parsian Pishro factory in Iran with the Investment of RENA group forproducing high-quality Brake-Pad with domestic knowledge

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 using Ms. Access & Excel (VBA) in accordance with processes for improving productivity.-Contract & Supply Term Negotiation with suppliers -Providing periodical reports (daily, weekly, monthly, annually) & presenting to all organizational levels (managers, directors, VPs, MD)My achievements:-Developing Planning system (by using Ms. Access) for aftermarket services-Establishing an after-market customers prediction planning system-Increasing the fill rate to aftermarket customers from 30% to over 83%-Reducing stock surplus from a 6-month supply to less than 3 months’ supply-Achieving aftermarket sales value to over $90 M (target acheivement120%)

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 consumption data of 2500 items; and developed new planning system.My achievements:-Developing a new prediction & ordering system through establishing a Systematic approach and procedures & centralizing all processes, such as plan, order, delivery in the Planning Dept-ROP strategy for non-routines (considering safety stock for 18.000 items)-MRP for routines (examine prediction methods & implement for 2000 items)-Reducing cost through Long term contracts for routine parts & Shorter delivery time for regular items

Bachelor'S Degree, Industrial Engineering

industrial engineering

Master'S Degree, Engineering/Industrial Management

Industrial management

Education record