Supply Chain Data Analyst

Fangning (Josh) Xu

Chicago, IL ************@*****.*** 224-***-****

https://www.linkedin.com/in/fangning-josh-xu/

EDUCATION

Wake Forest University-Winston-Salem, NC July 2022-May 2023 MS in Business Analytics GPA: 3.5

Relevant coursework: Data mining, Machine learning, Data management (SQL), Supply Chain SUNY at Binghamton-Binghamton, NC January 2019-May 2022 BS in Economics GPA: 3.5

SKILLS

Technical: Python, R-studio, MySQL, Excel, Tableau, Power BI, SAS, Salesforce Power: Data Visualization, Public speaking

PROFESSIONAL EXPERIENCE

Nationwide Marketing Group - Winston-Salem October 2022-May 2023 Data Analyst (practicum)

• Imported Excel files into MySQL workbench, created a calendar based on MySQL workbench and joined different customer activities

(sell-in, point of sales, and lease to own, etc.) into a single table grouped by month.

• Quantified the engagement of the customers (create an engagement score), and showed the business performance of customers with different scores, then provide recommendations to improve the services provided by NMG

• Calculated customer retention rate and churn rate then built a report to identify in which year customers are most engaged and have the highest retention rate

Deloitte - Shanghai, China April 2020 – May 2020

Business consulting intern

• Designed control factors to calculate the depreciation/impairment of fixed assets (medical equipment) and conduct tests and evaluations for those factors to see if they are reliable for the client (Health 100) with datasets of several hundreds of fixed assets.

• Built a random forest model to see what patient (who got a prescription) types tend to purchase medicine in the Health 100 branches instead of purchasing outside Health 100 branches based on patients’ data.

• Calculated financial ratios for the client, such as income-debt ratio and debt-equity ratio; constructed NPV and future value models for several different projects of the company using functions in Excel such as VLOOKUP and pivot table

• Built the risk-controlling matrices, found the risks, and provided corresponding measures to solve them Aroma International - Chicago, IL October 2023-January 2023 Account Manager

• Managed current customer information, tracked daily orders, and increased total sales by 14%.

• Searched for potential customers, conducted visits, and opened 22 new accounts for the company.

• Maintained the inventory database, and managed products in the system (built unique product ID, assigned lot for each product in the warehouse, tracked the actual amount of all products, etc.).

• Managed the supply chain, determined the sequence of delivery to customers, and optimized the route to minimize delivery time Universal Processing-Chicago, IL September 2023-October 2024 Business Development Associate

• initiated contact with small and medium-sized enterprises (SMEs) and secured business appointments through targeted cold calls, emails, and in-person visits to gather valuable business data and promote tailored products

• Conducted in-depth analysis of clients' credit card processing statements, enabling data-driven pricing adjustments and advising merchants on long-term payment strategies to optimize their operations

• Leveraged Salesforce to enhance the business development process, including client relationship management, potential lead tracking, and business data analysis

PROJECTS

Play Store Apps Data Analysis Using Python & SQL June 2023-July 2023

• Utilized the data collected from Google Play Store, then performed Data wrangling to improve data quality, including data cleaning

(handling null values, unwanted values, etc.), and data mining (creating visualizations as well as statistical plots).

• Built a random forest model to classify the apps, then identify which apps will likely get high ratings.

• Created statistical queries using MySQL to evaluate the performance of different apps, then built a professional report.

Contact this candidate