We provide IT Staff Augmentation Services!

Sql Server Developer Resume Profile

MN

A skilled software professional with 8 plus years of industry experience in design, development and implementation of business requirements with Microsoft SQL Server 2012/2008 R2/ 2008/2005 database system in client/server environment.

Followed the Microsoft recommended best strategies in designing, developing, and implementation and testing of the ETL using SQL Server Integration Services SSIS .

Expert in providing logging, error handling by using event handler and break points for SSIS packages.

Migrated organization orders, adjustments, objectives and data in various formats like text based files excel spreadsheets, to SQL Server databases using SSIS to overcome the transformation constraints.

Experience in handling Performance Tuning of SSIS using Horizontal Partitioning and Vertical Partitioning.

Designed complex T-SQL queries, User Defined FunctionsStored Procedures and Triggers in SQL Server 2012/2008/2005 followed by analysis and testing of those database objects before deployment to the production server.

Used SQL Server Integration ServicesSSIS2012/2008/2005 as an ETL Tool and created packages for the extraction of data from disparate sources SQL Server, Flat Files, Excel Source files, XML Files etc and loaded the data into target tables by performing data validation and cleansing using various transformations.

Well versed with different components of SSISControl Flow, Data Flow and Connection Manager while extensively using different kinds of Containers, Control Flow Tasks and various Transformations under data flow tasks.

Created Master SSIS packages in order to execute a set of packages on a timely basis and deployed those packages using Manifest Files and Import/Export Wizard so that the packages were available for use to other team members

Used SSRS Reporting servicesSSRS 2012/2008 to write complex formulas and to query database to generate different types of reports Drill Down, Drill Through, Linked, Sub-reports, and Parameterized for Business Intelligence.

JavaScript Requires
Sorry this site will not function properly without the use of scripts.
The scripts are safe and will not harm your computer in anyway.
Adjust your settings to allow scripts for this site and reload the site.