Data Migration Team

The Data Migration and Cleansing Team is responsible for implementing a data migration strategy from legacy payroll and human resource systems to SAP Business Intelligence (BI).  The team’s goal is to create seamless reporting from SAP R/3 and SAP BI that includes the necessary historical data to support the BEACON HR/Payroll system.  The State's chosen data migration strategy is to copy all PMIS online data to a relational repository; convert selected historical data required for reporting to SAP BI; and maintain, develop and test a process to move the data from archived formats into the relational repository.  In order to resolve back pay claims, leave, and other retroactive adjustments, the state maintains payroll earnings and master data files which must remain accessible for future processing.  In addition, the State is retaining all summarized and detailed historical information from PMIS, including PMIS Employee and Position Data and PMIS Forms History and Employee and Position Actions.  The data migration strategy includes support for a two-phased SAP ERP roll-out as determined by the BEACON time line.

Team Members: