DOE's EM hired PPC to develop an Integrated Planning, Accountability, and Budgeting System - Information System (IPABS-IS) - a single information management system for all the programs and activities overseen by EM.
Integrated Planning, Accountability, and Budgeting System (IPABS) for DOE's Office of Environmental Management
The Department of Energy's Office of Environmental Management (EM) has a responsibility like no other - to clean up and contain the waste and contamination that is the legacy of the Cold War nuclear arms development program. An extraordinarily complex problem that encompasses different types of waste and contamination at 114 locations throughout the United States, solutions are expensive and will take years and, in some instances, decades to achieve. EM is aggressively pursuing accelerated approaches to achieve its goals. Pursuit of these goals requires a comprehensive, traceable, and consistent set of data.
Unfortunately, EM, in the early and mid 1990s, was a rapidly growing, complex organization without a consistent data source. EM's responses to Congressional inquiries, Departmental requests, and other inquiries were inefficient, labor-intensive, and inconsistent. Each organization within EM maintained their own data source resulting in overlapping requirements, variations across organizations, and repetitive reporting burdens on the field sites.
In 1998, EM hired PPC to develop an Integrated Planning, Accountability, and Budgeting System - Information System (IPABS-IS) - a single information management system for all the programs and activities overseen by EM. The goal of IPABS-IS is to meet all of EM's data and reporting needs using a secure web-based data collection and reporting system. IPABS-IS collects life-cycle cost, scope, and schedule data as well as budgetary, financial, performance metrics, critical milestones, and waste disposition information. Data input from 21 offices is now reported in a consistent format and time frame, validated and reviewed within the system, and maintained in a single repository.
PPC worked with EM to document their business process and system requirements. The end result is a system that meets all of their needs - IPABS-IS incorporates a flexible database model, corporate data warehouse, and reporting functionality. PPC integrated a COTS suite of business intelligence tools into this customized system and tailored them to the specific needs of EM. Users can produce standard "canned" reports and slice and dice various pre-defined data sets to produce multidimensional analyses. PPC also developed a workflow component of IPABS-IS that tracks the submittal of Baseline Change Proposals to the EM Configuration Control Board. Since development of IPABS-IS in 1998, PPC has maintained and updated the system to reflect requirement changes and additional functionality.
With more data, captured more efficiently and accurately, and more analytical tools to apply to the data, EM has not only streamlined its basic business processes but can now respond quickly, effectively, and reliably to tough questions from Congress, OMB, and other stakeholders.
Oracle 9i Database Server
Oracle 9i Product Suite
Oracle 9i Heterogeneous Suite
Cognos EP Series 7 MR2
Microsoft Visual Studio Enterprise Edition 6.0
Microsoft Windows 2000 Server/Advanced Server
Microsoft Windows NT 4.0 Server
Microsoft Internet Information Server 5.0
Netscape Directory Server
Microsoft Office 2000
ER Studio 6.0