Extensive experience in data extraction, Transformation and loading (ETL) from SQL Server, Excel and Flat Files using 2014/2016.
Involved in creation of Complex SSIS packages using different kinds of Sources and Destinations.
Used Control Flow Tasks like For Loop Container, For Each Loop Container, Execute SQL Task and Data Flow Task in Designing packages.
Proven proficiency at Data Transformations like Lookup, Derived Column, Conditional Split, sort, data Conversion, Union All, Merge Join, Scd etc.
Experience in providing Error Logging and Error handling for SSIS Packages.
Designed different Types of reports like Drill Down, Drill Through, Multi parameterized and cascading reports.
Having extensive working experience on Configuration Tools like Report Manager, Configuration Manager in SQL Server Reporting Services (SSRS).
Strong ability in defining query Optimization for generating Sub Reports, Drill down reports, filters and handling parameterized reports and creating report layouts in SSRS 2014/2016.
Experience on Report Design, Development and Deployment using SSRS.
Strong Experience in creating objects like Stored Procedures, Functions, Cursors, Triggers, Indexes, joins and Views using MS-SQL in Development