PROFESSIONAL SUMMARY:

• Over 7+ years of extensive experience in IT industry as SQL Developer in MS SQLServer 2010/2008/2005/2000 in Production, Quality & Development environments.
• Professional experience in the MS BI stack: Integration Services (SSIS), and Reporting Services (SSRS).
• 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, flat file, Text file) by using multiple transformations available in SSIS toolbox such as Data Conversion, Conditional Split, Bulk Insert, Merge, Lookup and 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 Indexed Views, DDL/DML Triggers and User defined Functions for data consistency and manipulation.
• Experience in Dimensional Data Modeling Star and Snow Flake Schemas.
• Logical Data Modeling using ER-Win to fit business requirement.
• Experience in maintaining database, including updating statistics, re-indexing, structure modifications, and index analysis and also Log Shipping, Mirroring & Replication to restore Database backup.
• Transformation Services (DTS) and SQL Server Integration Services (SSIS) (2005/2008).
• Well-versed in usage of SSIS Control Flow items(For Loop, Execute package/SQL tasks, script task, send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping, Pivot).
• Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages.
• Experience with Terabyte scale relational data warehousing, and data warehouse quality models.
• Expert in designing Enterprise reports using SQL Server Reporting Services (SSRS 2005/2008) generated Drill down reports, Parameterized reports, Linked reports, Sub reports, Matrix reports and Cascaded reports in SSRS 2005/2008.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.

EDUCATION:

• Bachelor of Science

TECHNICAL SKILLS:
RDBMS:

• SQL Server 2008R2/2008/2005/2000.

SQL Server Tools:

• MS SQL Server 2008R2/2008/2005 / 2000,
• MS SQL Server Reporting Services 2008R2/2008/2005/2000 (SSRS),
• MS SQL Server Integration Services 2008R2/2008/2005 (SSIS),
• Data Transformation Services (DTS), 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/Vista/07.

Programming Language:

• T-SQL, C, C++.

Reporting Tools:

• Crystal Reports, Drill down reports, Parameterized reports, Linked reports, Sub reports, Matrix reports and Cascaded reports, SQL Reporting Services.

PROFESSIONAL EXPERIENCE:

Confidential,NYC, NY. Jan 2011 - Present
SQL 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 and Unique etc). Writing T-SQL Queries, Sub queries, and Co-related sub queries.
• Performance tuning of Stored Procedures and T-SQL Queries.
• 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.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases and data mart databases.
• Involved in Deployment and Administration of SSIS 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: MS SQL Server 2008, SSIS, SSRS, and Visual studio 2008.

Confidential, PA Jun 2010 - Dec 2010
SQL 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.
• Created SSIS incremental packages to transfer data between OLTP and OLAP databases.
• 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, Charts, and Matrix reports.

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

Confidential,CT Dec 2009 - Jun 2010
SQL 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).
• 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.
• Migrated data using ETL Tool inSSIS.
• 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.
• Designed and developedreports in MS SQL ServerReporting Services (SSRS)under SQL Server 2005.

Environment:MS SQL Server 2005, SSRS, SSIS, DTS/SSIS and BIDS.

Confidential,Colombo, Srilanka Aug 2006 - Oct 2009
SQL Developer
Description: Confidential, was amongst the first to receive an \'in principle\' approval from the Reserve Bank of Srilanka's (RBI) to set up a bank in the private sector, as part of the RBI\'s liberalization of the Sri Lanka Banking Industry in 1994. The bank was incorporated in August 1994 in the name of \'HNB Bank Limited\', with its registered office in Colombo, Sri Lanka. HNB 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.