Guanyi (Roxanne) Zong

*** * ******* ****. *******, IL60661 909-***-**** adgptd@r.postjobfree.com

EDUCATION

Northwestern University Evanston, IL

BA in Econometrics & Quantitative Economics, Art History Integrated Marketing Communication Certificate June 2019

• GPA: 3.5/4.0

• Relevant Coursework: Statistics, Econometrics, Behavioral Economics, Consumer Insights, Market Research, Communications PROFESSIONAL EXPERIENCE

Eduvantis LLC Chicago, IL

Associate Consultant September 2019-Present

• Perform data manipulation, forecast market trend and analyze primary and secondary market data with Excel, R, SPSS and STATA to form proprietary higher education data sets, which was used in every single client project

• Analyze primary market research, develop questionnaires, program surveys with Qualtrics and monitor surveys to capture target audience’s attitude as well as behaviors, create PowerPoint guided by actionable insights to inform clients’ business strategy, helped 4 clients reach seasonal sales goal

• Developed Tableau dashboard to enable clients visualize funnel data, provided accurate search ads audience targeting strategy

• Track client paid social, SEM and SEO marketing performance with Google Keywords and Google Data Studio, strategize client digital marketing through paid social content creation and brand persona development, helped 3 clients double ad conversion rate in the past year

Geometry Global Chicago, IL

Strategy Summer Intern June 2019-July 2019

• Researched and composed strategy on collaborating with 3 major retailers; updated, digitalized and mastered retail strategy tool

• Collected and analyzed MRI data, researched consumer trends on P2P and Mintel to produced strategy, insight and creative brief for Foster Farm product; brainstormed creative idea with 4 other interns to create campaign pitch

• Analyzed 2019 Cannes Lions winners’ strategic strengths, reverse-engineered briefs for strategy and creative team’s reference Egg Strategy Chicago, IL

Quantitative Brand Strategy Intern January 2019-June 2019

• Performed data analysis and visualization with SPSS, Excel and Gephi for 5 clients, created final presentation PPT

• Led 3-hour product design innovation session for CPG brand with 2 co-workers, finalized session result for client review

• Assisted 2 quantitative and 2 qualitative market survey design and test run, analyzed market survey results to extract insights

• Managed CPG project by actively communicating with vendor, tracking and fine-tuning survey results Qualitative Brand Strategy Intern June 2018-August 2018

• Conducted 12 in-home consumer interviews with 2 co-workers and client in Tampa and Chicago to obtain consumer insight for a Fortune 500 company, developed consumer illumination presentation deck for final client reporting

• Monitored online community for a major healthcare company, leading conversations and replying to consumers real-time, conducted social-listening to extract consumer insight for final client report

• Performed consumer data analysis, extracted insight from and participated in conducting 10 focus groups for 2 Fortune 500 clients, developed final reporting PowerPoint and edited final reporting video deliverable with QuickTime

• Researched on-going food industry trends and consumer reviews for a Fortune 500 client, presented research result to team, created brand positioning client presentation deliverable

• Researched trends for all industries in the US, created PowerPoint deck for future project trend usage, presented deck to strategists and company executives

CCB International Holdings Hong Kong, China

Market Research Intern July 2017-September 2017

• Researched the US and Chinese plastic surgery market, studied industry chain and pharmaceutical firms with Bloomberg, analyzed past due diligence reports, proved profitability of the market and presented results to firm executives

• Analyzed financial statement and stock performance of a Chinese food retail company, researched Chinese retail market, and produced report that led to investment decision

Hong Kong Stock Exchange Shanghai, China

Market Development PR Intern June 2017-July 2017

• Conducted quantitative market survey on New Board Securities IPO regulations, collected feedback from over 50 business leaders, compiled report on construction of new regulations

• Created social media post to market HKEX products and event news, updated pitch decks for HKEX product marketing SKILLS AND INTERESTS

Language: Mandarin (Fluent), French (Intermediate), Japanese (Intermediate) Skills: STATA, R, SPSS, SQL, Excel, PowerPoint, Word, Tableau, Google Analytics, Google Trends, Google Data Studio, Simmons

(MRI), Mintel, Gartner, Bloomberg, Qualtrics

Interests: Boxing, Triathlon, Visiting art museums, 19th Century European art, Hiking