Data analyst

JIANYU CHAI

319-***-**** Queens, NY ******@*******.***

EDUCATION

M.S., Informational System - Fordham University, New York, NY (GPA: 3.78) Dec 2017

• Leadership: PR in Fordham Chinese Students and Scholars Association (full time available since August)

• Relevant Coursework:

Database Management Web Application Business Analysis for Managers Data Mining for Business Programming with Python Business Modelling for Spread Sheet System Design and Analysis Project Management Info Systems Strategy & Management B.A., Economics - University of California, Santa Barbara, CA Jul 2014 EXPERIENCE

Accenture - Research Intern Dec 2016 – Jan 2017

• Analyzed advantages and disadvantages of hundreds financial companies’ products and prepared documents to support manager’s presentation for clients

• Sourced, collected, reviewed product data for over 50 companies with hundreds financial products across the current market of bonds and security industries in China

State Street - Fund Accountant, Customized Reporting Team (Full time), Hangzhou, China Dec 2014 – Apr 2015

• Reconciled and delivered a comprehensive set of customized data files (including holdings, transactions, NAV, security information) to clients using a compatible format

• Utilized Bloomberg to validate the accuracy of input data from various sources such as Samsung’ text files EREAL-WORLD DATA PROJECTS

Red Cross Home Fire Preparedness Campaign Projects - Red Cross, New York, NY May 2017 - Present

• Designed a web application and database based on the gathered requirements from Red Cross

• Built database with SQL, and associated platforms for web application using PHP Deloitte March Madness Competition - Deloitte, New York, NY Jan 2017 – Mar 2017

• Presented charts and graphs of the correlation between key features and results with Tableau and predicted 2278 games in March Madness Tournament 2017 with 77% accuracy

• Appended different data sets, merged calculated ratios and removed duplicated and empty data for 2000 March Madness games from 2002 to 2016 and created a new variable, which increased prediction by 5%

• Selected important variables, built and benchmarked different models such as, decision tree model, logic regression model, SVM model, neural network model by running SPSS Modeler, and calibrated each model to the best. Innovation and economic project - Fordham, New York, NY Jan 2017 – Apr 2017

• Analyzed 12 correlations between innovation indicators and GDP to predict the future trends of the relationship between innovation and GDP by using IBM Cognos

• Collected and processed raw data of 6 innovation indicators and 4 GDP indicators over 30 countries for past 10 years from World Bank

ENTREPERNEUTSHIP

Feiyu Internet Technology Co. Limited - Chief Executive Officer (CEO), Ningbo, China Oct 2015- Aug 2016

• Designed a smartphone application aiming to mobilize resources on Campus: primarily a social network to solicit assistance from other students with monetary compensation; secondly to provide an online platform for setting up small business on campus

• Developed the architecture for the application and led computer programmers to build the first version of our application based on Object-C and XCode

ADDITIONAL

• Interests: Road trip (Road trip from LA to NY within 10 days), Cooking, Fitness

• Languages: Fluent in English, Native in Mandarin

• Technical Skills: Proficient at Excel (VLOOKUP, Power Pivot, PivotTable), Proficient at Cognos (data analysis, dashboard building), Proficient at IMB SPSS (model building, prediction), Proficient at MS project, Advanced at Tableau

• Programming skills: Proficient at SQL, Advanced at Python, Advanced at PHP, Advanced at HTML&CSS

• Volunteer: Citymeals-on-wheels (Delivered meals to homebound seniors)

Contact this candidate