Engineer Project

PROFESSIONAL SUMMARY:

> Over * years of experience in analysis, design and development of

applications in Banking and Financial Solutions industries.

> IBM Information Server DataStage 8.1/8.0.1/7.5.1 and Ab Initio.

> Working in ETL team as a Designer/Developer. Responsible for deployment

of DataStage jobs.

> Worked on Metadata management and Business Glossary in IBM Datastage 8.1.

> Defining ETL standards and processes.

> Performance Tuning of existing ETL jobs.

> Data standards & Metadata management.

> Responsible for the creation of detailed test plans, perform Unit and

Integration testing exercises to ensure high-quality systems delivery.

> Ability to work independently as well as in small groups, performing

technical activities including analysis, design, development, testing and

production installation of all components of a DataStage application.

> Involved in migration of interfaces to DataStage 8.1

> Involved in analysis of migration project of Pro*C and PL/SQL to

DataStage 8.1 version.

> Strong functional & systems design and relational database background.

> Involved in Gap Analysis and change management process.

> Working knowledge of Oracle Warehouse Builder 10g R2 - ETL tool.

> Good knowledge of Oracle and Teradata databases.

> Strong Experience in DataStage version 8.1.

> Extensively used Visual Source Safe and PVCS for Version Control.

> Strong Unit testing experience with test case preparation and

documentation.

> Excellent communication skills.

TECHNICAL SKILLS:

ETL Tools : IBM WebSphere DataStage 8.1, 8.0.1 & 7.5.1, Ab

Initio

Operating Systems : Windows, UNIX, zLinux

Software/ Tools : XML, XML SPY, Toad

Databases : ORACLE, Teradata.

Version Management Tools : PVCS 7.5, VSS 6.0

Bug Tracking Tools : Rational Clear Quest

EDUCATION:

B.Tech in Information Technology, Chennai - India.

WORK EXPERIENCE:

Project Rainbow, Citigroup, Singapore Jan'08

-Present

Information Technology Analyst

Responsibilities:

V As a Information Technology Analyst involved in designing of the ETL

Framework for the NextGen DWH model.

V Designed the template Jobs for the Framework's different scenarios which

are reusable across the seven countries in Project Rainbow

V Made use of the newly introduced Slowly Changing Dimension Stage and the

Range Lookups functionalities across the framework templates.

V Design was extensively made generic so that the Framework would cater to

all the 7 different countries.

V Extensive experience with DataStatge Parallel Extender (EE) using

different stages like Join, lookup, File Set, Change Capture, Filter,

Funnel, Copy, Column Generator, Peek, Dataset, Sequential File, Oracle

Enterprise, Merge, Transformer, Aggregator, Remove Duplicates Stages etc.

Environment: IBM WebSphere DataStage 8.1/8.0.1, Oracle, PL/SQL and Toad

Citi Cards - Student Loan Corporation, FL, USA Jul'07

-Dec'07

The Student Loan Corporation (SLC) provides a full range of education

financing products and services to meet the needs of more than 1.8 million

students and parents and 3,000 schools nationwide. Some of the Applications

involved in the SLC system include Loan Originations (AppWorks & CLASS),

Loan Servicing (Diploma), Collections, Statement, NIVR and E-biz

applications.

Joined Citi Cards ETL team as a Ab Initio Developer and involved in Project

Development and Implementation.

V Involved in Ab Initio EME Administration activities like creation of

sandboxes and projects

V As a Team Member involved in Project Development, Implementation and

maintenance using DataStage

V Conducted unit and system tests for the Jobs and documented the

enhancement.

Environment: Ab Initio, BTEQ Teradata and Unix

Terms & Conditions, AIG - Enterprise Risk Management, NY

Jul'06- Jun'07

The T's & C's project is for the risk analysis of prices and the ratings of

the clients and counterparties are decided. The details about the products

for the clients are sent to the third party rating agencies like MOODYS,

FITCH and S&P. We get the details about the products from the rating

agencies and the best ratings and prices are calculated and the same has

been reported to top management for decision making.

V As a Team Member involved in Project Development, Implementation and

maintenance using DataStage 7.5.1

V Extended support to the Operations Team with day to day productions

issues and fixed the issues with priority deadlines.

V Conducted unit and system tests for the Jobs and documented the

enhancement.

Environment: IBM WebSphere DataStage 7.5.1, Oracle, PL/SQL and Toad.

Bloomberg Parent Child Data Automation, AIG - Enterprise Risk Management,

NY Mar'06- Jun'06

Asst Systems Engineer

Bloomberg the leading global provider of archived financial and market

data, news and analytics provides AIG with the counterparty hierarchy data

called the parent-child file. AIG uses this file to validate the legal

hierarchies in GDR and as a point of reference for Global Exposure

hierarchies.

Responsibilities:

V As a Systems Engineer involved in different stages of implementation from

development to testing and staging and maintenance of Jobs.

V Extensively used PL/SQL with DataStage for high volume Inbound and

Outbound transactions

Environment: IBM WebSphere DataStage 7.5.1, Oracle, PL/SQL and Toad

Dun & Bradstreet, AIG - Enterprise Risk Management, NY

Dec'05 - Feb'06

Software Engineer

The D&B's global commercial database contains more than 100 million

business records which are used by AIG ERM for Risk Management Solutions,

to mitigate credit risk, increase cash flow and drive increased

profitability. The DUNS Number is used to update the Party related

Information and the Parentage Information.

Responsibilities:

V As a Team Member involved in Project Development, Implementation and

maintenance using DataStage 7.5.1.

V Migrated the existing PL/SQL programs into DataStage Jobs and

performed gap analysis for all the Jobs

V Conducted unit and system tests for the Jobs and documented the

enhancement.

Environment: IBM WebSphere DataStage 7.5, Oracle, PL/SQL, Unix and XML SPY.

Standard & Poors, AIG - Enterprise Risk Management, NY

Jun'05 - Nov'05

Software Engineer

The Standard and Poors one of the world's preeminent providers of credit

ratings provides data to AIG which will be consumed and cleansed by GDR for

Risk assessment and to assign their own risk rating (AIG Risk Rating).

Responsibilities:

V As a Team Member involved in Project Development, Implementation and

maintenance using DataStage 7.5.1.

V Involved in writing Stored Procedures and Triggers at the back end

using PL/SQL.

V Involved in documentation of the Project Run Book for the Production

Support Team.

Environment: IBM WebSphere DataStage 7.5, Oracle, PL/SQL, UNIX.

Achievements

. Received the Outstanding performer award from Citibank - ITO - SD DABI

- Oct 2009.

. Received the Star of the Month Award for the month of Sept 2006.

. Received the Spot Excellence Award for the month of Aug 2006.

. Identified and blocked/resolved the sending of unwanted instruments to

Risk Metrics, saving hundreds of thousands of dollars that AIG -

Enterprise Risk Management pays to the Risk Metrics Data provider.

Reference Available upon Request

Contact this candidate