MSBI Developer

Overview:

• 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.
• Data Modelling – Design database tables, schemas
• Snowflake
• Created ADF pipelines
• UNIX and scripting (Shell, Perl or Python)
• Created data bricks cluster