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

TECHNICAL 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

PROFESSIONAL EXPERIENCE

Confidential, Miami, FL

Business Intelligence Developer/Data Warehouse Engineer

Responsibilities:

• Worked with the financial services staff and Business analysts for requirements gathering, business analysis, testing, and metrics.
• Created database objects such as Stored Procedures, Triggers, Indexes and views in SQL Server 2008R2 and 2012 using Visual Studio Data tools.
• 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, Los Angeles

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.