Business Analyst Intern

Weijing Zhang

St. Louis, MO +1-314-***-**** *********@*****.***

EDUCATION

Washington University in St. Louis St. Louis, US Aug 2022 - Dec 2023 (Expected)

Master of Science in Business Analytics (Supply Chain Analytics Track)

Core Courses: Professional Business Communication, Fountains of Supply Chain Management, Machine Learning Tools for Prediction of Business Outcomes (R), Database Design and SQL (SQL), Introduction to Python and Data Science (Python)

Wuhan University of Technology Wuhan, CN Sep 2018 - Jun 2022

Bachelor of Management in Logistics Management

Honors: Second-class Academic Scholarship in AY 2020, Outstanding Student

Core Courses: Database Technology and Application, Purchasing Management, International Logistics, Logistics Simulation, Supply Chain Management, Modeling and Simulation of Logistic System, Logistics Transportation Organization & Management

SKILLS

Tools and Programming: SQL, Python, Excel (Solver, Pivot Table), MATLAB, Tableau, R, C/C++, Java, VFP, WMS System

Machine Learning: Linear Regression, Logistic Regression, K-means, Random Forest, Time Series, Recommendation System

Supply Chain: Operations Optimization, Inventory Management

WORKING EXPERIENCE

Global Logistic Properties Beijing, CN Aug 2021 - Sep 2021

Operations Data Analyst

Collected and cleaned data from the supply chain database in Hive, interacted with 70+ tables to analyze shipment and order status across 20+ distribution centers using SQL

Analyzed data and shared results with supply chain managers and stakeholders to prioritize logistics management plans

Conducted descriptive and diagnostic analysis of warehouse data in the first quarter of 2021, including inventory storage capacity, water usage rate etc. and the space utilization rate improved by 15% within 3 months

Conducted Ad-hoc analysis and data retrieval tasks with advanced Excel, SQL and visualization tool

Shanghai Pharma Keyuan Xinhai Pharmaceutical Wuhan, CN June 2021 - Jul 2021

Supply Chain Analyst Intern

Found the bottle neck and reduced the process lead time by 8% by analyzing inventory and warehouse operations data

Conducted data analysis to identify trends and patterns in supply chain performance

Assisted the development and implementation of a demand forecasting system, resulting in a 15% reduction in excess inventory

Qingdao Ocean & Great Asia Logistics Qingdao, CN Jul 2020 - Aug 2020

Supply Chain Management Intern, Warehouse Management Department

Contributed to the optimization of warehouse operations by analyzing inventory data and forecasting to improve storage efficiency and enhance the accuracy of inventory information

Worked with the manager to manage and optimize the flow of shipping and receiving processes

Collaborated with company planning and supply chain teams to determine accurate inventory balances and receipts to maintain inventory accuracy

ACADEMIC PROJECT

Hiring funnel Analysis for Instacart (A/B Test, MySQL) Jan 2023

Loaded and transformed data from the hiring process of Instacart using MySql for further analysis

Performed sanity check to remove unqualified data from the dataset, calculated CVR and CPA, and used z-test to evaluate the treatment effect

Conducted marketing channel analysis to analyze the relationship between acquisition channels and conversion rate

Gained insights and provided actionable recommendations to test the correlation and causation

Covid 19 Cases Analysis (PySpark, Hive) Sep 2022

Conducted data analysis using Pyspark, MapReduce, and Hive to examine the relationship between COVID-19 infection and influence factors

Used Tableau to create visualizations including box plots, histograms, and line graphs to illustrate the relationships between these factors and COVID-19 rates

Found that poverty, unhealthy mental health, and obesity rates had a positive relationship with COVID-19 infection and death rates, while stay-at-home announcements were effective in reducing death rates

Distribution Route Optimization (genetic algorithm, Python) June 2022

Performed logistics distribution modes analysis and retrieved and cleaned crude oil distribution route data using SQL

Conducted optimization computations to optimize locations coverage and demand while minimizing crude oil shipping costs

Performed exact algorithm and genetic algorithm to achieve the best result in terms of time and space complexity by using Lingo and Python

Contact this candidate