Manchen Wang Email & Phone Number

• Advanced proficiency in demand planning software such as SAP APO, Oracle Demantra, and JDA Demand Planning.• Develop BI tools such as Tableau and PowerBI for data visualization and reporting to provide insights into business performance and trends.• Utilized historical sales data, market trends, and Customer insights to develop accurate demand forecasts for a diverse product portfolio.• Analyzed and reviewed KPI to identify trends and outliers for improvement in forecast accuracy and minimize forecast error to increase inventory turns.• Optimize safety stock levels to balance inventory reduction and service level achievement.• Compile and review ABC analysis based on material cost and usage to gauge accurate planning methods to meet departmental goals and plant productivity.• Lead and participate in continuous improvements that impact the materials department through lean and Six Sigma tool usage.• Support the Project Coordinators for engineering-change-notifications (ECN) new part forecasts based on reported estimated-annual-usage (EAU) forecasts.• Review opportunities to rework/repurpose/deviate and re-sale inventory ending its lifecycle.• Automate data extraction, transformation, and loading processes using SQL and UiPath to streamline reporting workflows.

United States

• Scheduling all departments store shipments correctly and efficiently including international orders, .com orders and Amazon orders.• Maintaining inventory level, setting up back orders and reducing waste to optimize customer service.• Creating purchase orders and tracking or pushing factory send over products on time as well as receiving the shipments instantly.• Collaborating closely with marketing team to analyze performance and forecast sales in the following months.• Tracking and monitoring accuracy of third-party shipments through a daily tracking document.• Cooperating cross-functionally with departments such as Sales, Finance, and IT to drive accurate forecasts to accomplish production, inventory, and sales targets.• Resolving shipping issues for Sales Support such as re-direct, address changes, lost or delayed product, shipping quotes and transit times for shipments to dealers.• Communicating with warehouse on incoming questions such as inventory issues, equipment not working, changing shipping on orders, tracking numbers, etc.• Evaluating potential tools, reporting and processes to enhance the planning function and develop and measure supply chain related Key Performance Indicators.• Reviewing inventory levels and warehouse capacity, initiating and coordinating necessary product movements to prevent out of stocks and out of date issues as well as overstock/warehouse capacity issues.

1414 Round Table Dr

• Worked closely with Sales and Customer Service team to balance order volume.• Managed and performed cycle count warehouse inventory and fixed the inventory discrepancies based on the daily cycle count results.• Analyzed inventory discrepancies issues related to damaged, defective or mis-shipment to customers and performed necessary inventory reconciliation and prepared proper documentation for management approval. • Monitored warehouse management system, utilized system to optimize floor space and safety stock level.• Worked with Planning, Customer Service team to ensure the availability of the product.• Participated in sales, production, and supply chain planning process related to setting and driving inventory targets.• Coordinated with outbound delivery team on expected outbound shipments, quality control and inventory accuracy.• Conducted monthly inventory adjustment based on monthly cycle count result.• Generated and updated inventory reports, on time delivery report and daily cycle count report. • Provided Promotion Supportability Report to category managers by analyzing lead time and inventory on hand.

Shanghai City, China

• Established and utilized the most proper statistical models in JDA (AVS-Graves, Fourier, Holt-Winters, Lewandowski, and Moving Average) to create forecasts, safety stocks and respective inventory targets.• Collaborated with Product Planners to ensure timely completion of regional demand for new product launch.• Provided Promotion Supportability Report to category managers by analyzing lead time and inventory on hand.• Collected, analyzed, and updated history start dates to identify unexpected sales and optimize overall forecast.• Audited daily demand suggestions from Material Planning Team to process customer shift and new acquisition. • Conducted root-cause analysis in SQL Developer for supply chain issues, variances, out of stock situations or shortage of supply issues and defined corrective action plans to mitigate the problem and avoid reoccurrence.• Leaded forecast and inventory planning meeting to review recommended sales forecasts and inventory goals.• Provided support in developing seasonal profile for demand forecasts to decrease inventory cost and shortage.• Identified opportunities to meet customer demands during constrained supply to meet anticipated service level.

Shanghai City, China

• Established requirements and standards for suppliers to ensure on time delivery of the agreed quantities.• Developed methods and procedures to assist with Procurement Manager to optimize procuring goods and services, including collaborating with departments to assist when requisitions need additional documentation.• Tracked order acknowledgement, prepared and communicated with Demand Planning Manager about shortage and backlog reports, and provided visibility of potential interruptions by using Pivot Table dashboard.• Monitored the Open PO Report to communicate with Logistic Team for Arrival Accuracy Analysis on a weekly basis and ensured proper documentation from vendors for domestic and international shipments.• Recommended new or revised purchasing procedures in an effort to improve operations, decreased turnaround time and streamlined work processes to provide seamless operations and quality customer service.• Evaluated and improved current processes to develop and maintain a new supplier rating system, establish and implement upgraded workflows as required in regards to sourcing, logistics and returns of product.• Performed reverse logistics specific to returned goods and exception, ensuring proper and timely execution.• Isolated and monitored potential errors, issues, miscommunication, and sub-optimal performance by reviewing monthly inventory reports, and recommend improvement and implement changes based on results of research.