Data Manager

John T. Rapps

***** ******* **.

Ashburn, VA ****7

Home phone: 703-***-****

Cell phone: 202-***-****

****.*****@*****.***

http://www.linkedin.com/in/johnrapps

Work Experience:

The Washington Post Company

Sr. Director, Data Warehouse, Washington Post Digital Labs

April 2010 - Present

. Leading the data warehousing infrastructure & tools development for

the Washington Post Digital Labs.

. Lead the reduction of the Omniture and DoubleClick processing cycle

from a 5 day business delay to next morning delivery for grain level

data. All ETL processing is done using Hadoop / Hive using Amazon Web

Services.

. Fixed Omniture processing logic and other warehouse errors that

improved accuracy from over 10% variance from Site Catalyst down to

less than 0.001% variance so that it can be used for deep analytics.

. Implemented quality controls to ensure accuracy of future processing.

. Report to the Chief Digital Officer, present to senior leadership and

work closely with Ad Ops, Research teams and technical groups to build

infrastructure to support data analytics.

. Testing the beta version of Tableau Software's desktop pro and server

analytics platform.

AOL

April 2003 - April 2010

Director, Data Warehousing, Reporting and Portal Platforms

December 2006 - April 2010

. Responsible for the roadmap, prioritization, development, data

privacy, data governance, and performance of the daily operations of

the Search Data Warehouse; Including Web Search, Local Search, Mobile

Search, International, and Partner implementations.

. Manage a multi-national development team across the US, India and

Ireland.

. Manage the reporting deployment of a custom web analytics platform

designed to replace AOL's use of Omniture.

. Lead the enterprise evaluation of Business Objects vs. Microstrategy.

. Rapidly matured the data warehousing, analytics, and knowledge

distribution environment for Search. Implemented enterprise-class

Business Intelligence tools and hardware infrastructure such as

Business Objects, OLAP, SAS, and Netezza to speed analytics and

discovery of new opportunities.

. Design and lead the development of custom analytic tools that use

warehoused data.

. Design and lead the development of a next generation intelligence

portal that included customizable dashboards and report presentation

in an easy to use but powerful environment. Portal is now rolled out

to all of AOL as an enterprise solution.

. Work in close partnership with the Search Business Intelligence team

to support all of their data and tools needs to support and drive

analytics.

. Team supports ad-hoc analysis and report development requests for all

of AOL.

. Lead privacy efforts for Search and work closely with legal to

establish policies and procedures to safeguard member privacy (PII,

personally identifiable information) while still providing the

business with the knowledge it needs. Hired to resolve issues with

AOL's Search data release in 2006.

. Experience working with CxO level executives.

. Top talent (top 1%) designation 2007, 2008, 2009

Technical Director, AOL Technologies, Portfolio Planning Lead

April 2004 - December 2006

. Manage the business relationship and data warehousing development

efforts for Marketing Analysis and the Member Management Campaign.

Provided executive level status/risks/directional recommendation on a

development portfolio size of ~ 40,000 hours.

. Lead a team of Product and Project Managers to proactively drive

analysis and data architecture requirements and lead the technical

delivery of the efforts. Skilled in authoring MRDs, BRDs, PRDs.

Skilled in all phases of the SDLC lifecycle.

. Assisted with the creation and initial management of the Billing

Consolidation PMO.

. Implemented new BIO capabilities around prototyping and data analysis

in an effort to speed project delivery for analytic teams and increase

the quality of data produced, stored, and consumed in the data

warehouse.

. Work with LOB leadership to develop the Access LOB data warehouse and

Marcom strategy. Evangelize and implement solutions to increase data

quality and accelerate development lifecycle.

. History of identifying, hiring, and developing highly talented teams.

. Very entrepreneurial, resourceful and interested in AOL's product

strategy. Submitted several new business concepts in an effort to

drive premium service subscription revenue; examples are 'eBay Tools',

'AOL video rental & download', 'Robust Online Children's Educational

Games', 'Clientless AOL - The PC Desktop GUI'.

. Restructuring of the Access business eliminated this role and the

Access BIO.

Product Manager - AOL Marketing

April 2003 - April 2004

. Defined and documented product requirements for Marketing Analysis by

working jointly with LOB leaders and the corporate data warehouse.

. Worked with BT development teams and project management to drive

development of the requirements through the SDLC lifecycle.

. Managed project scope, risks, and all customer interaction to ensure

that projects delivered the needed business functionality.

. Served as mentor to other Product Managers on the team.

. Promoted to Technical Director in April 2004.

Kinetic Storage

Co-Founder

2002 - 2003

. Conceptualized business opportunity for emerging market around storage

services provider software applications.

. Recruited business team, including previous manager and Chief

Architect of Core and Storage Services for Nortel Networks.

. Co-authored investor-grade business plan / pro-forma financials and

raised venture capital.

. Negotiated technology asset acquisition.

. Produced marketing collateral.

Nortel Networks

Sr. Market / Product Strategist, Consulting

2000 - 2002

. Developed investment grade business plans for consulting engagements.

. Defined market segmentation, pricing, sizing, in-depth product

descriptions, market requirements documents (MRDs) and delivered go to

market strategies for clients such as 360Networks looking to enter the

Bandwidth Provider / Internet Data Center / Web Hosting services

market.

. Developed investor-grade pro-forma P/L financials for market

requirements documents.

Network Solutions / Verisign

Sr. Manager, Business Reporting and Market Analysis

1999 - 2000

. Lead the executive performance reporting and marketing analysis for

Network Solutions' Knowledge Management Team for consumption by CEO &

GM.

. Lead the development of competitive analysis, market share reporting.

Managed analysis and presented findings to the marketing, product, and

executive team. Includes SWOT analysis, creation of customer and

competitor profile reports in support of product development and

strategic marketing plans.

. Oversaw management of mystery caller and customer satisfaction

research campaigns. Lead the management of call center reporting and

analysis for both our internal and outsourced call center operations.

SAIC

Data Warehousing Lead

1997 - 1999

. Lead the evaluation, design, development, and implementation of an

Internet accessible, web browser based data warehouse to report

performance of a custom CRM application for the Healthcare Financing

Administration (Medicare) in support of call center operations and

performance measurement for the Medicare Plus Choice program.

. Developed using Cognos Impromptu desktop client and Impromptu Web

Reports as well as their OLAP tools PowerPlay desktop and PowerPlay

Web.

. Responsibilities also included the co-development of the data

warehouse schema.

. Awarded a certificate of appreciation for the resulting positive

business impact the data warehouse and business intelligence had on

the implementation of the Medicare Plus Choice program. Managed a

staff of three reporting analysts and one statistician.

My Experience - Key Points

. Deft ability to successfully bridge the gap between business

information needs and technical teams to support marketing and product

development with actionable, timely data.

. Proven ability to reduce data availability lag to provide the business

with next day and intra-day data access.

. Proven ability to resolve data quality and privacy issues and put

operational controls in place to maintain quality without sacrificing

business intelligence needs.

. Proven ability in migrating to and making grain level data available

in high performance databases such as Netezza and Vertica for the use

by analysts.

. Proven ability to evaluate and make analytic tools selection and/or

design custom tools for the business to use to access data in the data

warehouse.

Education:

George Mason University

Executive MBA, 1998

Hofstra University

B.S. Marketing, 1990

Contact this candidate