Digital Marketing Data Analyst

JIAYUAN (Jocelyn) HAO

******@********.*** New York, NY 10025 917-***-****

https://www.linkedin.com/in/jiayuan-jocelyn-hao-8a3186137/ SUMMARY

Analytical and outcome-driven professional with demonstrated experience in forecasting and interpreting trends to develop effective business strategies. Good at using R, SQL, and noSQL tools to do the analytics work. EDUCATION

Columbia University in the City of New York, New York, USA Master of Science in Applied Analytics, December 2020 University of Shanghai for Science and Technology (USST), Shanghai, China Bachelor of Arts in English for Finance and Investment, June 2018 Queens College, New York, USA Bachelor of Arts in Finance, June 2018 ACADEMIC EXPERIENCE

Relevant Coursework Columbia University

● Applied Analytics Frameworks & Methods(The use of R); Applied Analytics in the Organizational Context; Managing Data (SQL, Java, nonSQL and Python); Strategy And Analytics(The automation strategy case for Fedex); Research Design; Storytelling With Data

Kaggle Competition Data Analyst

● Processed and cleaned large dataset individually containing 30K records and 96 variables from Airbnb NYC housing list

● Developed prediction models integrating Linear regression, Logistic Regression, and Random Forest with the lowest RMSE of 65.77

PROFESSIONAL EXPERIENCE

People’s Bank of China, Beijing, China

Intern, Apr 2019 – Aug 2019

● Joined the program to create “Regulation of Financial Holding Company"

● Translated English resources such as law files and news into Chinese

● Brainstormed and discussed how to learn other countries’ experience and adapt it to China ZARA (the main brand of the Inditex group), Shanghai, China Showroom Communication Intern, Nov 2017 – Jan 2018

● Organized and displayed samples; selected most attractive products to display in showroom

● Recorded and organized borrow-return information for media advertisements

● Completed a weekly report on the fashion cycle and sent it to headquarters

● Translated the name and description of new products, and information of models from English into Chinese

● Assisted the opening ceremony of the creative branch in Longemont Shopping Center, responsible for the communication part of media day with Public Relation agency, KOL, magazines and other media GE Medical Systems Trade & Development (Shanghai) Co., Ltd., Shanghai, China Healthcare Life Science Marketing Intern, June 2017 – Sep 2017

● Supported digital marketing work by operating the company WeChat account - GE Life Science, attracted thousands of users through designing layouts, posting attractive articles and active interaction with followers

● Helped on-site campaigns, responsible for planning warm-up activities, inviting customers, arranging site of the activity MSL Group (China), Shanghai, China

Digital PR Intern, March 2017 – June 2017

● Wrote and typeset articles for MSL WeChat account, wrote and released news, clipped information on press conferences

● Supported the campaign of Volkswagen Group at 2017 Shanghai Auto Show, including media reception, site guidance, user engagement, etc.

EXTRACURRICULAR ACTIVITIES

Young Volunteers Association, USST, Shanghai, China Member, October 2014 – June 2018

● Taught children in orphanages, helped the old, and foreigners in stations. Publicity Department, 1906 Café, USST, Shanghai, China Key Member, March 2015 – June 2017

● Created posters for offline marketing activities and websites for online campaigns Editorial Department, Students Union, USST, Shanghai, China Minister, October 2014 – October 2016

● Led a group of ten to report school activities of different sizes, reviewed news photos and articles, made improvements according to students’ opinions

Contact this candidate