GET STARTED 

Question about a feature?

Get in touch with one of our solutions experts to get your questions answered or schedule a short demo and see how quickly we can unify your data.

OR

GET STARTED 

Major DoD

Acquisition Activity

Learn how this company leveraged SNA’s Software Proteus Transformer to increase efficiency and cut labor costs.

Improvement Of

68.6%

On Business Value Index (BVI)

Total Savings

$5.46M

Direct cost savings over 7 year period

Goals Achieved

  • Early adopter of the IPMR schema in DoD.
  • Transitioned from outdated, labor-intensive data reporting processes.
  • Achieved significant reductions in data analysis lead times.
  • Improved data accuracy and fidelity, enhancing program performance insights.

Background

The client undertook a significant transformation by adopting the Integrated Program Management Reporting (IPMR) schema. This move set a precedent within the Department of Defense (DoD) for effective data management and reporting.

This was the first large DoD buying activity to implement the use of the Integrated Program Management Reporting (IPMR) schema on a comprehensive basis, including the new Formats 6 and 7 files.


During the initial proof-of-concept, SNA Software was found to be the only company with a complete IPMR solution using a COTS approach, which SNA had extended to capture data down to the work package and element of cost, as well as schedule (the Integrated Master Schedule, or IMS). Simultaneously, OSD also established the DoD Central Repository for submission of all program management data requiring EVMS submissions.

SNA Software's data transformation solution, known as Envision Data Transformer, leverages Aerospace & Defense industry standard schema transfer files, such as the ANSI X12 839 transaction set, the IPMR and IPMDAR standard files (as well as other various third-party proprietary file types).

Comprehensive data integration was possible using the SNA’s Fabric Architecture with three main methods:

  • Rationalizing data from separate sources into a common database
  • Direct connections to underlying data sources
  • Data enrichment entered by the user using a "shadow database" method.

"(Our) implementation of the Proteus IPMR schema solution revolutionized our data reporting process, significantly reducing lead times and improving data accuracy."


– Program Manager

Implementation

Our client implemented the IPMR schema, which included Formats 6 and 7, providing detailed insights into work-related activities. This transition enabled the application of predictive analytics and improved the timeliness and relevance of data available for decision-making.

Envision Data Transformer was used to create the necessary files for monthly deliverables (ex: IPMR Format 1-4). Government personnel also used Envision Data Transformer exporters to convert proprietary or legacy file formats into the industry standard schema’s so data is normalized with a repeatable and easy to use process. The Envision Database mirrors the IPMR and IPMDAR schemas with additional reporting tables and procedures added in, ensuring an objective non-proprietary structure should a government activity purchase a different solution.

Proteus Envision Envision Dashboard Apps were applied to automate previously manual direct labor efforts, supporting the drawdown of approximately 10 to 15 FTEs

Introduction of automated data capture, transformation, and load (ETL) as well as capture of more in-depth and relevant datasets through neutral schemas, eliminating redundant proprietary file submissions related to the integrated master schedule.

Reduction of

50%

In Manual Labor

some of the applications used

  • filter by role:
  • Analyst: Risk
  • Program Management Teams
Risk Mitigation and Response Planning
Ability to plan assign and track mitigation plans through out the risk lifecycle.Ability to integrate schedule with mitigation plans Ability to assess mitigation plan effectiveness vs planned.
Risk Register
Easily import or export data. Then easily score and prioritize risks. Customizable fully to meet your specifications.
Project Portfolio Risk Analysis and Management
Approve, assess, and manage risks at various levels, assess their impact across the organization, create custom reports for different user groups, customize risk assessments and reports for organizational groups.
  • 1
  • 2

Results

The transformation resulted in a significant reduction in lead times for data analysis and reporting, from 30-45 days down to just a few days. Additionally, the accuracy and fidelity of data improved, enhancing program performance insights.

The estimated cost savings since 2015 are approximately $700K in direct software sustainment costs. Additionally, the reduction in direct labor associated with data management and the establishment of a tighter qualitative feedback relationship between the PMO and its suppliers contributed to the overall success of the project.

Improved efficiency and cost-effectiveness in data collection, leading to significant cost savings and cost avoidance.

Direct software cost savings of about $100,000 a year pre-Envision implementation, spread across nine hubs and about 90+ users

Improvement of :

39%

Intrinsic Value of Information (IVI)

Value of cost avoidance in effort and redundancies:

$2.08M

Over five years.