Data Science, Data Analytics SQL, Python, R

Kaiping (Rory) Wang

626-***-**** • adb5v9@r.postjobfree.com • Los Angeles, CA • linkedin.com/in/rorywang1996/ EDUCATION

University of Southern California – Los Angeles, CA December 2020

• Master of Science in Business Analytics (STEM), Dept. of Data Sciences and Operations

• Membership: Marshall Business of Entertainment Association, Graduate Marketing Association, Data Analytics Club

• Courseworks: Machine Learning, Natural Language Processing, SQL/NoSQL Database, Statistics, Text Analytics National Chengchi University – Taipei, Taiwan June 2019

• Bachelor of Arts, International Business; Bachelor of Science, Digital Content & Technologies; GPA: 3.6 Honors: Dean’s List, Graduated with distinction

SKILLS & INTERESTS

• Programming Languages: R, Python, SQL, NoSQL, Java, JavaScript, Unity

• Data Analysis Tools: Google Analytics, Adobe Analytics, Bloomberg, SAS, Salesforce, SPSS

• Dashboard/Visualization Tools: Tableau, Power BI, MS Excel

• Specialization: Data manipulation/analytics, statistics, dashboard designing, machine learning, predictive models, hypothesis testing, regression, A/B testing, data driven decision making, communication

• Graphic Design Tools: Unity, Photoshop, Adobe Premiere, Adobe Illustrator, Adobe After Effect, Adobe InDesign

• Language: Mandarin (Fluent in Written and Verbal), English (Fluent in Written and Verbal)

• Interests: Film/television, yoga, piano, travel, vlogging PROFESSIONAL EXPERIENCE

Deloitte & Touche Financial Advisory – Taipei, Taiwan 2018 – 2019 Financial Analyst Intern

• Perform deep and continuous exploration of high-volume data to compose bimonthly industry reports

• Presented analysis of market trends to executives and senior analysts to assist in target research process

• Conducted 10+ target search, valuation, evaluation, and due diligence of merger cases in the consumer goods industry; total value of M&A deals worth $60M

EverPro International Market Research – Taipei, Taiwan 2017 – 2018 Data Analyst

• Led major projects and reports, built and maintained large datasets of market research using SPSS, SQL and SAS

• Created structured qualitative survey and recorded interview responses from target audiences into trackable system

• Presented recommendations and insights gathered from SQL data analysis to government officials at the Annual Taipei City Hall Christmas event; public satisfaction improved by 40% compared to previous year

• Managed and chaired focus groups of 20-40 people for household appliance design. Resulting style and pricing recommendations contributed to 25% increase in market share Microsoft – Taipei, Taiwan 2017

Marketing Analyst Intern for Azure team

• Collected and analyzed first-time user feedback of 50+ professionals and 200+ product surveys using Tableau for the Microsoft Azure platform at Taipei Infinity Exposition. Analysis throughput increased 50% compared to previous year

• Managed the official Facebook page for Microsoft products; leveraged analysis of target audience behaviors to engage user interaction with posted articles and increase follower count by 23% ACADEMIC PROJECTS

Unsupervised Fraud Model on New York Property 2020

• Built an unsupervised fraud detecting model with algorithmic system via Python to look through 1M property records with 30 fields of New York property data to find potential tax fraud; found 40+ anomalies with the model Google Analytics LACMA Email Marketing Project 2019

• Conducted Python and Google Analytics analysis of LACMA’s web data to evaluate email link click through rate

• Generated a 30% growth rate in web traffic on a MoM basis, through data-driven recommendations and visualizations of subscriber segmentation, email layout and link visibility World Happiness Report Project 2019

• Conducted machine learning techniques such as logistic regression, decision trees, random forests and cluster analysis using R on World Happiness Score and Human Development Index to find correlation between two reports.

Contact this candidate