tableau, rstudio, excel, python, sql, spark

Ziyi Lu

413-***-**** adcmhz@r.postjobfree.com www.linkedin.com/in/ziyi-lu/

EDUCATION

University of Miami Coral Gables, FL

Master of Science in Business Analytics—STEM credentialed. May 2020

• Project: Applied Regression: Analysis of FIFA 19 Player—Cleaned data in R and developed polynomial regression to predict the influential factors for FIFA soccer player; Performed Box-Cox transformation and variable selection to improve the accuracy by 3%; Used Cook’s Distance to eliminate outliers.

• Project: Machine Learning: Major League Baseball Playoff Prediction—Applied SVM, logistic, Random Forest, K-Nearest Neighbors to predict how many Major League Baseball teams will reach the playoffs, ending with KNN model with an error rate of 0.15.

• Project: Shiny App: Visualizing Chicago Parking Tickets—Established and published a shiny app to visualize Chicago parking tickets in RStudio; Analyzed Chicago city economic development and changes historically by creating the bar chart and pie chart using ggplot. Link: https://yiqingbai.shinyapps.io/Chicago_Parking_Tickets/

• Relevant Coursework: Applied Regression Analysis, Data Analytics with R, Data Visualization, Machine Learning for Data Analytics, Marketing Analytics, Supply Chain Mount Holyoke College South Hadley, MA

Bachelor of Arts in Statistics May 2019

• Relevant Coursework: Intro to Data Science, Network Analysis, Mathematical Statistics WORK & LEADERSHIP EXPERIENCE

Baptist Health South Florida Miami, FL

Business Intelligence Intern Feb 2020 – Present

• Maintain data infrastructure environments: big data Hadoop, ETL (Extract Transform Load) & visualization

• Implement predictive analytics algorithms for Hospital Capacity Management

• Apply Tableau to create dashboard to solve hospital call-center absence problem

• Convert and validate the data of hospital encounter volume from Oracle to Hive and rewire the dashboards using Tableau

• Project: Baptist Health Medical Group Ask Data: Automatic dashboard generation in Tableau from a user- entered question—Applied Big Data tool Hive to setup and clean data; Prepared dataset for consistency, clarity and scaling; Optimized query performance in DBeaver using cost analysis and reduced time by 50% Burgundy Fox Boston, MA

Marketing Intern Jun – Aug 2018

• Improved customer email interaction 50% by analyzing email clicking using AB testing in Mailchimp

• Increased Customer base by 300% using Tableau to analyze active customers

• Gained an increase in funds of $10,000 in three months via Angel List and LinkedIn SKILLS, ACTIVITIES & INTERESTS

Technical Skills: RStudio, Excel, SPSS, SQL, Python, Mailchimp, Tableau, MATLAB, Minitab, Prodiver, WorkBench, Hadoop, AWS, ETL, DBeaver

Languages: Fluent in English and Mandarin

Activities: K-pop Dance Cover, Hip-hop, Urban Dance

Contact this candidate