OBJECTIVE

• Seeking a challenging and interesting role as a SQL programmer in a company where my experience and knowledge can be utilized.
• SUMMARY
• Around 5 years of experience in Database Design, Development and Maintenance as SQL Server 2005,2008R2, 2012 Database / ETL / Warehouse Developer in Windows environment.
• Extensive experience with SQL Server Integration Services 2005/2008 in the areas of complex Master/Child Packages, SSIS Transforms etc.
• Experienced in using Visual Studio Data Tools in Visual Studio 2012.
• Experienced in logical and physical database design with different data modelers using ERD, data normalization, scripts and implementation on MS SQL SERVER 2005/2008/2008R2,2012.
• Hands-on experience in creating indexed views, complex stored procedure, User Defined Functions UDF , and effective triggers implementing different complex and critical business needs.
• Strong skills in designing relational database model and implementation as per business requirement
• Experienced in standardizing SSIS design in and across teams and establishing best practices.
• Proficient in Dimensional Modeling including Star and Snowflake Schema
• In-depth knowledge of T-SQL DDL and DML to perform batch processing and implement business logics into backend
• Good skills in developing strategies for extraction, transformation and loading mechanism
• Extensively used Stored Procedures, Queries and Triggers for performing ETL
• Extensively used SSIS Packages with Transformations for performing ETL on SSIS
• Experienced with Relational and Dimensional models using fact and dimension tables
• Created various types of reports such as Parameterized reports, Drill Down reports, Linked reports using SQL server Reporting Services
• Worked extensively on system analysis, design, development, testing and implementation of projects and capable of handling responsibilities independently as well as a proactive team member
• Hands-on experience in installing, configuring, managing, monitoring and troubleshooting SQL Server
• Involved in creating Technical Specification Documents TSD for the project.
• Experienced with tools such as Index Tuning Wizard, Database Engine Tuning Advisor and SQL Profiler for maintaining performance
• Highly motivated and a conceptually strong individual with exceptional analytical and design skills
• Flexible, enthusiastic and project oriented team player with good communication and leadership skills to develop creative solution for challenging client needs

SOFTWARE SKILLS

• Operating Systems: Windows 2000/XP, 2008
• Databases: MS SQL Server 2005, 2008, 2008R2, 2012
• Database Tools: SQL Query Analyzer, DTS Import/Export, SQL Agents, Data Tools
• ETL Tools: Integration Services, DTS Data transformation services
• Reporting Tools: SQL Server 2005 Reporting Services
• Data Modeling: ERwin v 4.0, Visio 5.0
• Development skills: Transact SQL T-SQL .
• Languages: SQL, XML, HTML, DHTML, HTTP
• BI Technologies: BIDS

EXPERIENCE

Confidential

Business Intelligence Developer/Data Warehouse Engineer

Responsibilities:

• Created database objects such as Stored Procedures, Triggers, Indexes and views in SQL Server 2008R2 and 2012 using Visual Studio Data tools.
• Worked with the financial services staff and Business analysts for requirements gathering, business analysis, testing, and metrics.
• Implemented various types of SSIS Transformations in Packages including Slowly Changing Dimension, Aggregate, Conditional Split, Row Count, Derived Column etc.
• Used SQL Server Agent for creating, maintaining and scheduling jobs and packages.
• Implemented the Master Child Package environment to minimize overhead of Package
• Created Drill down reports, parameterized reports, and linked reports to fulfill the needs of the business users using SSRS.
• Worked with business users to help gather the requirements about what data they expected to see in SSRS reports.
• Used variables and passed values of variables from a master to child package in SSIS 2012.
• Responsible for developing ETL mapping using SSIS 2008R2 and 2012.
• Responsible for the performance tuning of the stored procedures.
• Created SSIS packages for loading data between sources to operational staging targets using Star Schema, and implemented logic for Slowly Changing Dimensions.
• Involved in unit testing and created test cases for the database scripting and ETL processes.

Used SSIS Packages to extract, transform and load data from heterogeneous sources like flat files, Production SQL Servers 2005/2008R2 into SQL Server 20012 Staging Database.

Environment: SQL Server 2008R2, SQL Server 2012, SSIS, SSRS, Windows XP

Confidential

Senior Data Warehouse Engineer

Responsibilities:

• Analyzed and understood all data in the source databases and designed the overall data architecture and the individual data marts in the data warehouse.
• Created ETL process using SSIS for populating data store and imported backup server logs to SQL Server 2008.
• OLTP database design and implementation for tracking- leasing and rental transactions.
• Scheduled SSIS Packages using SQL Server Agent.
• Wrote Complex Stored Procedures and User Defined Functions for application development.
• Enforced the data consistency and referential integrity by applying Triggers Check Constraints and SQL Server rules.
• Created Views and Indexed Views.
• Imported/ Exported data from heterogeneous SQL Server Sources and flat files to target SQL Server by using SSIS, Bulk Insert, and BCP.
• Created Reports by using SQL Server Reporting Services.
• Created Clustered and Non Clustered Indexes on tables and views to improve performance.
• Actively involved in System Performance by tuning SQL queries and stored procedures by using SQL Profiler, Index Tuning Wizard.
• Involved in database backup to support development team.

Environment: SQL Server 2008, SSRS 2008

Confidential

SQL Server/ETL Developer

Responsibilities:

• Installed SQL Server Management tools using SQL Server Setup Program.
• Designed standards for database table, column, procedures and views.
• Helped database architecture to modify physical and logical data model for new add tables.
• Created complex stored procedures and functions to support efficient data storage and manipulation.
• Created databases, tables, views, indexes, stored procedures, triggers and constraints.
• Analyzed the requirements and fine-tuned indexes and stored procedures to improve performance.
• Performed data transfer between various servers using Bulk Insert, BCP and SSIS.
• Implemented SSIS Packages for transferring data and Data Loads.
• Handled query optimization by using extensive use of Index implementation and Index Tuning Wizard.
• Used SQL Server Profiler and Activity Monitor to find badly performing queries and deadlocks.
• Tuned SQL queries using Estimated and Actual Show Plans and Execution Plans for better performance.
• Resolved various performance issues running DBCC commands.
• Created Database Maintenance Planner for the performance of SQL Server, which covers Database Integrity checks, Database Statistics update and Re-building indexes.
• Created views to facilitate easy user interface implementation
• Created triggers on tables to facilitate consistent data entry into the database.
• Worked on SSIS Package, SSIS Import/Export wizard for transferring data from heterogeneous sources.
• Carried out data migration import export BCP from Text to SQL Server.
• Coordinated post-implementation events such as testing.

Environment: SQL Server 2005, T-SQL, MS Excel, MS Access, Windows NT.