Marketing Analyst

YIZHOU (CICI) CHEN

Brooklyn, New York, NY ***** ******@***.*** 319-***-****

EDUCATION

New York University, School of Professional Studies, New York, NY January 2019 - May 2020 Master of Science in Marketing Analytics GPA: 3.72/4.00 University of Iowa, Tippie College of Business, Iowa City, Iowa August 2014 – May 2018 Bachelor of Business Administration in Accounting, Minor in Psychology GPA: 3.13/4.00

• Iowa Scholarship for well performance new International Students – Cross all academic semesters TECHNICAL SKILLS

• Google Analysis Certificate, Google Ads Display Certification, SAS Certified Specialist: Base Programming Using SAS9.4

• Professional in Tableau, MS Office (Excel, Outlook, PowerPoint, Access, Project), MailChimp

• Advanced in R, SPSS, MySQL, Python

EXPERIENCE

ArmaVita Digital, LLC, Houston, TX

Marketing Analytics Trainee May 2020 – present

• Analyzed clients’ website results from Google Analytics and social media performance data to improve SEO/SEM

• Reviewed the projects with creative strategists and brainstorm marketing campaigns to achieve clients’ business objectives Swiss Chamber of Commerce, Shanghai, China July 2018 – January 2019 Marketing & Events Assistant

• Envaulted 300+ potential clients performance data to decide if they are qualified in the Membership Program using EXCEL

• Enhanced the benefits package plan for the Membership Program with 100+ existing partners

• Gathered business requirements from 600+ social media’ platform posts, promotions, and views Weekly Study Tour, Chicago, IL June 2018 – August 2019 Organization Founder & Leader

• Designed a 5-questions’ survey to collect 100+ potential customer’s idea of the hot selections of schools and programs

• Conducted a market strategy by using social media (WeChat followers) to increase engagement rates by +87% Deloitte China, Shanghai, China July 2017 – August 2017 Auditing Intern

• Interpreted Hong Kong financial report to understand the market value and seeking a potential corporation

• Prepared the 2017 annual Global meetings deck with the department high level strategy, roadmaps, and daily plans MARKETING PROJECT EXPERIENCE

Eight O’clock Coffee Rebranding (1st place) – Simmons Group Leader March 2019 – May 2019

• Extracted 20 + entity database for competitors’ customer and media expenses in Simmons

• Established 5 actionable metrics and 2 KPIs across marketing to align with business objectives

• Defined best marketing practices to creating & sharing business ideas to attract & engage audiences Lifestyle Discovery from Allrecipes - Excel, Tableau October 2019 – December 2019

• Cleaned and developed Tableau workbooks using 200K dataset from 2 data sources using Data Blending

• Created 4 interactive dashboards with Tooltips, selectable Dimensions and hover over charts (Tree map, heatmap, etc.) House Pricing Analysis - SQL, R November 2019 - December 2019

• Extracted 5K data from Kaggle, cleared the original dataset and transformed into 2K valuable data

• Randomly selected a sample size of 500 from the 2K data to understand the business and pricing insights using R ggplot2

• Optimized regression model by eliminating 20+ irrelevant/correlated variables OTHERS/ INVOLVEMENT

• Leadership Activities: Co-founder & Marketing Manager of Creative Entertainment Producer: Managed marketing promotion activities for 5+ CEP Offline Game Events and conducted monthly reports to track the working progress

Contact this candidate