Challenges

1. Accountability & Transparency In GovernmentFederal Financial Management Enterprise Data Warehouse Business SolutionAugust 2010

2. Challenges • Distribution of funds to the parent Federal Agencies and their transfer agencies • Agencies’ ability to execute spending plans • Transparency of funds – grants, contracts, and loans • Performance Management – collection and reporting of metrics & related financial management data • Ability to get something up and running quickly - COTS • Data accuracy with limited redundancy and reconciliation

3. Challenges & Solutions • Distribution of funds • Reports on funds (expenditures & obligations) • Qualifying Programs • Sizing programs • Allocation of funds • Federal Grant Reporting (SF269, 270, 272 & FFR • Distribution of funds • Identifying candidate programs • Qualifying Programs • Sizing programs • Allocation of funds Solution Capability Agency Challenges • Interface toFederal Financial Data – Agency & Treasury • Create an Enterprise Data Warehouse • Establish portal access for the Public • Include Nth tier reporting for Grants & contracts • Integrate BI software • Phased approach to address near & long term needs • Transparency • Provide interfaces to Federal system • Interface with Contractor financial systems • Provide access to public • Provide ad hoc reporting • Identify potential problem areas • Transparency • Leverage existing interfaces with Federal systems • Captures all levels of funding across Federal grants and contracts. • Provide phased approach to meet near term compliance goals and long term tracking objectives • Provides quick financial view of programs • Performance Accountability • Develop performance measures • Track metrics • Report on performance • Performance Accountability • Flexible creation of performance measures • Track metrics • Report on performance

4. Public Federal Government Contractors, Subcontractors Grantees & Subgrantees Transparency & Accountability in Government Business Solution Accountability & Transparency Startup Phase Operational Phase Contracts/Grants Contracts/Grants Subcontracts Contracts Public Public Grantees Subgrantees World Wide WebQuery World Wide WebQuery Analytical Tools Analytical Tools Enterprise Data Warehouse Business Solution Portal Portal Portal Portal Data Warehouse Data Warehouse Business Intelligence Business Intelligence Agency Financial Management SystemsAccounting – Asset Management - Procurement – Budget FPDS- FAADS Agency Financial Management SystemsAccounting – Asset Management - Procurement – Budget – FAADS/ FPDS Initial TARP Data Collection for Prime Obligations & ExpendituresFrom FAS Bureau of Public DebtCore Accounting System Other TARPData Collection –FFIEC HDMA& Dashboard Obligations Expenditures Data imports/exports FPDS/ FAADSObligations USAspending.govRecovery.gov Performance Reporting FFATATARP & ARRAImplementation Contractor Expenditures fromAgency Core Accounting System Initial Report Agents USAspending.gov Recovery.gov Performance Reporting GLOWS Corp Grant Expenditures from AgencyCore Accounting Systems SubcontractorExpenditures Subcontractors Contractor / Grantee Analytics & Controls • Prime Contractor & Grantee Expenditures • Sub Contractor & Grantee Expenditures & Obligations from Core acct systems • BI Tools • Auditing • Internal Controls • Risk Management • Reporting SubcontractorExpenditures Contractors PrimeExpenditures

5. Challenges – Discriminators - Crosswalk • Challenges • Near Term Implementation *30-60 days) – Long Term Migration Plan • Financial Management Challenges • Information Technology Challenges • Data Analysis Challenges • Top 10 Discriminators • Commercial Off The Shelf (COTS) Software - Hardware & Software Applications Available Immediately • Parallel processing architecture to provide accelerated response time • Addresses both short-term and long-term requirements, i.e., Sub-Tier Data Collection & Reporting, including Grants, Contracts, Loans near term 2nd Tier reporting & long term nth Tier reporting required by FFATA & ARRA • Performance Data Collection & Dashboard • Federal Grant Reporting (SF269, 270, 272 & FFR) • JFMIP & FSIO based system supporting current Account Classification Coding Structure (ACCS), accounting, internal control, & auditing requirements • System Integration capabilities with Federal Government • Web design/development business intelligence tools , hosting and enterprise data warehouse capabilities. • Financial Management experience and audit controls • Business Intelligence capability • Lockheed Martin • KPMG • GLOWS Corporation • KPMG • GLOWS Corporation • Lockheed Martin • GLOWS Corporation • Lockheed Martin • KPMG

6. Transparency & Accountability In Government Teaming Partners & Responsibilities • Lockheed Martin • Contract Management • Project Management • Software Development • Web Interface design / development • Systems Integration • Host Server • Enterprise Data Warehouse (EDW) • Analytical Tools • Data Analysis Support • Business Intelligence Support • KPMG, LLP • Business Analysis • Accounting Process Support • Internal Control Support • Risk Management Support • Data Analysis Support • Business Intelligence Support • GLOWS Corporation • Expenditure Data Collection • Performance Data Collection From: • Performance Reporting – Dashboard & Analysis • Financial Management Reporting • Financial Regulatory Reporting • Financial Audit Reporting • Data Resources • Internet Web Reporting: • Expenditure – http://usaspending.gov • Obligation – http://usaspending.gov/ • Obligation Data Collection • FPDS – GSA Website • FAADS – DOC/Census Website • Expenditure Data Collection • Treasury Government-wide Accounting System • Agency Core Accounting Systems • Agency Recipient Accounting Systems