Data Migration

SMS Data Migration services deliver a proven capability to deliver an effective data migration and conversion from legacy systems and platforms into your new solution. Data Migration is an often overlooked requirement of solution implementation projects and SMS has delivered data migration across single custom built applications through to very large scale enterprise data transformations.

SMS services include:

Data Migration Strategy/Approach
Data Migration Analysis and Mapping
Data Migration Build, Test, Execution
Data Reconciliation / Certification

Data Migration is a target state focused activity and as such future state business requirements, data architecture and systems design are the deliverable and drive the data migration requirements. Our objectives in delivering a data migration are:

Deliver the required business baseline of data for production start-up of target systems
Build, test and manage an executable, repeatable system to deliver the required target systems data, including:
- Legacy data staging;
- Data transformation (cleansing, enrichment, conversion);
- Exception management, and;
- Reconciliation (Source = Target + Exceptions)

Data Migration is a systems development, and as such must :

Have a defined scope, Data Subjects, Source and Target systems
Have detailed target data requirements:
- Field level technical specification including data types, constraints
- Business and Technical data mapping to legacy source data sets
- Defined data conversion requirements (code translations, merge rules, data quality requirements, historical data requirements)
Have technical tools and environment(s) for system development to be performed and executed within.
Be repeatable
Be Auditable/ Reconcilable
Execute to performance requirements (able to complete all required data migration in the specified migration windows)