Data Entry, SQL, Data Analysis, R, CRM

Haitian (Mike) Gao

***W **th Street New York, NY 10023

516-***-**** ******@*******.***

EDUCATION

FORDHAM UNIVERSITY New York, NY

MS, Applied Statistics & Decision Making, GPA: 3.78/4.0 GMAT: 700 Graduation: 05/17 2015 - 2017 Awards and Honors: 2nd place out of 18 teams in March Data Crunch Madness data analytics competition sponsored by Deloitte Graduate Assistant, Fordham University

SHENZHEN UNIVERSITY Shenzhen, China

Double Degree: BS, Finance and BS, Applied Mathematics 2011 - 2015 Vice President, Shenzhen University Student Unions EXPERIENCE

Fordham University New York, NY

Graduate Assistant Feb. 2016– Dec. 2016

Debugged 67 students' R code for data cleaning and manipulations, data visualization, regression model construction and validation, statistical computation and simulation.

Performed data entry and data manipulations on Blackboard and generated reports of students' homework performance for professor. Classwish.org New York, NY

Technical Intern Apr. 2016 – May 2016

Led a team of 3 technical interns and developed a web scraping tool to extract over 3000 of nonprofit organization data from GuideStar, which increased the efficiency of scraping by 50%.

Created pivot tables and modified spreadsheets of nonprofit organization data.

Researched for more than 300 nonprofit organizations’ programs and results, contacts and financial statements.

Conducted internal training for other technical interns on extracting data from GuideStar using Import.io. Alternative Asset Investment Management New York, NY Intern Oct. 2015 - Dec. 2015

Performed CRM data entry, de-duplication, cleanse, import and export on Act.

Compiled and generated spreadsheets of over 1000 hedge fund managers’ information.

Researched the size, returns, managers of over 500 ETF and Hedge Fund.

Coordinated the Alternative Asset Summit hold in Las Vegas and created marketing materials including email invitations, press releases and promotional letters.

PROJECTS

Database Optimization and Data Quality Check (SQL) New York, NY

Assessed business requirements and identified potential improvements of existing database to optimize its performance.

Redesigned Trade Group’s entity-relationship diagram and wrote SQL queries to retrieve data and performed data quality check.

Mentored 2 team members on SQL queries.

Web Analytics and Marketing Strategy Design (Python, Twitter API) New York, NY

Led a team of 4 graduate students to conduct a social media marketing strategy for Microsoft Surface Pro 4 using Twitter API, Python and Gephi.

Analyzed the link structure of more than 840 quantitative and qualitative data extracted from Twitter.

Collected over 900 tweets about people’s views on Microsoft Surface Pro 4 using Twitter API and Python.

Introduced Gephi to calculate PageRank of tweets, which improve the efficiency of web structure analysis by 60%. Deprivation Level Computation (R) New York, NY

Compute the Townsend Material Deprivation Index for census tracts in New York County using more than 280 American Community Survey (ACS) data collected from the U.S. Census Bureau.

Performed data manipulations including merging tables, standardizing variables and cleaning 300 ACS data for 5-year estimates spanning from 2009 to 2013.

Constructed heat map color coded by the deprivation index value. March Data Crunch Madness Competition (R) New York, NY

Collaborated with a team of 4 to conduct data analysis in R using Logistic Regression, Support Vector Machine, Decision Tree to predict the final championship of March Madness 2016 Men’s Basketball Tournament.

Introduced 3 methods, AUC, Log Loss and Accuracy Rate to validate models in R.

Coordinated group discussion on Feature Selection with the former winner of the competition.

Designed data visualization of the result and created poster for the competition using PowerPoint. SKILLS & CERTIFICATIONS

Language: Chinese, English

Skills: R, SQL, C/C++, SAS, Python, MailChimp

Certificate: SAS Certified Programmer for SAS 9

Contact this candidate