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