Supply Chain, SAS, SQL, CPIM. Microsoft Excel

YUEJUAN HU

RELOCATABLE Schaumburg, IL 214-***-**** *******.****@*****.***

EXPERIENCE

Great Wall Restaurant Supplier Inc., Elk Grove Village, IL May 2018 – Present

Supply Chain Specialist

Increase route efficiency 85% and avoid costly DOT penalties by tracking and monitoring 22 trucks’ transportation logs to alter routes and improve on system.

Expedite the resolution of all mechanical problems by promptly communicating with trucking services to guarantee timely deliveries.

Ensure product quality and adherence to HACCP requirements by managing day-to-day operations for frozen seafood; perform daily temperature checks in warehouse and trucks.

Successfully lead and monitor $1.25M live lobster international project from start to finish by securing permits/paperwork, allocating resources and facilitating construction process as liaison between Lobster King, Great Wall, and contracted parties.

Streamline international shipping process by classifying shipping details and buying international bond.

Save 33% on sewer system installation through comparative analysis of companies’ service quality and prices.

Richemont North America. Inc. January 2018 – April 2018

Student Supply Chain Consultant

Overhauled shipping operation and increased speed by eliminating non-value-added processes and creating a new system in Excel; calculated dock utilization and lead time, added bumper at the bottleneck, and redesigned warehouse layout.

Expedited package storing and retrieval process by adding maps to delivery carts and optimizing routes.

Reduced employee onboarding time by refining training process for seasonal and temporary workers.

Mombasa Brand, Arlington, TX January 2018 – March 2018

Supply Chain Intern

Boosted sales 70% by redesigning the company website to more effectively showcase and promote overstock items; revamped functions through coding, updated product images.

Reduced waste and maintained economical inventory levels by conducting monthly inventory planning and carrying out strategies in procurement.

Decreased working time 20% by building an Excel template to automate EDI and Peachtree process.

Lessened monthly payments 1.5% in first two weeks by analyzing and audited international purchasing and transportation to catch overcharges.

PROJECT

APICS and Deloitte Case Competition, National Level October 2017 – February 2018

Won prize at state level by increasing inventory turnover more than 75% and reducing delivery shipping window from five days to 0.2 days in case solution.

Reduced total cost 45% after three years by computing revenue and cost estimation under supply chain network scenarios and redesigned the supply chain network.

Generated 20% yearly profit increase for next 10 years by measuring financial and supply chain performance of Mexico Deloitte.

Informs Case competition (Tableau), Texas level, Jan 2017

Decreased cost 21% by analyzing case in qualitative and quantitative ways and improved data visualization.

Launched VMS (Vendor Management System) analysis to solve sourcing problem using Tableau.

SKILLS

VBA SAP SQL SAS Tableau Pivot Table Database E-views CPIM CTL Microsoft Office Suite

EDUCATION

University of Texas, Dallas, TX May 2018

M.S. in Supply Chain Management

Portland State University June 2016

Certification in Business Management

Zhengzhou University, Zhengzhou, China March 2016

B.S. in International Business and Trade

Contact this candidate