Led and managed a diverse team of 10 data analysts and data engineers, seamlessly bridging the gap between offshore and onshore expertise. Collaborated closely with stakeholders, data analysts, and data engineers to architect and build solutions that precisely aligned with requirements. Remained at the forefront of Data Analytics and Data Integration best practices, infusing innovation into our solutions. Kept a keen eye on industry trends, ensuring our approaches were both effective and forward-thinking. Designed and developed efficient pipelines to ingest data from various source systems. Transformed and cleansed this data using Azure Data Factory (ADF) and Azure Databricks, loading it into Azure Data Lake, Azure Synapse, and Azure SQL DB as needed. Crafted a comprehensive Datawarehouse landscape within Azure Synapse. Created multiple functional DataMarts, tailoring them to specific business needs. Engineered a delta lake architecture, empowering data engineers, data scientists, and business users to create on-demand notebooks for diverse use cases. Designed a semantic model in Power BI, enabling the creation of various reports and dashboards. Implemented best performance tuning practices in ADF and Azure Databricks, ensuring efficient pipeline execution. Leveraged a metadata-driven ADF pipeline to handle data loads—whether full or incremental—based on source requirements. Analyzed complex legacy systems, deciphering the logic behind existing tables and columns. Created meticulous mapping documents to align with new systems. Designed an external system interface architecture, applying appropriate techniques and standards (including SQL Server, Duck Creek, IRIS, and Oracle General Ledger). Implemented robust Data governance using Azure Purview and Profisee. Engineered a golden record approach for master data management in the legacy system.

Led and managed a team of 8 developers onshore/offshore. Orchestrated the seamless integration of Policy and Claims data from diverse sources into our Ceded applications, ensuring accuracy and efficiency. Pioneered the implementation of a robust Master Data Management system within the application, centralizing critical business entities for consistency and reliability. Crafted dynamic Power BI reports that illuminate exceptions and reconciliation insights, empowering data-driven decision-making and process optimization. Engineered a comprehensive Control Framework, safeguarding data integrity, confidentiality, and availability across our operations. Engineered dimensional model for Policy and Claims data mart for insurance and reinsurance. Designed ETL solution with controls to run processed Historical as well as Ad-hoc. Designed a dynamic, data-driven reporting system to generate comprehensive financial statements with multiple tabs. This solution was highly acclaimed and resulted in a significant efficiency gain, saving the equivalent of 2 full-time employees (FTE). Designed various PowerBI analytical dashboards for Insurance/Reinsurance Premiums and Claims. Implemented solutions with data partitioning, indexing, used query tuning techniques. Creation of Database project, ETL solution, SSRS solution with source control in place with automated deployment. Designed and developed proof of concepts for the Risk Funding Program, integrating new data sources using various Azure Data Services. Presented solution diagrams to business users, illustrating both the current and future states. Developed and reviewed strategic roadmaps with business stakeholders. Collaborated seamlessly with stakeholders, analysts, and developers to ensure effective project planning and management.

This project involved sourcing planned and actual premium and claim data to create various metrics and dashboards for the business council. Led and managed work estimates and reviewed high level technical designs for BI team of 4. Designed PowerBI solutions with reusable templets which can be used within the organization. Designed ETL framework for data sourcing Engineered a comprehensive Control Framework, safeguarding data integrity, confidentiality, and availability across our operations. Created PowerBI data model which can be commonly used across solution Collaborated seamlessly with stakeholders, analysts, and developers to architect and build solutions that precisely aligned with requirements.

Insurance Data Platform (IDP) This integration project involved building a data warehouse for an insurance client by consolidating data from multiple sources. We developed a comprehensive data model and integrated all source data into it. Our framework for SSIS packages facilitated data flow from source to stage and finally to the data warehouse. To enhance performance, we implemented indexes and logical partitions. We created dimensions and facts for reporting and developed SSAS cubes and SSRS reports. Additionally, we implemented Power BI dashboards to provide quick insights for business users. Led an offshore team of 10 developers, providing guidance and support. Engaged with clients to understand their business requirements and provided consultation on project implementation. Designed and developed data models to support business needs. Conducted thorough data analysis and profiling to ensure data quality and integrity. Developed and optimized SQL queries, procedures, functions, and indexes. Designed and implemented SSIS frameworks for efficient data integration. Designed and implemented SSIS frameworks for efficient data integration. Designed metadata-driven models in SSIS using CozyRoc components. Conducted code reviews to ensure quality and adherence to standards. Extensively worked on performance tuning to enhance system efficiency. Participated in release management activities to ensure smooth deployments.

The bank manages various applications under the Mortgage Legacy Asset Servicing, originally developed in SQL Server 2000 with DTS packages tailored to business requirements. With over 1,000 daily jobs and report generation, the project focuses on migrating from SQL Server 2000 to 2012 and transitioning DTS packages to SSIS, along with creating new SSIS packages for the updated server. Engaged in gathering and understanding business requirements. Developed the approach for rewriting/migrating DTS to SSIS packages. Developed over 50 SSIS packages. Developed SSAS cubes and simple SSRS reports. Created reusable components for error logging, event handling, and configurations used across all packages. Led an offshore team of 4 developers, making decisions on logic changes and component updates, and resolving team issues. Participated in all technical discussions throughout the project phases. Extensively involved in resolving other developers’ issues during daily status calls. Extensively worked on performance tuning to optimize system efficiency. Participated in release management activities, including code reviews, QA reviews, and obtaining line of business approvals.

As a Software Developer, I contributed to the development of various web applications using .NET and C#. My projects included A ticketing system for the Bus Rapid Transit System (BRTS) A PDA application for the Gujarat Government’s Forest Department A financial reporting system for GSFS A result hosting platform for 10th and 12th grade exams for the Gujarat Education Board