Process the facts, dimensions and implemented aggregation on granularity basis.Used Control Flow Tasks like For Loop Container, For Each Loop Container, Sequential Container, Execute SQL Task, Script Task, File system 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 and OLEDB Command to load data into SQL Server destination.Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.Maintaining the Log and Audit information in the SQL tables.Designing and Deployment of Reports for the End-User requests using Report Models& SSRS.Creating the reports as per client’s requirements in the form of table, matrix, Chart, navigation.