Delta Air Lines is the world's largest airline. From its hubs in Atlanta, Cincinnati, Detroit, Memphis, Minneapolis-St. Paul, New York-JFK, Salt Lake City, Amsterdam and Tokyo, Delta, its Northwest subsidiary and Delta Connection carriers offer service to 368 destinations in 66 countries and serve more than 170 million passengers each year.
E2 is currently managing a project to integrate newly acquired Northwest Airlines (NWA) business into Delta's ongoing implementation of a (COTS) software solution for the following environmental business processes:
Compliance Management
Air Quality
Chemical Inventory
E2 has been assisting Delta's EMIS team with reviewing the initial deployment of the software started by pre-merger Delta and formulating plans for system upgrade and deployment to pre-merger NWA stations.
The project includes leading the discovery of Delta's current implementation scope/progress; identification, documentation, and communication of NWA's business requirements; assisting Delta's EMIS team with an upgrade of the application; and supporting a coordinated implementation of the application for both the Delta and NWA's sides of the business.
The project includes leading the discovery of Delta's current implementation scope/progress; identification, documentation, and communication of NWA's business requirements; assisting Delta's EMIS team with an upgrade of the application; and supporting a coordinated implementation of the application for both the Delta and NWA's sides of the business.
Northwest Airlines
Prior to Northwest Airlines (NWA) acquisition by Delta Airlines, E2 was contracted to develop a solution design for management of a wide variety of environmental information. Functional requirements considered in the strategic plan and solution design were:
Compliance management / Task Tracking
Forms Management
Key Performance Indicators (KPI) / Metric Roll-Up
Facilities information
Chemical Inventory / Hazardous Materials
Waste management
For each functional area, E2 assessed current work practices, existing applications, requirements for future solutions, integration points with other business applications, and output requirements. In addition to addressing functional requirements, E2 addressed technical requirements and the framework required by NWA IT staff for new applications.
Based on the analysis of processes, current and future, E2 recommended an EMIS strategy and solution design for NWA. This design consisted of the use of existing applications, new COTS applications, integration with existing systems, and development of an implementation plan.
Pharma/Biotech
Merck & Co., Inc.
As a major pharmaceutical company, Merck has operations all over the globe. E2 was initially retained to assist with strategic planning for an EMIS solution encompassing compliance management, employee health and safety, enterprise reporting, hazard communication, management systems, training, waste management & conservation. The EMIS strategic planning activities resulted in the identification of two initial high priority EHS topics to address with an EMIS solution: EHS performance metric reporting and EHS event (incident) management.
Merck retained E2 to further assist with identifying and implementing a more efficient solution. E2 conducted a solution design to define and document the system requirements for both metric and event management. This was followed by a COTS review to assess known solution providers in the marketplace. After a series of vendor demonstrations and evaluations, the Entropy Solution by BSI was chosen by Merck as their software solution provider.
Working with Entropy and the Merck team, E2 helped implement solutions for both the metrics and incident modules including CAPA tracking. The project included:
The facilitation of requirements definition
Global process harmonization
Identification of global reporting needs
System integration requirements definition
Development of system configuration specifications
Rollout planning
Data migration from a legacy system
Med Immune
Med Immune retained E2 to develop an EMIS Plan for improving their current information management activities. E2 conducted strategic planning workshops with key EHS and Information Technology (IT) department representatives to help identify and prioritize their top information system needs.
The top six topics resulting from the workshop were retained for further analysis and detailed system functional requirements were established utilizing E2's Accelerated Requirements Definition process. Subsequent internal reviews conducted by E2 resulted in the identification of SAP and Track wise as potential existing enterprise applications that could be leveraged for EHS purposes. A detailed analysis of both systems, including both quantitative and qualitative summaries, resulted in a four-phase plan incorporating both systems to meet EHS needs. In concert with the software providers E2 assisted Med Immune with the implementation of the plan that includes the following modules:
1) Hazardous Materials Approval/Management
2) MSDS Management
3) Risk Assessment
4) Incident Reporting
5) Auditing
Food/Beverage
PepsiCo Inc.
PepsiCo retained the services of E2 to help provide a strategic direction and solution design recommendations for automating environmental information management across the enterprise. This EMIS project included the support and efforts of representatives across PepsiCo's business units including: Quaker, Tropicana, Gatorade (QTG), Frito Lay, Concentrate, Bottling Organization, and PepsiCo International.
PepsiCo's environmental data systems varied widely across the organization and included spreadsheets, stand alone custom databases (MS Access, Lotus Notes, etc.), mainframe systems, document management systems, and other commercial off-the-shelf (COTS) applications.
E2 facilitated a series of requirement definition and topic prioritization workshops geared at determining the topics of most value for automation and the requirements within those topics. The workshop sessions resulted in a focusing of the longer list of potential topics into a shorter list of six core topics. Using the requirements gathered in the workshops, E2 conducted a Keep/Modify/Retire (KMR) review of legacy applications across the business units as well as an evaluation of the commercial off-the-shelf (COTS) marketplace. Based on these reviews, a short list of COTS vendors were carried forward for vendor demonstrations. E2 facilitated the vendor demonstrations by preparing demo scripts and scoring matrixes. Upon completion of the demonstrations E2 facilitated a structured evaluation and comparison session. E2's final report of findings was structured to assist PepsiCo staff in obtaining the necessary project approvals and funding, and in justifying the procurement of the preferred vendor. Working with PepsiCo IT, E2 developed initial detailed implementation, resource responsibility/staffing, and module phasing plans.
Power Generation/Public Utilities
Eastern Municipal Water District
Eastern Municipal Water District (EMWD) is a water utility in southern California, providing both drinking water and treating sewerage for a substantial service area. EMWD purchased the ESS solution to replace an aging legacy MS Access application managing compliance data for wastewater operations, as well as managing process operator control information. The volume of data collected by hand in the field led to a design element requiring the development of a handheld data collection device and integration of the device with the ESS application. E2 has developed this integration using Symbol Technology handheld barcode scanner devices for data input, a staging database for syncing data to and from the ESS application, and a data validation interface for supervisor approval of the data from the handheld's.
Additionally, process control calculations required by EMWD required the performance of calculations across several process units at a time. The ESS application calculation engine is designed to calculate only within process units for outfalls, stacks and control devices. E2 is developing a custom application in ASP.net that will reside within the ESS database framework and user interface, but allow users to calculate parameters across process units.
Hawaiian Electric Company
Providing support to power plants, electrical sub-stations and base yards across the Hawaiian Islands, the Hawaiian Electric Company (HECO) Environmental department had a goal to replace their current manual methods of data collection and reporting with a software solution to help streamline environmental related reporting across the company. In 2005/6 E2 was retained to develop a corporate Environmental Management Information Systems (EMIS) strategic plan followed by solution design and implementation services. Key areas under consideration for HECO planning included:
Provided software vendor analysis, scoring and design recommendations
Developed estimated project costs and deployment schedule
Developed phased design and implementation recommendations (i.e. next steps)
Both the EMIS Strategic Planning and Design projects were completed on time, within budget and provided HECO with the necessary information to properly define their EHS information management system as well as justify the need to implement the system to upper management.
In 2008 E2 began assisting HECO with deployment of the preferred commercial software package. The first phase entailed deploying a common framework for compliance “task” management to assist with tracking and managing a myriad of environmental compliance activities. These tasks included both one-time corrective actions to recurring obligations associated with air, water, waste, and other permit management activities. E2 continues to provide ongoing maintenance and support as additional functional modules are being planned for deployment.
Oil/Gas/Pipeline
Baker Hughes, Inc.
Baker Hughes Inc. (BHI) is a global oilfield service company with operations in over 90 countries. They provide advanced products and services to help customers drill, evaluate, complete and produce oil and gas wells. BHI also provides reservoir engineering and other consulting services.
In 2007, BHI retained the services of E2 to help develop an EHS management information system (EHS MIS) design for 300 + global sites focusing on development of their Environmental Performance Metrics. Upon completion of the design, E2 implemented the IHS Opinion product managing environmental metrics information for all 300 sites. The implementation was completed and the majority of the 300 sites were reporting metrics within 6 months of project kick off. E2 continues to provide maintenance and system improvement services for BHI including system optimization, customization, and external reporting.
El Paso Corporation
In 2005, El Paso Corporation contracted E2 to assist in the evaluation of existing environmental information management business processes and systems, and ultimately to provide strategic recommendations for improved environmental information management for twenty functional EHS topics. E2 established key objectives with workshop participants. The collective objectives identified for the project were:
Identify efficiency opportunities
Assess multitude of systems that EHS relies upon for data management (seven existing systems)
Improve trending and data analysis
Improve data accuracy
Identify opportunities to integrate with existing systems (Max imo, COMET, etc.)
Eliminate or reduce redundant data entry
Improve data consistency
Assist in assuring regulatory and internal compliance
Help focus resources on highest risk areas
Improve environmental performance reporting to executive management
Support company direction towards increased corporate social responsibility reporting
Improve alignment of staff resources to highest value activities
The strategic planning analysis took 4 weeks from the initial workshop meetings on-site. A phased design and implementation approach was recommended and E2 has been engaged for solution design recommendations. In 2008, E2 assisted with deployment of a Share Point based web portal and assisted with vendor selection for a waste tracking system. Working in concert with El Paso IT and the software provider in 2009, E2 provided software configuration, data loading, report development and related implementation services for the waste system supporting 200+ locations.
Valero-Wilmington Refinery
Valero implemented the ESS Essential Suite software package compliance management module corporate wide in 2005/6. E2's had a contract with the Valero Wilmington Refinery to review the existing ESS instance and a compare it with a revised Title V permit. In 2006 the refinery applied for the Title V and loaded an initial set of tasks into the system based on that application. With the newly issued final Title V permit, it was necessary to update the revised requirements into Valero's Compliance Management tool. E2's role involved reviewing the Title V permit and modifying existing tasks, adding new tasks and removing tasks that were no longer applicable. From this initial effort, additional module re-implementation activities were identified including restructuring the system configuration to enhance user adoption.
Based on past experience with successful implementations of the software in other refineries, E2 provided key recommendations about appearance, system speed and requirement/task structure that have been implemented over time. Recommendations included standardizing menus and naming conventions, optimizing system performance and the creation of more applicable end-user reports.
Mfg/Distribution
Almatis
Almatis is the only global and the world's leading producer of alumna-based materials for Refractory, Ceramics and Polishing applications as well as a leader in Flame Retardants, Cast Polymers and Paper applications.
Almatis retained E2 to conduct an EMIS solution design encompassing:
EHS Incident Management
Quality Event Management
Risk Management
Corrective and Preventative (CAPA) tracking
The project included business and technical requirements definition, evaluation of client's existing systems, commercial off the shelf software evaluation, solution design recommendations, and the facilitation of onsite software demonstrations.
Upon selecting a commercial off the shelf software provider, Almatis then retained E2 to manage the implementation of the product. E2 worked in concert with the Almatis EMIS team and the software vendor through all phases of the implementation including development of the project plan, software configuration specification, solution testing, and deployment.
Toyota Motor Sales
E2 implemented OpsEnvironmental Software for Toyota Motor Sales (TMS). The scope of the implementation included compliance management and task tracking, and key metric tracking for approximately 35 sites across North America. Information collected and managed in the Topspin system is used to analyze key health, safety, and environmental performance, identify areas of operational efficiency, and set Health & Safety Environmental (HSE) policy. Additionally, the information is sent to Toyota Corporate offices in Japan to be included in the Toyota Corporate Sustainability report as part of Toyota's Corporate Responsibility initiatives.
E2 has provided system maintenance, optimization, and upgrade services since initial implementation in 2002. The Topspin system is hosted off-site by E2, which has significantly reduced the need for internal IT resources in the upkeep of the system. The system has had minimal downtime since moving to E2's hosting centers in 2008.