HJ

Hanting Jiang

Supply Chain Data Analyst Intern · Byton

Vista

Work Experience

Supply Chain Data Analyst Intern

Byton

2019 – 2019

Owned SAP HANA and portal to support procure to pay process cross different country entities, managed Quick Base information update and automated BOM cost mapping and ad-hoc reports for VP car program by Python. • Assisted PR creations of 15 car systems, executed PO/GR modifications per business priorities, closed internal SAP change requests and managed SAP master data to support 265 POs for VP program. • Connected database API with Python to establish tracking metrics of 16 critical part attributes, supported GSMs to keep updating metrics of 1648 parts weekly, increasing average fill rate from 30% to 85%. • Applied Python packages to achieve data wrangling and automation for two types of BOM to visualize cost structures and generated time series parts delivery reports by Tableau to push the program schedule.

Purchasing Analyst Intern

Faraday Future

2018 – 2018

Supported chassis team to purchase the parts, ED&T and tooling for FF91 program, operated SAP HANA to make ABC cost analysis of different stage cars, owned parts tracking and vendor management. • Operated SAP HANA to create, modify and manage PO/PR, collected PO payment documents including invoices/GR and communicated with Finance team to map PO list with high priority. • Collected data from SAP HANA to make ABC analysis report for different projects to visualize the cost structure and worked with SAP consulting team to optimize the existing SAP HANA layouts. • Kept tracking 3PL logistics to guarantee purchased parts JIT delivery to hit the project deadline and communicated with 50 plus vendors to collect all necessary documents such as NDA, GTC and PPDA.

Supply Chain Analyst Intern

Bonduelle Fresh Americas

2018 – 2018

Participated in daily demanding planning and scheduling for supply chain operation, conducted supply chain mapping project to optimize the plant operation by Access/SQL and built supply planning models by Excel. • Prepare POS data by Access to execute production control project, covering 17 production lines, to forecast volume trend, to determine reorder point/volume and to optimize inventory and scheduling. • Conducted optimization analysis to reduce the operation constraint CDR by 10%, forged cross-function effort to trade-off and relieve the pressure on scheduling, manufacturing, logistics and warehouse. • Built supply planning model by Excel to visualize the material quantity and shelf life, applicable for more than 50 short-shelf-life raw material to support MPS.

Education

Bachelor of Management

Shanghai Customs College

2011 – 2017

Bachelor of Management

Master of Science

University of Southern California, Marshall School of Business

2017 – 2018

Master of Science