data analyst
Resume:
Qing Dong
***-** **** *****, ***#*R Forest Hills, NY11375
******@********.*** **************@*****.***
EDUCATION
Columbia University, Graduate School of Arts and Sciences, New York, NY February 2015
Master of Arts in Statistics, GPA: 3.87/4.00
Relevant Coursework: Data Mining, Advanced Data Analysis, Linear Regression Models, Probabilities and Statistics Inference
Central University of Finance and Economics (CUFE), School of Applied Mathematics, Beijing, China July 2013
Bachelor of Science in Mathematics and Applied Mathematics (Financial Mathematics), GPA: 3.37/4.00
Relevant Coursework: Mathematical Modeling, Fuzzy Mathematics, Stochastic Process, Database Principle and Application
Awards: Honorable Mention, Mathematical Contest In Modeling (2012)
Outstanding Student Scholarship Second Prize, Central University of Finance and Economics (2011)
EXPERIENCE
Columbia University, Graduate School of Arts and Sciences, New York, NY September 2014- December 2014
Teaching Assistant/ Grader
• Assisted in teaching the course of Probabilities and Statistics Inference
• Graded assignments of over 100 students and answered questions relating to this course
• Created spreadsheets in Excel to give feedback on the performance of students of each assignment
China Development Bank (CDB), Beijing, China August 2012
Intern, Data Analyst
• Achieved relationship between sales amount of bonds underwrited by CDB and other bond indicators by analyzing data
of the first half year of 2012 in Matlab
• Used spreadsheets and charts in Excel to clarify the structure and trend of Chinese bond market and the difference
between Chinese and US bond markets
• Gave suggestions on bond underwriting plan of CDB based on data analysis to improve Chinese bond market
PROJECTS
Analysis of White Wine Quality
Class Project, Team Leader, Columbia University, New York, NY October 2014
• Dealt with dataset contains over 4800 data and 11 indicators from UCI Machine Learning Repository
• Used R to build regression and classification models, like linear regression, LASSO, random forest, and decision tree,
and compared the results of different models
• Found classification models were better than regression models, and random forest was the optimal algorithm to predict
quality of the white wine
Text Classification
Class Project, Columbia University, New York, NY April 2014
• Worked on dataset with 77 papers from Federalist Papers written by Hamilton and Madison
• Transferred the texts into a document-term matrix, which counts the number of times each dictionary element is used in
a document, and the dictionary contains 4873 different words
• Classified papers by Naïve Bayes method, and used 5-fold cross-validation to determined the best value of parameter
miu which achieved 91% classification accuracy
• Built tree classification models to classify the papers and got 96% accuracy
Investment Strategy using Bayesian Portfolio Selection
Class Project, Team Member, Columbia University, New York, NY November 2013
• Achieved an optimized a portfolio of eight stocks from different industries by maximizing sharp ratio in Excel
• Used Bayesian method to adjust portfolio allocation, and compared the results with Classical method
• Forecasted performance of the portfolio in next period using optimal method
Estimate the Weight of Leaves on a Tree
Mathematics Contest in Modeling, Team Leader, CUFE, Beijing, China February 2012
• Completed the project and a report in limited 4 days and under high pressure
• Simulated the crown of a tree based on the theory of fractal by using Matlab
• Made a mathematical model to obtain the increment of weight of a tree through the photosynthesis
SKILLS AND INTERESTS
Languages: Native Mandarin
Technical skills: Microsoft Word, Excel, PowerPoint and Access, Matlab, R (Proficient); Stata, Visual Basic for Applications,
SAS, SQL (Advanced); SPSS, Python (Intermediate)
Certificate: SAS Certified Base Programmer for SAS 9, SAS Certified Advanced Programmer for SAS 9,
Passed Level I of the CFA Program
Interests: Music, Erhu (a Chinese musical instrument with Grade Ten), cooking, drawing, calligraphy, swimming
Contact this candidate