R/SQL/PYTHON

Jinman (Jemma) Rong

Waltham, MA 781-***-**** adhzj5@r.postjobfree.com www.linkedin.com/in/jinmanrong github.com/jemmarong0704 SKILLSET

R, SQL, Python, Tableau, PySpark, Google Analytics, SPSS, EViews, STATA, Advanced Excel EDUCATIONAL BACKGROUND

Brandeis University Waltham, MA

Candidate for Master of Science in Business Analytics (STEM-Designated) (GPA: 3.8) 08/2019-12/2020 Relevant Coursework: Big Data, Machine Learning & Data Analysis, Python and Applications to Business Analytics Shanghai University of International Business and Economics (GPA: 3.8) Shanghai, China Bachelor of Management 09/2015-06/2019

Royal Melbourne Institute of Technology University Melbourne, Australia Bachelor of Business 09/2015-06/2019

WORK HISTORY

MedBlob Boston, MA

Data Science Intern 05/2020-08/2020

• Conducted data cleaning (numeric data rescaling, categorical variables conversion & variables combining) and exploratory analysis (variation, missing values, covariation & patterns) by extracting data from the CDC database with R (tidyverse)

• Selected important features by backward method & domain knowledge; trained machine learning models

(Logistics/Random Forest/XGBoost etc.) to predict the risk scores of getting chronic diseases with Python (numpy, scipy, pandas, sklearn); determined the best model with 87% Recall Rate

• Applied SHAP (SHapley Additive exPlanations) values to visualize individual predictions of risk scores of different diseases

• Ran cost-sensitive machine learning models regarding the imbalanced dataset to cross-validate the model results with Weka

Ipsos Shanghai, China

Data Analyst Intern 12/2018-03/2019

• Conducted positive/negative word frequency chart, Radar chart and word cloud using PowerPoint in consumer sentiment analysis based on text mining result (300,000 comments)

• Calculated key metrics such as the conversion rate of each stage in the sales funnel model and analyzed data trends & consumer churn to clients

Kantar Shanghai, China

Quantitative Analyst Intern 11/2017-02/2018

• Quantified the popularity of 200 social media accounts based on the average numbers of reads, likes and reposts of advertising articles to provide a potential social media partners list to clients

• Created Excel Macros scripts to simplify secondary data (5,000 records) querying procedures, improving efficiency by 30% ACCOMPLISHMENTS

Brandeis University Waltham, MA

Genivity Field Project with Python and R 07/2020-08/2020

• Projected health insurance plans’ future premiums by autoregressive models and average growth rate

• Built k-Nearest Neighbor based system to recommend the top 5 health insurance plans regarding customers’ insurance preference and demographics information

• Organized and led 1-hour weekly internal meetings with team members to define problems and update progresses Grocery Shopper Behavior Analysis with MySQL and Tableau 09/2019-12/2019

• Used window function on purchase dates to identify loyal customers; conducted queries to find relations between # of trips and average # of items, price per trip and # of items etc.; visualized results and provided insights towards purchasing behavior and customer loyalty analysis

Healthcare Analytics and Data Mining with R and Python 09/2019-12/2019

• Analyzed odds ratio & p value in Fisher’s exact test to explore gender difference in healthcare providers practicing as sole proprietor; manipulated data from the CDC database (5.9 Million rows & 329 variables)

• Conducted clustering analysis to construct low/median/high costs of diagnosis-related groups (DRGs); Checked the elbow curve and F-statistics to choose the optimal k in K-means clustering algorithm ADDITIONAL INFORMATION

Certificates: Google Analytics Individual Qualification, Assistant International Trader Certificate

Contact this candidate