SIYUN (CHARLOTTE) MAO

adikde@r.postjobfree.com 614-***-**** 4734 Hepler Ridge Way, Glen Allen, Virginia 23059 (RELOCATABLE) EXPERIENCE

Evergreen Enterprises, Richmond, Virginia April 2019 – Present Inventory Analyst

• Produce and execute $30M inventory purchasing plan by generating strategic product forecasting and planning with more than 3,000 active items.

• Advance profit potential by conducting product performance analysis to define characteristics of successful products and trace the root cause of poorly performing products; compared historical data to provide suggestions for product development and identification of new potential markets.

• Reduce costs by maintaining inventory turnover rate and safety stock through timely purchasing and inventory replenishment.

• Negotiate price and MOQ with more than 50 suppliers to reduce total cost and participate in cross-functional meetings for new product selection; generate SKU plan for target sales and volume in next year. Mast Global (L brands), Columbus, Ohio August 2018 – December 2018 Student Consultant

• Performed technical analysis for more than 10,000 Skus inventory; creatively ranked velocity of SKU by dividing inventory into groups and establishing a systematic methodology and instructions for long-time usage.

• Improved DC efficiency and shipment forecasting by continuously tracking the accuracy of historical data and summarizing it into daily and weekly report for performance measurement.

• Decreased stock costs by analyzing logistic reflections and planning accuracy with different sales forecasting tools and identifying more than 1,000 aging stock.

• Strengthened decision making by forecasting future velocity of each SKU with more than three statistical methods. Bloom Energy, Newark, Delaware June 2018 – August 2018 Supply Chain Intern

• Saved more than $100K in transportation costs by identifying four main transportation problems; analyzed 2,000+ data points in Expeditor quantitatively and qualitatively and provided solutions to the COO.

• Invested forecasting methods for 83+ lanes separately based on dynamic plan for lean manufacturing.

• Created RFQ system with VBA for yearly quote adding more than eight user-friendly functions including password security, automatic summary, and custom research; ensured administrative authority by utilizing separate Excel modules and preparing detailed instructions.

Decathlon, Shanghai, China March 2017 – July 2017

Supply Chain Production Intern

• Ensured optimal transportation process by determining lead time and quantities of materials for 6+ suppliers and 10+ customers.

• Realized production forecasting and transportation planning through data analysis with SPSS, Access, and Tableau.

• Adjusted production schedule aligned with customer requirements and collaborated with the planning team to pro-actively identify available vendors and constraints of the open capacity for six suppliers’ product lines to develop appropriate actions. Kohler, Shanghai, China December 2016 – February 2017 Supply Chain Intern

• Lessened transportation fees 5% by monitoring and tracking logistic processes including negotiations with suppliers, cooperating with 3PL, and estimating weight and volumes in order to maximize the utility of containers.

• Operated SAP system created 60+ orders corresponding to customers’ requirements and maintained model information in ERP.

• Performed multi-communication with suppliers and customers in 16+ countries and supported in editing the monthly report and performing KPI analysis.

EDUCATION

The Ohio State University, Fisher College of Business, Columbus, OH December 2018 Master of Business Logistics Engineering GPA 3.63/4.0 Shanghai Maritime University, Shanghai, China June 2017 Bachelor of Communication and Transportation GPA 3.51/4.0 PROJECT

DHL Localized Equipment Room Process and Design Project

• Led Project to help company saved $281,000+ labor cost by comparing 10+ possible solutions in Arena stimulation model to generate the most cost efficiency solution, then, created reward and punish system to reduce equipment loss.

• Reduced 50% worker waiting time with new designed equipment room layout in Visio & calculated needs of equipment for each one separately to reduce the stockout risk.

TECHNICAL SKILLS & CERTIFICATIONS

Advanced Excel (VBA, Marco, Pivot Table, VLOOKUP), R, SQL, Prezi, Access, Visio, SAP, Tableau Python, Minitab, Lean Sigma, Photoshop, CPIM, CSCP, PMP

Contact this candidate