Account: Bacardi USA

Account: McDonald’s Global

• Spearheaded development of measurement plans prior to campaign launches, accounting for clients’ marketing funnel objectives, historical performance, and budget to select KPI’s and benchmarks for each channel; presented plans to internal teams and clients • Onboarded 5 new brands to the agency’s portfolio; managed floodlight tagging process for website launches and updates, and created new data feeds for visualization and reporting purposes• Leveraged Tableau to construct both client-facing and internal dashboards for real-time performance monitoring; created ETL maps in coordination with engineering team to establish data feeds; involved constant QA, communication, and decision-making• Fashioned logical, narrative-driven decks in PowerPoint to present to the client on various reporting cadences; involved managing multiple internal teams to provide input on data interpretation, and acting as brand expert to field client questions• Extensive experience with Google Analytics, Campaign Manager, Search Ads, Meta Business, and more; often used for daily ad hoc requests via exports to Excel, aggregation with other reports using Excel functions for analysis and organization through pivot table creation for quick deliverables if Tableau feeds had not been established• Special Project: assisted Insights & Strategy team by reviving an old dashboard with new Kantar data to be used in pitch presentations; involved manipulating raw data files, feeding into Tableau dashboard, creating new calculated fields & parameters to adjust to new datasets, and updating aesthetics for ease of use and enjoyable functionality

• Responsible for compiling and distributing weekly, monthly, and quarterly marketing and sales reports for entire franchise (16 stores); directly contributing to marketing decisions made by management• Developed detailed reports by extracting data from multiple sources, organized in Excel, delivered to Corporate via Google Drive• Organized and distributed store-by-store reports in multiple forms by separating store specific data• Spearheaded report analysis, distributing: monthly and quarterly KPI’s; weekly Appointment Goal by store; monthly ROI’s for direct mail, newspaper, and open house marketing; monthly and quarterly NPS; monthly Market Data; quarterly sales meeting (multiple reports); etc.• Assembled mailing lists from company database containing thousands of customers per store for open house events; organized, cleaned, and protected sensitive material

• Worked with Quality Assurance department to identify and report any flaws in the company’s website on various browsers• Contract comparison for General Counsel; reviewed client contracts for potential unauthorized edits or discrepancies, requiring careful attention to detail• Compiled reports for sales department; used Bloomberg terminal to gather information used by Sales for company analyses