Client Satisfaction
OLAV has consistently met or exceeded the legacy data migration and conversion needs of its clients. The tabs below contain samples of feedback from OLAV's clients and select project details:OLAV's work with American Electric Power (AEP) involved two large projects:
1. Legacy database conversion and migration - Energy Delivery Group's Supply Chain
Client comment: "We have enjoyed multiple successful data conversion projects with OLAV, but the Energy Delivery Supply Chain conversion was easily our smoothest conversion to our EAM software." Michael DeLoach, AEP Project Manager
This project for AEP's Energy Delivery Group's Supply Chain (EDSC) implementation into their PassPort (now Asset Suite) Enterprise Asset Management (EAM) system. OLAV was brought in on this project for the data conversion and migration efforts. OLAV provided AEP with state-of-the-art software tools, years of PassPort implementation experience, and high productivity data conversion methodologies developed by OLAV & Co, Inc. These included:
This project for AEP's Work Management and Supply Chain (WMSC) implementation into their INDUS PassPort Enterprise Asset Management (EAM) system. This large scale enterprise implementation consisted of the installation of the Financial Integration, Work Management and Supply Chain modules of the Indus Passport application. On this very large project OLAV was brought in later in the project schedule to assist with data conversion and migration efforts. OLAV provided AEP with state-of-the-art software tools, years of PassPort implementation experience, and high productivity data conversion methodologies developed by OLAV & Co. These included:
This project for AEP's Energy Delivery Group's Supply Chain (EDSC) implementation into their PassPort (now Asset Suite) Enterprise Asset Management (EAM) system. OLAV was brought in on this project for the data conversion and migration efforts. OLAV provided AEP with state-of-the-art software tools, years of PassPort implementation experience, and high productivity data conversion methodologies developed by OLAV & Co, Inc. These included:
- Structured legacy data mapping sessions.
- Multiple conversion test data loads.
- Data gathering tools and worksheets and import/export utilities.
- Special data loads for System Integration Testing efforts.
- Legacy data conversion warehouse, warehouse management, and data load programs.
- Assistance with maintenance and management of simple and custom code tables.
- Load program error analysis software.
- Ad Hoc reporting, data conversion and manipulation tools.
- Successfully worked with Enterprise System Provider and IBM Global Services resources, and also with the AEP functional and technical project teams.
This project for AEP's Work Management and Supply Chain (WMSC) implementation into their INDUS PassPort Enterprise Asset Management (EAM) system. This large scale enterprise implementation consisted of the installation of the Financial Integration, Work Management and Supply Chain modules of the Indus Passport application. On this very large project OLAV was brought in later in the project schedule to assist with data conversion and migration efforts. OLAV provided AEP with state-of-the-art software tools, years of PassPort implementation experience, and high productivity data conversion methodologies developed by OLAV & Co. These included:
- Vendor analysis and consolidation software tools and expertise.
- Multiple conversion test data loads.
- Data Load Verification & Validation Test Plans and documented Audit Trails.
- Data gathering tools and worksheets and import/export utilities.
- Special data loads for Integration Test efforts.
- Custom data load modules for unique Inventory Usage History requirements and Traceable materials.
- Legacy data conversion warehouse, warehouse management, and data load programs.
- Assistance with maintenance and management of simple and custom code tables.
- Load program error analysis software.
- Ad Hoc reporting, data conversion and manipulation tools.
- Successfully worked with both Indus International (now ABB) and PricewaterhouseCoopers consulting (now IBM Global Services) resources, and also with the AEP functional and technical project teams.
- OLAV also completed a cleanup and conversion effort of AEP's existing PassPort production environment for their Vendor and Catalog records.
OLAV successfully completed the largest PassPort (now Asset Suite) data conversion of the year for Bruce Power. The entire project - including data mapping, data conversion programming, six pre-production full data loads, production data load, informal testing, and full closeout CD documentation - was completed by two full-time-equivalent employees in sixteen months, a full two months ahead of schedule. The size can be demonstrated by fifty million TIDBLOB records being converted and moved, and the final data conversion production load was completed in twenty hours.
The conversion took an IBM platform running PassPort© Version 6 to a Unix platform running PassPort© Version 10. A significant amount of data required modification prior to uploading. Data from the following PassPort areas was converted:
- System administration
- Catalog, material request and bills of material data
- Work management data
- Financial data
- Removed and archived obsolete and non-associated data from the base system.[1]
- Rearranged primary and associated facility data to meet business process review requirements.
- Loaded converted data to the production system in 20 hours, thus minimizing client down-time.[2]
OLAV has completed several projects for the DOE facility, including the legacy enterprise system to Oracle Peoplesoft projects described below.
Client comment: “The evaluation provided for your company is the best that I’ve ever seen. Your total was 100 points out of 100…Service and products were always delivered on time and properly completed. No exceptions.” Amber Bullard, Contract Specialist, Procurement Department
1. Legacy Enterprise System to Oracle Peoplesoft - This project entailed the setup of foundation tables and system preferences along with the migration planning for a new Oracle PeopleSoft system. This project was performed in three months. The company was using a legacy enterprise system and was migrating to the PeopleSoft System.
The new system consisted of PeopleSoft applications for Accounts Payable, Asset Mgmt, Manufacturing, Engineering, Purchasing, eProcurement, Inventory, Project Costing, Supply Planning, Maintenance Management, Quality, Strategic Sourcing, and Supplier Contract Management.
2. Continued Maintenance/Enhancement Support of Peoplesoft Implementation - This project entailed the maintenance/enhancement of the Oracle/PeopleSoft applications for Accounts Payable, Asset Mgmt, Manufacturing, Engineering, Purchasing, eProcurement, Inventory, Project Costing, Supply Planning, Maintenance Management, Quality, Strategic Sourcing, and Supplier Contract Management.
This support has been provided with quality by OLAV personnel with multi-discipline capabilities. This equates to very cost-effective staffing of less than one full time equivalent to cover the work across all applications.
OLAV has performed multiple projects for Northeast Utilities and NSTAR (both now part of Eversource).
Client comment: "Nice job on the solution. The Go-Live was textbook. It was a really good day." Mark Lemke, IT Project Manager
1. Database Conversion and Migration - Database conversion for an application upgrade for Northeast Utilities from an older version of an Enterprise Asset Management (EAM) system to the latest version Multi-Version Upgrade).
OLAV assisted in the initial implementation of Asset Suite/PassPort at NU in 1995.
In addition, OLAV set up stand-alone Asset Suite/PassPort Implementations for the Seabrook and Millstone Nuclear Facilities. These were both provided to the company that bought these two facilities.
Multi-Version Upgrade:
- Northeast Utilities was at the time the largest energy company in New England, based in Berlin, CT.
- For this extensive project OLAV performed the entire database conversion and migration from an older version of an Enterprise Asset Management (EAM) system to the latest release. This conversion was particular'y difficult because of the large time span (i.e., it spanned 5 versions of the software, which resulted in significant data differences) between the two software releases. The project tasks included full project planning, business process reviews, data consolidation, data cleansing/scrubbing, data mapping, data verification and validation, several full pre-production data test loads and the production data load.
- In addition, OLAV performed a significant data reduction to remove the data associated with facilities that had been sold by Northeast Utilities. This last task is a form of archiving of the data from the production system.
- This project came in under initial budget. A few post-production data problems were encountered and corrected in the first production week. The client was especially satisfied with the results of this project.
OLAV has performed four PassPort (now Asset Suite) data conversion and migration projects for Nevada Public Power Company (now NV Energy).
Client comment: “OLAV has a wonderful group of people who know PassPort inside and out. They performed all the data conversion along with providing PassPort programming and interface building…The OLAV staff and my staff worked seamlessly during these (five) major projects (covering 13 power plants). They are professional in every way…OLAV may be the best project decision we have ever made.” Sherry Jackson, Project Director, Generation Information Systems - NV Energy (Nevada Power)
All projects were completed on time, on budget, and with minimal post-production problems (this means top quality results).
Each project included data mapping, data conversion programming, data cleansing, data consolidation, data standardization, multiple pre-production data loads, and comprehensive verification and validation prior to the production data loads. Full closeout documentation was provided at the end of each project, thus ensuring a complete audit trail for client use.
The Nevada Power Company data conversion projects are listed below.
1. IBM PassPort V6 to Unix PassPort V10 - One-year project entailed data conversion programming, three pre-production data loads, full data mapping specs, final production load, and close-out CD. No post-production problems.
2. Moved Silver Hawk Power Plant SAP Data into PassPort - Six-month project of data conversion programming; three pre-production loads; Full data mapping specs; catalog consolidation; catalog description to PassPort template characteristic values conversion; vendor and manufacturer consolidation and conversion; final production data load. No post-production problems.
3. Moved Bighorn Power Plant Maximo Data into PassPort - Project required data conversion programming; two pre-production loads; full data mapping specs; catalog consolidation; catalog description to PassPort template characteristic values conversion; vendor and manufacturer consolidation and conversion; ; final production data load. Minimal post-production problems.
4. Moved Three Northern Power Plant Legacy Data into PassPort - Project involved data conversion programming; three pre-production loads; Full data mapping specs; catalog consolidation; catalog description to PassPort template characteristic values conversion; manufacturer consolidation and conversion; vendor consolidation and conversion; final production data load. Minimal post-production problems.
Some of the projects involved considerably more than simple data conversion.
OLAV implemented an 18-module project for Omaha Public Power District (OPPD), a Nebraska publicly-owned electric utility that includes a nuclear power plant.
The 18 project modules covered the following:
- Work Management - Work Management, Labor Entry & Reporting, Personal Qualifications Data, Equipment Tagout, Design Engineering;
- Supply Chain - Inventory Management, Purchasing, Accounts Payable, Procurement Engineering, Contract Management;
- Configuration Management - Action Tracking, Document Management, Engineering Change Control, MSDS, Project Management; and
- Asset Management - Project Costing, Asset Management, Miscellaneous Billing). The nuclear area requires a far more detailed and thorough Verification and Validation.