SUMMARY

• 7+ years of extensive experience in IT industry as SQL Developer in MS SQLServer 2008/2005/2000/7.0 in Production, Quality & Development environments.
• Professional experience in the MS BI stack: Integration Services (SSIS),Reporting Services (SSRS) and Analysis Services (SSAS).
• Excellent skills in High Level Design of and implementing ETL packages using SSIS 2008/2005 for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text file, Teradata) by using multiple transformations available in SSIS toolbox such as Data Conversion, Conditional Split, Bulk Insert, Merge, Lookupand Union all.
• Good Hands on experience in Data Warehouse Design and analysis of various approaches for maintaining different dimensions and facts in the process of building a data warehouse application.
• Experience in writing Complex Stored Procedures, Indexed Views,DDL/DML Triggersand User defined Functionsfor data consistency and manipulation.
• Experience in Dimensional Data Modeling Star and Snow Flake Schemas.
• Experience in maintaining database, including updating statistics, re-indexing, structure modifications, and index analysis and also Log Shipping, Mirroring & Replication to restore Database backup.
• Experience in creating SQL Logins, Roles and Authentication modes as a part of security policies for various categories of users.
• Expert in designing Enterprise reports using SQL Server Reporting Services (SSRS 2005/2008) generatedDrill down reports, Parameterized reports, Linked reports, Sub reports, Matrix reports andCascaded reports in SSRS 2005/2008.
• Developed OLAP Cubes by using SQL Server Analysis Services (SSAS), and defined data sources, data source views, Dimensions, Measures, Hierarchies, Attributes, Calculations using multi dimensional expression (MDX), Perspectives and Roles.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.

EDUCATION

• Bachelors in Engineering, Confidential University,

TECHNICAL SKILLS:

RDBMS: SQL Server 2008R2/2008/2005/2000, Oracle, MS Access.
SQL Server Tools: MS SQL Server 2008R2/2008/2005 / 2000/7.0, MSSQL Server Reporting Services 2008R2/2008/2005/2000 (SSRS), MSSQL Server Analysis Services 2008R2/2008/2005(SSAS), MSSQL Server Integration Services 2008R2/2008/2005 (SSIS), Data Transformation Services(DTS), Oracle 9i/10g, ODBC, OLTP, OLAP, SQL Server Management studio (SSMS), MS SQL Server 2000 Enterprise Manager, SQL Query Analyzer, SQL Profiler, Bulk Copy Program (BCP).
Operating Systems: Windows 2000/2003/XP/NT/Vista.
Programming Language: T-SQL,C, C++, C#,HTML and VB.Net
Reporting Tools: Crystal Reports, SQL Reporting Services.
Data Modeling Tools: Erwin 7.2/4.5/4.0, MS Visio 2003/2007

Confidential, NYC, NY. Jan2011 – Present
Sr. SQL Server/SSIS/SSRS Developer
Description: Confidential is one of the world’s largest investment banks and a leading global investment bank with a substantial private clients franchise and handles international capital markets business. It has clients that are both public and private, ranging from sovereign states to multi-national companies. Its business is divided into Corporate & Investment Bank and Private Clients & Asset Management.
Roles & Responsibilities:

• Actively participated in interaction with users, team lead, DBA’s and technical manager to fully understand the requirements of the system.
• Applied knowledge of Normalization and De-Normalization techniques.
• Writing queries to create stored procedures, User Defined Functions, Views, Triggers and CTEs (Common Table Expressions).
• Using all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Check, Unique etc).
• Writing Complex T-SQL Queries, Sub queries, Co-related sub queries and Dynamic SQL queries.
• Performance tuning of Stored Procedures and T-SQL Queries.
• Created logins, users and configuring permissions and assigning roles to users.
• Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
• Used Execution Plan, SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
• Created SQL scripts for tuning and scheduling.
• Performed data conversion from flat file into a normalized database structure.
• Created new SSIS package to extract date from legacy to SQL Server Objects using Business Intelligence Development Studio (BIDS) and Visual studio 2008.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases and data mart databases.
• Developed SSIS Templates which can be used to develop SSIS Packages in such a way that they can be dynamically deployed into Dev, Test and Production Environments.
• Executing data validation stored procedures in SSIS packages in Business Intelligence Development Studio (BIDS).
• Involved in Deployment and Administration ofSSIS packages with Business Intelligence development studio.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Generated reports using SSRS and Excel (Pivot) that could be used to send information to diverse group of users, clients, and managers.
• Responsible for creating the reports based on the requirements using SSRS 2008.

Environment: MSSQL Server 2008, SSIS, SSRS, BIDS, Visual studio 2008, MS Visio 2007 and XML.

Confidential, PA September 2009 – December 2010
Sr. SQL Server/SSIS/SSRS Developer
Description: Confidential offer various types of life insurance, from the pure protection of term life insurance to the flexibility and growth potential of universal and variable universal life insurance policies. The main goal of the project is to extract, transform and load data from different sources using Microsoft Integration Services and maintain them in a Data ware house.
Roles & Responsibilities:

• Developed and Optimized Stored Procedures, Views, and User-Defined Functions for the Application.
• Followed Microsoft recommended best practices in designing, developing and implementation of the ETL using SQL Server Integration Services (SSIS), including upgrading DTS to SSIS.
• Used SSIS to create Dynamic ETL Packages to validate, extract, transform and load data from online transaction Processing (OLTP) databases to data warehouse databases and involved in Data cleansing in the data transfer.
• Migrated DTS packages from SQL Server 2008 to SQL Server 2008R2 as SSIS Packages.
• Involved in creating SSIS jobs to automate the reports generation and cube refresh packages.
• Configured Server for sending automatic mails to respective people when a SSIS process failure or success.
• Performed data conversion from flat file into a normalized database structure.
• Deployed SSIS package into production environment and used package configuration to export various package properties to make package environment independent and scheduled Jobs using SQL Server Agent.
• Developed various operational Drill-through and Drill-down reports using SSRS.
• Developed different kinds of reports such a Sub Reports and Charts, Matrix reports.
• Involved in Designing, Analyzing, building and testing of OLAP cubes in SSAS and adding calculations using MDX.
• Involved in System Study analysis for logical/physical data model there by defining strategy for implementing Star Schema with Fact and Dimension tables.

Environment: MSSQL Server 2008, SSIS, SSRS, SSAS, BIDS and T-SQL

Confidential, Hartford, CT January 2008 – August 2009
SQL Server/SSIS/SSRS Developer
Description: Confidential provides a full range of business services to meet the complex needs of national employers and health plans. As a consultant at UHG for the Human Resource Management System (HRMS), part of an ERP (Enterprise Resource Planning), developed and helped UHG to implement HRMS that is designed to handle the human resource activities for the company. 
Responsibilities:

• Generated database monitoring and data validation reports inSQL Server Reporting Service (SSRS).
• CreatedTablePartition for large tables using vertical and horizontal partitioning for good performance.
• Designed dynamicSSIS Packagesto transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Responsible for writing SQL queries, Stored procedures, Views, Triggers, T-SQL andDTS/SSIS
• DeployedSSISpackages and Reports to Production Servers.
• Created Data warehouse Cubes inSQL Server Analysis Service (SSAS).
• Migrated data using ETL Tool inSSIS.
• Maintained system monitoring jobs and providehigh availability support.
• Worked on Migration of packages from DTS usingSQL Server Integration Service (SSIS).
• Participatedin Databases ArchitectureandData Modelingdesign.
• Performing DBA functions, installing, configuring and supporting database systems.
• Reported all events and requirements through established reporting mechanisms inSSRS.
• Reviewed and developeddata models and database designswith development teams
• Wrotestore proceduresfor some job automations.
• Generated test data andtested databaseto meet the functionalities deliverables in the project documentation and specifications.
• Designed and developed OLAP using MS SQL ServerAnalysis Services.
• Designed and developedreports in MS SQL ServerReporting Services(SSRS)under SQL Server 2005.

Environment:MS SQL Server 2008, SSRS, SSIS, SSAS, OLAP, DTS/SSIS and BIDS.

Confidential March 2006– November 2007
SQL Developer
Description: Confidential continues to be the dominant life insurer even in the liberalized scenario of Indian insurance and is moving fast on a new growth trajectory surpassing its own past records. Confidential has issued over ten million policies during the current year. Confidential has crossed many milestones and has set unprecedented performance records in various aspects of life insurance business.
Responsibilities:

• Involved in various stages of SDLC like gathering User requirement and System Specification. System Analysis, Design, Development, Testing and Implementation
• Creation, manipulation and supporting the SQL Server Database.
• Created Stored Procedures, User-defined Functions to take care of back end validations when transferring data to Production Server.
• Extensively involved in designing the DTS packages to make the automated synchronization of data from one system to another system.
• Created Data warehouse Cubes inSQL Server Analysis Service (SSAS).
• Created queries with Inner Join, Outer Join, and correlated sub-query with String function, Mathematical function, Aggregate function, Date and Time function.
• Involved in migration of Data from Excel, Flat file, Oracle, XML files to SQL Server by using BCP and DTS utility.
• Configured SQL Server 2000 in-built log shipping from primary server to secondary server.
• Analyzed and implemented backup and database maintenance plans.
• Configured Mail Profile for sending automatic mails to the respective people when a job is failed or succeed. Maintaining SQL Script for creation of Database Objects.
• Fine-tuning Stored Procedures to improve performance that was achieved by removing unnecessary cursors, temporary tables wherever possible.
• Administering MS SQL Server by Creating Logins and assigning appropriate roles
• Developed Index tuning stored procedures.

Environment: MS SQL Server 7 and Windows NT 4.0

Confidential August 2004 – February 2006 
SQL Developer
Description: Confidential was amongst the first to receive an 'in principle' approval from the Reserve Bank of India (RBI) to set up a bank in the private sector, as part of the RBI's liberalization of the Indian Banking Industry in 1994. The bank was incorporated in August 1994 in the name of 'HDFC Bank Limited', with its registered office in Mumbai, India. HDFC Bank commenced operations as a Scheduled Commercial Bank in January 1995.
Roles and Responsibilities:

• Created a Database and normalized the database into small tables by applying rules of Normalization, defined Check Constraint and applied Business Rules.
• Installed SQL Server 2005 Servers, multi instances.
• Responsible for security and roles.
• Responsible for development of Procedures, Functions and database Triggers.
• Designed Data was stored in MS SQL Server
• Created indexes and analyzed its role for optimizations
• Developed Dynamic search queries and results with manipulated data.
• Responsible for developing file transfer controls.

Environment: SQL Server 2005, Crystal Reports, ETL and Win XP.