TEAM:

• Identification of the data migration team
• Determination of data migration responsibilities and tasks
• Kick-off meeting for the data migration project

DEFINING BUSINESS OBJECTIVES:

• Data migration strategy,
• Defining high-level transition plan,
• Defining data quality requirements

BUSINESS PLANNING PHASE:

• Business survey,
• Defining data migration scopes, objects, migration toolkits, target loader template record-level, field-level loading logics and loading formats, empty and default values, pivot tables, other data inputs, determination of necessary target data references,
• Defining data validation rules: target data, target data reference, source data, input data, pivot table data,
• Defining preconditions for target system loading
• Defining post-loading validations

IMPLEMENTATION PHASE:

• Creation of migration database,
• Implementation of source data extracts,
• Implementation of data cleansing,
• Implementation of loading of source data, pivot tables, other data inputs,
• Data transformation, implementation of business logics,
• Implementation of data validation rules,
• Implementation of loading of target data extracts, target loader templates,
• Execution of a sample record for each target template, verification of results in the target system,
• Defining detailed migration cut-over plan, considering target object precedence order, other system transition steps, and business execution sequence

MIGRATION CYCLE PHASES:

• Review and management of target loader template record-level and field-level loading logics, necessary target data references, handling changes if necessary
• Review and management of target data, target data references, source, input, and pivot table data validation rules, handling changes if necessary
• Verification of fulfillment of preconditions for target system loading
• Update of pivot tables, other data inputs
• Extraction and loading of source data, or loading of cleansed data
• Execution of data loading simulation as per cut-over plan, evaluation of logs and results
• Execution of data loading, evaluation of logs and results
• Loading validation: checking key indicators, counts, totals, sampling check (smoke test) to verify loaded data
• Preparation and publication of loading statistics

EXECUTION OF DATA MIGRATION CYCLES in different environments,

SUPPORT/EXECUTION OF LIVE DATA MIGRATION