Data Analyst Service

Ziyun Yi

**** ******** *** ****, *** York, NY ***31 917-***-**** ******@********.*** https://www.linkedin.com/in/ziyun-yi EDUCATION AND AWARDS

Columbia University, Graduate School of Arts and Sciences New York Aug. 2015-Dec. 2016 MA in Statistics, GPA:3.88/4.00

• Teaching Assistant for Probability and Statistics Sep. 2016-Dec. 2016 Jinan University (211) Guangzhou, China Sep. 2011-Jul. 2015 Bachelor of Economics in Statistics, GPA: 3.76/4.00; Top 5%

• First-class Outstanding Student Scholarship 2011-2012, 2012-2013

• Outstanding Student Leader Honorary Title (Secretary–general of the Student Union) 2011-2012 University of Birmingham Birmingham, UK Sep. 2013-Jul. 2014 Exchange Student in Mathematics, GPA: 4.00/4.00; First-class Honors WORK EXPERIENCE

Arecy LLC New York Mar. 2017-Present

Data Analyst Intern

• Maintained accurate and detailed records on assigned portfolios and performed statistical analysis with Excel and R

• Developed and implemented data collection systems to ensure the process of data preparation and to optimize data quality for pricing scenarios using Python

Bomoda New York Mar. 2016-Jul. 2016

Data Analyst & Strategist Intern

• Analyzed complex data with Excel and Python to gain actionable insight into trending, user experience, and behavior in order to create highly-targeted and strategic marketing solutions

• Created customized KPI dashboard and visualized data into reader-friendly weekly & monthly reports interpreting global digital market trend

• Typical customers: Ferragamo, Kate Spade, Omega, Tiffany, etc. HSBC Guangzhou Nov. 2014-Dec. 2014

Winter Intern, Branch Banking Operations

• Consolidated corporate and personal customer database in Excel and performed daily banking operations

• Made flexible use of HSBC Hub System to process FX transactions and conducted statistical analysis on those data Statistical Bureau of Guangzhou Municipality Guangzhou Jul. 2014-Aug. 2014 Data Analyst Intern, Department of Service Industry Statistics

• Gathered and categorized figures in financial statements from small and medium-sized service companies

• Assisted with preparation of the monthly report by checking validity of data RESEARCH EXPERIENCE

Traveling Website’s New Customer Behavior Prediction by Machine Learning Methods Columbia University Dec. 2016

• Conducted Exploratory Data Analysis and preprocessed over 20 million rows’ raw data

• Applied Multinomial Logistic Regression, Random Forest and XGBoost methods with Python and R to do classification and prediction

US Soybeans and Wheat Futures Markets Trading Strategy Research Columbia University May. 2016

• Developed and back-tested trading strategies with R from 34 years 5-minute high frequency data set by cross-validation

• Analyzed the trend following and mean reversion properties of the two markets

• Attained good resulting indicators such as Sharpe Ratio and Maximum Drawdown Yield Curves Construction by Interpolation Columbia University May. 2016

• Calculated US interest rates by bootstrapping from 1 month to 30 years

• Utilized 4 interpolation methods to attain different yield curves with Excel VBA SKILLS AND LANGUAGES

Computer Technique: R, Python, SQL, SAS, Excel VBA, Tableau, Access Language: Cantonese (Native), Mandarin (Native), English (Fluent)

Contact this candidate