Summary:

Top-performing, highly accomplished manager with 15 years of experience. Analytical strategist experienced in media financials, accounting, system development and architecture, database design, warehousing, warehouse design, and cross-platform groups. IT experience spanning data conversion, consolidations of financial and internal media applications, and internal/external database support management. Seasoned budget management professional with innovative methods for cost saving initiatives and Business Intelligence. Areas of Expertise include:

Business Intelligence

Manager of business intelligence vertical for Univision Sales, Traffic, and Research department. Provide support for Tableau and Business Objects reports focusing primarily on linear advertising revenue, research and traffic reports.

Key Accomplishments:

• Managed the development efforts of building a visual dashboard focusing on advertising sales upfront data derived on near real time data from SalesForce using Informatic into Teradata. Change data Capture CDC measured on Upfront changes, YoY, and sales revenue flow.
• Developed reports in Tableau for sales team focused on advertising pipeline, upside/downside revenue, upfront timing report by office, demographic, agency, advertiser, and network.
• Architecture and managed the retirement of a legacy Kalido MDM/Enterprise Data Warehouse on Oracle/Kalido MDM hosting Univision Business on the Books which capture revenue streams from Interactive, Radio, Network, Local Station and Corporate Sales to a Teradata/Informitica/Business Objects/Tableau platform. 2 million dollar OPEX savings.

Confidential

Business Intelligence / Application Manager

Manager of business intelligence team and data architecture developers. Provide support for enterprise BI, primarily comprising digital and linear advertising revenue, programming rights, and finance. Developed and implemented strategic repositioning, restructuring, product development, fund-raising and full operational management for each business unit. Keen focus on raising standards of operations, risk management, advice, and client services capitalized on technological advantages and the global reach of a new, web-based economy.

Key Accomplishments:

• Developed a new group called Data Management within A E Networks. Group is focused on Business Intelligence, Data Security, Application DBA, Master Data Management, and Data Quality.
• Manage a large team of 10 .Net C developers supporting financial, revenue ad-sales and affiliate sales , on-air broadcast applications within a scrum agile mythology. Technology stack consisted of Microsoft framework, SOA, Oracle SQL Server backend supporting revenue system generating 5 billion in revenue.
• Managed the converting of A E Networks financial and revenue systems written in .NET from a calendar accrual system to A E parent Disney company fiscal accrual.
• Developed a BI architecture for business subject areas Content Management, Finance Ad Sales and Digital Ad Sales using separate data marts and unifying each data mart through a multi-dimensional business intelligence layer using MS SSAS cubes.
• Managed the development of a data hub using CDC technology in a data mart project focused on capturing near real time data of A E content Rights and Inventory Avails from source system Jaguar using SOA API to deliver data to consuming application. This lead to the retiring of several legacy VB API and high maintenance backend coding.
• Managed production and development Build and Run .NET teams within an agile methodology composed of sprints and jogs. Key focus was delivering quarterly releases for affiliate group and monthly releases for linear sales customers composed of new enhancements and bugs fixes using an on-shore and off-shore model.
• Managed CAPEX and OPEX budget lines within BI and development group.
• Created detailed, high-level roadmaps for budget planning and execution of capital projects.
• Improved business relationship with senior management for internal business by establishing and delivering monthly status meetings and progress reports. Fostered increased level of trust by meeting deliverables without changing dates or scope of projects while staying within a limited budget.

Confidential

Oracle Database Administrator/Database Architect

Managed both internal and external database teams, performed merit and assessment reviews. Assisted in managing consultants on Lifetime Enterprise Intelligence System EIS data warehouse project using Pentaho open source ETL software.

Key Accomplishments:

• Architecture, designed and project manage the consolidation of A E Lifetime databases and application servers to reduce licenses expenses.
• Created RFPs for storage overhaul of Lifetime data warehouse project and media asset management storage to address data warehouse ETL jobs performance needs and Digital Media needs for additional space.
• Assisted in designing Lifetime data warehouse EIS using a STAR and accumulative snapshot design for the subject areas. EIS allows the sales team to compare revenue, deals changes, and contracts attributes.
• Architect Data Model, Physical, Logical, ETL Lifetime Media Viewer LMV search engine. Architect is based on a fact table containing multiple entities in a tree structure to store information on Titles, Sub titles, titles media cuts, promos, secondary events, episodes, and series. Data extracted from multiple sources Content Media Rights, Adsales, Media Access Management, and Secondary Event Database .

Key Accomplishments:

• Created QTC data warehouse on Fujitsu PrimePower 450 Oracle 98 instance for ad-engines revenue reporting on Ask.com, iWon, Excite, MyWay, MySmileyCentral, and MaxOnline.
• Developed architecture, designed, and managed the consolidation of A E Lifetime databases and application servers to reduce licenses expenses.
• Managed multiple VLDB s in MySql, Postgres, and Oracle databases for search, unique address chaining, and retention reporting. Assisted in migrating and analyzing backend infrastructure of EMC symmetric to 3PAR data movers. Supported Vignette and apache web servers and services.

Confidential

Oracle Database Administrator

Key Accomplishments:

• Database modeling Star Schema, Data Marts, Data Warehousing for Pearson Education K12 project Higher Education and Cost Tracking Projects.
• Re-modeled Prentice Hall K12 salesforce data mart for faster response time and more accurate data result.

Confidential

Junior Database Administrator/Database Application Specialist

Key Accomplishments:

• Maintained several Oracle databases on Solaris and AIX IMB boxes.
• Planned new databases Physical and Logistical architecture.

Confidential

Consultant to Application Programmer

Key Accomplishments:

• Developed a Visual Basic application for marketing team to display monthly, quarterly, and fiscal sales forecast.
• Created store procedures in Sybase for top and slow-moving inventory.