Project Profile

Industry-Leading Data Consolidation Streamlines Workflow

Since December 2020, Evergy, an energy utility based in Kansas City, Missouri, has been consolidating multiple legacy data sets and asset management applications on to a Maximo application platform. This initiative covers multiple fossil plants and one nuclear plant. 1898 & Co. was brought on to provide data services to help the utility efficiently implement a solution.

Key goals of this initiative include:

  • Empowering people by enabling the full potential of the generation teams through use of modern tools and simplified processes to improve effectiveness and efficiency.
  • Improving performance and reliability by tracking performance metrics across all generation stations and helping revise maintenance programs.
  • Optimizing processes and standards by leveraging the Maximo platform, standardizing and improving maintenance processes using industry-leading practices.
  • Standardizing asset management and consolidating inventory functions on a single platform.

Evergy engaged our team to assist with the following key areas of the project:

  • Conversion of supply chain data (item master, requisitions and purchase orders) from legacy application to target the enterprise resource planning (ERP) system
  • Conversion validation and reconciliation
  • Data cleansing activities
  • Legacy data analysis

Detailed Analysis of the Legacy Data

Initially, our team analyzed the legacy work and asset management data across multiple applications. We then shared key inputs with the business and functional teams to help Evergy understand: differences in the data across multiple platforms; data inconsistencies; and data quality. This involved completing a detailed analysis of the legacy data including assets, locations, item master, work orders, requisitions, purchase orders and inventory details. The team also assessed the data from spreadsheets and stand-alone databases supporting current business functions. The team shared the detailed findings with the Generation Enterprise Asset Management business team and helped the team to develop tailored conversion approaches to bring disparate data into the planned common enterprise asset management solution.

Data Cleansing

Using the knowledge and understanding gleaned from the detailed analysis, our team also helped to develop methods and routines to cleanse a limited number of data areas. This included standardizing the data sets and merging data from additional sources to make the data set complete. Cleansed data sets were staged for the conversion routines to be processed further before loading the data into the targeted Maximo application.

Data Conversion

Our team’s responsibility included converting supply chain data from the legacy applications to the target ERP application, set to support the supply chain functions upon deployment of the Maximo solution. Functional scope included item master, requisitions, purchase orders and inventory balances from the legacy application.

Our team worked closely with the supply chain management functional leads and ERP professionals experts to define the conversion requirements and develop a detailed mapping of everything from the target data elements to the source data structures. The team leveraged the initial detailed analysis to provide inputs to the business and functional team members to speed up the conversion mapping.

The team designed and developed the conversion routines to support the conversion and transformation rules captured in the mapping documents. Additionally, the team designed and built routines to capture conversion controls and to automate the validation checks.

Our team actively participates in mock conversions and revises the conversion routines to improve the quality of the converted data. The team continues to coordinate its conversion activities with other functional, application and conversion teams to align with the overall goals and objectives of the overall program.

Data Conversion Validation and Reconciliation

The team is helping to develop automated conversion validation routines to assist with data validation across the entire program. It is also developing automated routines to reconcile converted data across multiple target platforms. These automated reconciliations help the functional leads to confirm quality and alignment of the converted data across multiple applications. These reconciliations also bring out any conversion issues early and helps the business leads to direct remediations.

By outsourcing this project to 1898 & Co., Evergy garners numerous benefits. 1898 & Co.’s client-centric practices provided data conversion services that enhance the client’s internal flexibility and efficiency of workflow.

Video Column Complete

Cool Video Headline Goes Here

video description goes here. video description goes here