Summary:

• ETL/SSIS Developer having 7 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 Analyses 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 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.

Projects Summary:

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.

Confidential

MS SQL/ BI Developer SSIS/SSRS

Responsibilities:

• Worked with end users and Business analysts to gather reporting requirements based on customers business needs.
• Involved in writing stored procedures, Triggers, User-defined Functions, Views and Cursors for both OLTP and OLAP systems for various modules.
• Worked on Huge Data Transfers to SQL Server Databases using DTS, SSIS, BCP, BULK INSERT.
• Migrated data from SQL Server 2000 to SQL Server 2005 and upgraded packages from DTS 2000 to SSIS 2005.
• Generated multiple Enterprise reports using SSRS from SQL Server Database OLTP and SQL Server Analysis Services Database OLAP and included various reporting features such as drilldowns, drill through, sub-reports.
• Worked with different report parameters including single valued parameters and multi-value parameters which also consisted of different parameter types like hidden, internal, default queried and non queried parameters .
• Wrote MDX Scripts in order to create datasets to perform reporting and included interactive drill down reports and report models.
• Documentation of database/data warehouse structures and updated functional specification and technical design documents.

Environment: MS SQL 2005/2000, VS2008/2005, SQL Server Reporting Services SSRS 2008/2005 , SQL Server Analysis Services SSAS , SQL Server Integration Services SSIS , Business Intelligence Development Studio BIDS , T-SQL.

Confidential

MS SQL Developer.

Responsibilities:

• Wrote and Optimized Triggers and SQL queries.
• Wrote stored procedures to generate account statements for different types of accounts.
• Tuned SQL queries for better performance.
• Created and automated the regular jobs.
• Developed complex T-SQL code for the application.
• Designed and implemented stored procedures and triggers for automating tasks.
• Worked on improving stored procedures and trigger performance.

Environment: SQL Server 2000 Enterprise Edition, SQL, Enterprise Manager, T-SQL, XML, MS PowerPoint.