• Developed and delivered optimized stored procedures, leveraging SQL server concepts such as views, UDTs, scalar functions, CTEs (including recursive CTEs), temp tables, and window and analytical functions to meet specific requirements• Enhanced performance and adherence to standards by improving legacy SQL scripts through modifications and updates to logic, indexes, joins, and constraints.• Collaborated with Customer Professional Support to fulfill client requirements and generate customized reports using i-NET Clear Reports• Conducted comprehensive analysis of database performance, evaluating various settings including different non-clustered indexes and compression, and effectively communicated findings to the team• Utilized BDD methodology to foster collaboration, clarify requirements, automate tests, and document system behavior• Proficiently utilized C# and ADO to efficiently extract and manipulate data from databases• Leveraged Git extensively to effectively manage version control and streamline software delivery procedures.

Technologies Used: Azure Data Factory, Azure Synapse Analytics, PySpark, ,Azure Databricks, Azure Active Directory, Key Vault, Azure Monitor, Data Warehouse Architecture, Data Modelling • Created ingestion data flows using Data Factory, Synapse Analytics and Datalake (ADLSG2) integrating 20+ diverse datasets into a centralized platform, optimizing data integration efficiency • Conducted transformative data operations on the Azure Databricks platform using PySpark, SQL and Hive, enhancing processing efficiency, and performed performance tuning, ensuring optimal performance of workflows.• Participated in cross-functional team meetings to design and implement data models, ETL processes, and data validation and governance strategies, ensuring the seamless integration of diverse data sources.