Data migration specialist with over 9 years of experience in UK life and pension insurance. Led large-scale data migration projects, showcasing expertise in legacy data analysis, data mapping, ETL design, and data quality management. Proficient in SQL, Oracle, PL/SQL, Python, and SQL Loader, with a strong emphasis on delivering measurable results. Aiming to leverage technical skills and project leadership in a new, challenging role.
Overview
9
9
years of professional experience
2016
2016
years of post-secondary education
Work history
Lead migration technician
Tata Consultancy Services
Peterborough, UK
2022.06 - 2026.04
Led data migration team in techno-functional capacity from discovery to successful migration of legacy platform to TCS BANCS platform leading UK LnP administration platform for leading UK insurance companies like Lloyds Banking Group, Aviva Plc, Phoenix group.
Experienced in client facing role with multiple stakeholders engagement with product, proposition, legacy IT and servicing teams to identify scope and functional requirement for data migrations.
Experienced in data analysis, data mapping, data quality management, ETL design and Audit & reconciliation report designing for creating and documenting an effective data migration strategy.
Experienced in data loading from multiple sources, and developing, delivering and performance tuning ETL code along with developer team and supporting defect management during testing lifecycle.
Led multiple successful data migration for from their legacy platform to TCS BANCS platform.
Innovated multiple reusable component and framework implementing automation reducing manual repeatable task, reducing delvepment and delivery time for data migrations projects.
Led data migration team of migrating 2.3 Millions Life and pension policies and 10 Millions customer for Lloyds Banking Group in 2022.
Led successful data migration of complex life and pension policies for more than 15 aging mainframe system with limited knowledge base to TCS BaNCS life and pension platform in 2018, 2019, 2021, 2024 and 2025.
Currently working on RAG POC to leverage LLM models using Ollama framework for aiding data migration activities.
Data Migration Specialist
Tata Consultancy Services
Kolkata, India
2017.01 - 2022.06
Worked as Data Migration Specialist in legacy data analysis, source to target data mapping, data quality management, ETL design - ODI data mapping and stored procedure, and Audit & reconciliation report ensuring successful data migration to TCS BANCS platform.
Worked as Junior Data migration specialists from Jan 2017 to Jan 2018 for Phoenix Group which involved data migration of 1 Million policies to TCS BANCS platform.
Education
Bachelor of Technology - Computer Science
Assam University
Silchar, India
Skills
Data migration: scoping and strategy
Legacy data profiling, analysis and target mapping