Grain Processing Corporation (GPC), a leading U.S. manufacturer of corn-based products, needed a smarter, more efficient tool to capture, track, notify, and report daily Clean Air Act Title V compliance parameters for numerous emission sources and points at their various production facilities. GPC was using SharePoint to enter over 20 daily logs at two facilities and had to address several questions per log and per shift, throughout a two-shift day. Their system had no reporting or notifications, and there was no consistency between the forms in the system. The EHS manager would spend weeks searching through information to obtain the data needed for GPC’s annual Title V certification report and other reporting needs.

Honeywell, a Fortune 500 company specializing in diversified technology and manufacturing, was in need of an enterprise remediation data management system. The company sought a system that could safeguard and maintain the quality and integrity of their significant investment in generating site remediation data. They also wanted to ensure that this data was available for future use and could assure business partners of its reliable quality. Honeywell's existing data was scattered across stand-alone consultant systems, spreadsheets, and paper records, making it difficult to access and share within the company.

Chevron, a leading integrated energy company, had various remediation sites spread out across multiple suppliers throughout the United States. They had no way of determining where their environmental data was or what condition it was in. They did not truly own the data that they paid for during remediation projects. Charges were incurred each time sites were transferred between consultants, and the quality and consistency of the data was not being managed properly. They needed a single repository to manage their data, unify reporting and streamline the process of generating data tables.

San Jose Water Company (SJWC), a large water utility serving over a million people in the greater San Jose area, was in need of a more robust and comprehensive software solution for managing drinking water and general environmental compliance data. They were collecting routine and ad hoc samples from various activities and assets, and needed a solution to automate the entire process from sample planning to the preparation of regulatory reports. They also wanted robust data analysis tools to optimize their system operations and organizational performance, and integrated GIS to quickly view field and analytical data in real time.

San Jose Water Company (SJWC) is a tech-forward company that manages dozens of internal and third-party applications. However, they faced challenges in managing their compliance programs and environmental recordkeeping. The regulations required recording company activities, which were not very predictable and involved diverse records to maintain. Before this effort, records were all managed on paper and in Excel, with no validation or backup. This made it difficult to ensure data accuracy and completeness. For example, the annual report for NPDES Discharge Reporting required hand-reviewing a full year's records, verifying data accuracy, entering it all into Excel, running analysis as required by permit, and formatting data for submission to the state.

Honeywell, a Fortune 500 diversified technology and manufacturing leader, was in need of an enterprise remediation data management system. The company required a system that could protect and preserve the integrity and quality of their substantial investment in generating site remediation data, have it available for future use, and assure business partners that legacy data is of reliable quality. Their existing data resided in stand-alone consultant systems, spreadsheets and paper records that was not readily available and shared within the company.

Grain Processing Corporation (GPC), a leading U.S. manufacturer of corn-based products, was struggling with an inefficient system for tracking and reporting compliance parameters for the Clean Air Act Title V. They were using SharePoint to enter over 20 daily logs at two facilities, with several questions per log and per shift, throughout a two-shift day. Their system lacked reporting or notifications, and there was no consistency between the forms in the system. The EHS manager would spend weeks searching through information to obtain the data needed for GPC’s annual Title V certification report and other reporting needs.

The Environmental Data Flow Six Sigma improvement project was initiated in September 2009, driven by a cost-benefit analysis on data validation conducted earlier that year. The project aimed to improve LANL’s environmental data processing following receipt from the analytical laboratories. The project identified thirty-three process improvements, broken into seven subgroups. However, six of the improvements were never implemented, and two of the seven improvement subgroups did not lead to any cost savings but did lead to more accurate sample planning and increased transparency into the system.

Del Monte Foods, a large manufacturer and marketer of processed foods in the U.S., was struggling to meet its sustainability goals due to issues with data validation and manual report creation. The company was exporting data to spreadsheets to create reports, a process that was time-consuming and prone to errors. Del Monte needed a solution that would simplify reporting, ensure data quality, and make data more transparent within the company.