Sign in

supply chain analyst

Princeton Junction, NJ
November 13, 2018

Contact this candidate



***** ****** *****, **** *******, NJ, **550 216-***-****


**/**** – 08/2018 Logistics Operations Team Specialist

Built loads and deploy trucks between DCs and factories based on warehouse daily capacity report and planners’ recommendations using SAP

Maximized truck load utilization (by pallets and truckload) to optimize transportation costs

Checked daily actionable orders, worked with warehouse and 3PL to solve delay issues

Attended weekly KPI meeting and analyzed root causes for PO delay or inaccurate quantity

Correlated KPIs into easy-to-use databases to drive performance across the network

Consolidated transship and expedite requests to control budget

Developed a validation tracker using VBA Macro in Excel for the Category team to increase SAP system usage, trained team members to use the tracker for their sites 09/2017 – 12/2017 TRAVELCENTERS OF AMERICA LLC Westlake, OH Six Sigma Student Consultant

Led a team of 4 to develop process map for TA-Petro calling center, identified process bottleneck

Investigated call records to categorize different customer requests, drew issue tree of various cases and conducted root-cause analysis, helped build up a standard working process

Developed VBA tools in Excel to analyze hourly, weekly and monthly inbound calling history

Determined significant demand seasonality of inbound calls, suggested allocating labor resource to align capacity with the distribution of demand, which potentially reduce current labor cost by 20%

Determined frequent customers and developed VIP system to simplify call procedure 06/2017 – 08/2017 DELPHI DYNAMICS & PROPULSION SYSTEMS CO., LTD Shanghai, China Purchasing Intern

Compared PO history price in SAP with quotation of suppliers to evaluate their performance

Developed a VBA tool in Excel to categorize price in BOM sheet, reducing 90% of manual work

Drew PIVOT Tables and analyzed data with Vlookup functions in Excel to measure the performance of sub factories, simplifying the evaluation of sub factories’ productivity and revenue

Forecasted demand of powertrain accessories and calculated savings for year 2018 in Excel PROFESSIONAL


Quality Control (Minitab, Value Stream Mapping, Power BI)

Inventory Management and Project Management (SAP, SQL Server, Microsoft Project)

Forecasting (VBA, Microsoft Excel, R Programming, SPSS)

Optimization Modeling and Transportation Modeling (Excel OpenSolver, Arena)

Material/Production Planning (MRP, ERP)

EDUCATION CASE WESTERN RESERVE UNIVERSITY Cleveland, OH 09/2016 – 12/2017 Master of Science in Management, Operations Research & Supply Chain

Six-Sigma Green Belt Certification, GPA 3.8, GMAT 680

Merit-Based Scholarship Recipient, Student Ambassador for admissions

Teaching Assistant of Statistics for Business and Management Science 09/2011 – 06/2015 SOOCHOW UNIVERSITY Suzhou, Jiangsu, China Bachelor of Management, E-Business

Outstanding Graduate, Merit Student and First-class Scholarship Recipient, GPA 3.54

Study Abroad: University of Wisconsin-Madison, WI, Fall 2014 ADDITIONAL Awards

2nd Prize, 8th Soochow University College Student Entrepreneurial Competition 04/2014 Bilingual

English, Mandarin

Contact this candidate