Technical Operations Report (TOR)

Problem

  • Lack of a reporting tool easy to use and obviates the labor-intensive way of putting together Tech Ops financial reports.

Approach

  • Designed a solution to extract “big” data from PRISM and DELPHI through a synchronized data pull operation using java standalone interfaces.
  • Implemented a Programmable Logic SQL interface to merge datasets from PRISM and DELPHI into a usable single dataset with records aligned.
  • Utilized existing resources to create flexible, time efficient, cost-effective customized applications.
  • Provided an external systems architecture highlighting the authentic agency financial data sources needed.
  • Ability to be deployed on newer technologies.

Result

  • Near real-time access to data in dashboard view of data from PRISM and DELPHI for accurate projections and EACs.
  • Consolidated view of operating costs and allocation status by cost center.
  • Reduced report cycle times from 2-3 weeks to near real-time
Man with device
 
 

<< Back to Case Studies

Corporate Headquarters at L’Enfant Plaza
955 L'Enfant Plaza SW, Suite 4500
Washington DC 20024

 

 

P: 202.650.6042


Close