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.
• 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 and 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.
• Highly committed, motivated and a natural team player with strong analytical ability.

TECHNICAL SKILLS

• SQL Server Integration Services (SSIS)
• SSRS 2005/2000
• MS-SQL Server 2008/2005/2000
• VB 6.0
• PL/SQL
• T-SQL
• TCP/IP
• HTTP
• UDP/IP and FTP
• MS Visual Studio 2008/05/03
• MS-SQL Server Management Studio
• PL/SQL Developer
• Windows XP/2000/NT/98/95
• Oracle 10g/9i/8i.

PROFESSIONAL EXPERIENCE

Confidential, White Plains, NY

MS SQL/BI Developer

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.
• Extracted, transformed and loaded data using SSIS Import/Export Wizard.

Environment: MS SQL Server 2008, Oracle 9i, MS Excel, DTS, BCP, T-SQL.

Confidential, Houston, TX

MS SQL/BI 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, Dashboard reports for the analysis of managers and end users by using SSRS.
• 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 usingSQLobjects 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, MS SQL Server Reporting Services 2008, MS SQL Profiler, SQL Query Analyzer, SQL Server Index Tuning Wizard, Windows XP, MS Office 2003/2007.

Confidential, Oklahoma, OK

MS SQL Server 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 SSRS.
• 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, Houston, TX

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, South Pembroke, FL

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.