Ankit Vats

About Ankit Vats

I am a Data Architect with 19 years of experience specializing in enterprise data warehouse modernization, cloud migration, and scalable data platform design. Over the years, I have advanced from BI Developer to Cloud Data Architect and now Data Architect, bringing a strong data engineering mindset and the ability to deliver end-to-end data solutions.My expertise spans across data architecture, modeling, governance, integration, and optimization, with hands-on skills in Azure cloud services, Microsoft Fabric, and modern architectures such as Medallion, Data Mesh, Lambda, and Kappa. I have designed and implemented solutions using conceptual, logical, and physical data models, ETL/ELT frameworks, and advanced warehousing techniques including Dimensional Modeling, Star/Snowflake Schema, and Data Vault 2.0.In 2024, I was recognized for leading the rapid migration of on-premise data centers to Azure Cloud, modernizing a client’s data platform while resolving significant architectural debt. My career foundation as a Database Developer, ETL Developer, Data Engineer, and BI Developer enables me to bridge both technical and business perspectives effectively.Beyond technology, I bring strong project delivery and management skills — certified in TOGAF, Scrum Master, ITIL, SAP HANA, and currently pursuing PMI Cognitive Project Management in AI. I thrive in agile environments, collaborating with stakeholders and cross-functional teams to translate business requirements into impactful data solutions. Next Ambition: Transition into roles such as AI Data Architect or AI Technical Project Manager, where I can leverage my deep data expertise with AI-driven project delivery to shape the future of enterprise data.

Experience

1. Data Architect

   LTIMindtree

   Oct 2022 — Present · Gurugram, IN

   Project 1: Enterprise Data Consolidation & Platform Modernization Program• Consolidated OLTP systems from multiple subsidiaries with varied data formats and vocabularies into a unified Enterprise Data Warehouse (EDW). Developed Data Strategy for Digital Transformation and Defined Data Optimization standards.• Standardized data models across subsidiaries, enabling accurate enterprise-wide reporting, and modeled key Insurance domain dimensions • Designed and developed conceptual, logical, and physical data models to support enterprise data warehouse and analytics platforms. Created user friendly Power BI report layouts.• Deployed Medallion Architecture in Microsoft Fabric, improving data quality, lineage, and governance.• Contributed to hands-on development and issue resolution in MS Fabric, providing technical support to accelerate team delivery and ensure project success.Project 2: On-Premise to Azure Cloud Migration Project • Led modernization and migration of legacy on-premise data centers to Azure leveraging hybrid service models IAAS & PAAS. Worked with C-level stakeholders to shape cloud strategy for migrating MDM systems.• Designed migration roadmap and to-be models, and delivered the solution to support business and IT strategies. Estimated cost/effort, and implementing secure, scalable database solutions.• Utilized Azure Services like Azure Managed Instance, Azure SQL DB, Azure VM, Azure Data Factory (ADF), and Data Lake to modernize infrastructure, achieving a 40% cost reduction against On-Premise YoY.• Contributed to the development and deployment of Azure services like Resource Groups, NSG, vNet, VM, SQL DB, Managed Instance, Data Factory, Blob Storage to enable end-to-end migration.• Appreciated for helping users of client’s IT team to onboard to Azure providing seamless experience.

Education

• Institute of Technology and Science

  Bachelor of Computer Application, Computer Application

  2000 — 2003

• St. Vivekanand School, Delhi

  XII, Commerce

  1989 — 2000

• St. George's School, Agra

  Primary Schooling

• Guru Gobind Singh Indraprastha University

  Master of Computer Application, Computer Application

  2003 — 2006

Skills

• Software Development Life Cycle (Sdlc)
• Crystal Xcelsius 2008
• Certified Scrum Master Certificant Id: 543091
• Sap Businessobjects
• Crm
• Sap Erp
• Sap Hana
• Sap
• Crystal Reports
• Microstrategy Reporting
• Sql
• Business Objects Data Integrator
• Business Intelligence
• Sdlc
• Solution Architecture
• Etl
• Integration
• Consulting
• Business Analysis
• Data Warehousing
• Dashboard
• Sap Products
• Microsoft Sql Server
• Informatica
• Databases
• Oracle
• Requirements Analysis
• Business Objects