Developed and Optimized Store Procedures, SSIS Packages, SSRS Reports, Dynamic SQL, SQL Cursor, Profiler, Joins, Views, and User-Defined Functions for the Application.
Good hands-on T-SQL skills (Procedures, Functions, Triggers).
Strong hands-on experience in developing Business Intelligence solution with the Microsoft Business Intelligence stack.
Hands–on experience with SQL Server Reporting Services to design Reports.
Create SQL Server Integration Services (SSIS) Packages Data Migrations.
Performed on the Stored Procedures for the requirement to handle the errors with the help of SQL Debugging.
Modify the database like DDL, DML in SQL Server.
Create Stored Procedures, functions, index, and cursor, Dynamic query using T-SQL programming.
Perform database backup and restore, check database transaction traffic.