Utilized Agile Methodology and Scrum for project management, leveraging Azure DevOps and Jira for progress tracking, task allocation, and team communication.Collaborated closely with business users to capture and translate requirements into actionable BI solutions.Executed data architecture design, encompassing data models, integration strategies, and data quality protocols.Worked with diverse teams to ensure successful project outcomes, spanning project planning, risk mitigation, and stakeholder engagement.Architected and executed a data warehouse within Azure Synapse Analytics and a data lake using ADF and Databricks, fostering enhanced data governance and improved data accessibility.Proposed designs with cost and budget considerations in Azure, providing recommendations to optimize data infrastructure.Spearheaded the management of Azure SQL Database, Azure Synapse SQL Pools, Azure Data Factory, and Databricks notebooks for constructing Data Lakes and Data Warehouses to host Power BI reports.Conceived proof of concept (POC) solutions, showcasing the feasibility of Azure technologies like Azure Synapse, Azure Purview, and Azure Kusto Log Analytics through prototype creation.Developed Spark applications employing Spark-SQL within Azure Databricks to extract, transform, and aggregate data from diverse file formats, uncovering insights into customer usage patterns.Designed and deployed scalable and reliable big data pipelines, employing Azure Data Factory (ADF), ADLS, PYSPARK, Databricks Notebooks, and Azure Synapse.Erected a centralized data lake for processing daily price and promotional data utilizing Databricks and ADF. Leveraged Azure Data Factory for data ingestion and transformation from various sources, streamlining data preparation using PYSPARK, Python, and SQL in Azure Databricks.Created Delta Lake and Delta tables in Azure Databricks for efficient processing of large data volumes.

Engaged with developers and stakeholders to gather requisites and conceptualize data models. Collaborated with the architect and developers to devise ERDs, data mapping, and data dictionaries.Collaborated closely with the architect to engineer ERDs, data mapping, and data dictionaries.Engaged in code reviews to ascertain code quality and alignment with best practices. Employed advanced SQL scripting techniques, including window functions, for data validation and exploration.Designed SQL views, triggers, UDFs (User-Defined Functions), and stored procedures to facilitate data processing and analysis.Held responsibility for optimizing performance of slow SQL queries to enhance overall database efficiency. Devised intricate T-SQL scripts for data analysis, manipulation, and report generation. Instituted and maintained indexes to streamline query execution time.Fixed production issues and offered prompt resolutions to ensure sustained system availability.Designed data models and database structures for diverse applications, generating T-SQL scripts for data analysis, manipulation, and report generation.Contributed to data engineering tasks within a cloud migration initiative, transitioning on-premises SQL servers to Azure SQL databases. Orchestrated effective data solutions using Azure Data Factory and T-SQL scripts.Operated within a large team, actively participating in Agile methodologies involving sprints and sprint planning via Azure DevOps for project management.Erected data lakes using ADLS to house and administer extensive datasets. Devised ETL pipelines employing Azure Data Factory to harmonize data from diverse sources within the data lake.Established Logic App and Azure Monitor for streamlined error notifications and email-based communication to bolster data processing efficiency.Leveraged Function App to execute API calls to external services and applications.