{{brizy_dc_image_alt imageSrc=
Schedule Demo
{{brizy_dc_image_alt imageSrc=
Schedule Demo

Major DoD

Acquisition Activity

Learn how this government agency leveraged SNA’s Envision Data 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 to more powerful IPMDAR schema for Enterprise PPM.
  • 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. The agency's evolution continued with the adoption of the more powerful IPMDAR JSON file, opening the advantages of Enterprise Project and Portfolio Management (EPPM).

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 and non-proprietary data approach. SNA extended the capture of data down to essential tactical levels, including work package and element of cost. Combined with data from the Integrated Master Schedule, a complete integrated view of project performance was available for the first time.

SNA Software's data transformation solution, known as Envision Data Transformer, captures and transforms Aerospace & Defense industry standard schema transfer files, such as the ANSI X12 839 transaction set, the IPMR and IPMDAR standard files, as well as proprietary third-party file types, such as those originating from Microsoft Project, Open Plan Professional, Oracle P6, forProject, Deltek Cobra, IBM's DOORS, and Atlassian's JIRA, among others.

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

  • Transforming data from any source and loading into a common database of open-linked data tables that establish an open systems data lake
  • Direct connections to underlying data sources
  • Data enrichment entered by the user using a "shadow database" method.

"(Our) implementation of the Proteus and Envision solutions 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. With the evolution to IPMDAR CPD and SPD, greater insight, performance, and speed to data availability resulted.

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 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:
  • Compliance Management
  • Control Account Manager
  • Cost Analyst
  • Executive Management
  • Program Management Teams
  • Schedule Analyst
  • Risk Analyst
Program Management Review
Integrates program management metrics, provides flexibility through the IPMDAR schema, and offers customized information based on user roles.
EVM Child Drivers
Focused application that shows variance trending for an element, it's children and grand children to easily identify cost and schedule EVM variance drivers.
Integrated Project Management
Fully integrates cost and schedule performance metrics and analysis for EVM, GEAC, IMS, and risk information. Provides
Schedule Analysis with 14-Point Assessment
Visualization of the entire IMS, with features for drill down, schedule tracing, historical trending, performance metrics, reporting and ad hoc visualization and analysis.
Time-phasing Compare
Allows the comparison of two time-phased EV data periods, identifying discordant WBS changes and assisting in tracking retroactive changes for consistent planning and execution in cost performance progress calculation and reporting.
EVM and Schedule Performance
Reports and visualizes level 1 performance data across projects and programs to easily compare performance, providing data regarding differences among project and program performance, and future planning and execution data.

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.