Sign in

Assistant Data

New York City, NY
December 27, 2018

Contact this candidate


Yan Qin

*** ***** ***., *** ****, NY, ***** 718-***-****


Columbia University New York, NY

M.A. in Statistics Expected Dec 2018

Relevant Coursework: Probability, Inference, Linear Regression Model, Advanced Data Analysis, Statistical Computing and Data Science, Machine Learning, Statistical Method in Finance, Time Series Analysis, Sample Survey, Stochastic Process University of Colorado Denver Denver, CO

B.A. in Economics, B.S. in Mathematics, GPA: 4.0 May 2017 Relevant Coursework: Econometrics, Health Economics, Intermediate Macroeconomics and Microeconomics, Applied Regression Analysis, Data Analysis with SAS, Mathematical Statistics, Problem Solving Tools with Matlab, Numerical Analysis, Math Clinic

Honors: 1st Class Academic Scholarship (2015, 2016), Cum Laude in Economics (2017), Merit Student (2015) China Agricultural University Beijing, China

B.A. in Economics, Minor in Mathematics, GPA: 3.82 May 2017 Skills

Programming: SAS, R Studio, MATLAB, Excel, C++, and Stata (proficient); SQL, SPSS, Python (intermediate) Certification: SAS Certified Base Programmer for SAS9 Microsoft Office: Excel, PowerPoint, and Word

Languages: Mandarin (Native), English (Fluent)

Project Experience

A Study of the Movie Database Sep 2018-Dec 2018

Team Lead Kaggle Competition, Columbia University New York, NY

• Led a dynamic 15-member group to analyze the movie database from Kaggle

• Performed data cleaning and exploratory data analysis in Python and R; synthesized data to inform decision making

• Predicted the popularity of movie using different statistical models, such as linear regression models, random forest, boosting, and neural network in R; made comparisons based on their mean absolute percentage errors Portfolio Construction Using Principal Component Analysis Feb 2018-May 2018 Team Lead Columbia University New York, NY

• Monitored and tracked the progress of the project of forming diversified assets portfolio

• Utilized R to import and manipulate price information of 100 assets over 3 years from SP&500

• Implemented quantitative models such as factor analysis and Kaiser’s rule to select stocks and computed value-at-risk and expected shortfall to remove risky stocks

• Constructed efficient portfolios and equally weighted portfolios, evaluated their performances based on Sharpe’s ratio and 3-month rolling window test

Syngenta 2016 Business Competition Panel Aug 2016-Dec 2016 Math Clinic, University of Colorado Denver Denver, CO

• Analyzed, visualized and presented the data results into graphs and tables by using R and Excel

• Built statistical and economic models such as stratified sampling and coefficient of variation to identify the next-year best-selling soybean seed’s varieties and predict their sales volume

• Formulated a detailed and feasible business plan which was chosen by Syngenta to reach to the final contest Abenomics and Female Labor Force Participation in Japan Feb 2015-May 2015 International College at Beijing, China Agricultural University Beijing, China

• Conducted literature review on the impact of the Japanese Prime Minister Abe’s policies on women’s participation in the labor market

• Built labor market models concerning human capital, development of the childcare system, retention rate and “tokens”

• Contributed to the publication of journal articles on the issues pertaining to the economic and social background of women’s labor force participation rate

Additional Experience

The Zenas Hartvigson Memorial Math Education Resource Center Denver, CO Student Assistant College Math Oct 2015-May 2017

• Assisted students in using MyMathLab, Matlab, R studio and gave advice on doing programming projects

• Mentored students from over 10 different college-level and some graduate-level mathematics courses Department of Mathematical and Statistical Sciences, University of Colorado Denver Denver, CO Learning Assistant Abstract Math Aug 2016-Dec 2016

• Supported course reform of large lecture courses by developing lesson plans and overall goals with the department chair

Contact this candidate