Sql Server Management

PROFESSIONAL SUMMARY

Over * + years of progressive experience in Developing, Enhancing and supporting database and reporting applications using SQL Server 2005, SSIS, SSRS

Worked with SQL extensively by using Joins, Sub Queries, functions and advanced OLAP functions.

Strong knowledge in SQL SERVER 2005, SQL SERVER Integration Services & SQL SERVER Reporting Services.

Sound Knowledge of RDBMS Concepts & Documentation of Project

Knowledge of Unified Modeling Language (UML), WML, XML.

Ability to work as Team Member / Team Lead and ability to learn multiple technologies.

Having experience in various web technologies using ASP.

Experienced in error handling, performance tuning & debugging of existing ETL process.

Implemented performance tuning at various levels.

ADHOC request of the clients by using functions & advance OLAP functions.

Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing.

EXPERIENCE SUMMARY

Working as a Software Engineer at Genesys International Ltd., Mumbai (2009 Feb to till date)

AREAS OF EXPERTISE TECHNICAL

Extraction, Loading, Transformation (ELT) tools: UNIX, SQR SERVER 2005, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS).

EDUCATIONAL BACKGROUND

MSc (Biotech) from Periyar University 2008 Tamilnadu.

CERTIFICATION

BEC (British English Certification)

MCTS (Microsoft Certified Technology Specialist)

TECHNICAL EXPOSURES

Operating System : UNIX, MS Windows

Languages : T/SQL, C & C++

Databases : Teradata, SQL Server 2005

ETL Tools : SSIS, IBM-web sphere DataStage 8.0.1

Reporting Tools : SSRS, Crystal Reports

Web Technology : HTML, DHTML, VB Script, XML, Java Script, ASP,

Visual Interdev, Macro Media Mx Dreamweaver

MAJOR PROJECTS

Project #1 LMP

Client : M & T Bank, USA

Role : SQL Server Developer.

Tools/Utilities: SQL Server 2005, SQL Server Integration Services, SSRS

Organization : Genesys International Ltd.

Description:

Liquidity is the availability of funds, or assurance that funds will be available, to honor all cash outflow commitments (both on- and off-balance sheet) as they fall due. These commitments are generally met through cash inflows, supplemented by assets readily convertible to cash or through the institution’s capacity to borrow. The risk of illiquidity may increase if principal and interest cash flows related to assets, liabilities and off-balance sheet items are mismatched. Managing liquidity is a fundamental component in the safe and sound management of all financial institutions. Sound liquidity management involves prudently managing assets and liabilities (on- and off-balance sheet), both as to cash flow and concentration, to ensure that cash inflows have an appropriate relationship to approaching cash outflows. This needs to be supported by a process of liquidity. The Liquidity Management Project has been mandated to deliver a Production service, as required by the FSA. Following a vendor selection process, the Belgium based company Finarch has been chosen to provide the solution.

Roles & Responsibilities

Coding on SQL-Server using T-SQL for creating Database Objects

Performance Monitoring and Performance Tuning

Responsible for code review, stored procedures tuning and optimization

Worked in data Extraction, Transformation and Loading from source to target system using SQL Server Integration Services.

Created appropriate indexes depend on the table situation and requirement.

Some times for answering ad hoc requests using advanced OLAP functions.

Did data reconciliation in various source systems.

Involved in unit testing Involved and Preparing test cases.

Project #2 GEC (Group Economic Capital)

Client : HTSE, UK

Role : SQL Server & ETL Developer

Tools/Utilities: IBM-web sphere DataStage 8.0.1, SQL Server 2005, SQL Server Integration Services, SQL Server Reporting Services

Organization : Genesys International Ltd.

Description:

The objective of GEC (Group Economic Capital) is to provides the Economic Capital framework as a core component of Group wide Capital, Business and Risk management process. It should also serve as a requisite component of HSBC’s Capital Management Governance needed to achieve the Group’s IRBA (Internal Rating Based Approach) status under Basel 2.The project is part of Credit & Finance Systems - Strategic Development Programme (CFS-SDP).

Roles & Responsibilities

Developing indexes to solve strategic and tactical queries.

Data Files were loaded into database using datastage jobs.

Coding on SQL-Server using T-SQL for creating Database Objects

Performance Monitoring and Performance Tuning

Responsible for code review, stored procedures tuning and optimization

Creating and Scheduling of SQL Server Jobs

Worked in data Extraction, Transformation and Loading from source to target system using SQL Server Integration Services.

Created appropriate indexes depend on the table situation and requirement.

Some times for answering ad hoc requests using advanced OLAP functions.

Did data reconciliation in various source systems.

Involved in unit testing and Preparing test cases.

Project #3 CSS (Commercial Scorecard System)

Client : M&T Bank, USA

Role : SQL Sever Developer

Tools/Utilities: SQL Server 2005, SSIS & SSRS

Organization : Genesys International Ltd.

Description:

Performance management of commercial banks is an important aspect of banking business management, this paper makes study about how to use the Balanced Scorecard as a tool, which is applied to commercial banks performance management system, and points out that it breakthrough the defects in the traditional single application of financial indicators which measures performance. And it raises the value of performance management appraisal system based on the introduction of customer factors, internal business processes, employee learning and growth and financial factors. This paper also makes study about the commercial banks in the performance of the balanced scorecard management system mechanism, the strategy of application, application limitations, and outlook on the future of commercial banking services model based on the above points.

Roles & Responsibilities

Developing indexes to solve strategic and tactical queries.

Exported data files using Fast Export utility and also developed Bteq scripts.

Used Multi Set tables to load bulk data in the forms of inserts and deletes.

Created various types of temporary tables such as volatile and global temporary tables.

Worked with collect statistics and join indexes.

Involved in unit testing Involved and Preparing test cases.

Contact this candidate