Phone: CHUZHU 302-***-**** Email: adm7yu@r.postjobfree.com com New York

EDUCATION

Columbia University New York, NY

M.A in Statistics Aug.2019 - Dec.2020

• Advanced Finance Courses: Time Series Analysis, Math Methods in Financial Analysis, Statistical Method in Finance, Multi-Asset Portfolio Management

Pennsylvania State University State College, PA

B.S in Mathematics, B.S in Statistics, B.S in Economics Aug.2014 - Dec.2018 EXPERIENCES

Memo New York, NY

Data Analyst Apr.2021 - Current

• Categorized more than 500 articles daily by adding structure to very unstructured information, found patterns and buckets for data to fall into;

• Monitored for articles online around specific brand including Microsoft, Hershey, MAC Cosmetic and Johnson & Johnson;

• Created dashboards, queried data and visualize data for client weekly reports. School of Dental Medicine, University of Nevada State College, PA Data Analyst Oct.2018 - Dec.2019

• Utilized Python to acquire data with more than 30,000 entries from public sources with different formats and doubled the speed of data collection;

• Cleaned and filtered massive public demographic data and built database in SQL;

• Supported statistical analysis such as weighted logistic regressions and performed data validation using R;

• Interpreted analysis results and provided insights for the 19-page proposal article. The Pacific Securities Co., Ltd. Beijing, China

Data Analyst Intern May.2019 - Aug.2019

• Collected and organized financial data for city investment bonds using Excel;

• Utilized advanced Excel functions (Pivot Table, VLOOKUP) to prepare datasets for data analysis;

• Analyzed risk of investment bonds using financial models built in Excel;

• Drafted KPI dashboard and visualized data to support financial planning using Tableau and PowerPoint. PROJECTS

Price Forecasting and Analysis of different Industry Sectors Dec.2020 - May.2020

• Led a 12-people team: created project objectives and arranged meetings;

• Used forecasting methods such as Moving Average, Linear Regression, LSTM and Time Series to analyze the best models for predicting stock price in different industry.

Netflix Film Recommendation System Design based on Users’ Tastes Oct.2018 - Nov.2018

• Collected data files from Netflix and compared user-based and item-based collaborative filtering to determine recommendation mode;

• Utilized Panda and Numpy Python Packages for data cleaning and building film recommendation algorithm. ACTIVITIES

Minister of Media Department, CUSA, Penn State Oct.2014 - Nov. 2016

• Designed brochures, posters and shot promotional videos for Penn State, produced freshman handbooks and organized international student orientation events, and initiated activities to promote cultural diversity on campus. Game Streamer Dec. 2012 - Dec. 2014

• Streamed League of Legends at Douyu TV and was the 1st place on recommendation page for 2 years. SKILLS

• Computer Skills: SQL, SAS, R, Python, Microsoft Excel & Access (Vlookup, if, Pivot Table), Tableau, Google Analytics.

Contact this candidate