Panqian (Theresa) Yang Email & Phone Number

New York, Ny, Us

New York, Ny, Us

New York, Ny, Us

Data Analytics- Query and analyze large data sets from social media and e-commerce platforms using BigQuery and MySQL- Develop new metrics, analytical categories and scoring systems to evaluate brand digital health and marketing performance (consumer purchase intent, counterfeit rate, KOL identification, etc.)- Design reporting structure and illustrate data into visualized stories using Excel and business intelligence tools (Tableau)- Extract actionable insights to make strategic recommendations on digital content optimization and local marketing strategy (increase client brand followers by 40% and campaign engagement by 300%)Product Development- Construct and build customized keywords database, encode data analysis instructions, and identify machine-based outliers - Design, test and iterate delimitations and algorithms to improve the relevance of text analysis, sentiment analysis and emotion analysis- Identify process bottlenecks, responsible for data QA and cleaning, assist defining product roadmap and track progress- Illustrate UI/UX mockups and prototypes for Bomoda's website and SaaS product.Client Management - Lead client presentations and conversations during monthly meetings with APAC executives- Support and improve client decision making- Develop new business with existing clients and identify areas for improvementsClients: Bulgari, Ferragamo, Kate Spade, La Mer, Louis Vuitton, Jaguar Land Rover, Michael Kors, New Balance, Ralph Lauren, Shiseido Acquired by Weber Shandwick, a subsidiary of Interpublic Group (NYSE: IPG) in November 2017

- Composed and managed content focusing on B2B communications on social media platforms including Twitter, Facebook and LinkedIn- Designed infographics to build brand awareness- Monitored media coverage and identified potential opportunities for increasing publicity in collaboration with external PR agencies- Created strategic marketing solutions based on rich data sets, performed competitor analysis, and assisted in key influencer outreach- Wrote organic and advertorial pieces for a wide spectrum of clients on Weibo and WeChat

- Managed bilingual social media accounts (Wechat, Weibo, Twitter, etc.) with more than 1.8 million followers- Composed creative content (photography, video, infographic, etc.) to effectively build brand awareness and generate engagement with followers for advertisers- Created editorial report for clients and coordinated with PR agency for press coverage- Tracked and analyzed social media performance and trends to provide recommendations on a weekly basis- Developed marketing strategy for various media products, including print publication, mobile app, newsletter and website- Participated in new business development, influencer outreach and in-store VIP event planning- Clients included Estee Lauder, Nars, Tiffany, Berluti, Havas Media, Group M, etc

- Coordinated the re-branding campaign for the Missouri InterScholastic Press Association- Conducted in-depth competitor research and market analysis- Created the campaign blueprint book, redesigned the client's logo, and developed both print and interactive ads to help the client build awareness

Santa Clara, Ca, Us

Utilized online tools to optimize marketing solutions.Networked with consumer intelligence companies around the globe to get access to research sponsorships.Designed and conducted student insight surveys at both local universities and overseas institutions.

Columbia, Missouri, Us

Gathered and systematically reorganized local news data.Created a spectrum of graphics for the Columbia Missourian, a daily newspaper, to help tell the news stories more informatively.

Blackfriars, London, Gb

Provided various support to help the Lipton team promote the brand.Engaged in proactive and timely communication with regional managers, performed sales data reorganization, and assisted with identifying business trends and future opportunities.Gained good working knowledge of the Unilever reporting systems and sharpened the ability to capture information and incorporate it into spreadsheets and presentations (PowerPoint).Gathered and analyzed customer-specific and categorical data using SAP systems.

上海, Cn

Participated in the design and administration of the famous singing reality show "Chinese Idol".Brainstormed contest format, episode themes, and stage effects with other directors.Facilitated contestants preparation, video shooting and live broadcast.

Bachelor Of Arts - Ba, Strategic Communication, Minor In Business

Bachelor Of Arts - Ba, Broadcast Journalism