50 likes | 196 Views
Accountability & Transparency In Government Stimulus Tracking June 2009. Stimulus Spending Challenge . Distribution of funds to the parent Federal Agencies and their transfer agencies Agencies’ ability to execute spending plans and track obligations and expenditure transactions
E N D
Accountability & Transparency In GovernmentStimulus TrackingJune 2009
Stimulus Spending Challenge Distribution of funds to the parent Federal Agencies and their transfer agencies Agencies’ ability to execute spending plans and track obligations and expenditure transactions 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 Satisfies Federal accounting, internal control, & auditing requirements
Agency Challenges Solution Capability Stimulus Spending Challenge • Distribution of Stimulus funds • Reports on funds (expenditures & obligations) • Qualifying Programs • Sizing programs • Allocation of funds • Federal Grant Reporting (SF269, 270, 272 & FFR • Distribution of Stimulus funds • Identifying candidate programs • Qualifying Programs • Sizing programs • Allocation of funds • Interface toFederal Financial Data • Create Enterprise data warehouse • Establishes portal access • Include Nth tier reporting for Grants& contracts • BI intelligence • Phased approach to address near term compliance needs • 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 • Transparency • Provide interfaces to Federal system • Interface with Contractor financial systems • Provide access to public • Provide ad hoc reporting • Identify potential problem areas • Performance Accountability • Flexible creation of performance measures • Track metrics & links to financial data • Reports in dashboard tracking format • Identify non-performing programs • Performance Accountability • Develop performance measures • Track metrics • Report on performance
USAspending.govRecovery.gov Performance Reporting FFATA ARRAImplementation Public Federal Government Contractors, Subcontractors Grantees & Subgrantees Accountability &Transparency In Government Business Solution Proof of Concept Accountability Startup Phase Operational Phase Subcontracts Contracts/Grants Contracts/Grants Contracts Public Public Grantees Subgrantees World Wide WebQuery World Wide WebQuery Analytical Tools Analytical Tools Enterprise Data Warehouse Business Solution Portal Data Warehouse Data Warehouse Portal Portal Portal 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 PrimeObligations & ExpendituresFrom FAS Bureau of Public DebtCore Accounting System Other TARPData Collection – FFIEC HDMA & Dashboard Obligations Expenditures Data imports/exports FPDS/ FAADSObligations FPDS/FAADSObligations Initial Report Agents USAspending.gov Recovery.gov Performance Reporting Current Collection System Orion Microsystems New Collection System Contractor Expenditures fromAgency Core Accounting System Grant Expenditures fromAgency Core Accounting Systems Contractor / Grantee Analytics & Controls Subcontractors • Prime Contractor & Grantee Expenditures • Sub Contractor & Grantee Expenditures & Obligations from Core acct systems • BI Tools • Auditing • Internal Controls • Risk Management • Reporting SubcontractorExpenditures Contractors PrimeExpenditures
Orion Microsystems, Inc.American Recovery & Reinvestment Act – Proof of Concept Tier 1Prime Data Collection Tier 1 Prime Contractor/GranteeAccounting SystemTier 2 Data Collection Federal GovernmentCore Accounting SystemTier 1 Data Collection Orion Microsystems, Inc.Data Collection System Sub Tier 2Data Collection Orion Microsystems, Inc.Enterprise Data WarehouseNCCIPS – Stennis, MS PublicEnterprise Data WarehouseAccess