Data Analyst Assistant

Yuexi (Elena) Wang

Rochester, NY • 585-***-**** • *************@*****.*** • linkedin.com/in/yuexi-wang-4b8b2a127/ CORE TECHNOLOGIES

• Programming: SQL(5+ yrs), Python(5+ yrs), R(5+ yrs), SAS(3+ yrs), Matlab

• Tools: Tableau(5+ yrs), Git(3+ yrs), PowerBI(2+ yrs), Hadoop, AWS, PHP, Hive

• Methods: Machine Learning, Data Mining, Database Management, Data Visualization, Image Processing EXPERIENCE HIGHLIGHT

University of Rochester IT Department 05/2019-08/2019 Data Visualization (Internship)

• Wrote SQL queries to extract needed data from database; Preprocessed data for visualization and analysis in Tableau.

• Analyzed GPA, SAT scores, and admission data to create US Map and over 20 Tableau dashboards.

• Created world map which shows percent change of admission headcount by years.

• Presented results to staff in a clear and concise manner, enabling them to make data driven decisions. Miami University Advancement Office 05/2016 – 05/2018 Project Assistant

• Extracted and merged 12 databases in SQL; Analyzed trend with Alumni donation data in R.

• Implemented BFast algorithm help reduce time complexity, decreased modeling time from 21 hours to 3 hours.

• Built shiny app includes visualization as well as future alumni donate prediction. Origent 01/2019-05/2019

Data Science

• Trained models in Python: LDA, Random Forest, XGBoost to optimize disease progression rates in ALS over time.

• Designed ensemble algorithms to improve predictive ability for ensemble model and improved R from 0.68 to 0.73.

• Used S3 in AWS to deploy models. Communicated code by Git with Origent staff.

• Implemented Python package containing semi-autonomous functions of metrics to compare model performance. IZP Network Technologies Co., LTD 05/2016-08/2016

Data Analyst (Internship)

• Applied cutting-edge knowledge of qualitative tools (R, Tableau, Alibaba Cloud) to analyze over 11GB of trading data. Compared, and evaluated discrepancies between publicly available data and external tests.

• Developed and tested Tree and Neural Network models to measure averages; improved RMSE by more than 15%.

• Created diverse visualization graphs in Shiny app and presented findings to staff and client. Miami University 05/2016-05/2018

Research Assistant

• Designed new algorithm – “Weighted Ensemble” in R to improve predictive ability and modeling cost.

• Tested Bin-Ensemble method with abalone data from UCI repository and increase accuracy rate from 0.56 to 0.54.

• Designed comparison between new model and existing models (KNN, K-means, Random Forest) on time complexity.

• Employed package: “Binsemble” in R through GitHub. EDUCATION

University of Rochester 07/2018-12/2019

Master of Science in Data Science GPA: 3.8/4.0

Miami University Oxford 08/2014-05/2018

Bachelor of Science in Statistics GPA: 3.7/4.0

CERTIFICATE

Tableau Desktop Certified Associate

Machine Leaning A-Z Hands-on Python & R in Data Science (Udemy) Python for Data Science and Machine Learning Bootcamp (Udemy) The Ultimate Hand-On Hadoop – Tame Your Big Data (Udemy)

Contact this candidate