Frank Shao Email & Phone Number

United States

New York City Metropolitan Area

• Conducted data analysis with R to measure email campaign performance, visualizing key metrics (open rates, CTR, bounce rates)using R ggplot, and compiled findings into a comprehensive PowerPoint report to inform subsequent marketing strategies• Utilized time-series analysis on Google Analytics data to identify a winter drop in email open rates and tailored content topromote indoor fitness activities and seasonal cooking recipes, countering seasonal trends to boost engagement• Executed content analysis and word clouds to pinpoint underperforming email subjects, driving a subsequent 30% increase in email open rates

New York City Metropolitan Area

• Boosted efficiency of local news audience re-engagement by 20%, company high, through making strategic changes of delivery method of content, informed by qualitative and quantitative research results • Leveraged SQL for data analysis of survey responses, identifying barriers to audience engagement and uncovering content consumption preferences in local broadcast news

New York, United States

• Utilized R machine learning for cluster analysis to identify key customer segments and purchase behaviors, leading to a 15% increase in targeted marketing efficiency• Increased potential customers’ willingness to purchase by 30% after conducting 5 focus groups and a survey with 300+ responses, gaining both qualitative and quantitative insights into customer attitudes towards traditional Chinese herbal medicine • Realized a 50% increase in customer trust, company high, by effectively presenting key data insights to the CEO through a persuasive PowerPoint presentation, which prompted improvements to the online consultation model

Boston, Massachusetts, United States

• Achieved an over 45% increase in daily visits to the official website in September 2021, tripling YoY growth, by crafting a compelling promotional article in two languages, demonstrating expertise in international marketing and language proficiency• Selected and evaluated films received globally and assigned prizes to outstanding filmmakers

Shanghai, China

• Scraped HTML using Python to conduct sentiment analysis and multivariate regression to investigate audiences’ watching habits on 200 TV series and provided company with professional report on current trend of streaming TV market• Built Excel pivot table to analyze box office performance big data by filtering film features and identifying patterns of audience tastes, uncovering factors that drive box office success, which resulted in actionable insights for improving existing scripts• Wrote and improved the commercial viability of a screenplay based on research results, helping the screenplay win a rank of top 60 out of more than 1000 scripts in the creative project market conference of Golden Rooster Festival• Convinced investors of the financial soundness of investing in company's scripts by presenting the results from our research• Scheduled, storyboarded and directed government-sponsored advertisement for four major theaters in Shanghai, including Shanghai Grand theatre and Shanghai World, with final video output presented on publicly owned media outlets

Master Of Science - Ms, Marketing Science - Marketing Analytics

A highly selective, industry-oriented program (5% acceptance rate) which combines PhD and MBA courses to provide advanced statistical.

Bachelor Of Science - Bs, Film And Tv, 3.82/4.00

Activities and Societies: BUTV 10 (Student Film Production Association)Dean's List

Business Administration And Management, General, 4.0/4.0

Dean's List