PROJECTS

Delivering total client satisfaction is the foundation of all of our projects. Browse this section to learn about projects we have completed to help our clients achieve their site and portfolio goals. Narrow your search by service, market, or region to view our experience on sites similar to yours.


Data Management System Consolidation

Montana State Superfund Site
Montana

Services Provided

Market

Data_management4
Laboratory and field analytical data for a site being managed under the Montana State Superfund program were originally maintained in two separate databases by two separate parties. Data contained within the two databases were similar but not entirely identical. Inconsistencies discovered between the two data sets began to adversely affect cleanup progress at the Superfund site due to eroded confidence by both parties in the completeness and accuracy of each database. Compounding the problem was the issue that information within each party’s database was not easily accessible by the other party in order to identify and resolve differences. The client decided to consolidate the data in a centrally located data management and document sharing system accessible by both parties.  

The client selected Trihydro to consolidate and host the project site data, including project documents, in Project Direct©, our custom data management system. The client and other party decided that Trihydro’s Project Direct© data management system would provide transparency in data management with its standardized laboratory analytical data loading tools and collaborative data validation, query, and spatial analysis tools.

Trihydro evaluated the two data sets and developed a migration plan, agreed upon by both parties, to address the most challenging aspect of the merge – assuring accurate data consolidation without losing data or loading duplicate information. Trihydro paid particular attention to keeping communication channels open between the two parties to resolve these issues. Scripted data migration methodologies were used to load the final vetted dataset into the SQL-Server based structure, document migration decisions, and  allow stages of the migration to be rolled back to a previous state in the event discrepancies were to be discovered. The two parties used Project Direct©’s data query tools to review and approve the accuracy of the merged data set.  

As part of the original project, Trihydro conducted classroom-style training on the use of the site’s full Project Direct© system to the client and other party stakeholders, and our support team continues to provide product technical support for the two parties.  

The merger of the two databases with input and guidance from the two parties allowed both parties to feel assured in the accuracy of important project data. Enhanced confidence by the two parties in the new and merged data, along with implementation of Project Direct© as a collaborative data management and document hosting solution, has allowed project stakeholders to easily access, analyze, and report on project data in support of project decisions.
Back to All Projects
"The quality of Trihydro's work matches the exemplary nature of the individuals performing them."
- Guillermo J. Silva-Wiscovich, Partner, Morell Bauza Cartagena & Dapena LLC

Trihydro’s success is based on working safely, maintaining high quality, and having strong project managers on the front line. Our considerable technical and regulatory expertise allows us to anticipate challenges, recognize opportunities, and strategically work with you to reach well-defined milestones and clearly defined end-state visions.

Headquarters 307-745-7474  |  Contact Us