Dilip Kumar Email & Phone Number

⇨ Having 11 years of Professional experience in IT industry, Involved in MSBI projects with extensive usage of ETL & Reporting tools like SQL Server Integration Services (SSIS), SQL Server Reporting Service (SSRS).⇨ Expertise in Data Warehouse applications, directly responsible for the Extraction, Transform and Load from different sources into Data Warehouse.⇨ Extensively worked on creating packages by implementing transformations, containers in Integration Services.⇨ Experience in extracting data from heterogeneous sources, transforming and loading process using MSBI. Loaded data into various tables through incremental, SCD approaches.⇨ Experience in providing Error Logging and Error handling for SSIS Packages.⇨ Created Tables, Views, Indexes, Stored Procedure and Triggers. Used multiple join statements to retrieve data and update the tables. Created Backend validations using Insert/Update and Delete triggers.⇨ Extensively used Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources and converted SAS environment to SQL Server. Developed, monitored and deployed SSIS packages.⇨ Worked in transferring the data using SQL Server Integration Services Packages Extensively used SSIS Import/Export Wizard for performing the ETL operations.⇨ Extensive knowledge of using System Variables and creating User-Defined Variables for SSIS Packages.⇨ Extensive knowledge of using Package Configuration wizard to configure SSIS packages.

• 

  Anna University

  Electronics And Communications Engineering