ORACLE FEDERAL FINANCIALS PROJECT CONVERSION

Challenge:

A large U.S. Government service support center was faced with a critical issue to convert all data from a legacy accounting system, including associated programs, interfaces, feeder systems, and processes that generated the data at a departmental level with 100% accuracy and complete reconciliation.

This would be one of the largest Federal financial system conversions in this country.

Solution:

The solution involved utilizing the skills and experience of Starry Associates staff as well as the experience of the Federal financial employees.

The solution was comprised of the following activities.

• Reviewed current requirements for the selection of the new system.
• Reviewed all Joint Financial Management Improvement Program requirements.
• Determined the best skilled and experienced staff.
• Reviewed all proposed functional and technical documents.
• Developed programs and processes to review and refine all documents and changes requested in requirements and testing to provide a high quality documentation and future deliverable.
• Developed a detailed project plan to address all data clean up, values, and data integrity issues within the legacy system.
• Developed a detailed project plan to address the complete conversion and training.
• Developed and completed 7 mocks conversion efforts.
• Developed and implemented both legacy and Oracle Federal Financial implementation reports to support the conversion reconciliations of data and values.
• Developed and implemented new procedures and business processes to support the conversion and future operations of the Oracle Federal Financial implementation.
• Set the percentages of acceptable differences between the mocks, where Mock 7 was to be, and was, 99.99 percent accurate with reconciliations and 100% with data integrity.
• Developed and implemented an accelerated conversion process that removed weeks from the expected conversion period.

Benefit:

The conversion of the Federal financial legacy system, and its associated interfaces and ancillary feeder systems, was completed on time and significantly under projected budget. The 99.99% accuracy of reconciled values and 100% of data integrity goals were met.

It was noted that this was the first time in the U.S. Government service support center group's history that such accuracy and integrity had ever been accomplished.