A multi-platform data migration specialist with 7 years corporate IT experience. Has a wide experience of high volume, high profile migrations, with responsibilities from Analyst/Programmer through to Team Leader of 8 developers. A problem solver with a clear view of migration processes, who has a proven track record of multi-way communication, working to ISO 9001/TickIT standards throughout.

Education:

2(i) BSc.Honours Degree in Chemistry.

Roles and Responsibilities

Team Leader:

Responsible for ensuring customer needs are met through timely and efficient completion of deliverables. Acts as the primary liaison with the customer, incorporating customer-directed changes into the plan, and obtaining final sign-off on the deliverables. Oversees the execution of all deliverables. Works with the customer to manage issues and remove obstacles.

Analyst:

Liaises with specific business process leaders/subject matter experts as needed in order to complete and fully document the following activities:

• Gap analysis - identifying differences in functionality between legacy and target systems.
• Data Mapping - from legacy database schema to target including any transformations needed.
• Specifications - driven by the output of the gap analysis and data mapping activities, the specifications produced allow the developers to code the Extract, Transform and Load (ETL) modules as well as any reconciliation and data cleanse performed during migration.

Migration Developer:

Develops bespoke code according to the specification within the structure of ISO9001/TickIT. This bespoke nature allows us to work efficiently, effectively and flexibly within a controlled environment. Scripts are written for:

• Extraction and Loading of raw data from Legacy/Target/Interim databases
• Migration/Transformation. Safe, reliable manipulation of data
• Reconciliation.
• Referential File Integrities.

Migration Execution:

Prepares databases and executes developed code for extracts, transformation and load of the data, adhering to strict timescales. Supports quality assurance team in timely resolution of reconciliation, integrity, regression and scenario testing issues and liaises closely with all interdependent steps in the plan.

Quality Assurance:

The role of 'Quality Assurance' ensures that data is extracted and transformed without loss or corruption by:

• Reconciliation: Counts and summations of pre-determined critical data on both legacy and target systems to independently validate the end-to-end process and allow mitigation of any differences. Typically reported in a spreadsheet. Discrepancies must be within an agreed tolerance limit.
• Referential Integrity: Validation that migrated data is fit and accurate enough to be usable on the target system, i.e. that the data conforms to the constraints of the target system (e.g. non duplicates, correct data types etc…)

Technical Experience

Databases:

Oracle, Ingres, DB2/400, SQLServer, MS Access, Sybase.

Operating Systems:

Unix, OS/400, Windows, Linux, VMS, AIX

Platforms:

VAX Alpha, AS400, RS6000, HP3000, HP9000, NT Server

Applications/
Technical Skills