market research, Pivot table, SQL, SPSS

Location:

Posted:

April 05, 2014

Wangshu (Selena) Guo

* ******* **., *** ***• Woburn, MA 01801• 617-***-**** • **********@*****.***

SKILLS: Proficient in Pivot table, SQL, SPSS, Photoshop, Constant Contact, MailChimp, SEO, Google Analytics, Google CRM, HubSpot

EDUCATION

Bentley University, Waltham, MA Jan 2014 – Present

M.S. in Marketing Analytics

Boston University, Boston, MA Sept 2010 – Sept 2012

M.A. in International Relations and International Communication

Concentration: Marketing and Regional Studies, GPA: 3.65/4.0

WORK EXPERIENCE

HopeRun Technology Corporation May 2013 – Oct 2013

Marketing and Business Development Assistant

• Developed new customers and promoted HopeRun’s products/services from existing client base

• Development of project infrastructure such as contact lists, data collection, databases, market segmentation

• Conduct Internet, telephone or direct-mail surveys or face-to-face customer satisfaction studies

• Develop current CRM (Customer Relations Management) system - custom Excel databases to track stimuli and compile survey

data for norm calculations

• Supports customer marketing, public relation efforts, and market development for high -level clients

Thermo Fisher Scientific Sep 2012-Jan 2013

Intern, Market Research Assistant

• Conducted market research on biosafety cabinet and CO2 incubator

• Produced reports and SWOT analyses on key competitors and global market and pricing trends

Brunswick Laboratories May 2012 – Feb 2013

Intern, Healthcare Marketing and Business Development

• Helped in research design and questionnaire development

• Developed SEO strategy by analyzing website traffic and quality links with Google Analytics

• Generated highly qualified inbound leads, contributing to $100,000 new sales

• Designed and maintained company website on HubSpot and WordPress platforms, helping adding creative modules and

writing online blogs

APCO Worldwide, London Summer 2011

Intern, Market Research Team

• Helped develop a digital media strategy proposal and pitch for University of Pittsburgh Medical Center

• Conducted background research on social media strategies for the GE Team Lotus Formula One project

• Researched and summarized media coverage for stakeholders and clients

Ruder Finn Relations, Beijing Oct 2008 – Jan 2009

Intern, Corporate Social Responsibility (CSR)

• Liaised with 40 media outlets and created press releases for the L’OREAL Women Foundation

• Planned and coordinated the Volkswagen China Green Olympics for Teenagers project

• Conducted monthly CSR spotlight issues research to support industrial CSR trend analysis

LANGUAGES: Fluent in English and Mandarin, basic knowledge of French