Sunil K.

Having 16 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