SYSTEMS INTEGRATION AND ANALYTICS

Project Summary

Modus in was retained to help design and implement an integrated Project Management and Project Controls system for our client. The goal was to have the managed system in place to support the first phase of a multibillion dollar 10-year project. While our client had previously purchased or upgraded its project controls tools for Cost, Schedule, Estimating and Risk management the systems stood alone and alignment and integration was not established.  Moreover, many of the processes and procedures the company had in place were made obsolete by the new systems and did not meet the needs of the enterprise.   

Our Solution

Modus provided comprehensive IT Service Management support for our client. Ensuring constant integration checkpoints with the broader organizational changes underway, our focus on the ground level needs of the Project Controls and Project Delivery Organizations and the decision-making needs of the Enterprise ensured the IT Infrastructure was designed to optimize Project Planning and Performance Reporting. Modus reviewed and updated all Project Controls and data governance documents and used them to generate detailed technical requirements for IT Organization to execute. Multiple attempts from IT in the past delivered solutions that did not meet business requirements, because they did not align with the needs and business considerations critical to the Project Management Organizations. 

During the design phase of the Enterprise (IT) Architecture, the organization’s requirement for a Cloud solution was identified. To accommodate cyber security requirements we assisted our client in establishing a hybrid solution with a mix of On-Premise and LoadSpring Cloud environment. Modus evaluated our client's Scheduling, Cost, Estimating, Risk and Reporting tools and work began to execute the upgrades, migration to the cloud and integration of the following applications. The applications themselves are important, but the processes and methodology undertaken by Modus will work for any IT integration challenge you may be facing.

 

  • Oracle Primavera P6 (Scheduling) 

  • Hexagon EcoSys (Cost) 

  • Sword ARM (Risk) 

  • Cleopatra (Estimating) 

  • Microsoft Power BI (Analytics) 

  • Microsoft SQL Data Repository with Power Apps (Data Warehouse) 

To establish an Enterprise Project and Portfolio Reporting system, a single source of truth for project planning and performance data needs to be established. When Modus started this job, each department used their tools to manage project data creating conflicting datasets and an inability to understand the ground truths. In many cases project data elements were duplicated across the systems, causing data quality issues. Modus was able to deliver the reporting solution by doing the following: 

  • Analyzed Project Data across all the Source Systems to establish the Master Project List (MPL) for the Enterprise’s Portfolio. 

  • Identified Master Source System for every Project data element, automate data transfer across different systems and generated Data Quality Checks to monitor mis-alignments across the systems.  

  • Designed custom interface solutions between the Cloud and On-Premise applications, including in-house custom toolkits, and a data repository of all the data from each system. 

  • Configured Primavera P6 environment to facilitate industry best practices on Earned Value Management (EVM), by using Physical Percent Complete. 

  • Enabled Primavera Extended Schema for full data integration to the Enterprise Data Repository. 

  • Generated Data Dictionary with definitions of all the Project Data elements. 

  • Deployed a Relational Database to provide a SSoT (Single Source of Truth) for Master Project Controls Data 

  • Modified in-house custom tools (Access Databases and Excel files), not supported by the IT organizations and integrated them into the overall solution. 

  • Designed and implemented Project and Portfolio Reports, including dashboards, which provided Project information to all stakeholders, at the right level of detail.  

 

Interested in working together?

519.368.3385
  • LinkedIn

©2020 by Modus Strategic Solutions