Independent ERP and Lean & Operational Excellence Consultants

Data conversion and migration can be a significant challenge in any large system implementation. This is particularly true in ERP implementations where specific challenges are posed by:

• The interconnection of financial data and data from other functional modules.
• Migration strategy development detailing the approach to be taken to data conversion, data retention and archiving.
• Business expectations of improved data quality and the implication that existing data is often poorly maintained.
• Differing expectations of what data will be migrated between vendor and client stakeholders.
• A lack of business commitment - particularly the view that data is only a technical concern.
• The frequent necessity to modify certain data (revised numbering systems; different analysis groupings and so on) as part of the migration process to the new system environment.
• The lack of available resource for data conversion and migration due to deployment of significant resources to other system implementation activities.
   

BSM have developed and refined a proven methodology for Data Migration Management over many life science sector ERP implementations. The methodology can be scaled to suit the differing requirements posed by implementations of differing complexity - from single site ERP replacement to multi-site multi-system replacement.

Deliverables:

• Data identification, analysis and definition.
• Migration strategy development detailing the approach to be taken to Data Conversion, Data Retention and Archiving.
• Technical design covering Data Extraction, Cleansing, Transformation, Harmonisation and Load.
• Validated transactional and non-transactional data.
• Data cutover/go-live plan and procedures.

Benefits to the client include:

• BSM have a body of experience operating in different technical environments ranging from legacy file structures to databases, including many of the leading ERP systems.
• Proven methodology and experience.
• Reduced learning curve in the early stages of the project.
• Strong project management skills.
• Previous experience migrating data across many leading ERP systems.
• Familiarity with best-of-breed tools for data extraction and manipulation.
• Reduced risk.