**** Viktoria *******
**** ******** *****, *** ****, CA 95121 714-***-**** ****.*******@*******.*** linkedin.com/in/lenafrenzel lenafrenzel.weebly.com Summary
Excellent spreadsheet modeling and presentation skills Outstanding problem solving and analytical skills California State University Fullerton, USA Fullerton, CA Master of Arts in Mass Communications: Research and Theory (GPA 4.0) Expected graduation: August 2017 Master Thesis: Building a General Linear Model for Facebook Engagement Technical University Freiberg, Germany Freiberg, Germany Bachelor of Science in Business Administration (2nd best business student out of 150, ECT-Rank A) October 2014 Google, Inc. via Omega Solutions, Inc. & eTeam [Temporary Assignments] San Jose & Palo Alto, CA
Measured, tracked, and improved data quality management KPI’s to reach a achieve a 95% customer satisfaction rating, to streamlining processes to make them offshorable Digital Process Specialist January 2017 – March 2017
Retrieved SQL data from multi-billion-dollar ad campaigns across Facebook, Google, and third party ad providers
Cleaned, modified, analyzed and presented DoubleClick data in Tableau to internal and external stakeholders to help troubleshoot data discrepancies
YouTube Inventory Analyst March 2017 – Current
Analyze YouTube content for ad targeting, addressing concerns of advertisers seeing their ads alongside sensitive topics Traffik Online (Award-winning full-service advertising agency) [Temporary Assignment] Irvine, CA Marketing Intern promoted to Marketing Analyst promoted to Marketing Analytics Manager May 2016 – October 2016
In charge of a $4 million budget for the agency’s biggest client
Executed sophisticated quantitative analyses and advanced modeling which increased cross-channel leads by 46 % while reducing the cost per lead by 73% through identification of low converting marketing assets (email lists, Facebook and Google ads, marketing channels, and ineffective calls-to-action)
Analyzed research data and synthesized raw information into insights and recommendations for Facebook, Instagram and Google PPC, remarket, prospect email, and direct mail campaigns
Communicated findings of A/B tests, analyses, and optimization efforts to the senior leadership and creative team
Developed strategies based on synthesized insights, presented recommendations using dashboards and reports Nike, Inc. Berlin, Germany
Converse Marketing Intern February 2015 – June 2015
$3.15 million marketing campaign “Made by You”: Exclusive contact person for five global marketing agencies to create marketing material and Facebook & Instagram content, coordination of brand focus groups
$4.5 million product launch campaign “Chuck II”: Press releases and press events for product launch and trade shows Lovoo (Online Dating App & Competitor of Tinder) Dresden, Germany Marketing Analytics Intern April 2014 – August 2014
Researched and analyzed key business drivers, competitive environment, opportunities, trends, and performance of operating metrics in a daily, weekly, and monthly report assessing the utilization of the $12 million marketing budget
Reported on Facebook, Google PPC ads, and app downloads, directly addressing the CEO, CMO, and COO APP, Inc. (Supplier of i. a. Lamborghini, Boeing, NASA) Santa Ana, CA Marketing Intern promoted to Marketing Coordinator March 2013 – September 2013
Organized meetings with marketing agencies, point of contact between media requests and internal stakeholders YouTube Creator and Partner (Channel: Lucid Layla) San Jose, CA
Lifetime achievements: Over 800 subscribers and 667,000 views April 2007- Current Cert i f icates
YouTube Certified - Content Strategy -
Exclusive Brand Partner Program, 2017-2018
Google AdWords Display, 2017-2018
Google AdWords Search, 2017-2018
Bus iness Ski l ls
Quantitative and qualitative research
Marketing strategy and optimization
Quant i tat ive Research Ski l ls
Descriptive statistics, data visualization, hypothesis testing, sampling, survey design, execution and analysis, focus groups, content analysis, quasi-experiments, regression analysis, (M)ANOVA, t-testing, chi-square, General Linear Modeling
Data Anal ys is Tools
SPSS, Tableau, Microsoft Excel (vlookup, pivot tables, graphs, formulas), SQL IT Ski l ls
Microsoft Word, Excel, PowerPoint, Outlook, Adobe Photoshop, Adobe Premiere Pro, Adobe InDesign
Facebook Ads Manager, Facebook Insights, Facebook Power Editor, YouTube Insights, Google Analytics, Google AdWords, DoubleClick, diverse BI tools
German (Native), English (Fluent), French (Professional Working Proficiency)
Data and Business Analytics
San Jose, CA - cassandra, analytics, aws, etl, informatica,...
Web/iOS App Developer
San Jose, CA - selenium, automation, app, test, application,...
Data Analytics and Reporting
Santa Clara, CA - vba, analytics, sharepoint, tableau, metrics,...
Customer Service Social Media
San Jose, CA - german, social media, educational, game, germany,...
Developer Computer Science
San Jose, CA - ios, developer, api, cloud, pos, facebook,...
San Jose, CA - tableau, analytics, data analyst, hadoop, trial,...
Computer Science / Engineering
Sunnyvale, CA - jira, app, python, js, battery, sensor, android,...