Sign in

Data Analyst Professional Experience

New York, New York, 11201, United States
October 20, 2016

Contact this candidate



*** ******** **, *** ***, Brooklyn, NY 11201 ● 646-***-**** ●


Columbia University, Graduate School of Arts and Sciences New York, NY Master of Arts in Statistics, GPA:3.77/4.00 Feb 2016 Relevant Coursework: Machine Learning, Data Mining, Statistical Methods in Finance, Stochastic Methods in Finance Zhongnan University of Economics and Law, School of Statistics and Mathematics Wuhan, China Bachelor of Science in Statistics, Finance orientated GPA:3.62/4.00 Ranking: top 10% Jun 2014 Relevant Coursework: Econometrics, Time Series Analysis, Non-parametric Statistics, Statistical Software, C++ Programming, Securities Investment Analysis, Economic Forecasting & Decision-Making, Design of Experiment, Risk Management SKILLS:

• Programming Language and Software: R, Python, SQL, SPSS, SAS, C++, Matlab, Excel, VBA, PPT

• Languages: Native in Mandarin


Tilting Point New York, NY

Data Analyst Intern Aug 2016 - Present

• Use SQL, combined with some other tools to create standard reports, dashboards and offer daily data support

• Automate reports and UA(User Acquisition) process using Python and SQL

• Constructed regression, decision tree and A/B testing models to provide developers with the direction of game update and increased the total revenue and user retention

Shanghai General Motors (SGM) Shanghai, China

Data Analyst Intern, Market Department Jul 2015-Aug 2015

• Optimized and maintained cross-selling, customer value, and lost customer models to improve the consistency and accuracy of valuations using SAS and offered daily data support

• Audited monthly and weekly reports of multiple brands to detect latent errors and improve data integrity Bank of Wenzhou Ningbo, China

Rotational Intern Jul 2013-Sep 2013

• In the Operation Dept.: Verified the accuracy and the validity of the bank’s acceptance bills; contacted corporation representatives on problem-shooting when needed; built models on SPSS and analyzed the features of core customers

• In the General Business Dept.: Evaluated client information of borrower and guarantor; determined the intrinsic value of securities based on analysis and external valuations services; built models to evaluate the CPR mortgage risk and profits RESEARCH EXPERIENCE:

Water Strategy Model to Meet the Projected Water Needs of China in 2025 Feb 2013

• Won the Honorable Mention in the American Mathematical Contest in Modeling (MCM)

• Constructed five sub-models respectively concerning the prediction of demand and supply on water in 2025, the water shortage forecast system, the transportation, the supply coming from desalination and the optimal water allocation implementing various methods in statistics and operations research Impact of the Internet on the Travel Decision-Making Research Feb 2013-Oct 2013

• Explored the online travelling expending by performing descriptive statistical analysis and SWOT analysis

• Used Cluster analysis, PCA, correlation analysis and stepwise regression to quantify the strategic impact of the internet primarily on tourism suppliers and intermediaries

Stock Trading Strategy Using Machine Learning Method and Time Series Models May 2015

• Combined six technical indicators of stock to provide investors with long-short strategies based on decision tree

• Constructed a trading signal prediction model using time series analysis, including Monte-Carlo Simulation and Black- Scholes Model

Major League Baseball Hall of Fame Analysis and Prediction Nov 2015

• Examined main factors that influence baseball players to make the Hall of Fame by constructing a L1 Regularized logistic regression in R

• Built a decision tree model and applied random forest to predict the membership of the Hall of Fame

Contact this candidate