Msbi & Sql Developer
Summary
Having 9 years of experience in SQL Server, SSIS, SSRS services(MSBI), ETL, Automation.
Excellent T-SQL Developer skills including Stored Procedures, sub-queries, joins, Cursors, CTE, temp tables,DDL/DML queries, Indexes, Views, Triggers, Transaction.
Experience in Managing Jobs, Alerts, SQL Server Agent and Scheduled SSIS Packages.
Worked on Performance Tuning, Query Optimization by creating various clustered and non-clustered indexes, troubleshoot slow running query, Extended Event, SQL server profiler.
Worked extensively with Data Adapter, Dataset, Data reader as a part of ADO.NET to access and update database.
Designing, building, testing and deploying SSIS packages on various SQL server versions such as 2008 R2, 2012 and 2016 Achieved Automation of SSIS, SSRS build and deployment.
Worked with SSRS Configuration Manager, Deploy Reports using BIDS/Report Manager, Cached Reports, Linked Reports, Report Snapshots, History Snapshots, Reports & Data driven Subscription.
Expectations
Good work life balance, Good Work Opportunity
