Post Job Free

Resume

Sign in

Business Analytics Intern

Location:
Astoria, NY, 11103
Posted:
November 23, 2016

Contact this candidate

Original resume on Jobvertise

Resume:

Yuqi (Rita) Jin

th

**-** ** ****** *** York NY, 11103 929-***-**** acxl52@r.postjobfree.com

EDUCATION

**/** **/** ******* UNIVERSITY, GABELLI SCHOOL OF BUSINESS New York, NY

Master of Science in Business Analytics (GPA: 4.0/4.0)

Core Courses: Explanatory Model (R programming), Data Mining (SPSS Modeler), Web

Analytics (Python), Text Analytics (Python), Business Analytics for Managers (IBM

Cognos), Database Management (SQL), Data Warehousing, Business Performance

Management Risk Analytics (Tableau, Spotfire, Qlikview, Alteryx)

09/11 06/15 ZHONGNAN UNIVERSITY OF ECONOMICS AND LAW Wuhan, China

Bachelor of Management in Accounting (GPA: 3.4/4.0)

EXPERIENCE

Real-world Type Projects New York, NY

03/16 - 05/16 Text Analytics for Evaluating Restaurant Weeks Impact on Participating Restaurants

Crawled 1,451 reviews from Yelp by using Python for all eateries in Manhattan

Performed sentiment analysis in SPSS Modeler and cost-benefit analysis for each restaurant

Concluded Top 5 popular restaurants during Restaurant Week

02/16 - 04/16 2016 Sports Analysis for March Madness Sponsored by Deloitte

Analyzed game data from 2002 to 2015 and selected eight variables from 98 variables

Built Logistic Regression Model in R to predict winners of games with 81% accuracy

09/15 - 12/15 Data Mining for Predicting the Success of Bank Telemarketing

Analyzed 40,000 customers information by building classification models in SPSS Modeler

Predicted customers likelihood of subscribing a term deposit with 86% accuracy

09/15 12/15 Web Analytics for Predicting the Trend of Movies Box Office Results

Crawled 1 million tweets about 20 movies for 20 days using Python and performed sentiment

analysis through Site Content Analyzer

Predicted the box office results of movies by Support Vector Machine Model in Python

09/15 - 12/15 Building Database for Art Gallery

Developed the conceptual model and the physical model in IBM IDA, built database in IBM Data

Studio, wrote 10 SQL queries to efficiently retrieve information from database

Working Experience

05/16 - 10/16 New York, NY

NYC Department of Design and Construction

Business Analytics Intern

Cleaned and balanced a dataset consisting of vendors financial data, project

budget data, and project duration data for over 1,000 projects by using R

Built classification models and regression models in SPSS Modeler to predict

possible project delays and budget adjustments

06/16 - 08/16 NYC Mayors Office of Management and Budget New York, NY

Summer Intern, Pension Analysis Unit

Updated 12 actuarial models used to value pension benefits by utilizing

advanced formulas in Excel, created an Excel dashboard using VBA

Reviewed 15 comprehensive annual financial reports to assist the unit in

developing a comparative analysis of pension system funding assumptions

07/14 - 09/14 PricewaterhouseCoopers Ningbo, China

Intern, Audit and Assurance Department

Researched companies and found 15 potential audit clients in local

manufacturing industry

In IPO audit projects, found seven discrepancies when examining accounts, and

communicated with senior accountants to ensure there was no wrong entry

ADDITIONAL

Software: Microsoft Excel, PowerPoint, Word and Access, IBM Watson Analytics

Languages: Native in Mandarin, Fluent in English, Fluent in Cantonese



Contact this candidate