PMG Global developed a mission critical data warehousing application, on a time and material basis, for Lockheed Martin and EPA. This was a 3-year project.
PMG’s data warehousing and Business Intelligence experts were brought in, post-Katrina, to help solve an urgent problem for the EPA.
Hurricane Katrina, as we all know, devastated the states of Mississippi and Louisiana. EPA was in dire need to determine the extent and nature of the pollution in these states. Tons of toxic chemicals and contaminants ranging from heavy metals and hydrocarbons to industrial waste, human feces and the decayed remains of humans and animals flooded every nook and corner of the affected areas.
In order to provide effective remediation, EPA turned to TRI – Toxic Releases Inventory Database to find solutions. TRI is a publicly available database that provides information on toxic chemical releases and other waste management activities.
TRI was a poorly architected database, as was the “Data Mart” that interfaced with this database. EPA was severely handicapped because report generation through this system was extremely slow (typical data warehousing reports would take 8- 10 minutes and the system would perpetually hang or crash).
Lockheed brought in PMG to solve the problem. PMG deployed an expert team consisting of a Senior DW Architect, ETL Administrator, Database Administrator, ETL developer and a Business Objects Report developer on this project. They completely re-architected the application and within a span of 30 days they were able to develop an interim solution that generated reports in less than 10 seconds as opposed to the earlier 8-10 minutes. PMG’s team then went on to move the application to a new data-warehousing (DW) platform that was built around Informatica and Business Objects, two industry leading products in the DW space. PMG’s effort was highly appreciated by Lockheed and EPA and what was initially a 90-day assignment turned out to be a 3-year project for PMG Global.