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