Professional Summary

Around 5 years of IT experience focusing on MS SQL Server products including 2005/2008/R2 as a Business Intelligence developer.

• Extensively created and debugged large T-SQL database scripts and batches to facilitate effective database management.
• Extensive experience in performance tuning, query optimization, database optimization and data integrity.
• Expertise in designing and optimizing various T-SQL database objects like tables, views, stored procedures, functions, indexes and triggers using Management Studio and SQL Profiler.
• Created complex stored procedures for backing up all the databases in a server and for other maintenance tasks
• Adept in fine-tuning and optimizing the Stored Procedures and Triggers in SQL Server by analyzing the Query Execution Plan and using the Profilers and Index Tuning Wizards.
• Experience in Importing/Exporting Data from various data sources like Excel, Oracle and Flat file using BCP & Bulk Insert.
• Experience in creating efficient ETL Strategy for initial load in to the databases as well as incremental load
• Utilized the fuzzy logic transformations like fuzzy grouping and fuzzy lookup as cleansing techniques and also have excellent knowledge of other transformations like derived columns, lookups, SCDs, and conditional splits.
• Handled errors in SSIS Packages using Event-handlers, Loggings, Transactions and Checkpoints.
• Skilled in proper scheduling for the execution of automated procedures, scripts, and ETL packages for off peak hour operations using SQL Server Agent.
• Experience in developing, optimizing and monitoring SSIS (SQL Server Integration Services) packages for data extraction, transformation and loading.
• Proficient in creating SQL Server Reports, handling sub reports and defining query for generating drill down reports using SSRS.
• Designed, developed and deployed reports in MS SQL server environment using SSRS 2008.
• Monitored the bug reports, code reviews using TFS during the complete software development cycle.
• Adept in monitoring and tuning SSRS Report Performance by creating schedules for report execution, caching the reports and creating proper user roles.
• Hard working, goal oriented, highly motivated individual with excellent documentation and communication skills.

Technical Skills

DATABASES: SQL Server 2005/2008/R2
DATABASE TOOLS: Management Studio, ER-Win, MS Visio, Team Foundation Server (TFS)
DATABASE/WEB LANGUAGES: SQL, T-SQL, XML
BUISNESS INTELLIGENCE: BIDS, SSIS, SSAS, SSRS, CUBES, ETL, OLTP, OLAP
PROGRAMMING LANGUAGES: C, C++, Java
OPERATING SYSTEMS: Windows XP/ Vista/ 7

Work Experience

Confidential, Chevy Chase, MD April 2012 – till date
SQL/BI Developer
Confidential is an auto insurance company. It is a wholly owned subsidiary of Berkshire Hathaway that as of 2007 provided coverage for more than 13 million motor vehicles owned by more than 11 million policy holders. Confidential writes private passenger automobile insurance in all 50 U.S. states and the District of Columbia.

Description:
Company wanted to analyze its business process of life insurance sales. New Data Mart was designed from scratch, Analysis were made based on policy, gender, age, location, etc. My responsibility was to design an efficient ETL strategy for incremental load, creating various reports using cubes and data marts resources.

Responsibilities:

• Created and optimized various T-SQL database objects like tables (schemas), views, stored procedures, User Defined functions (UDF), indexes and triggers using Management Studio and SQL Profiler.
• Reviewed the existing stored procedures and improved efficiency by critically evaluating the code and optimized
• Enforced the Business Rules by implementing constraints.
• Created complex stored procedures to manage the accounts and credit information which supported the front end applications.
• Implemented the error logging and monitoring of the tables and databases by creating the DML/DDL triggers in TSQL.
• Performed the Index maintenance by checking the index health and reorganizing and rebuilding the indexes based on the different fragmentation levels.
• Performance tuning of ETL transformations, data validations and stored procedures.
• Transferred data from flat files, Excel spreadsheets and heterogeneous data to and from SQL Server using BCP and Bulk Insert.
• Designed complex ETL strategies to pull data from different sources, like SQL server, oracle, and flat files and load it to the destination database after using multiple transformations.
• Implemented the Master Child Package Model for easier maintenance and better performance.
• Performed Error Handling and Debugging of SSIS Packages using Checkpoints, Data Viewers, Breakpoints, Event Handlers and Loggings.
• Designed Cubes, Optimized each cube using Partitioning ,Assigning Proper Storage mode (MOLAP,ROLAP)
• Designed the creation of application-specific Reports like Reports by customer, Reports by account and Reports by Debit/Credit amounts using Reporting Services.
• Used Reporting Services to schedule various reports to be generated on predetermined time. Created a tree view application to view the recent reports generated and a scheduler to schedule a selected report to be run on a particular date.
• Generated reports for insurance claims, sales and area wise research using the drilldown, drill through and parameterized reports in SSRS.
• Maintained different versions of TSQL code along with MS BI stack by checking-in and checking-out on Team Foundation Servers (TFS) to distribute them to different cross-functional team members.
• Performed report testing and Verification as per internal reporting system requirements.
• Generated daily, weekly and monthly reports regarding assigned projects to designated managers and clients.

Environment: MS SQL Server 2005/2008, Erwin 7.0, Excel and Access 2007, SSIS, SSAS, SSRS, Team Foundation Server (TFS)

Confidential, San Francisco, California March 2011 – April 2012
ETL Engineer/Reports Developer
Confidential is a leading global specialty retailer offering clothing, accessories and personal care products for men, women, children and babies. With about 132,000 employees and about 3,000 company-operated stores and over 200 franchise stores, company’s presence is felt around the world.

Description:
Company had existing Data Warehouse in place and wanted to extend its functionality according to the business needs with faster processing interactions from clients. Projects involved in creation of data marts for specific departments and implement an ETL Strategy using SSIS packages to populate this Data Mart. Project also included the creation of cubes.

Responsibilities:

• Involved in designing conceptual, logical and physical model of the relational databases (OLTP and OLAP)
• Created Database objects - Stored Procedures, Triggers, Cursors, Indexes, functions, views
• Built SSRS project to generate reports with desired formats(Word, PDF, Excel and etc.) to present statistics information according to business requirement
• Updated existing and created new reports using SQL Server Reporting Services
• Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-clustered Indexes for significant performance boost
• Extensive experience in writing, debugging and optimizing complex T-SQL queries, and views.
• Supported the existing BI platform for populating the data warehouse
• Created SSIS package to fulfill the SQL Server maintenance tasks including rebuilding index, backing up database and updating statistics
• Created event handlers on every executable in an SSIS package
• Documented Processing times for each Module, developed Test Cases and used them to run through each Process
• Created Package Configurations in XML Files to efficiently Promote Unit Tested Packages to Live Environment from Development Environment.
• Tuned the matching Parameters based on the Test Results. Implemented and supported the Business Intelligence tools and various web User Interfaces (UI) for front end applications.
• Configured Report Server with SQL Server 2005 to drive Reporting Services
• Developed Custom Selection of reports ordering using SQL Server Reporting Services.
• Generated various reporting services RDL’S using reporting services for Account Aggregation reports.
• Created ad-hoc reports using Report Builder to provide a template for end-users for creating reports by themselves with preselected group of relational tables.
• Configured the report server by providing proper service accounts, encryption key backups and database accounts.
• Handled scale out deployment of the reports by balancing the load on multiple report instances.
• Documented and analyzed test plan results as well as system and application errors.

Environment: Microsoft SQL Server 2008/2005, SSIS, SSAS, SSRS, Microsoft Office, Erwin

Confidential, Boston, MA Jan 2009 – Feb 2011
ETL/Reports Developer
Confidential is a major global financial services provider engaged in personal banking, credit cards, corporate and investment banking and wealth and investment management with an extensive international presence in Europe, the Americas, Africa and Asia. With over 300 years of history and expertise in banking, Barclays operates in over 50 countries and employs 140,000 people.

Description:
Responsible for building enterprise system and its services for Confidential. The project involves creation of centralized database in SQL Server 2005 to match up clients\' needs which was also linked with a .NET application.

Responsibilities:

• Developed backup restore logics for SQL Server as needed.
• Involved in Performance tuning using T-SQL queries and SSIS packages.
• Developed and designed the front end module using the .Net framework and the linking the front end application with the database for data management.
• Troubleshoot the SSIS Packages bugs, configurations to transfer them from production to other databases.
• Involved in modeling the database and implemented Views, Normalization, Performance, Optimization and Referential Integrity
• Scheduled routine Jobs, Tasks, and Alerts and their maintenance.
• Developed Database objects such as stored Procedures, Functions, Tables, Views, and Cursors.
• Developed backup and recovery plans depending upon OLTP load, server down time, percentage of data loss and budget issues and automated all the things using SQL Server Agent.
• Implemented ETL strategy to transfer data from existing data warehouse to new data warehouse. Processing cubes, adding business intelligence to cube and dimensions, applying conditional formatting, processing and deploying cube.
• Prepared User Level Groups and assigned them Permission levels to the Database.
• Created many complex stored procedures and used them in Reporting Services directly to generate reports on the fly.
• Documented Processing times for each Module, developed Test Cases and used them to run through each Process
• Produced reporting data models that are used by the Report Builder ad-hoc reporting tool in Reporting Services 2008.

Environment: Microsoft SQL Server 2005/2008, Excel, .Net, SSIS, SSAS, SSRS, Microsoft Office

Confidential, Whitehouse Station, NJ April 2008 – Jan 2009
Database Developer
Confidential has a long and rich history of working to improve people\'s health and well-being. Through the years, Confidential researchers have helped to find new ways to treat and prevent illness - from the discovery of vitamin B1, to the first measles vaccine, to cold remedies and antacids, to the first statins to treat high cholesterol.

Description:
Project involved in focusing on building a modern, adaptable, innovative and inclusive system of their services. The application was developed and tested in a SQL Server 2005 by merging data from Oracle and IBM DB2 Databases. The project was to create a centralized data warehouse in SQL Server 2005 to match the needs of clients which was also integrated with a .NET frontend application.

Responsibilities:

• Responsible for installation, configuration, security, maintenance of Database Engine, ETL and SSRS.
• Developed backup restore scripts for SQL Server as needed.
• Tuned and monitored the performance of T-SQL queries and SSIS packages.
• Involved in the troubleshooting of SSIS Packages, managing their configurations to transfer them from production to other databases.
• Implemented Type II slowly changing dimension to maintain current information and history information in dimension tables.
• Migrated data from Legacy system (Text files, Excel docs and Access files) to SQL Server Databases using SSIS pertaining to Health Screening from Previous years.
• Involved in modeling the database and implemented Views, Normalization, Performance, Optimization and Referential Integrity
• Responsible for monitoring all the Packages that are Scheduled, Running, Completed or Failed.
• Dramatically Increased Query Performance and enhanced response time for statistical reporting by more than 35% after Monitoring, Tuning and optimizing Indexes using Performance Monitor, SQL Profiler and Index tuning wizards (DTA).
• Scheduled and maintained routine Jobs, Tasks, and Alerts
• Developed and created various backup and recovery plans depending upon OLTP load, server down time, percentage of data loss and budget issues and automated all the things using SQL Server Agent.
• Generated reports using SSRS like Drill-Through, Linked and Sub-Reports that could be used to send Business information to higher Management.
• Created many complex stored procedures and used them in Reporting Services directly to generate reports on the fly.

Environment: Microsoft SQL Server 2000/2005, SSIS, SSRS, T-SQL, SQL Agent.