Summary:

• ETL/SSIS Developer having 8 years of IT experience in Requirement Gathering, Analysis, Design, Development and Implementation of Enterprise solutions.
• Excellent command in writing Dynamic and Advanced SQL queries in MS SQL Server 2008/2005/2000, and extensively experienced in using SQL/T-SQL/SSIS/SSRS/Perl.
• Excellent Programming experience in writing Complex Stored Procedures, Queries, Views, User Defined Functions, Cursors and Common Table Expressions using T-SQL.
• Experience in Performance Tuning and Query Optimization by Indexing, Partitioning and Denormalization.
• Expert in creating tables, indexes, keys, constraints and triggers to facilitate efficient data manipulation, integration and consistency.
• Excellent understanding of Entity-Relationship/Multidimensional Data Modeling Star schema, Snowflake schema , Data Warehouse Life Cycle and SQL Server Analysis Services SSAS .
• Extensively worked on Design, Development, Deployment Maintenance of ETL process using SSIS to Extract, Transform and Load ETL data from different sources Flat/Excel/Access/XML/SQL/Oracle to different targets DB/Files .
• Experience in creating master and child packages, package configurations, logging and in using variables and expressions in packages.
• Migrated DTS packages to SSIS using DTS editor wizard and generated reports using SSRS 2005/2008.
• Experience in Data Extraction, Transforming and Loading ETL between Homogenous and Heterogeneous System using SQL tools and utilities SSIS and Bulk Insert .
• Worked with tabular reports, matrix reports, parameterized reports according to business requirements in time restricted environment using SQL server reporting services SSRS .
• Experience in creating Jobs, Alerts, SQL Mail Agent and scheduling DTS Packages.
• Experience working in an Agile Environment.
• Highly committed, motivated and a natural team player with strong analytical ability.

Skills Set:

SQL Server Integration Services SSIS , SSRS 2005/2000, MS-SQL Server 2012/2008 R2/2005/2000,C ,VB 6.0, PL/SQL, T-SQL, TCP/IP, HTTP, UDP/IP and FTP, MS Visual Studio 2008/05/03, VSS, MS-SQL Server Management Studio, PL/SQL Developer, Windows XP/2000/NT/98/95, Oracle 10g/9i/8i, Team Foundation Server TFS .

Projects Summary:

Confidential

MS SQL/BI Developer

• Designed the ETL procedure required for modifications to the existing data.
• Documentation of SSIS packages and existing stored procedures.
• Creation of 20 SSIS packages for the migration of data from MS Access to SQL.
• Created stored procedures used in the creation of final reports.
• Improved efficiency of stored procedures from 3hours to 30mins using execution plan and SQL Server profiler.
• Performed unit testing and system testing.
• Created jobs and participated in implementation of deployment strategy.
• Assisted in the training of new and less experienced employees.

Environment: Agile, MS SQL Server Integration Services SSIS 2012, MS SQL Server Reporting Services 2008, Team Foundation Server TFS , XP, Excel, MS Office 2010

Confidential

Systems Application Developer

• Created data models and design diagrams using Oracle SQL Developer Data Modeler and Microsoft Visio.
• Creation and design of migration strategy for large tables with over 500 million records.
• Coordinated with team lead in the Implementation of migration strategy.
• Created stored procedures and Functions in PL/SQL Developer.
• Performed data transformation and loading using SSIS and Attunity connectors.
• Improved efficiency of SSIS packages.
• Assisted the QA process with unit testing and system testing.
• Performed performance tuning on existing stored procedures to improve efficiency of scripts.
• Improved efficiency of ETL scripts through use of dynamic sql.
• Created jobs and participated in implementation of deployment strategy.

Confidential

MS SQL/BI Developer

Responsibilities:

• Designed and implemented SSIS packages for credit and debit memo reimbursements.
• Documented all packages and technical steps involved in the Monthly Reimbursement process
• Created automated Monthly Master Processing Package.
• Created automated Vendor Initiated Reimbursement Release and Reimbursement Re-calculation Master processing packages.
• Created locking stored procedures to lock reimbursement period for Monthly Master Processing Reimbursement package and Vendor initiated Reimbursement Re-Calculation Master Processing package.
• Created stored procedures for the Vendor Initiated Processing Packages.
• Adjusted the Monthly Master Processing Package and Vendor Initiated Packages to ensure locking procedures are enforced as per requirement.
• Coordinated with the Internal Applications UI developer to ensure proper integration between user interface application and the backend ETL processes for the Vendor Initiated Processing Packages.
• Modified existing packages to load data from a different source into the Data warehouse.
• Utilized Script task to pass variables from child package to parent packages
• Created Vendor Grid CSV reports.
• Assisted with reviewing SQL Server Delta scripts for the Test QA environment.
• Implemented deployment strategy and created SQL jobs for the Master Packages.
• Utilized Team Foundation Server as a source control repository.

Environment: Agile, MS SQL Server Integration Services SSIS 2008, MS SQL Server Reporting Services 2008, MS SQL Delta, Team Foundation Server TFS , XP, C , Excel, MS Office 2010

Confidential

MS SQL/BI Analyst

Responsibilities:

Designed high level ETL architecture for overall data transfer from the OLTP to Data warehouse with SSIS and also prepared ETL mapping processes.

Created SSIS Packages to integrate data coming from Text files and Excel files and developed, deployed and monitored SSIS Packages.

• Used various SSIS tasks such as Conditional Split, Derived Column etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Implemented various tasks and transformations for data cleansing and performance tuning of packages by using SSIS.
• Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages.
• Created local variables and global variables package configurations and error handling.
• Designed, created and deployed parameterized and ad-hoc reports into the production server using Report builder, for the brokers and clients.
• Created complex stored procedure to copy Database Objects from remote server to local machine and vice versa.
• Identified slow running query and optimization of stored procedures and tested applications for performance, data integrity using SQL Profiler.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.
• Utilized Team Foundation Server TFS for Source Code Control of Stored Procedures.
• Extracted, transformed and loaded data using SSIS Import/Export Wizard.

Environment: Agile, MS SQL Server 2008 R2 SQL2008 R2 ,MS SQL Server Integration Services 2008, MS SQL Server Reporting Services 2008, Oracle 9i, MS Excel, C ,DTS, BCP, T-SQL.

Confidential

MS SQL Developer

Responsibilities:

• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS and performed documentation for all kinds of reports and SSIS packages.
• Created Alerts for successful or unsuccessful completion of Scheduled jobs and implemented indexes on tables for optimum performance.
• Generated Daily, Weekly, Monthly, Subscriptions and Dashboard reports using SharePoint for the analysis by managers and end users.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
• Created effective functions, appropriate Triggers to facilitate efficient data manipulation and data consistency.
• Transformed complex business logic into Database design and maintaining it by using SQL objects like Stored Procedures, User Defined Functions, and Views.
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Generated reports using SSRS that could be used to send information to different Primary Vendors, Clients, and managers.

Environment: T-SQL, MS SQL Server Integration Services 2008/2005, MS SQL Server Reporting Services 2008/2005, MS SQL Profiler, SQL Query Analyzer, SQL Server Index Tuning Wizard, Windows XP, MS Office 2003/2007.

Confidential

MS SQL Server Developer/BI Developer

Responsibilities:

• Created Data Transformation tasks like BCP, BULK INSERT to import/export data from clients and transformed data using from MS SQL Server 2005 using OLEDB connection.
• Designed, Developed and Deployed reports like Cascade type reports, Tabular reports, and Drill down reports in MS SQL Server environment using Crystal Reporting.
• Designed a new schema for the Data Mart databases and created MDX queries to extract data from the Data Mart.
• Responsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of software.
• Generated various reports like Cascade type reports, Tabular reports, and Drill down reports and Generated Dynamic reports from Cubes using SSRS.
• Created Store Procedures, Functions and Triggers for retrieval and update of data in the database.
• Performed daily tasks including backup and restore by using SQL Server tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Generated Daily, Weekly and Monthly Trigger based reports regarding assigned projects to designated Managers and Clients.

Environment: MS SQL Server 2005, Query Analyzer, Enterprise Manager and Replication.