Having 14 years of professional software development experience in the areas of Microsoft Business Intelligence (MSBI) and Hands-on experience in Data Warehousing (DW) applications primarily using Microsoft SQL Server 2012/2014/2019 stack.
Having a good Experience in Designing and Developing the SQL Server Integration Services-SSIS Packages with different Control Flow Tasks and Data Flow Transformations, Securing Packages, and Deploying the Packages.
- Expertise in Performance Tuning, Optimization, Data integrity, and Statistics by using SQL Profiler
- Used SQL Profiler for Performance monitor to resolve Dead Locks and long-running queries by checking appropriate changes to Transaction Isolation levels
- Hands-on experience creating indexed views, Stored Procedures, Functions, Triggers, User Defined Functions, and Cursors using SQL Server 2012/2014/2019 with T-SQL
· Hands-on experience and outstanding knowledge in building and deploying the reports by using SQL Server Reporting Services-SSRS 2012.
· Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like table, matrix, Drill Down, Parameterized, Cascaded Parameter reports, and Sub-reports using SSRS.
· Experienced in Data Warehouse concepts. Having knowledge of SQL Server Analysis Services-SSAS 2012
Having knowledge in Dimensional Data Modeling, Cube development and manipulations in SQL Server Analysis Services (SSAS), and administration of SSAS and TABULAR DATA MODEL
· Experience working with Tabular Mode and Multidimensional mode databases
-Hands-on experience with MDX and DAX
- Hand-on experience With Power BI and administration of Power BI.
· Hands-on experience with SSRS and OLAP Cube Report Development, Design