 Seasoned MSBI developer with over 2+ years of experience in IT, Business Intelligence (BI) and Data warehouse lifecycle, utilizing a range of SQL server tools such as Azure Data Factory, Azure Analysis Services, SSIS, SSAS, SSRS for various BI and reporting tasks.  Experienced in design and development of ADF Pipelines, SSIS packages to extract, transform, and load data from both homogeneous and heterogeneous sources, including JSON files and databases, into data warehouses (OLAP) based on user requirements.  Experienced in coordinating across various phases of Software Development Life cycle (SDLC).  Strong command over creation of various Database objects like Tables, Views, Indexes, Stored Procedures, and User Defined Functions.  Proficient in creating Workflows based on Functional Specification Document.  Experienced in Deploying ETL packages in SQL Server and further creating, scheduling and monitoring SQL Server Agent jobs.  Proficient in optimizing SQL queries, performance tuning using SQL Profiler as well as understanding execution plans.  Extensive knowledge on SSRS Tabular model.  Experienced in creating various reports like Tabular, Matrix, Drill down, Drill-through, Parameterized, Cascading, Conditional, Chart, Sub Reports and deploying reports in report server.  Demonstrated knowledge of SDLC, including Azure DevOps, Agile methodologies, SCRUM, and TFS.  Experienced in conducting Unit Testing, System Integration Testing and User Acceptance Testing.  Worked closely with Project and Program Managers, Business Analysts, and Data and ETL specialists to determine the precise business rules and functionalities required for the deliverables.  Strong analytical and leadership qualities with excellent communication skills.