Summary
Overview
Work History
Education
Skills
Certification
Accomplishments
Timeline
Generic

Vivekananda Khan

Peterborough,Cambridgeshire

Summary

I want to work in such a place in a challenging and highly competitive environment where would be able to explore my abilities and hence contribute to the best of myself & to the team acting as a collaborative member at the same time leading my team and add value towards the organization I work for. Currently I am playing as a data migration and data engineer lead in a large UK based Life and Pension Transformation project with a policy data volume of 20 million , Customer data volume of 60 million, claim data volume of 10 million along with its 2 billion Fund data in TCS as Data Migration Project lead handling multiple Mainframe,DB2 based legacy systems to fit in TCS BaNCS Life & Insurance product suite with industry leading and cutting edge transformation practice to improve customer experience in new business landscape. Also ensuring an E2E BI solution by implementing Data lake house in Azure Databricks for Client's new generation Warehouse solution. Being a Highly motivated database expert with 16+ years of experience been part of several Successful Life, Pension, Health Insurance Transformation Migrations in various European and UK geography. Have strong aptitude to learn and adapt to new technology. Proven my skill in transforming and revitalizing strategies using available systems and modern approaches. Specialized in Data base design, management, data mining , data remodeling, reporting and in both ‘Source driven' & ‘Target driven' Data Migrations with industry leading best practices. I believe to have excellent Analytical problem-solving skill dedicated to achieving continuous improvement. Strong background in optimizing ICT processes, monitoring database performance and handling production batches. Throughout my career I have defined and enforced robust Data Migration strategies & standards in large scale transformation projects having millions of customer base. Throughout I outperformed my job role demands and deadlines through diligent work-ethic and dedication to quality. And helped my organization to motivate and educate my junior team mates to become productive and added value to my organization.

Driven Data Engineer with knack for crafting scalable data solutions and refining data pipelines. Boosted data processing efficiency by implementing innovative ETL processes, leading to faster analysis and more accurate insights. Known for collaborating seamlessly with cross-functional teams to deliver impactful data-driven projects.

Overview

2025
2025
years of professional experience
1
1
Certification

Work History

Data Migration and Data Engineer Lead

Diligenta
Peterborough, Cambridgeshire
10.2018 - Current
  • A lead Data base architect and data Migration lead , performing all kinds of warehouse and data migration related activities with complex data transformation & industry leading best practices to move data from multiple Mainframe, DB2 etc Based legacy systems to TCS BaNCS insurance product
  • Achieved 99.9999% Accuracy in Audit and Reconciliation report and appreciated by Customer on such a large volume of transactional historical data transformation ETL based project
  • Modelled data warehouse/EDL for BI and implemented Data Governance in the implementation ecosystem in Azure databricks with Data lake house solution with enhanced BI reporting capabilities.
  • Ensured strong data governance over Vulnerability checks, GDPR ,PII and other UK regulatory compliances
  • Handled millions and millions of Customer and Policy data to remodel with cutting edge reconciliation process to successfully move in ‘Target Driven' migration approach
  • Created Data Migration road map & Data Migration Audit, reconciliation requirement
  • Defined Data Migration strategy
  • Successfully implemented transformation and been SPOC of Production support team
  • Provided in-depth and tailored training to clients on project deliverables when needed
  • Conducted initial consultations and followed up meetings to communicate project requirements and scope
  • Scheduled regular client meetings to discuss project updates and issues
  • Conducted in-depth reviews into client communication documents, making edits where required to improve Data quality and controls
  • Responded, managed and dealt with client's questions and concerns, completing in a timely manner
  • Trained and mentored 10+ Consultants to increase team productivity
  • Handled complex problems and issues by understanding root causes and implementing solutions
  • Designed and sustained automated reporting operations for accurate, reliable data records
  • Interpreted and developed various SQL coding commands, resolving queries for enhanced programming capabilities
  • Collaborated professionally with clients and stakeholders to implement optimal database solutions
  • Created conceptual, logical and physical models using specific methodologies for analysis
  • Synthesised large datasets into actionable insights, elevating decision-making
  • Kept updated on advancements to latest information system solutions
  • Simulated system operation virtually to complete assessments and tests
  • Analysed business' current work practices to recommend improvement action
  • Created and deployed system testing plans to back up deployments
  • Assessed linkages between system components and implemented improvements to optimise connectivity, compatibility and functionality
  • Tracked technology trends and researched potential integrations to meet functional or performance needs
  • Applied appropriate project management technique to execute ICT projects successfully
  • Wrote detailed proposals covering system specifications, resource requirements and timelines
  • Determined strengths and weaknesses of established processes and practices
  • Validated systems to assess needed improvements and recommend options for closing gaps and enhancing functionality.

Database Architect

Tata Consultancy Services
Kolkata
01.2018 - 10.2018
  • Interpreted and developed various SQL coding commands, resolving queries for enhanced programming capabilities
  • Demonstrated expertise in marketing automation tools, including FastStats, for dependable campaign management
  • Designed and sustained automated reporting operations for accurate, reliable data records
  • Liaised with cross-functional teams to produce functional, high-performing database architectures
  • Evaluated efficacy of database solutions, resolving and escalating issues for maximised functionality
  • Designed and mapped out life-cycle data flows and processes, creating high-performing data- management systems
  • Performed regular data validation and cleansing, optimising database quality standards
  • Collaborated professionally with clients and stakeholders to implement optimal database solutions
  • Troubleshot ICT systems to isolate issues, bottlenecks and malfunctions, recommending best course of action
  • Prevented breaches and loss by enforcing security and integrity controls
  • Used Oracle Database to extract, store and verify information
  • Optimised database performance by systematically tackling system weaknesses
  • Wrote documentation on database for both technical and non-technical audience
  • Migrated existing data strategically to prevent disruption to critical business applications.

Database Consultant

Tata Consultancy Services, Den
01.2015 - 01.2018
  • Designed and implemented targeted solutions to precise client needs using various database structures
  • Troubleshot ICT systems to isolate issues, bottlenecks and malfunctions, recommending best course of action
  • Evaluated efficacy of database solutions, resolving and escalating issues for maximised functionality
  • Demonstrated expertise in marketing automation tools, including FastStats, for dependable campaign management
  • Created conceptual, logical and physical models using specific methodologies for analysis
  • Provided training to employees on newly installed, developed or upgraded database software
  • Prevented breaches and loss by enforcing security and integrity controls
  • Wrote documentation on database for both technical and non-technical audience
  • Completed preventative maintenance tasks and recovery procedures for maximum database integrity.

Migration Data Analyst

Tata consultancy services
Brussels
05.2012 - 12.2014
  • Synthesised large datasets into actionable insights, elevating decision-making
  • Kept updated on advancements to latest information system solutions
  • Simulated system operation virtually to complete assessments and tests
  • Analysed business' current work practices to recommend improvement action
  • Created and deployed system testing plans to back up deployments
  • Tracked technology trends and researched potential integrations to meet functional or performance needs
  • Outlined system principles after consulting with clients and management
  • Gathered and defined user requirements for system updates
  • Wrote detailed proposals covering system specifications, resource requirements and timelines
  • Prepared and updated system specifications to support developers.

Database Programmer

Tata consultancy services
Kolkata
08 2008 - 04 2012
  • Built database and warehouse, including consolidating disparate data sources andunverifiedqueries into central source
  • Assessed customer needs and goals through communication and system evaluations tomodifyexisting databases for personalised customisation
  • Developed data models and database designs to plan projects
  • Wrote and coded descriptions for physical and logical databases
  • Developed and implemented security initiatives to protect important company data
  • Applied various skills to evaluate, design, implement and optimise databases anddatabaseapplications
  • Identified databases not reaching peak performance and determined ways to solve concerns
  • Produced complex database project with zero issues due to effective troubleshooting
  • Developed, designed and optimised data structures for analysis
  • Partnered with project management teams on development of scope and timelines
  • Developed and updated all documentation related to database technologies for department
  • Defined technical specifications and naming conventions for information systems projects
  • Performed Extract, Transform, Load (ETL) processes to support data warehouse system
  • Established policies and procedures for database access and usage
  • Optimised database performance by systematically tackling system weaknesses
  • Performed backups and procedures for quick data recovery
  • Migrated existing data strategically to prevent disruption to critical business applications
  • Drafted database scheme by following Relational Database Management System(RDBMS)rules

Education

Master of Science - CS

University of Calcutta
05.2008

Bachelor of Science - CS

University of Calcutta, St. Pauls C M College
05.2006

Skills

  • Data Architect
  • Data Warehouse Engineer
  • Data Analysis and Modeling
  • Oracle PL SQL programmer
  • ETL Specialist
  • Data Migration specialist
  • Data Quality strategist
  • Azure Databricks Engineer
  • Techno Functional Consultant
  • Audit & Reconciliation specialist
  • Data Governance Expert

Certification

  • Oracle OCA and OCP certified - 2010
  • Azure Databricks data engineer - 2023
  • Programming in R basic - 2021
  • AWS Solution Architect - 2022

Accomplishments

  • Successfully lead the data migration and reconciliation project of different (top 4 ) UK based Insurance and Pension transformation projects to new Insurance platform from 50-60 years old PAS systems
  • Established robust data lakehouse solution in Azure Databricks landscape which improved the overall E2E BI solution in a number of transformations project.
  • Created a number remarkable productive teams by mentoring and giving training to team members in multiple accounts of my current employer
  • Been acknowledged and recognised by a number of UK Clients and Customers for the quality and robust implementations of different data solutions ( Data Migration, Data Analysis, Data Cleansing, Audit and Reconciliation, Finance Reporting, Data Lakehouse )

Timeline

Data Migration and Data Engineer Lead

Diligenta
10.2018 - Current

Database Architect

Tata Consultancy Services
01.2018 - 10.2018

Database Consultant

Tata Consultancy Services, Den
01.2015 - 01.2018

Migration Data Analyst

Tata consultancy services
05.2012 - 12.2014

Database Programmer

Tata consultancy services
08 2008 - 04 2012

Master of Science - CS

University of Calcutta

Bachelor of Science - CS

University of Calcutta, St. Pauls C M College
Vivekananda Khan