Advanced Technology

• Aerospace and Defense
• Automotive and Industrial
• Environmental and Nuclear
• Jacobs Australia
• Contract Vehicles
• Scientific Research
• Systems Engineering Excellence
• Products
• Safety and Quality
• Careers
• Jacobs Engineering

Advanced Technology > SeaPort Enhanced

Database Architecture and Rapid Prototyping

Silvergate Software

For thirty years Silvergate Software has been providing software solutions to a multitude of corporations varying in type and size. Project experience, both past and present have consisted of application development, distributed database services, IVR to DB integration, web-based applications, and network management, thus providing a range of specialized services including, shipping, tracking, ordering, economic, and auditing capabilities to their customers.

Over the past several years Silvergate's focus has been primarily in support of the U.S. Department of the Navy (DoN). The Silvergate team has filled a critical need to the DoN by providing rapid development services so that mission critical data is captured quickly and presented in the most efficient and effective manner possible. This assures that each DoN customer can support their mission, collectively rolling upward to the main mission of supporting our war fighters.

Silvergate Software has stood up multiple software tools built around an integrated approach to the multiple, unconnected databases that manage and track this large project. These tools have been created for the Navy PMO, USMC PMO, MARCORSYSCOM, and SPAWAR.

Their team knows the NMCI databases, and how they inter-relate, and where they don't. This solid grounding in the data structures of the NMCI project gives further impetus to our rapid prototyping. When they get a new requirement, they know which database to get the data from and how to handle it. This ability lets tem quickly respond to emerging requirements, so that the software systems are propelling the solution rather than being reactive in nature.

One project combined all asset information from multiple data sources to produce a coordinated dataset linking NET, eMarketplace, monthly contract CDRLs, and lease documents by site code or by serial number across the enterprise. Silvergate then shared the data in a “drill-down” application showing listings by UIC and site code.

Another system applies contract logic to eMarketplace daily downloads to automatically calculate completeness of Order segments and then payment tiers, and then available cash deobligations, by site and CLIN group, for each month. A Command Budget system for the USMC links to eMarketplace daily. The system summarizes current expense information from eMarketplace by Task Order and UIC and integrates actual task order spending into the appropriate column for each UIC in the budget review screens.

Silvergate Software stood up a CM Tools website by automating their Access database and adding web browser interaction for users. This site provides and maintains a database of RFC documents.

They also developed and operated a Schedule Ratification Tool for enterprise-wide reconciliation and planning of NMCI seat rollout. This tool downloaded data from other databases and then provided a planning surface for two hundred users for about ten weeks, offered screens and spreadsheets by Claimant or UIC, and was stood up within 10 days of first request.

Another tool that they stood up for the Legacy Network Shutdown project. Again, converging data from multiple databases to provide a distributed group of users (regional transition teams) to review systems and server linking and planning.