Yuxuan Li

MS in Business Analytics & Information Management

Aug 2021 - June 2022

Relevant Coursework

• Advanced Business Analytics
• Management of Organizational Data
• Statistical and Machine Learning
• R for Analytics
• Analyzing Unstructured Data
• Data Mining w/SAS Enterprise Miner
• Spreadsheet Modeling and Simulation

BA in Mathematics, Minor in Statistics

Aug 2015 - Aug 2019

Relevant Coursework

• Statistics for Business
• Experimental Design and Analysis
• Regression Modeling and ANOVA in the Health Sciences
• Research Data Management
• Mathematics of Finance I&II
• Introductory to Actuarial Science

Restoration Hardware (RH)

June 2022 - November 2022

Data Analyst

• Extracted and automated external large-volume data to analysis-ready tables into SQL Server and performed data quality checks
• Built and maintained 2 Tableau dashboards to monitor department operational performance and performed Root Cause Analysis on KPI drivers; Presented weekly insights to executives and identified 3 cost-down opportunities with 1 resulted in 9% saving
• Developed ad-hoc reportings/visualizations based on project needs and provided consultancy on troubleshooting SQL queries
• Developed custom data models & algorithms in Python to process PO-level data at scale and led data investigations on order delivery patterns by conducting descriptive and statistical analysis
• Initiated a predictive model using Python with 93% accuracy to estimate and audit monthly freight payments, resulting in 15x increased scalability and saved $54K from third party invoice overbilling
• Created automation for common reporting workflows using Power Automate, Python and SQL Agent to reduce manual works

Restoration Hardware (RH)

January 2022 - May 2022

Data Scientist Intern

• Collected and translated clients’ business strategy into technical solutions and assisted in Agile project management in Notion
• Led team of 5 to conduct data cleaning and hypothesis testings in R and EDA in Tableau to visualize data trends and outliers
• Predicted annual product shipping demand by building and validating Time Series models (ARIMA, Auto ARIMA, Holt-Winter’s) in R and saved ocean freight spot-market costs of ~$320K
• Launched automated user-interactive RShiny web app to enable clients to modify input data and business constraints and get simulated model forecast results in 1 click

Purdue University - Mursix Corp. Database Implement & Production Lead Time Analysis

Septempber 2021 - December 2021

Data Analyst Student Consultant

• Developed complex SQLite queries in Plex to mine manufacturing data, integrate, and wrangle raw data into MySQL
• Designed Entity Relational Diagram of 17 tables and conducted database normalization to 3rd normal form to resolve anomalies; Assisted in the processes of database implementation and team members training
• Analyzed production process and late delivery trends using Excel & R and delivered advised on production process improvement

Trasen Science & Technology Corp., Ltd. (Largest medical IT company in south China)

June 2020 - July 2021

Business Analyst

• Performed extensive market research on leading players in the global medical IT industry, and conducted a comparative analysis using a spreadsheet to help the company shape its 5-year strategic business development plan
• Partnered with Project Management Center to develop dashboards in Tableau and Excel to visualize and monitor KPIs of 60+ projects such as project on-time delivery rate and payment collection rate
• Facilitated Pre-IPO due diligence process of 6 investment institutions by gathering due diligence checklists and coordinating cross-function partners to provide documents and create data reports, including sales reports and account payable schedules

Languages and Databases

Frameworks

Tools