United States Navy
Naval Supply Systems Command
June 2014 – On going
The US Navy is a large SAP customer, and it needs a BI solution for its SAP (and non-SAP) data, for the same reasons commercial customers do. Naval Supply Systems Command (NAVSUP-BSC) led the Navy’s effort to integrate multiple commands’ SAP data into a consolidated warehouse.
Role of AGR, LLC
- AGR Provided PM and Lead architecture support on this effort to design and implement a BI solution for the Secretary of the Navy, Office of Financial Operations (FMO) with the capability to analyze financial data in support of the Navy financial auditability mandate. Assisted NAVSUP BSC to provide audit readiness support regarding Standard Accounting and Reporting System (STARS) data and providing monthly briefings to the Assistant Secretary of the Navy, Financial Management and Comptroller (ASN[FM&C]).
- Supervised Research & Development efforts that bring together partner technologies to create solutions to solve complex customer challenges. Loaded STARS data into Netezza appliance and brought down the queries runtime from 11 hours each to less than 5 seconds each.
- Built capabilities for end users to interact with this data through SAP Business Objects and through direct SQL query engine using Netezza native PostgreSQL language platform. Setup a program for mentoring and knowledge transfer to BSC civilian staff. Demonstrated Data.