Paid Search and Programmatic Display Team Lead. Responsible for the performance and management of all Search Engine Marketing and Programmatic Display, Audio and Connected TV client accounts across Google Ads, Bing Ads, Centro and AudienceX DSPs. Effective cross-team and client communication. Managerial responsibilities for direct reports including performance evaluations, one-on-one meetings, general oversight and continuous mentorship.

Develop initial keyword lists based on initiative and landing page relevancy.Upload assets (keywords, ad copy, campaigns and ad groups) to Google AdWords and Yahoo/Bing search engines.Configuration of Google Search, Display (GDN) and Yahoo Stream Ads.Perform search engine optimizations including bid adjustments, negative keyword inclusions and match type modifiersResponsible for all Insertion Orders and billing validation. Generate paperwork necessary for purchase authorization. Ensure media authorization matches IO amount for all initiatives.Bi-weekly and monthly SMR (Search Media Reporting) displaying key metrics; Clicks, Impressions, Average Position, ROI, ROAS and Conversions for all search media campaigns by engine. Reports are presented to the client and used to track overall campaign performance.Creation and maintenance of daily media tracker. Used to track pacing throughout for the entire flight period for all initiatives.Experience with RLSA account setup and configurationExperience with DCM (DFA) Ad serving and Double Click for Search Platforms.Maintain strong relationships with engine/vendor partners.

Responsible for all monthly and quarterly data processing and reporting for MEC’s largest client, AT&T.Data sources include Kantar Media, Competitrack, Comscore, Adresult and Nielsen Ratings.Data is used to measure clients media spend and reach across Paid, Owned and Earned media over period of four years, enabling the media agency and the client to develop marketing campaigns and strategies.Competitive analysis highlighting AT&T and major competitor activity (Verizon, T-Mobile, Sprint/Nextel).Data is also reported across all 210 DMA and MSA nationwide.Develop internal and external client dashboards via Qlikview 11 platform to visualize and trend media spend and reach across all media types.Dashboards include dynamic pivot tables for analyst driven reporting.Visualizations consist of various interchangeable charts and graphs highlighted media spend, reach (GRP) by demographic and dimensions such as creative, product, brand, daypart, etc. over time.

Create processes to accept incoming data from the Center of Medicare and Medicaid Services (CMS) and internal WellPoint systems via SSIS packages.Implement dynamic and user driven reports using sales and membership data using Microsoft Reporting Services, which are presented to executive management via a centralized reporting website. Develop SSIS packages, tables and stored procedures in SQL Server 2005 and 2008 to process and manipulate membership data.

Responsible for the creation, publication, and support of master data elements and structures.Oversaw master data publication schedules across public schemas in the data warehouse. Prepare Proof of Concept, Business Requirements/Functional/Technical Documentation and Use Case Scenarios for internal customers and senior management.Developed Oracle PL/SQL packages and procedures to transport master data from central repository to target schemas; perform validation against business rules to ensure data purity.Created various inbound (ERP system to data warehouse) and outbound (data warehouse to ERP system) data feeds.Created and maintain scheduled batch processes via IBM Tivoli Workload Scheduler.Provided continuous support of master data processes – system releases, bug fixes, program aborts, SQL tuning, mission critical resolutions. Developed/maintain Foreign Trade Compliance and Customer Master Inquiry web applications using Microsoft Visual Studio 2005 & 2008 C#. Net. Designed and developed application tables, stored procedures and database execution logic.Experience as a project leader; provided a project plan along with business, functional and technical specifications to a web developer. Responsible for successful implementation and on-going support.