Adopt & Adapt Tips on Enterprise Data Management Annette Pence September 10, 2009

1. Adopt & AdaptTips on Enterprise Data ManagementAnnette PenceSeptember 10, 2009 MITRE

2. Center for Advanced Aviation System Development Center for Connected Government Command, Control, Communications, and Intelligence Center Sponsored bythe InternalRevenue Service (1998) Sponsored bythe Federal Aviation Administration (1990) Sponsored by the Department of Defense (1958) MITRE Is an Operator of FFRDCs The MITRE Corporation operates three FFRDCs, each under the sponsorship of a government organization. The work performed by an FFRDC is defined by a Sponsoring Agreement, unique to FFRDCs, that describes the context in which work is to be performed. MITRE 2 9/10/09

3. Currently Supported Federal Agencies DoD FAA Intelligence Community HHS USMC • Office of Foreign Assets Control DHS IRS CBP US Department of Agriculture DoED DoED National Institute of Standards and Technology DISA United States Visitor and Immigrant Status Indicator Technology Government Printing Office ICE Census Centers for Medicaid and Medicare Services NGA DoJ USAF MITRE 3 9/10/09

4. Data Mining The process by which data is managed from creation to storage to end-use and end of life cycle Internet Intranet Information Delivery Data Marts Functional Data Management OLAP Metadata Data Accessibility Project Management Data Quality COTS Data Structures Authoritative Data Sources Data Integration Data Management Data Transformation Distributed Systems RDBMS Enterprise Architecture Program Management Business Requirements Politics MITRE 4 9/10/09

5. Avoid the tug of war between people, technology, process and priorities MITRE 6 9/10/09

6. The Challenge • Massive information to store, manage, and access • Stored within stove-pipe, application-centric data stores • Duplicated across multiple environments • With unclear data definitions • Requiring appropriate attention to, and infrastructure for, ensuring individual privacy and information confidentiality • Characterized by questionable or uncertain data quality • And lacking sufficient integration and synthesis for analysis Every Government agency is data management challenged Without AppropriateData Management • Reduces ability to achieve program mission and assess program performance and outcomes • Elevates cost of operations • Increases risk to public safety • Diminishes public confidence Adversely impacts program and mission performance MITRE has an opportunity and a responsibility to address these challenges MITRE 5 9/10/09

7. Data Management Approaches MITRE • Engagement Scope • Federated – multiple agencies, similar mission • Enterprise – Organization focused • Program – Single Initiative • Enterprise Data Management Strategic Plan • Top Down • Enterprise Wide • Holistic • Program Specific Data Management Strategy • Data Management Assessment • Time boxed • Enterprise or program focused • Data Management Diagnostic • Program specific trouble shooting or optimization • Data Management Audit • Data Management Diagnostic 7 9/10/09

8. Some Things to Think About • Synonymous terms • Enterprise, company, corporation, organization • What about that metadata? • Do you need a separate repository? • What about tool repositories? • Who will use it? • Consider the economic payoff • If you can’t measure it, you can’t manage it • Turn time savings into $$$ • Understand the Roles • Some have gone away • Some have been combined • Some responsibilities have changes • Some places have no roles! • Be ready to explain ‘why’ anything and everything MITRE 8 9/10/09

9. Organizational Scenarios • Large data management organization • Responsible for the ‘all encompassing’ conceptual and logical models • Responsible for setting policy and standards • Responsible for operations and maintenance of databases and data structures • Sign off authority for all data and data structures entering in to the production environment • Large data management organization • Responsible for all encompassing conceptual models • Responsible for setting policy and standards • Responsible for physical design • Sign off authority for all data and data structures entering into the production environment • No central data management organization • Business Units entirely responsible for their own data and its management • Integration after the fact • Medium sized data management organization • Responsible for enterprise logical model • Responsible for physical design • Small data management organization • Responsible for policy and compliance monitoring MITRE 9 9/10/09

10. Best Practice Recommendations • Define the ‘enterprise’ • Focus on the area that has the most challenges • Identify and manage expectations • Identify and gain commitment of functional knowledge • Establish the foundation for governance and quality • Understand the benefits and boundaries of metadata and master data • Allocate enough time for training and transition • Adopt a framework for conflict resolution and decision making (entity equivalent to a Change Control Board) • Implement and execute continuous qualityimprovement • Be willing to compromise and look for a “win-win” situation MITRE 10 9/10/09