Manikandan

ABOUT ME

• Having 5+ years of professional software development experience in the areas of Microsoft Business Intelligence (MSBI) and Having Knowledge in Data Warehousing (DW) applications primarily using Microsoft SQL Server.
• Created SSIS package to extract, transform and load (ETL) data from different sources into destination target, like data warehouse, Flat file, Excel, OLE DB, using SQL Server Integration Services.
• Having a good Experience in Designing and Developing the SQL Server Integration Services-SSIS Packages with different Control Flow Tasks and Data Flow Transformations and Deploying the Packages.
• Knowledge in creating the stored procedures, Functions, Views, Joins, and Indexes using SQL Server.
• Ability to prioritize work and meet deadlines.
• Executed effective processes for modification of existing SSIS packages as per new business requirements.
• Extracted data from various sources like SQL Server 2008/2012, .CSV, Excel and Text file.
• Created SSIS packages which involved a variety of transformations such as Slowly Changing Dimension, lookup, Derived Column, Conditional Split and Data Conversion before loading the data into Data Warehouse.
• Created SSIS packages and involved in Package Configurations and deployments between Development and QA and Production servers so that various properties like variables, connection managers could be changed when moving the Package from one environment to another.
• Data loading to the production server on daily, weekly, Monthly basis.
• Created Procedures to implement the Business logic.

SKILLS