As a seasoned data engineer, I specialize in leveraging cutting-edge technologies like Azure Data Factory, Azure Databricks, and Apache NiFi to automate complex data processes using SQL and Python, from extraction to transformation and loading. With a keen focus on efficiency and accuracy, I've designed and implemented real-time and on-demand data warehouses across diverse domains such as banking, sales, and HR for both on premise and cloud based data sources.I am also skilled in SQL optimization techniques such as table indexes, filtering datasets, and adjusting join conditions. Using TSQL (SSMS) I have created hundreds of stored procedures for data cleansing and transformation purposes for use within the data warehouse and reporting. Moreover, I've built numerous real-time SSIS packages in Visual Studio for data warehousing seamlessly integrating multiple on-premise data sources while implementing automatic error handling, logging, and monitoring to ensure robustness and reliability.My proficiency extends to methodologies like Agile and tools like JIRA, ensuring smooth execution of tasks within sprint cycles. Additionally, I am highly effective in working on-call support and root cause analysis as I've maintained the integrity and functionality of critical data pipelines while resolving JIRA support tickets.In the past as a report writer, I’ve spearheaded the migration of production reports to leverage centralized data warehouse sources, guaranteeing consistency and accuracy in reporting. Additionally, my expertise in SSAS and SSRS has enabled the creation of dynamic dashboards and automated report subscriptions using Power BI and Report Builder, empowering stakeholders with actionable insights and facilitating informed decision-making.