Jialin (Janie) Zhao
** ***** ****, *** ***, New York, NY 10044 ******@***.*** janiezhao.weebly.com EDUCATION
New York University New York, NY
MS in Marketing Analytics 2014 – 2016
• GPA 3.7/4.0; Dean’s list for all semesters
• Relevant Course: Data Visualization in Tableau, Data Mining and Analytics with SAS, Digital Marketing (Social Media, Email and Paid Advertising), Web Bahavior with Google Analytics FudanUniversity Shanghai, China
BA in Sociology 2010 – 2014
• Major GPA 3.5/4.0; Awarded Merit Scholarship 2011-2014 (top 10% of undergraduate students) WORK EXPERIENCE
Snooky’s Custom Cake New York, NY
Marketing Consultant 8/2016 – Present
• Rebranded Snooky’s by restructuring website (www.snookysoven.com), designing new logo and creating Paid Social campaigns, resulting in 45% website traffic growth and 55% revenue boost
• Analyzed customer behaviors with Google Analytics to optimize website and social media performance
• Optimized website content and created new keyword lists to optimize SEO strategy, which has increased conversion rate and other KPIs
• Managed and executed A/B and multivariate tests to optimized the marketing messaging in the funnel to better deliver the value proposition of Snooky’s, and ultimately increased conversion rate by 25% BuzzBack Market Research New York, NY
Research Analyst 3/2015 – 8/2015
• Strategized with SVP to create concepts, pitches and reports to our clients and attended clients meetings with leading brands including Nestlé, Haribo, Dole and Elizabeth Arden
• Analyzed data with SQL and Excel on customer demographics, preferences, needs and purchase behavior to identify potential markets and factors affecting product demand
• Performed consumer insights analysis, social media research, survey pretests, brand awareness and campaign perception research, and visualized data with Wordle and heat mapping for reporting
• Collaborated with Sales, IT and UX teams to interpret clients’ business problems into technical problems and helped implementing new features into survey system Bain & Company Shanghai, China
PTA 3/2012 – 8/2012
• Worked with senior analysts and consultants for industry leading clients to determining the requirements of clients’ projects through secondary research to help fulfill clients’ business needs
• Performed lit search and data collection in retail industry to support projects progression
• Prepared reports and presentation deck with visualized data using Excel and PowerPoint, which were used for pitching to clients
DATABASE PROJECT
San Francisco Airport International Airport New York, NY Team Leader & Analyst 9/2015 – 12/2015
• Analyzed datasets of 3,100+ with SAS to built regression and predictive models
• Interpreted data findings into understandable results and actionable insights to present to client
• Created dashboard reporting in Tableau with visuals, index charts and graphs to simplify complex data SKILLS & CERTIFICATE
• Web Analytics: Google Analytics (certificated), Google Adwords (certificated), SEO/SEM, A/B Testing
• Data Analysis: SQL, SAS, SPSS, Excel (Pivot Chart, Macro, VBA)
• UX & Website: HTML/CSS, Squarespace, Weebly, Wordpress
• Data Visualization: Tableau, Wordle, Heat Mapping
• Social Media: Facebook Insights, Twitter Analytics