Enterprise Data Management Office

Data Quality Team

Project Charter

Author Title File Name Last Edited

EDMO Data Quality Team Project Charter DQT_Project_Charter_v1.0.doc 02/04/2009

Data Quality Team

Page 1

1/25/2012

Version Table
Version 1.0 1.1 1.2 1.3 1.4 1.5 1.6 1.7 1.8 1.9 Revision Date 2/01/2008 Revision Comments Final DQT Author

Table Contents

Data Quality Team

Page 2

1/25/2012

Executive Summary..........................................................................4
INTRODUCTION........................................................................................................4 PROJECT OVERVIEW ...............................................................................................4 PROJECT OBJECTIVE .............................................................................................. 4 PROJECT BENEFITS................................................................................................. 5

Project Organization.........................................................................5
(EDMO) ENTERPRISE DATA MANAGEMENT OFFICE.......................................................5 TRANSFORMATION SOLUTIONS TEAM............................................................................6 DATA QUALITY TEAM - ROLES AND RESPONSIBILITIES.....................................................6

Project Scope....................................................................................9
ENTERPRISE SYSTEMS SCOPE....................................................................................9 AMCOM SCOPE (CCAD, LEAD DEPOTS)............................................................10

Audit Strategy .................................................................................10

OVERVIEW........................................................................................................... 10 AUDIT PROCESS SCOPE.........................................................................................10 DATA SAMPLING...................................................................................................11 11 DATA EXTRACTION................................................................................................11 MASTER DATA AUDIT TEMPLATE..............................................................................12 TESTING STRATEGY...............................................................................................12 SCORING & METRICS ............................................................................................12 AUDIT ACCURACY OUTPUT......................................................................................12 AUDIT RESULTS DATABASE....................................................................................13

Data Quality Team

Page 3

1/25/2012

Executive Summary
Introduction Welcome to the Transformation Solutions Integrity Sustainment Team. This Project Charter outlines the overall project scope, organization, roles and responsibilities, approach and processes for the Data Quality Team project. The Project Charter is a living document that is maintained and controlled by Project Management. The document is updated as required during the project, with the most current version available on the L: drive Data Quality project folder. Project Overview The LMP SAP enterprise information system(s) provides a comprehensive solution for the supply and maintenance of components for National logistics. This solution extends to other components, but the core of the solution is supply and maintenance for weapons systems. Supply and maintenance are dependent on accurate data to ensure that tasks are applied in the proper sequence and that the proper spare parts are ordered. The solution includes depot maintenance, so detailed product data is an absolute requirement; e.g., Bill of Material (BoM) variants, classifications, routings, equipment, materials, etc. This complexity plays to the strength of the SAP core enterprise software solution, only if clean and accurate data can be provisioned and maintained in the LMP production environment. The Data Quality teams current project initiative includes: 1. Provide team resources and work with user community to identify, extract, audit and report the validity and integrity of core master data cleansing activities and ongoing sustainment for the LMP SAP enterprise solution that support entities such as Depots, LCMCs, STAMISs, LIW and CVS. Project Objective Establish an enterprise data quality governance model, audit strategy, policy and procedures and approach that will support the current project data migrations and ongoing sustainment of core master data quality within the Army Logistics enterprise solution.

Data Quality Team

Page 4

1/25/2012

Project Benefits The SAP data environment is tightly integrated and the table relationships reflect the business process logic that is configured at the application layer of the SAP architecture to facilitate daily business process operations. If the data quality and integrity is not established and maintained, the SAP software will likely not execute properly, consistently and not achieve expected outcome. Establishing an enterprise data governance model that will facilitate the integrity and validity of the master data, processes and technology, for current data migrations and ongoing sustainment, will be vital to enabling the AMC enterprise environment to leverage its ongoing information as enterprise assets. This data governance modeled and approach, will directly impact three critical factors of the enterprise daily operations: 1. Increasing Efficiency 2. Lowering cost 3. Reducing risks

Project Organization
(EDMO) Enterprise Data Management Office

EDMO

Operations Officer

Deployment Liason

Info. Systems Support

Transformation Solutions

Data Migration

Integrity Sustainment (Data Quality)

Enterprise Transformation (Sales Components)

Data Quality Team

Page 5

1/25/2012

Transformation Solutions Team

Chief Transformation Solutions Blackshear, Mildred

Integrity Sustainment (Data Quality)

Enterprise Transformation (Sales Components )

Rice, Carrie

Benita, Back

Allen, Audra (GCSS/AESIP)

Knoth-Jez, A

Hulbert , Jerry

Colburn , Ken Lead Machado , Daniel Robinson , Richard

Reed, Dianna (LMP, LNO)

Rodrigues , (GCSS, KT Support )

Kennedy , chris Lead, AESIP McCoy, Terry

Yurcaba , Walt (GFEBS, LNO)

Shaw , Clifford

Stone, Dave

Data Quality Team - Roles and Responsibilities

Turner , John The purpose of this matrix is to define project roles and expected responsibilities assigned to Data Quality project team members. This CCAD matrix should be completed early in project planning, before detailed resource allocating or scheduling.
The goals of the roles and responsibilities matrix are to: Define roles and responsibilities of project stakeholders. Improve overall project team and stakeholder communication. Proactively identify gaps in assignments, accountability, or Data Quality Team Page 6 1/25/2012

resources. Clarify cross-functional interactions between project team members. Document project interdependencies with other enterprise initiatives. Define project team interactions with supporting resources and departments.

Project Role

Name

Responsibilities Champion for the project Provide vision and strategic goals Liaison to executive management Ensure availability of resources Remove program/project barriers Empower the team and support the decision making process Manage overall project initiative Manage and coordination of the internal working groups and contractor support Communication announcements for the organization and key stakeholders Risk Management Project Resolution o Scope or Project Change o Resource Resolution o Issue Resolution o Decision Resolution o Identify Program/Project barriers Scheduled Status Meetings o Project Sponsor o Project Team o Team Status Manage team-level project plan Manage team deliverables 1/25/2012

Project Sponsor Kline, Randy

Project Manager Blackshear, Mildred

Project Co-Lead

Rice, Carrie Back, Benita

Data Quality Team

Page 7

Project Role

Name

Responsibilities Project Status Reporting o Weekly o Issue o Decision o Resolution Process and documentation Reviews Day-to-day project management to ensure timeliness and quality of deliverables Coordinate project team resources Contribute knowledge and experience Development of process reviews, documentation and audit results Assist with Audit awareness, preparation and support of delivery and review Coordinate and assist remote extended team members Facilitate audit process and localization issues with remote extended team Manage logistics and scheduling for remote extended team members As needed support for Core Team and Extended Team deliverables

Core Team Rowden, Vance Stone, Dave Bunn, Andy Angeles, Gaby Hall, Jeff

Site Coordinator Turner, John Colburn, Ken

Extended Core Team

Kennedy, Chris Robinson, Richard McCoy, Terry Clifford, Shawn Machado, Daniel SMEs and CSC

Extended Team

Contribute subject matter expertise and specialized knowledge of business areas Execute and/or assist with audit validation and audit process

Data Quality Team

Page 8

1/25/2012

Project Scope
Enterprise Systems Scope
EDMO
Enterprise Systems View

LMP

AESIP

GCSS Army

GFEBS

LO

CECOM Communications & Electronics

AMCOM Aviation & Missile

TACOM Tanks & Automotive

JMC Joint Munitions

Purpose Provider of Customers (DODAAGs) & Vendors (RICs) in the Sale (CVS)

Purpose Field & Tatical Logostics

Purpose Financials & Asset Master FFMIA-COM

Pu Logistict Wa

Depots

Depots

Depots

Depots

Arsenals

Arsenals

Arsenals

Arsenals

Other

Other

Other

Other

Finance Acquisitions Distribution IBO Industrial Based Ops . Maintenance Mgt . PLM Product Lifecycle Mgt . SCP Supply Chain Planning WMIM Warehouse /Inv. Mgt.

Business Areas

Data/ Processes

Data Objects

Data Quality Team

Page 9

1/25/2012

AMCOM Scope (CCAD, LEAD depots) .

AMC Army Materiel Command

AMCOM Aviation & Missile Command

Depots

Arsenals

Other

Finance

IBO Industrial Based Ops .

Maintenance Management

Aquisitions

Distribution

PLM Product Lifecycle Mgt

SCP Supply Chain Planning

W Wareho

Business Areas
Accounts Payable Accounts Receivable GLA Balances Cost Centers Fiscal Year Budget Funds Mgt. Master Data Profit Centers Z OP Code Statistical Internal Orders BOM - Kitting BOM Wrkst./Rtg. Alloc BOM Re-Manfct. Production Orders Routings SDS Work Centers HR Admin HR Personnel Dev. Catalogues

Project accounting WBS Shells Customer Funding Tables Planned Cost

Audit Strategy
Overview

PR CCSS PO CCSS PR/PO CCSS PR CCSS DVDs PR SDS PO SDS MILSTRIP CCSS PR&PO MILSTRIP SDS PR&PO Purchase Ord. History

Funded Orders Direct Shp. DVD Ord. Loans Post-Post Orders Return Orders CLF Files TRI Files CAV II Tables MCA Tables Image Orders

Material Master BOM Provisioning Pricing Inspection Types MOE Rules Weights/Measures/Pkg/EH&S I&S Relationships Supply Chain Request WSSP

Demand Planning Tables FMS Tables Math Models Sales & Return History SPR Tables War Reserve Tables

Serial N Inv. Bal. Inv. Bal. Batch re Charact Classes Storage Handling

Data Objects

Current Data Quality Audit strategy is focused on LMP master data that has migrated from legacy systems and overall enterprise master data going forward. Defined critical master data elements related to business domains will be randomly sampled and validated by project Data Quality Team. Audit Process Scope First initial Data Quality audit will focus on critical Material Master data elements as it relates to the support of AMCOMs MRP/Scheduling operations.

Data Quality Team

Page 10

1/25/2012

Data Sampling The chart below represents the Industry Standard for Data Extracts of samples to determine data accuracy. The +/- 3% calculations will be applied to the individual data object types to arrive at the sample numbers that are requested to be pulled from the LMP solution.
Sample size for 3%, 5%, 7% and 10% Precision Levels Where Confidence Level is 95% and P=.5. Size of Sample Size (n) for Precision (e) of: Population 3% 5% 7% 10% 500 a 222 145 83 600 a 240 152 86 700 a 255 158 88 800 a 267 163 89 900 a 277 166 90 1,000 a 286 169 91 2,000 714 333 185 95 3,000 811 353 191 97 4,000 870 364 194 98 5,000 909 370 196 98 6,000 938 375 197 98 7,000 959 378 198 99 8,000 976 381 199 99 9,000 989 383 200 99 10,000 1,000 385 200 99 15,000 1,034 390 201 99 20,000 1,053 392 204 100 25,000 1,064 394 204 100 50,000 1,087 397 204 100 100,000 1,099 398 204 100 >100,000 1,111 400 204 100 A = Assumption of normal population is poor. The entire population should be sampled.

Data Extraction The current extracts for the Data Quality Audits will be manual data extraction utilizing current SAP access. Current initiatives are being explored to minimize the manual process overhead and implement a more systematic approach with the expansion of the Information Systems Support group application tool sets.

Data Quality Team

Page 11

1/25/2012

Master Data Audit Template

EDMO Data Quality Audit

Location: CCAD Date: Audit:M aterial Master Audit Focus: Scheduling
Testing Strategy

TBD Business Owner (SM E) TBD M SAP Technical Field NamesARC-FXHOR M ARC-DISLS The Data Quality team will coordinated all auditData Views toM RP 1 efforts required M RP 1
schedule, notify and deliver the audit package to the defined SMEs The SMEs will be responsible for executing the master data audit Planning T im e validation Dataaudit team. Fence Fields tasks and report the results back to the Data Quality

Lot Size

NIIN's - National Identification Item Num ber (Data Value) As part of the audit tasks, the SMEs will be responsible for defining root cause analysis, corrective action and the follow through for all data quality errors that are detected.
Scoring & Metrics Based on the sample data record extracts as defined in section 4.2, any defined sample data elements that are found to be incorrect; the complete sample data record will be marked as failed. Scoring will be reported to primarily reflect the overall record accuracy, but also to reflect overall data element volume accuracy. Audit Accuracy Output Based on the audit results received back from the SMEs, the Data quality team will review and compile the results into a Data Quality Audit Accuracy Report. This report will outline the audit results as listed below: Site Audit Area Audit Focus Sampling Population Accuracy Results

(Data Value)

Data Quality Team

Page 12

1/25/2012

Root Cause Analysis Corrective Action and Ownership

The Audit Accuracy report will be sent to the LCMC, Depot, and HQ AMC Executive Management and will provide an at a glance review of how well the deploying sites are doing in achieving data accuracy targets.

Audit Results Database Going forward, the establishment of an Audit Results Database will be necessary in order too monitor, mange and deliver timeline performance results as it relates to Quality metrics and any KPIs.

Data Quality Team

Page 13

1/25/2012