YATING YUAN

315-***-**** https://www.linkedin.com/in/yating-yuan-su/ adg5rc@r.postjobfree.com

SUMMARY

Data professional with 1+ years of proven excellence in developing data analysis solutions using data exploration and showcasing findings in the finest visualizations possible. Actively seeking entry-level Data Scientist/Analyst and willing to relocate.

EDUCATION

Syracuse University, Whitman School of Management, Syracuse, NY Aug 2018-May 2020 Master of Science – Business Analytics GPA: 3.7/4.0 South China Agricultural University, Guangzhou, China Sep 2014-July 2018 Bachelor of Science – Real Estate Development and Management SKILLS

• Software Skills: Python, NumPy, Pandas, Matplotlib, RStudio, Excel VBA, Pivot Table, Tableau, Power BI, MySQL, SPSS, Qualtrics, Access, A/B Testing, Google Analytics, Adobe Photoshop, Adobe Illustrator

• Algorithms: Machine Learning: Regression, Decision Tree, Random Forest, Logistic Regression, SVM

• Language Skills: Fluent in English, Mandarin and Cantonese PROFESSIONAL EXPERIENCE

Institute for Veterans and Military Families, Research Analyst, Syracuse, NY Feb 2020-Present

• Working in the Research team and collaborating closely with Blue Star Family to finish the Annual Military Lifestyle Family Survey and Report

• Created the 2020 MLF survey by using Qualtrics, and improved the survey format and logic

• Performed descriptive analysis of RUSS survey by providing data visualization and professional report

• Utilized statistical modeling with data from Validation survey by using SPSS College of Visual and Performing Arts, Design Research Assistant, Syracuse, NY Dec 2019-May 2020

• Managed data cleansing and performed hypothesis test (t-test) to verify the impact of the courses

• Built regression model between TTCT score and course’s attributions to explore the relationship using Python

• Applied association rules mining to find a combination of variables that lead to high TTCT score

• Developed Tableau dashboards with different performance metrics for presentation Prudential Hong Kong, Marketing Analyst Intern, HK, China July-Sep 2017

• Awards: “Outstanding Intern” in the summer intern trainee camp

• Led my team to analyze the business data and provided marketing strategy which ranked top 2% in the marketing analysis & business contest

• Produced marketing posters by using Adobe Photoshop and Adobe Illustrator SELECTED PROJECTS

Microsoft Malware Prediction in Python, Syracuse University Sep-Dec 2019

• Performed data cleansing and feature engineering for continuous and categorical variables

• Built logistic regression, random forest classification model and GBDT to predict malware

• Accomplished cross-validation to find the best combination of parameters Vehicle Insurance Database Development and Management, Syracuse University Feb-May 2019

• Design the vehicle insurance price comparison system, determine the relationship by creating ERD

• Built the vehicle insurance database and inserted the data by Implementing SQL queries

• Extracted data from database for price comparison, further give recommendation to the clients