SUMMARY:

• Microsoft Certified Professional with 8 years of IT experience as a MS SQL Server Developer 2005/2008/2012 in various industries like Financial, Health-Care and Insurance
• Extensive experience in MS SQL Server 2008/2005/2000, Business Intelligence in MS SQL Server Integration Services and MS SQL Server Reporting Services
• Extensive experience in Extracting, Transforming and Loading ETL using SSIS, bulk insert, BCP, DTS packages into the Data warehouse from heterogeneous databases
• Proven ability in utilizing ETL tools including SQL Server Integration Services SSIS , Data Transformation Services DTS
• Expert in creating and deploying SSRS Reports on the portal for user accessibility
• Experienced in writing parameterized queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and sub totals for the reports using SSRS 2008/2005
• Supported large user groups in productions and work closely with OLTP and OLAP/ data warehouse infrastructure management teams and database administrator
• Expert in deploying SSRS reports on the portal for user accessibility.
• Highly proficient in using T-SQl for developing complex Stored Procedures, Tables, Views, SQL Joins and T-SQL Scripting
• Expert in transforming complex business logic into database design maintaining it by using SQL objects like User Defined Functions and Views
• Worked with third party tools like AQT, Attach Mate, Star-Team, SVN,TFS and Visio
• Excellent communication and inter-personal skills with ability to develop creative solutions for challenging client needs using agile methodologies
• Flexible and versatile to adapt to any new environment and work on any project.

Technical Skills:

• RDBMS/DBMS : MS SQL Server, MS Access
• Database Technologies/Tools : SQL Server Enterprise Manager, T-SQL, OLTP, OLAP, Query Analyzer,
• SQL Profiler, DTS, SSIS, SSRS, Replication, DBCC, BCP
• Operating Systems : Windows XP, 2003, 2000, Windows 3.0, MS DOS 4.0 6.2
• Programming Languages : SQL, TSQL, XML, HTML, C, C
• Web Tools : Internet Information Server IIS , FTP, MS Office 2007/2003, MS
• Excel 2007/2003, MS Outlook 2007/2003

Professional Experience:

Confidential

SQL/SSIS Developer

Responsibilities:

• Involved in Business Meetings to gather the requirements.
• Created and customized packages using SSIS to load data from difference sources into SQL Database.
• Extensively involved in designing the SSIS packages to export data of flat file source with fixed width and pipe delimited files to SQL Server database.
• Used SSIS to create ETL packages to validate, Extract, Transform and load data from different Databases to the Data Warehouse.
• Performed data analysis, data conversions and source to target mapping using transformations.
• Dealt with duplicates and Primary Key Missing data and redirected it to the rejected records using SSIS.
• Involved in moving the data from SQL Databases to Netezza using SSIS.
• Used Advanced Query Tool AQT to check the queries on Netezza and used to generate statistics on huge data.
• Involved in granting the permissions to the group using AQT on Netezza.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Used Table Definition and Audit table for error handling and created loggings for all the packages.
• Wrote T-SQL code for handling the data validations.
• Designed and implemented batch scripts through SQL Jobs for automating tasks.
• Created email notifications tasks for Success and Failure of Tasks.
• Scheduled SQL jobs on a Daily basis, Weekly basis and Monthly basis based on the application.

Environment: MS SQL 2008R2/2012, Microsoft SSIS, Excel, Text Files, Bat Files, MS Visio, Advanced Query Tool, Star-Team, Netezza and Attach Mate

Confidential

SQL/SSISDeveloper

Responsibilities:

• Used SSIS to create ETL packages to validate, Extract, Transform and load data from different Databases to the Data Warehouse.
• Worked on Agile environment as a team for the success of the project go-live.
• Scheduled jobs for executing the stored SSIS packages which were developed to update the database on a daily basis.
• Loaded on demand source files to SQL Server destination using SSIS.
• Used Procedures, Functions and Views in the SSIS packages in Development and Production environment.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of User Support
• Responsible for Creation of Database, Tables and assigning the roles.
• Created objects like Procedures, Functions, Packages, Indexes and Views using T-SQL Scripts in Development and Production environment.
• Rebuilding the indexes at regular intervals for better performance.
• Monitored and modified Performance using execution plans and Index tuning
• Was part of comprehensive Backup plan and disaster recovery strategies.

Environment: SQL Server 2005/2008R2/2012, T-SQL, Windows 2003 Server, SSIS, SSRS, DB2, Excel

Confidential

Role : SQL/SSIS/SSRS Developer

Responsibilities:

• Analysis, Design and Development of the requirements based on Application Functional Document AFD .
• Providing analytical and technical support in the design, development, and implementation of applications in a SQL environment.
• Created SSIS packages to Extract, Transform and load data using different transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension, Merge Join and Union all.
• Created archive folders and variables to the packages for success/Failure.
• Create and modifying various Stored Procedures used in the application using T-SQL.
• Design and Create Packages in SSIS for file transfer, and data movement across databases.
• Design and Develop the reports in the form of Excel and text files.
• Developing complex Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports, Matrix reports and linked reports using SSRS
• Deployed and scheduled reports using SSRS to generate weekly and monthly reports
• Designed security based Roles in SSRS SQL Server Reporting Services .
• Managed Reports accordingly with the business user requirements.
• Created and managed the database, tables, stored procedures, functions and views.
• Analyzed and manipulated data using T-SQL queries.
• Scheduled jobs for executing the packages which were developed to update the database on day to day basis.
• Involved in index tuning for better performances.
• Involved in Development, QA and Production environments.
• Document all work of ING applications, so users can easily understand the flow of process.

Environment : MS SQL Server 2008R2, Microsoft SSIS, Microsoft SSRS, MS Visio, Excel, Share Point Portal, QRM , SVN and AC

Confidential

Role: SSIS/SSRS Developer

Responsibilities:

• Involved in the Requirement Analysis, Design and Development phase of the project.
• Created SSIS packages to extract data from OLTP to OLAP systems and scheduled jobs to call the packages and stored procedures.
• Used SSIS to implement the Slowly Changing Transformation, to maintain historical data in data warehouse.
• Extensively involved in designing the SSIS packages to export data of Excel spreadsheets and flat files sources to SQL Server Database.
• Worked with development team to document ETL requirement and turn those requirements into ETL jobs
• Schedule and maintained routine SSIS packages and alerts using Event Handler in SSIS and SQL Server Agent
• Developed, scheduled and generated variety of reports like List, Matrix, Drill-Down, Chart and Sub Report and standardize company report by implementing SQL Server Reporting Services SSRS
• Design standard and menu driven subscription to generate ad-hoc reports
• Used notification services to generate error messages and send them to the users through e-mails and text messaging
• Involved in trouble-shooting SSRS reports and maintained proper documentation for future references and used role based security to control access to folders and reports
• Used Report Manager to deploy and schedule reports and created groups and users
• Troubleshooting performance issues, optimizing and performance-tuning queries and stored procedures and providing consultation to other developers
• Implementing and administering database replication, database mirroring, log shipping
• Used SQL Server profiler to monitor and trace the events
• Created stored procedures and user defined functions to support efficient data storage, manipulation and report creation Optimized the overall performance by creating clustered and non-clustered indexing, index views and stored procedures

Environment : SQL server 2008/2005/2000, VB.Net, ASP.Net, SQL Server Integration Services SSIS , SQL Server Reporting Services SSRS , .Net Framework 2.0 3.5, Team Foundation Server Visual Studio 08 10

Confidential

Role: SSIS/SSRS Developer

Responsibilities:

• Designed and developed SSIS packages to extract , transform and load various data sources such as text files, CSV files, Excel spreadsheets and Oracle data into SQL Server 2005 for further data reporting and analysis
• Performed various transformations on data such as Data Conversion, Conditional Split, Term Extraction, Execute SQL task, Bulk Insert, Merge and Union all etc
• Implemented Complex loggings in SSIS packages
• Scheduled jobs for executing the stored SSIS packages which were developed to update the database on daily basis
• Developed reports using SSRS
• Created different types of reports such as drill-down, list, matrix and ad-hoc reports to meet business requirements using SSRS
• Created dynamic reports using SSRS for monthly claims and details of all locations, generated report models using report builder for the end users
• Assisted in scheduling and deployment of the reports and also assisted in uploading files to a report server catalog from the report manager
• Scheduled the monthly/weekly/daily reports to run automatically.
• Created and manage notification services to manage packages on success, completion and failure
• Created and managed stored procedures, indexes, views, user defined functions and database constraints to meet business requirement and policies

Environment: SQL Server 2005, 2008, T-SQL, SSIS, SSRS, Query Analyzer, MS-Access, SQL profiler

Confidential

Role: SQL Developer/ SSIS/SSRS

Responsibilities:

• Transformed data from MS SQL Server 2000 to MS SQL Server 2005 using OLE DB Connection by creating various SSIS packages
• Developed DTS Packages to transfer the data between SQL Server and other database and files.
• Created the DTS packages in which records were loaded daily in order to create and maintain a centralized Data Warehouse
• Used SSIS to create ETL packages to validate, Extract, Transform and load data from different Databases to the Data Warehouse and Data Marts.
• Scheduled jobs for executing the stored SSIS packages which were developed to update the database on a daily basis.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS 2005
• Generated various reports like Tabular reports and Drill down reports, Sub reports and Parameterized reports using SSRS.
• Responsible for Monitoring and tuning Report Performance.
• Created objects like Procedures, Functions, Packages, Indexes and Views using T-SQL Scripts in Development and Production environment for SQL Server 2005
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of User Support
• Creating stored procedures, batch scripts, cursors for the Bulk application, testing on the test servers and moving them to production
• Responsible for Database creation, database tuning, performance planning and database administration
• Rebuilding the indexes at regular intervals for better performance.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency
• Monitored and modified Performance using execution plans and Index tuning
• Was part of comprehensive Backup plan and disaster recovery strategies.

Environment: SQL Server 2000/2005 with clustering, T-SQL, Windows 2003 Server, DTS, SSIS, SSRS, Oracle, DTS, Excel, Access, IIS

Confidential

SQL Server/SSIS/SSRS Developer

Responsibilities:

• Migrated DTS packages from SQL Server 2000 to SQL Server 2005 as SSIS Packages
• Experience in creating complex SSIS packages using proper control and data flow elements
• Experience in Extracting, Transforming and Loading data from Excel, Flat file to MS SQL Server by using BCP utility, SSIS services
• Created SSIS Packages using different type's task and with Error Handling
• Regular Monitoring of Servers which includes Backup Job Monitoring, Disk Space Monitoring, Services Monitoring, Block Monitoring and troubleshoot all the issues on a regular basis
• Created SSIS packages for daily sales and delivery reports as well as for adhoc data transforms and data extraction for the Data Migration team and also upgraded DTS packages to SSIS packages
• Developed SSIS Packages to transform data from excel/Access file to SQL Server database.
• Extensively involved in using SSRS to author, manage and deliver both paper-based and interactive Web-based reports
• Experience in building Adhoc reports, Parameterized reports, Toggle reports, Matrix reports, reports with Sub reports using SSRS
• Maintained and configured SQL Server Report Server
• Performance Tuning upon the live databases. This includes scanning for performance bottlenecks and troubleshoots them in order to provide the best service with the Servers
• Creating and Modifying Tables, Stored Procedures, Views, Indexes and User-defined Functions as required
• Tuning Queries and Database performance using tools SQL Server Tuning Advisor, SQL Server Profiler

Environment: SQL Server 2005, MS Access, Windows 2000, T-SQL, SSIS, SSRS, SSMS,SQL Profiler, Performance Monitor, DTS, Erwin, MS Visio.