Case Studies: Oracle

Saturn Systems was part of a team that developed an end to end solution which converted and migrated over one million legacy time and attendance records into the SAP based Navy ERP System. Project requirements established zero tolerance for conversion errors, which necessitated the development of an elaborate array of reconciliation software and processes. This large scale conversion effort involved a core management team of four persons, and ten NAVSEA sites located throughout the continental United States. In addition to developing the core conversion software, Saturn engineers created sophisticated reporting mechanisms to ensure the conversions were 100% accurate. All code was fully unit tested and system tested through a series of mock conversions before the final conversion was performed. Through extreme attention to detail and a focus on continuous process improvement over a period of eight months, the final conversion effort of over 1 million records was executed with 100% accuracy.

Saturn assumed a leadership and architecture role for the SPAWAR Enterprise Managed Services (EMS) application which is an e-commerce application that makes it easy for users to order and manage their critical telecom IT assets, while providing sophisticated financial and workflow controls to implement government mandated processes. The EMS application implements a tiered architecture using Java Server Pages (JSP) and Java Struts framework. The solution used BEA WebLogic Server as the application server and Oracle 9i as the database. Business layer components were created using Enterprise JavaBeans (EJB). Saturn's leadership and enterprise design skills made this project a great success.