Ruiyao (Rena) Hong
**** ***** ****** ****** *** *304 • Ontario, CA 91764 • 614-***-**** • **************@*****.*** Highly motivated, result-oriented supply chain professional with experiences in data analytics, transportation, order management, and operations. Currently seeking a position in business/data analyst. SKILLS S
Certified in Production and Inventory Management(CPIM)
Advanced in Access, Tableau, Excel, Logic Net; Proficient in SQL, Minitab, Arena, Python
Clustering analysis, Regression, Linear optimization, Monte Carlo Simulation, Forecasting EDUCATION N
The Ohio State University, Fisher College of Business Columbus, OH Master of Business Logistics Engineering Dec 2015
GPA: 3.71/4; Vice President of MBLE student council
Award: 1st Place Winner-Fourth Annual Fisher Supply Chain Simulation Case Competition
Courses taken: Linear Optimization, Facility Design, Simulation for System Analytics, Project Mgmt., Six Sigma Shanghai University Shanghai, China
Bachelor of Management, Management Science (Financial System Engineering) Jul 2014
GPA: 3.71/4; Merit-based scholarship for two consecutive academic years for achieving top 2% WORK EXPERIENCE E
Niagara Bottling, LLC Ontario, CA
DTS Transportation Analyst (Direct to Store) Oct 2015 – Present
Optimized supply chain network by analyzing production plan, service constraints and transportation cost; Identified cost savings opportunity of over $1 million, and recommended solutions for execution
Managed transportation and order databases including millions of transaction data; Conducted ad-hoc analysis and used various data analytics tools to interpret and visualize the result for executive management
Revamped order management process and removed redundancy of metrics, developed service metrics framework and produced reports including actionable data to improve efficiency; Provided performance root cause analysis and successfully improved on-time delivery by 4%
Elicited and analyzed business requirements into project deliverables, collaborated and provided inputs to IT team on developing business tools/reports/dashboard in IBM Cognos
Engaged as a core member on cross-functional projects: loading vehicle downtime cost impact, customer clustering, inventory safety stock level set up, customer transportation solutions and VMI savings Big Lots Stores, Headquarter Columbus, OH
Global Transportation Intern, Distribution & Transportation Services May 2015 – Aug 2015
Proposed the optimized forecasting methodology in ocean shipping volume forecast, improved LCL& FCL forecasting accuracy by 14%, 10%, collaborated with third party forwarder to implement the plan
Conducted vessel string analysis and scorecard analysis to evaluate 6 ocean carriers’ service performance at origin and destination; Created dashboards for terminal volume and dwell time Stryker Healthcares Products Shanghai, China
Procurement Intern, Indirect Sourcing Mar 2014 – Jun 2014
Analyzed expense cost model in an effort to identify opportunities for contract negotiation and cost saving, estimated potential savings of $0.6 million
Fiat-Chrysler Asia Pacific Shanghai, China
Supply Chain Management Intern May 2013 – Sept 2013
Collaborated closely with senior management on the Order to Delivery team, advising the team on ways to improve their reporting process and delivering efficiency improvements on subsequent reporting work
Served as liaison between the team and seven country markets, responsible for producing and analyzing production achievement, sales, inventory, and order status reports PROJECT T
Intelligrated Mason, OH
AS/RS Simulation Tool Design and Evaluation Sept 2015 – Dec 2015
Built up two simulation model of AS/RS systems in Automod and Arena; Tested fulfillment time and utilization of AS/RS system through different scenarios to discover bottlenecks of the system, improved efficiency by 17% Ascena Retail Group Columbus, OH
Distribution Center Audit Area Design and Simulation Mar 2015 – Apr 2015
Mapped layout and process flow in Visio, designed the area ergonomically
Simulated auditing process in Arena, and advised ways to troubleshot bottlenecks