Data Analyst

*

YUXUAN(OLIVE) WANG

*** **** **** ******, ***, New York, NY 10019

929-***-**** ********@*******.***

SUMMARY

Data Analyst with the ability to employ the latest tools, technologies and techniques required to analyze, debug, iterate and optimize analysis to infer actionable insights from data; with moderate understanding on the use of R, SPSS and Python. EDUCATION

2017-2018 FORDHAM UNIVERSITY, GABELLI SCHOOL OF BUSINESS New York, NY MS, Business Analytics, GPA 3.5

• Relevant Coursework: Data Mining, Risk Analytics, R Statistical Programming, Programming with Python, Database Management

2013-2016 MIAMI UNIVERSITY OXFORD Oxford, OH

BS, Quantitative Economics

• Relevant Coursework: Microeconomics, Macroeconomics, Statistics SKILLS

• Software Skills: SPSS, SQL, R language, Python, Tableau, Qlik, Excel (VLOOKUP, Pivot Table)

• Technical Skills: Cleaning data, SQL Queries, Correlation, T-test, ANOVA, Regression, Classification, Clustering, AB testing

• Others: Excellent Critical thinking, Reliable, Conflict Management, Adaptive Communication skills, Analysis and Decision making

PROJECTS

Fall 2018 Optimization Portfolio Composed of Two Exchange Traded funds - R Language

• Constructed a portfolio tracking US equity and fixed income markets and applied optimization techniques to determine what fraction of money should be allotted to each asset

• The portfolio should consist of 59.58% S&P assets and 40.42% long-term assets

• Technologies: Control structures, Exploratory data analysis, Data visualization, Time series, Integration and optimization

Spring 2018 Data Mining for Online News Popularity - Python and SPSS

• Applied data analytics to find attributes influencing the likelihood a news item will be shared; applied Google Analytics to assess profiles of visitors and traffic sources on company website

• Built, tested and modified over 5 product prototypes and identified the most accurate and appropriate solution

• Technologies: Feature selection, Logistic regression, Decision Tree, Naive Bayes, K-means Clustering Fall 2017 Assessing the relationship between Healthcare spending and economic performance - Tableau

• Operated multiple Tableau visualization tools to communicate insights produced through data analysis to classmates

• Technologies: Tableau, with a focus on heat maps, box and whisker charts, scatter plots, geographic maps, pie charts, bar charts, and density charts

EXPERIENCE

02/17-07/17 Beijing Kegan Education Company - Beijing, China Economic Teacher

• Used webcasts to teach economics courses to more than 300 undergraduate students seeking banking jobs

• Published 9 different textbooks collaborated with 6 colleagues

• Excelled in highly competitive probationary period to become one of a small percentage of instructors invited to remain throughout six-month term

ADDITIONAL

• Language: Fluent in English and Chinese

Contact this candidate