SUMMARY

• SQL/ETL Developer having 8 years of IT experience in Requirement Gathering, Analysis, Design, Development and Implementation of Enterprise solutions.
• Expertise and experience in designing and developing RDBMS, including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers, cursors, Database objects such as Tables, Schema, Indexed Views and User Defined Functions for data definition, manipulation and access.
• Expert in Query Optimization and Performance Tuning using tools such as SQL Profiler, Index Tuning Wizard and Database Engine Tuning Advisor
• Extensively worked on Design, Development of the ETL data from different sources (Flat/Excel/Access/XML/SQL/Oracle) to different targets (DB/Files)
• Experienced in data Extraction, Transformation and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), DTS, Bulk Insert and Bulk Copy Program utility.
• Well versed in creating Dynamic SSIS packages, using containers & variables, configuring the packages, and scheduling the packages.
• Experienced in creating configuration files, Logging, Error handling using Event Handlers in SSIS.
• Data Modeler with strong Conceptual and Logical Data Modeling skills, has experience with JAD sessions for requirements gathering, creating data mapping documents and queries
• Excellent Programming experience in 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 De-normalization.
• Highly committed, motivated and a natural team player with strong analytical ability

TECHNICAL SKILLS

• 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
• FTP
• SharePoint
• Visual Studio Express 2012 for Web
• Visual Studio Express 2012 for Desktop
• Oracle 10g/9i/8i.DB2
• Erwin
• Teradata
• DB2

PROFESSIONAL EXPERIENCE

Confidential, Toledo, OH

SSIS ETL/SQL Server Developer

Responsibilities:

• Worked on improving stored procedures and trigger performance.
• Performed Data Profiling of legacy source systems through SQL
• Identified Primary, Foreign and Natural Keys to set Referential Integrity between a parent and child tables
• Experience in backend programming including schema and table design, stored procedures, Triggers, Views, and Indexes
• Transformed complex business logic into Database design and maintaining it by usingSQLobjects like Stored Procedures, User Defined Functions, and Views.
• Created Data Transformation tasks like BCP, BULK INSERT to import/export data from clients and transformed data using from MS SQL Server 2005 using complex stored procedures.
• Responsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of software.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Designed and implemented stored procedures and triggers for automating tasks.
• Involved in Planning, Defining and Designing data based on business requirements and provided documentation.

Environment: SQL, FTP, T-SQL, XML, MS PowerPoint, MS Project & Windows 2003 server, Visual Studio Express 2012 for Web, Visual Studio Express 2012 for Desktop

Confidential, Plano, TX

SQL server/ SSIS

Responsibilities:

• Enriched Fact Table with Dimensional Attributes and transformed columns and declared data type
• Created a Logical Data Map by indicating Target Table Name, Column Names and Slowly Changing Dimension type 1 or 2, Transformations and Source System Mapping
• 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.

Confidential, Houston, TX

SSRS/SQL Developer

Responsibilities:

• Generated reports using SSRS that could be used to send information to different Primary Vendors, Clients, and managers.
• 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 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.

Confidential, Oklahoma, OK

MS SQL Server Developer/SSRS

Responsibilities:

• Dimensional Data Modeling and Cube development in SQL Server Analysis Services (SSAS)
• 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.

Confidential, Houston, TX

SQL/ BI Developer (SSIS/SSRS)

Responsibilities:

• Involved in writing stored procedures, Triggers, User-defined Functions, Views and Cursors for both OLTP and OLAP systems for various modules.
• 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, report models and dashboard reports.
• Documentation of database/data warehouse structures and updated functional specification and technical design documents.

Environment: SQL Server Analysis Services (SSAS), SSIS, BIDS, T-SQL, PL/SQL, MDX.