Client Satisfaction

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:

  1. Structured legacy data mapping sessions.
  2. Multiple conversion test data loads.
  3. Data gathering tools and worksheets and import/export utilities.
  4. Special data loads for System Integration Testing efforts.
  5. Legacy data conversion warehouse, warehouse management, and data load programs.
  6. Assistance with maintenance and management of simple and custom code tables.
  7. Load program error analysis software.
  8. Ad Hoc reporting, data conversion and manipulation tools.
  9. Successfully worked with Enterprise System Provider and IBM Global Services resources, and also with the AEP functional and technical project teams.

2. Legacy database conversion and migration – Work Management and Supply Chain

Client comment: This AEP EAM Implementation “Would not have been as successful if not for the OLAV staff and consultants. The knowledge and professionalism of OLAV is greatly appreciated by us all.” Ella N. Liggins, AEP Application Delivery Manager

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:

  1. Vendor analysis and consolidation software tools and expertise.
  2. Multiple conversion test data loads.
  3. Data Load Verification & Validation Test Plans and documented Audit Trails.
  4. Data gathering tools and worksheets and import/export utilities.
  5. Special data loads for Integration Test efforts.
  6. Custom data load modules for unique Inventory Usage History requirements and Traceable materials.
  7. Legacy data conversion warehouse, warehouse management, and data load programs.
  8. Assistance with maintenance and management of simple and custom code tables.
  9. Load program error analysis software.
  10. Ad Hoc reporting, data conversion and manipulation tools.
  11. 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.
  12. 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:

  1. System administration
  2. Catalog, material request and bills of material data
  3. Work management data
  4. Financial data

The OLAV JumpStart process not only converted the PassPort data shown above, but achieved the following objectives as well:

  1. Removed and archived obsolete and non-associated data from the base system.[1]
  2. Rearranged primary and associated facility data to meet business process review requirements.
  3. Loaded converted data to the production system in 20 hours, thus minimizing client down-time.[2]

The project relied heavily on OLAV’s custom load programs and proprietary SQL code to cleanse and consolidate the data. These OLAV tools – used on many previous PassPort conversions — provided a significant technical advantage resulting in lower project costs, shortened conversion schedules, and higher quality. For example, this conversion project was completed in 5,500 staff hours with minimal post-completion issues noted. This compares to some data conversion times of 30,000 hours or more for projects of this size.

OLAV also delivered complete data mapping specifications and a fully-auditable record of the data conversion (data & process) at the close of the project. Two copies of the CD were provided to the client and two copies were retained by OLAV.

[1] Obsolete data included non-current catalog id’s, obsolete manufacturer and vendor data, and shared data such as associated documents in TIDBLOB.

[2] Fixed data was pre-loaded as required. One example would be the TIDBLOB data. Only incrementals needed to be covered at the production load.

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:

  1. Northeast Utilities was at the time the largest energy company in New England, based in Berlin, CT.
  2. 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.
  3. 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.
  4. 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.

2. Combine Multiple Production PassPort Regions Into One Data Repository for Reporting and Standardization – This project entailed: 1) Combining PassPort Regions of different versions into one common data repository that is updated daily (using Informatica), 2) Providing a state-of-the-art web interface Catalog ID search capability (using .net C# and MicroFocus COBOL), 3) Providing a state-of-the-art web interface Vendor search capability (using .net C# and MicroFocus COBOL), 4) Providing high level reporting for management (using BI Publisher), 5) Providing an Admin tool to standardize data for new enterprise system (Vendors, Catalog IDs, Catalog ID Templates, etc.) using web interface, .Net C#, and MicroFocus COBOL.

3. PassPort Accounting Interface for Report Generation -This Project created a comprehensive interface of Passport (now Asset Suite) to the PowerPlan Financial System for accounting and issue data transactions. All transactions with any tax implications are captured.

The project also required the heavy modification of the Asset Suite/PassPort System (computer programs and data) to function correctly with PowerPlan.

This process integrates multiple Passport instances into a common data warehouse. Olav personnel were used to define and map Passport transaction entries. The system was set up to run an automatic production feed with global preferences for extracting and purging data. It also provides an ad-hoc process for creating customized data extracts going back to the inception of Passport.

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:

  1. Work Management – Work Management, Labor Entry & Reporting, Personal Qualifications Data, Equipment Tagout, Design Engineering;
  2. Supply Chain – Inventory Management, Purchasing, Accounts Payable, Procurement Engineering, Contract Management;
  3. Configuration Management – Action Tracking, Document Management, Engineering Change Control, MSDS, Project Management; and
  4. Asset Management – Project Costing, Asset Management, Miscellaneous Billing). The nuclear area requires a far more detailed and thorough Verification and Validation.

The project was completed within initial schedule (one year) and within initial budget – half the time, and at half the budget, estimated by the vendor of the Enterprise System.