Mehran A. Email and Phone Number
A supply chain expert with exceptional ability in the Data Analysis. Skilled in Inventory Optimization, Supply Planning, Demand Planning, Material Requirement Planning, and Business Process Modeling, with an extensive ability in data analysis software, such as Excel, SQL, Power BI, Power Query, Power Automate, Access, Python, and VBA.• Financial reporting and cost optimization (Total Supply chain cost TSCC) • Defining objectives and KPIs.• S&OP• Reporting and Dashboards.• Demand planning, Master Schedule scheduling, and material requirement planning.
Edwards Lifesciences
View- Website:
- edwards.com
- Employees:
- 8955
-
Senior Logistics (Planning) AnalystEdwards Lifesciences Oct 2024 - PresentSydney, New South Wales, Australia -
Senior Supply Chain AnalystEdwards Lifesciences Jan 2024 - Oct 2024Sydney, New South Wales, AustraliaSales 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 -
Demand And Supply Planning AnalystAbbott Jul 2022 - Jan 2024Sydney, New South Wales, AustraliaSales 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 -
Supply Chain Planning ManagerBun Dec 2020 - May 2022•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 -
Supply Chain Planning ManagerEstiri Group Feb 2018 - Dec 2020My 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) -
Supply Chain Lead AssociateLg International Ltd Nov 2014 - Aug 2018Tehran, IranKeep 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 -
Supply Chain PlannerSapco Jun 2008 - Nov 2014Tehran, IranSapco 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%) -
Material Requirment PlannerRaja (Rail Way Company) Jun 2007 - Dec 2008As 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
Mehran A. Education Details
-
Industrial Engineering -
Engineering/Industrial Management -
Behesht
Frequently Asked Questions about Mehran A.
What company does Mehran A. work for?
Mehran A. works for Edwards Lifesciences
What is Mehran A.'s role at the current company?
Mehran A.'s current role is Supply Chain/logistics professional.
What schools did Mehran A. attend?
Mehran A. attended Sharif University Of Technology, Shahid Beheshti University, Behesht.
Who are Mehran A.'s colleagues?
Mehran A.'s colleagues are Mai-Loan Truong, Diego Medina, Mary Okello, Leidy Mariolys Cruz De Los Santos, John Reehill, Vivienne Healy, Fabio Martinez Hernandez.
Not the Mehran A. you were looking for?
-
Mehran A. Yousafzai
Research Student, Southeast University | Founder & President, Unit313 | Civil Engineer | Progressive Collapse Of StructuresNanjing -
-
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial