Aryan Salunke

• Professional IT Industry 3.1 Years of Experience as a software development experience in the areas of Microsoft Business Intelligence (MSBI) development and Having Knowledge in Data Warehousing (DW) applications primarily using Microsoft SQL Server 2012/2014 stack.
• Hands on experience in Extract, Transform & Load (ETL) development using SQL Server Integration Services (SSIS), Power BI and SSRS

  Project : COMMINSURE

  Role : SSIS Developer, SQL Server

  Environment : SQL Server 2012& 2016, SQL Server Integration  Services.

  Roles & Responsibilities: 

• Designed, Created and Implemented complex ETL Strategies using SSIS packages that extracted and loaded the data from different heterogeneous sources like Flat Files, Excel Files, Oracle & DB2, CSV and SQL Server.
• Involved in business requirement document preparations by communicating with business and their needs.
• Deployed various types of SSIS transforms in package including slowly changing dimension, Derived Column, Data Conversion, Aggregate, Sort, Conditional Split, Look Up, OLE DB Command, Merge, Merge Join, Pivot, Unpivot, Union All, etc…
• Developed master child package technique to manage ETL projects efficiently.
• Extensively used SSIS tasks such as For Each Loop, Execute SQL task, Script task, File System task, Execute package task, Data flow task and Bulk Insert task etc...
• Created, Configured and Scheduled Jobs with SSIS packages in SQL Server 2016. Configured SSIS packages in Job using XML, SQL Server table and parent package configuration.
• Created Database and Database Objects like Tables, Views, Stored Procedures, Functions, Indexes and User Roles in SQL Server 2016/2008.

• Date of Birth : 13-10-200
• Nationality : Indian
• Marital Status : Unmaried

I hereby declare that above details are true and correct to the best of my knowledge it would be pleasured to work in your firm.

Place : Pune

Name : Aryan Salunke