Data Analyst Marketing

KEXIN WANG

**-** ****** ******, **** Island City, NY 11101 • ******@********.*** • 202-***-**** • linkedin.com/in/kexin-wang EDUCATION

COLUMBIA UNIVERSITY, School of Professional Study New York, NY MS, Applied Analytics September 2019 – December 2020 Relevant Courses: Applied Analytics Frameworks & Methods (R Studio), Python for Data Analytic, Managing Data (SQL), Storytelling with Data, Research Design, Strategy and Analytics THE GEORGE WASHINGTON UNIVERSITY, School of Business Washington, DC BS, Finance; Minor Statistics, GPA:3.72 September 2014 - May 2018 Honors: Dean’s List (Spring 2017 and Fall 2017); Member of BETA GAMMA SIGMA (Business Honor Society) PROFESSIONAL EXPERIENCE

Porsche (China) Motors Limited (PCN) Shanghai, China Data Analyst Intern June 2019 – August 2019

• Developed order tracking system by compiling and inserted past 5-year order and bid records into SAP

• Collaborated with internal departments and external vendors to resolve 50+ purchase order issues; Built a database to solve VAT problem

• Analyzed and maintained vendors metadata; Identified new potential vendors

• Conducted Request for Quotation and consolidated to a database for price comparison, which increased the work efficiency by 20% Nanjing Hai Qin Investment Management Nanjing, China Financial Data Analyst Intern July 2016 - August 2016

• Collected and manipulated financial data from Yahoo Finance; Generated financial analysis by developing the cash flow model

• Collaborated with sales and customer service teams to develop new customers based on existing contracts, located 20 potential clients.

• Resolved over 30 issues related with wealth management products (Bonds/Funds) by communicating with customers AIA Group, Hongkong Hong Kong, China

Trainee December 2014 – January 2015

• Performed a survey analysis by using R to promote the marketing campaign with catering business

• Built a marketing data manipulation pipeline using R, which increased the data processing efficiency by 90%

• Provided the presentation to senior managements and 6 marketing team leads by creating the data visualization dashboard of marketing data with R

• Awarded First Place in Street Marketing Competition with outstanding efforts in Management Enhancement Program (MEP) DATA ANALYTICS PROJECTS

Airbnb Data Mining Competition

• Achieved a rank of top quartile in Kaggle Competition held by Columbia University (with 46.7% Root Mean Squared Error) while leading a team of 5

• Predicted the rental price of Airbnb in New York City by using Random Forest and Boosted Tree

• Collected, cleaned and transferred over 25 thousand Airbnb rental records by leveraging dplyr package in R program

• Generated static data visualizations to present the final results by leveraging ggplot package in R program Database Designing and Implementation for Columbia Deli

• Designed and built 4-entity Database in PgAdmin with DML and DDL SQL

• Conducted and normalized Entity-Relationship Graph to show the database framework SKILLS

• Technical: SAS; R; Python; Microsoft Office 365 (Team, Outlook); Microsoft Office Suite (Word, Excel, PowerPoint); E-Portal

(USPAACC Internal Database); Salesforce; Quickbook; Hubspot; Canva

• Languages: English (fluent); Mandarin (native)

• Interests: Add hobbies and interests as an additional information

Contact this candidate