QIAOQI SUN

*** ****** ******, *** ****, Jersey City, NJ 07302 201-***-**** acxpoc@r.postjobfree.com

OBJECTIVE To obtain an entry-level full time position related to data analysis

WORKING EXPERIENCE

Bank of China, the Bund Branch, Shanghai, China 05/14 – 07/14

Project Intern of Operation Management Department

● Updated and classified the clients’ information into database

● Took responsibility of foreign trade declaration, documentation management and invoice handling

● Evaluated data quality, accuracy and completeness

● Learned related theory of foreign trade with practice, gained an understanding transaction process

Citibank, Lujiazui headquarter, Shanghai, China 02/14 – 05/14

Project Intern of Individual Finance Department

● Competed highly-competitive training program in data analyzing and decision making

● Merged, summarized, updated and classified the clients’ information into database

● Built a customer database and analyzed what they are most interested in investment products

● Led the program members to improve the project procedures

SKILLS

Programming Languages: SAS, Python

Database Systems: SQL workbench, SQLite, Excel

Data Visualization: NodeXL, Palisade DecisionTools, Tableau

PROJECTS

Functions of Walmart in SQL

● Consolidated data from multiple data sources, databases

● Prepared the dimensional model for the further analysis

● Demonstrated few functions of Walmart in SQL queries such as tracking orders and managing products storage

● Used k-nearest neighbors algorithm to simulate the function of finding the closest shops according to the address provided

Best Treatment Effect & Optimal Allocation of Funding of Diabetes in New Jersey

● Collected the related data and did ETL design for the analysis

● Built the model and applied the model in Excel for the further study

● Used Excel and SAS to solve the optimal solution and SolverTable to do the sensitivity analysis

Analysis the Factors of Electronic Products Consuming

● Conducted a survey for collect the data used to analyze

● Crawled survey data from the internet using python

● Integrated, visualized and grouped the databases to analysis the networks in NodeXL

● Used linear regression and normal distribution to analyze customer behavior and pattern

EDUCATION

Stevens Institute of Technology, Hoboken, NJ

Master of Science in Business Intelligence and Analytics, anticipated May 2016 GPA: 3.88

Coursework: Social network analysis, Data & knowledge management, Process analysis & optimization, Experimental design, Data warehousing, Multivariate Data Analysis, Text Mining, supply chain analysis

Shanghai University of International Business and Economics, Shanghai, China

Bachelor of Engineering in Financial Engineering, May 2014 GPA: 3.23

Coursework: Mathematics of Finance, Financial Engineering, Financial Derivatives, Fixed income analysis, Quantitative Methods for investment Analysis, Investment Analysis and Portfolio Analysis, Finance Simulation, etc

Awards: Honored individual scholarship of Shanghai University of International Business and Economics in 2012

POSTS & ACTIVITIES

Member of the Organizing Committee of SUIBE Financial Case Analysis Competition 2012 –2013

● Planned the procedure of the competition, participated in the preparations

● Publicized the competition among the school and looked for the sponsorship

Contact this candidate