Sr. Data Architect
Resume:
PROFESSIONAL SUMMARY
Over two decades of IT experience with 15+ years specializing in Enterprise Data Architecture, Data Engineering, Data Warehousing, Business Intelligence, Analytics, and Cloud Modernization.
Expert in architecting and modernizing enterprise data platforms across Microsoft Fabric, Azure, Databricks, AWS, GCP, and Snowflake, enabling organizations to transition from traditional BI ecosystems to scalable Lakehouse and Warehouse architectures.
Proven expertise in Microsoft Fabric including OneLake, Lakehouse, Warehouse, Data Factory, Dataflows Gen2, Real- Time Intelligence, Semantic Models, Direct Lake, Activator, and Fabric Administration.
Strong experience in designing Conceptual, Logical, and Physical Data Models, Dimensional Modeling, Semantic Layer architecture, Master Data Management, and enterprise-scale analytical data platforms.
Extensive experience implementing data governance and data management frameworks using Microsoft Purview, Unity Catalog, metadata management, data lineage, data quality, security, and compliance best practices.
Hands-on expertise in building scalable ETL/ELT frameworks using Microsoft Fabric, Azure Synapse Analytics, Data Factory, Databricks, Snowflake, Matillion, and modern cloud-native data engineering technologies.
Experienced in designing Databricks-based Medallion Architecture solutions leveraging Delta Lake, Unity Catalog, performance optimization, workload governance, and cost management strategies.
Proven track record of delivering Microsoft Dynamics 365 F&SCM, Customer Engagement, and Business Central analytics platforms across Finance, Supply Chain, Manufacturing, Procurement, Inventory, Sales, Marketing, and Customer Service domains.
Experienced in leveraging GenAI, Azure OpenAI, Claude, MCP, AI Chatbots, and Data Agents to deliver conversational analytics, knowledge assistants, intelligent automation, and AI-powered business insights.
Proven ability to lead and mentor global cross-functional teams of 60+ Architects, Engineers, Analysts, and AI professionals while driving architecture governance, budgeting, forecasting, utilization planning, Centers of Excellence, and strategic delivery initiatives.
Active contributor across the full project lifecycle, including enterprise architecture strategy, stakeholder engagement, digital transformation roadmaps, accelerator development, presales solutioning, proposals, SOWs, POCs, and business growth initiatives.
Sr. Technical Architect Synoptek, Ahmedabad
12/2021 – Present Project: Data Engineering/BI/Analytics/AI (Industry: Multiple) Data Engineering Modernization Microsoft Fabric Azure Synapse Analytics AWS GCP Databricks Snowflake Matillion OpenAI/LLM Python MSSQL Server Medallion Architecture Lakehouse MSBI Dimensional Modeling Data Governance Semantic Model Power BI Tableau QlikSense
• Manufacturing • Transportation • Market Research & Consumer Insights • Competitive Intelligence
• Ecommerce • Retail • Healthcare • Insurance • Finance • Waste Management
*********@*****.***
Ahmedabad, India
Hiren Kapadia
Head of Data Architecture
Seasoned Data Architecture and Engineering leader with over two decades of experience designing scalable, cloud-native data platforms across Microsoft Fabric, Azure, AWS, GCP, and Databricks. Expert in Lakehouse and Warehouse architecture, RTI, semantic modeling, data governance, and AI- driven analytics. Proven leader in enterprise data modernization, leveraging GenAI/LLMs and conversational data solutions for business insights. Plays a strategic role in forecasting, budgeting, team utilization, and presales solutioning. Adept at translating complex business requirements into actionable data architecture roadmaps that drive digital transformation, operational analytics, and AI adoption across retail, manufacturing, healthcare, and logistics industries. Enterprise Data Architecture & Modernization
Architect and lead enterprise data modernization initiatives, transforming legacy data warehouse and BI platforms into scalable Microsoft Fabric, Azure, and Databricks-based Lakehouse and Warehouse architectures.
Define enterprise data strategies, target-state architectures, governance frameworks, operating models, and modernization roadmaps aligned with business and digital transformation objectives.
Design enterprise-scale data platforms leveraging Medallion Architecture (Bronze, Silver, Gold), OneLake, Lakehouse, Warehouse, Direct Lake, Semantic Models, and Real-Time Intelligence (RTI) capabilities. Microsoft Fabric Architecture & Governance
Led multiple Microsoft Fabric implementations covering OneLake, Lakehouse, Warehouse, Data Factory, Dataflows Gen2, Eventstream, Activator, Semantic Models, Direct Lake, and Power BI.
Established Fabric governance standards including workspace architecture, security models, deployment pipelines, CI/CD processes, naming conventions, monitoring strategies, and capacity management.
Managed Fabric administration activities including workspace governance, capacity planning, workload optimization, performance tuning, access management, and operational monitoring.
Implemented enterprise semantic layer strategies using reusable semantic models, governed metrics, calculation groups, and self-service analytics frameworks.
Domain-Centric Data Platforms (D365 & Enterprise Applications)
Designed and implemented Fabric-based analytical platforms integrating Microsoft Dynamics 365 Finance & Supply Chain Management (F&SCM), Customer Engagement (CE), and Business Central.
Delivered cross-functional analytics solutions spanning Finance, Procurement, Inventory Management, Manufacturing, Supply Chain, Sales, Marketing, Customer Service, and CRM domains.
Defined enterprise data models, master data strategies, business glossaries, and analytical data products supporting executive reporting and operational decision-making. Data Governance, Modeling & Metadata Management
Implemented enterprise Data Governance frameworks using Microsoft Purview, including data cataloging, lineage, business glossary, data classification, stewardship, security controls, and compliance processes.
Led Conceptual, Logical, Physical, and Dimensional Data Modeling initiatives for Lakehouse, Data Warehouse, and Semantic Layer implementations.
Developed metadata-driven ingestion frameworks, reusable data quality controls, reconciliation mechanisms, and governance-ready architecture blueprints.
Cloud & Databricks Architecture
Designed and implemented modern cloud-native data platforms utilizing Microsoft Fabric, Azure Synapse Analytics, Azure Data Factory, Databricks, Snowflake, AWS, and GCP technologies.
Architected Databricks Lakehouse solutions using Delta Lake, Unity Catalog, Medallion Architecture, workload isolation, cluster governance, performance optimization, and cost management strategies.
Developed scalable ELT frameworks supporting batch, micro-batch, and streaming ingestion from SAP Hana, D365, SQL Server, APIs, flat files, and third-party SaaS applications. Generative AI/ LLM Enablement
Collaborate with data science teams to deliver GenAI/LLM based use cases including personalization, forecasting, and customer insights. Leverage OpenAI (GPT via Azure/OpenAI API) for LLM-driven applications like content generation, summarization, and conversational analytics.
Accelerators & Platform Engineering
Led development of reusable accelerators for Microsoft Fabric modernization, metadata-driven ingestion, governance implementation, semantic model automation, and data quality frameworks.
Developed Azure Tenant Migration accelerators supporting migration and validation of Power BI, Azure Data Factory, Azure Functions, Azure Data Lake Storage, Databricks, Key Vault, and supporting platform services.
Leveraged Claude and MCP-based automation frameworks to accelerate architecture documentation, impact assessment, code generation, test case creation, and migration planning activities. Solution Advisory & Business Development
Act as a trusted advisor to C-level executives, business stakeholders, and technology leaders, translating strategic objectives into scalable data architecture roadmaps.
Lead architecture workshops, modernization assessments, solution reviews, migration planning exercises, proof-of- concepts, and executive presentations across multiple industry verticals.
Contribute to business growth through proposal development, Statements of Work (SOWs), solution estimation, architecture governance, and strategic presales engagements. Senior Data Architect Cygnet Infotech, Ahmedabad 09/2020 – 12/2021 Project: Datawarehouse/ELT/BI (Industry: Digital Advertising)
Successfully designed and implemented an ELT solution by utilizing Matillion ETL to extract and transform data from multiple sources to S3 buckets and loading to Snowflake.
Led the data model design and database migration deployment production releases, ensuring successful implementation across Dev, QA, and Prod environments on AWS Cloud (Snowflake).
Worked on SnowSQL and created Snowpipe for continuous data load, including transforming data during load using internal/external stages.
Involved in logical and physical dimensional modeling, data cleansing, standardization procedures, and business transformation rules (ELT). Used GitHub for version control and peer review of Matillion jobs. 04/2020 – 12/2020 Project: Enterprise Data Warehouse (Industry: Insurance)
Involved in architecting and developing Azure Data Factory pipelines to move data from a legacy application database to Azure Data Lake Storage raw zone.
Built pipelines to transform data from the staging layer to Azure SQL Database.
Built data marts and multi-dimensional models (star/snowflake schema) and developed multi-dimensional/Tabular models in Analysis Services. Set up Power BI Reporting Server (PBIRS) and managed the migration of SSRS reports to PBIRS.
Delivered data cleaning solutions, mapping/transitions rules, and data integrity solutions for applications, migration, and integration.
Head of BI MicroOrbit Consulting, Ahmedabad
06/2019 – 04/2020 Project: Business Intelligence & Analytics (Industry: Waste Management)
Closely involved with Sales & Marketing to support initiatives by providing quality insights and recommendations to achieve maximum value creation.
Managed data migration from On-premises SQL database to Azure SQL Database and Azure SQL Datawarehouse using Data Factory.
Consulted with Sales, Marketing, Logistic, and Finance to develop the BI system, monitor KPI data, and measurements to promote budgeting and forecasting. Developed various dashboards for core departments using Tableau and Qliksense.
Migrated aggregate data from MSSQL to Redshift DB using Alteryx and pulled data using API endpoints within SSIS Principal Technical Architect Cygnet Infotech, Ahmedabad 11/2017 – 05/2019 Project: Business Intelligence & Data Warehouse (Industry: Retail)
Designed a Rule-based system for predicting sales, store transfer, and ordering inventory.
Finalized technology stacks (MySQL, Pentaho, Mondrian, MongoDB, Power BI, Python). Designed tenant-specific Dimensional Modeling for the Data Warehouse.
Designed ETL solutions using Pentaho Data Integration (PDI/Kettle) to load data from legacy systems to DW. Implemented table partitioning and performance improvement to optimize daily ETL operations.
Created Mondrian schema for various Data marts and developed Cubes for Sales, Inventory, Customers, Employees, and Digital signage. Built several dashboards using Power BI.
Led a team of 19 developers, providing technical solution guidance and managing Proof of Concepts (PoCs) 06/2018-11/2018 Project: EMR Data Migration (Industry: Healthcare)
Migration Process: Architected the full EMR data migration pipeline: pulling data from various sources (MSSQL, MySQL, CCDA), loading to a Sandbox (Linux) using Python 3.7, moving data files to Amazon S3, and then loading to Amazon Redshift using Python jobs.
02/2016 – 11/2017 Project: Fleet Management (Industry: Transportation)
Led the Enterprise Data Management team; designed and implemented MSBI solutions (SSIS, SSAS, SSRS) for data warehouse and datamart.
Developed complex ETL packages from multiple sources with incremental loads, error handling, and logging, and created dimensional models for analytics.
Built OLAP cubes and authored MDX queries to populate performance reports, dashboards, and scorecards.
Architected MDM and data warehouse frameworks to deliver reliable transportation analytics and insights. BI & Data warehouse Architect SAN Healthsoft, Ahmedabad 04/2015 – 02/2016 Project: EDW & Reporting System (Industry: Healthcare) Data Architect APIMA Consulting (subsidiary of Numerator / MarketTrack), Vadodara 07/2011 – 03/2015 Project: ETL, EDW, BI, Analytics (Industry: Market Research & Consumer Insights Competitive Intelligence)
(CPG/FMCG Focus)
Database Architect / Project Manager Gateway Technolabs, Ahmedabad 06/2006 – 07/2011 Project: EDW & BI Solution (Industry: Healthcare) Project: Online Ticketing System (Industry: Ecommerce) Project Leader Globaltech (I) Pvt Ltd, Ahmedabad 02/2005 – 06/2006 Project: IOMS (Industry: Manufacturing) SSE Arraycom (I) Pvt Ltd, Gandhinagar / Vadodara 10/2000 – 02/2005 Project: Multiple (Industry: AVL, Satcom)
Contact this candidate