Hanting Jiang
Supply Chain Data Analyst Intern · Byton
VistaWork Experience
Supply Chain Data Analyst Intern
Byton2019 – 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 Future2018 – 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 Americas2018 – 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 College2011 – 2017
Bachelor of Management
Master of Science
University of Southern California, Marshall School of Business2017 – 2018
Master of Science