SPACER


GOV.NET® TO THE NEXT GENERATION - DATA AND REPORT REPOSITORY

Challenge:

The same United States Federal organization was later challenged with the need to expand Gov.net® as a service support center to accomplish the following requirements as they moved from the legacy accounting system to an Oracle Federal Financials implementation:

  • Maintain a repository of the legacy accounting system reports for historical purposes
  • Reporting archive solution for additional feeder systems as access to the mainframe was being shutdown
  • Provide a report repository for the Oracle Federal Financial reports to maintain the periodic reports and distribute to the user community
  • A web based application that would allow the user to print their reports to a local or networked printer
  • Establish a data archive to house the legacy financial system as access to the mainframe was being shutdown
  • Inquiry access to the legacy data archives for research and audit
  • The ability to limit the user's access to the master data repository allowing the user only data that was required to do their job

Solution:

Starry Associates identified this as an opportunity to expand the Gov.net® solution to the next generation, GovNetNG® a complete data and report repository. Starry Associates extended the web-based solution architecture so that the users could access the reports from various systems and the legacy data archives from their computer.

Starry Associates developed the GovNetNG® system, which became a full data repository including data warehouse and report archives.

GovNetNG® maintains the substantial security measures to ensure that each user gains access to only a portion of the data that they are given authorization to view, which was now upgraded to the Oracle Federal Financials user identifications.

Starry Associates provided additional training for the users and instructed the trainers so they can continue to perform the training for new users.

Benefit:

GovNetNG® now provides the Federal service support center with the following capabilities:

  • Supports the data archive from the legacy system (14 years of documents, approximately 18 million archived documents)
  • Response time to stored queries is under 2 seconds
  • Ad-hoc queries are generated from parameters usually execute in less than 20 seconds
  • Web based application
  • Saved the government agency over 19 million dollars from inception to implementation (amount determined by prices provided for the same report and data warehouse)
  • Delivered within 1 year as a full production system (other implementations of the same functionality was estimated at three plus years)
  • System expanded by 66% - transparent to user organizations
  • Expanded to support production reporting needs
  • Production system resources not required for multiple executions of the canned report cycles reporting
SPACER