• Extraction of data from Flat-Files into staging area, then cleansing the data using transformations and loading that information into Target tables.• Development of mappings according to the ETL specifications for the staging area data load & warehouse data load using Integration Services.• Implementation of Variables and Parameters in Mappings.• Using Control Flow Tasks like For Loop Container, For Each Loop Container, Sequential Container, Execute Task, Email Task and Data Flow Task,ScriptTask.• Extensive use of Derive Column, Row Count, Data Conversion, Conditional Split, Aggregate, Lookup and Sort to load data into Data Warehouse.• As per requirements, development of the reports in the form of Matrix, Table and Charts with Drill down and Drill-Through features using SQL Server Reporting Services.• Generation of weekly and monthly reports as per the Client’s Requirements.• Understanding existing business model and customer requirements.• Extensively worked in Scheduling and Deploying of Reports in Unit Testing.• Creation of SSIS packages to load data into Warehouse databases.• Working with Dataflow tasks with appropriate transformations like Derived Column, rowcount, lookup, and data Conversions to process the Raw Data.• Implementing SSIS Package Configurations with sensitive Information.• Implementing Logging for each SSIS package.• Involved in deployment for 2012 and implemented special configurations.• Developed T-Sql code like procedure and functions as per the requirement.• Involved in Unit testing and Deployment documents.• Creation of Sql Server agent jobs to run the SSIS packages on daily.

Digitization of classroomsGetting the required SoftwaresSystem configurations school database management using SQL