Ayan Chakraborty

About Ayan Chakraborty

I am an experienced techno-functional Data Migration Expert with expertise in directing data analysis, mapping & transfer, identifying data inconsistencies and automating data cleansing to improve quality of migrated data, reimagining migration process & operation and delivering enhanced customer experience.My ability in scoping, planning & handling ownership of project portfolios is completed by my proficiency in delivering post-production support and ensuring smooth business transition from old to new system.Effectively conduct business analysis, identify data architecture of legacy systems by utilizing understanding of legacy data dictionaries and analyze & map data. I identify data quality issues, automate data cleaning and execute audit & reconciliation of data between source & target. In addition, I maintaining relationship with stakeholders, define data migration strategy and get buy in from customers.I have led and delivered large, complex multi-year end to end data migration programs for multi-million-dollar client accounts across multiple geographiesAdopted new technologies and simplified process to enable improvement in data migration programs across UK, South East Asia & USABusiness Area handled: Life, Pension and Payment SolutionsI have proven to have an advanced level of Scrum Mastery and an understanding of the underlying principles of Scrum and have an ability to apply Scrum in complex scenarios.Winner of 4 Star Team Awards for successful execution of transformation programsHands-on experience in Entity Relationship (ER) modelling and development of Data Warehousing for insurance domain. I am well versed with ETL tools (Oracle Warehouse Builder (OWB), Oracle Data Integrator (ODI)), PL/SQL, AWS components, Oracle OLAP and Oracle Apex.I love to spend my leisure time in gardening, reading.Specialities: Data Migration, Data Warehousing, Data Modelling, Transformation Programs, Project & Delivery Management, Software Development Life Cycle (SDLC), Requirement Gathering & Analysis, Data Analysis & Mining, Vendor Management, Risk Management, Client Relationship Management, Team Management.

Experience

1. Associate Consultant

   Tata Consultancy Services

   Jan 2021 — Present

   Associated for over 15 years with Tata Consultancy Services, a global leader in IT services, consulting, and business solutions by leveraging technology for business transformation.I gained hands-on experience in all areas of Software Development Life Cycle (SDLC) through various roles including Tester, Programmer, Module Lead, Offshore Migration Lead and Migration Manager.Worked in a transformation program with focus on data migration of life & pension policies of multiple legacy systems to a single platform, helping client reduce cost and improve process efficiency. Effectively ensured smooth business transition from old to new system.Worked as a part of the Implementation team, participated in Go-Live and delivered post-production support for data migration.

Education

• University of Kalyani

  B.Tech, Computer Science

  2000 — 2004

• ICFAI Business School

  MBA, Marketing & IT

  2004 — 2006

Skills

• Business Analysis
• Pl/Sql
• Data Modeling
• Data Warehousing
• Business Requirements
• Business Intelligence
• Oracle
• Requirements Analysis
• Software Development Life Cycle (Sdlc)
• Team Management
• Requirements Gathering
• Vendor Management
• Pre-Sales
• Sql
• Data Migration
• Sdlc
• Software Project Management
• Solution Architecture