Resume

Sign in

Data Analyst or Business Analyst

Location:
Irvine, California, United States
Posted:
February 08, 2018

Contact this candidate

Resume:

YE XIAO

* ***** *****, ******, ** ***** 949-***-**** ac4eme@r.postjobfree.com https://www.linkedin.com/in/yexiao127/ Education

University of California, Irvine, Irvine, CA June 2018

• M.S. in Business Analytics GPA: 3.70/4.0

• Courses: Statistics for Data Science, Data and Programming for Analytics, Business Intelligence for Analytical Decisions, Mastering Predictive Analytics, Web & Social Analytics Shanghai Jiao Tong University, Shanghai, China June 2017

• B.E. in Food Science and Engineering Minor in Finance GPA: 3.75/4.0

• Honors: China National Scholarship (Top 1% of the School) Skills

Programming Language: Python(Pandas, NumPy, SciPy) R(dplyr&tidyr),

Machine Learning: Python(Scikit-learn), Weka

Database: SQL, AWS(S3)

Data Analysis: Alteryx, Excel, SPSS

Visualization: Tableau, R(ggplot2), Python(Matplotlib) Projects

Movie Analysis for IMDb.com, Irvine, CA Sept. 2017 – Dec. 2017

• Scraped data of top 250 movies for each year from 1994 to 2016 on IMDb.com in Python

• Processed Review attribute by Natural Language Processing(NLP), and built Review-Rating classification models by Naive Bayes, Logistic Regression, and Random Forest methods

• Built recommend system based on users’ preferences, which summarizes characters of uses’ favorite movies and finds out similar recommendations

Marketing Analysis for Bank Telemarketing Success, Irvine, CA Sept. 2017 – Dec. 2017

• Pre-process data via feature engineering and feature selection through exploratory analysis in Alteryx

• Resampled the unbalanced dataset to fit Decision Tree model and improved the rate of predicting clients who purchased bank deposits from 48.1% to 97.9%

• Segmented clients by cluster analysis and gave recommendations based on targeted group’s characteristics Options Pricing, Shanghai, China Sept. 2016 – Dec. 2016

• Cleaned and transformed Apple stock prices from March to October 2016 from Yahoo Finance

• Performed ACF and ARCH tests and built Time-Series GARCH model to forecast future stock prices in R

• Used historic volatility to calculate option prices based on Black-Scholes-Merton model

• Compared theoretical option prices to the real-world prices and analyzed the potential causes for the deviation Rainbow Noodle Research and Development, Shanghai, China Jul. 2016

• Conducted marketing research about customers’ needs to noodle and built Quality Function Deployment(QFD) diagram to visualize the relationship between engineering characteristics and product differences

• Launched sensory tests including descriptive and preference tests, used one-way ANOVA to analyze sensory data in SPSS, and concluded significant differences in mean scores of samples Experience

Wanlian Securities, Shaoxing, China Jul. 2016 – Sept. 2016 Analyst Intern - Investment Strategy Office

• Visualized and analyzed textile industry data using Excel to provide investment insights for Qingfangcheng company

• Conducted financial analytics to forecast revenue, identify future trends in local, and assess risks associated with national economic policies and capital expenditures Societe Generale, Shanghai, China Apr. 2016 – Jul. 2016 Analyst Intern - Business Development Office

• Broadened business development channels by writing credit card proposals and negotiated with Edaibo company to establish free parking services for high-class customers

• Segmented potential customers into different groups, analyzed data of targeted customers’ behaviors, and organized salon activities (e.g. Parent-Child activities) to advertise the bank

• Analyzed the tendency of world market, collected information of macroeconomic forms and latest published news, and conducted analysis reports based on daily fluctuation of gold price and oil price



Contact this candidate