Client Focus: Warner Bros.Role Highlights:- Research the vastly changing media landscape of content consumption and assess new ways to size audiences and accurately measure viewing behaviors across multiple platforms- Perform in-depth cross-platform budget split analyses for Warner Bros. Theatrical and Home Entertainment/Gaming titles- Create and improve upon Tableau Dashboards to inform clients of digital advertising performance, theatrical attendance and competitive advertising activity- Utilize Nielsen Media Impact/MRI Fusion data to define custom audience targets, analyze detailed media usage, input and assess plan deliveriesResearch/Planning Tools: - Nielsen Media Impact, ComScore, MRI, Simmons, Pathmatics, iSpot, EDO, Google TrendsData Manipulation/Visualization Tools: - PowerQuery, PowerPivot, PowerView, Tableau, SQL, Excel, Clickstream

Clients Include: Warner Bros., Experian, Hilton, Asics, eHarmony, Ancestry, Nest, Principial Financial Group, Levi's, ActivisionRole Highlights:- Performed in-depth cross-platform budget split analyses for Warner Bros. Theatrical and Home Entertainment/Gaming titles- Created and improved upon Tableau Dashboards to inform clients of theatrical attendance and competitive advertising activity- Utilized Nielsen Media Impact/MRI Fusion data to define custom audience targets, analyze detailed media usage, input and assess plan deliveries- Executed extensive segmentation analyses using multiple syndicated research tools to inform media targets and provide detailed persona profiles that support media recommendations.- Provided insight using segmentation models to inform clients, such as eHarmony and Hilton in advertising strategies using both traditional media, as well as digital and mobile platforms.Research/Planning Tools: - Nielsen Media Impact, ComScore, MRI, Simmons, Google Analytics, OmnitureData Manipulation/Visualization Tools: - PowerQuery, PowerPivot, PowerView, Tableau, SQL, Excel, Clickstream

- Build both reports and dynamic dashboards using the Microstrategy Desktop application for future self-service use by product analysts and executives.- Assist marketing and production teams with Omniture Site Catalyst tag creation and implementation, Provide ongoing Omniture reporting and ad hoc analysis using Site Catalyst, Discover and Test & Target.- Gather extensive requirements from business units and provide data warehouse team with detailed descriptions of all metrics needed by the users to achieve the automation of existing reports.- Provide ongoing daily and weekly reports to Marketing teams for Disney Online premium games, such as Club Penguin, Pixie Hollow, and Toontown. Reports are based on both automated queries using Microstrategy, as well as extensive manual queries using SQL.- Provide trending and insights based on data and work with Marketing and Production teams to implement solutions.- Based on growing needs and new product launches, create new and manipulate existing queries to provide meaningful results.- Assist in the conversion of manual queries to automated efforts in Microstrategy during both planning and user acceptance portions of the process.

- Monitor and report monthly/quarterly metrics by campaign and media channel.- Campaign management and data analysis for various media channels (direct mail, telemarketing, paid search, and online banner ads).- Work with list vendors to acquire and recommend ad-hoc lists for direct mail campaigns.- Work with data vendors and call center to ensure accuracy of data feeds.- Work with direct response team and production to guarantee timely execution of campaigns.

- Analysis of client-provided donor data using SQL Server 2005 and Microsoft Access to assist with recommendations for direct mail cultivation appeals and client strategy.- SQL script modification to refine or create new reports per departmental request.- Extensive usage of Microsoft Excel (incl. Pivot Tables, Linked Worksheets, Formula Creation, Subtotals), Microsoft Access (incl. Table Import, Query Creation and Modification), and Microsoft Word (incl. Mail Merge).- Supervision of enhancements to the direct mail database to include conception of new ideas for improving on planning, ordering, and reporting aspects of the database.- Analysis and reconstruction of merge/purge process for syndicated direct mail client in order to maximize list performance.- Coordination with Merge/Purge Vendor and supervision of data processing jobs.- Assistance in planning direct mail campaigns for various non-profit clients.- Analysis of results to provide list recommendations.- List Research with use of MIN, SRDS, and Simmons Data.- Purchasing of list orders, including negotiation of net name arrangements and invoice discrepancies.