Oracle System

Location:

Plano, TX, 75024

Posted:

June 30, 2010

Contact this candidate

Resume:

Sangeetha Muthiah [pic]

Mail id: ****************@*****.***

Phone no: +1-214-***-****

Experience Summary

. Around 4 years of experience in Data warehousing.

. Possesses good knowledge in development of enterprise software in

Information Technology industry, with key emphasis on Design,

Development and Unit testing

. Proficient in developing Informatica ETL mappings.

. Proficient in developing Oracle PLSQL procedures and Unix shell

scripts

. Good understanding of Banking domain.

. Possesses strong system life cycle skills (requirement gathering,

analysis, technical design, construction, testing, implementation, and

production support).

. Experience in leading small teams

. Preparation and review of technical design documents, Unit test plans

and test scripts

. Possesses good interpersonal skills, co ordination, leadership,

management and organizational skills

. Extremely adaptable and flexible to project needs.

. Hard work and Commitment towards work

. Active and quick in learning new technologies.

COURSE YEAR OF INSTITUTION UNIVERSITY/BOARD MARKS

PASSING OBTAINED %

B.E. May 2005 Government Anna University, 75

Electronics college of India

and Engineering,Tirun

Communicatio elveli

XII March 2001 Rose Mary Matric Tamilnadu State 95

Hr. Board, India

Sec.School,Tirune

lveli

X March 1999 Rose Mary Matric Tamilnadu 86

Hr. Matriculation

Sec.School,Tirune Board, India

lveli

Education

NAME OF THE COMPANY DESIGNATION FROM TO DURATION

Cognizant Technology Associate 19/09/200 12/02/2010 4+ Yrs

Solutions, Chennai 5

Employment History

External Certification Details

S.No CERTIFICATE MONTH AND YEAR OF COMPLETION

1 Oracle Certified Associate Introduction to Oracle9i: SQL -

(OCA) in Developer Track. Dec, 2006

Program with PL/SQL -

Mar, 2007

2 Informatica - PowerCenter 8 Mar, 2009

Mapping Design

Project Profile

Company Cognizant Technology solutions

Client CompuCredit HBoS Northern Trust

Duration Dec 2005 - Apr Apr 2007 - Aug Sep 2008 - Feb

200*-****-****

Hardware Pentium PC, IBM IBM PC IBM PC

AIX

Operating Windows NT Windows XP Windows XP

Systems Server/Windows

2000/Workstation

Programming Oracle 9i PL/SQL Oracle 9i PL/SQL, Oracle 10g

Languages Unix, PL/SQL,

Informatica

8.6,Unix

Location Chennai Chennai Chennai

Project Details:

Client description:

CompuCredit

CompuCredit is an information and technology driven provider, direct

marketer and servicer of branded credit cards and related fee-based

products and services to consumers who may have been overlooked by other

traditional providers of consumer credit. CompuCredit believes these

consumers deserve the opportunity to establish credit and gain access to

services previously unavailable to them.

CompuCredit's unique proprietary credit scoring models evaluate

consumer credit and bankruptcy risk using credit bureau data and repayment

history on consumer loans. Compucredit's advanced technology enables them

to identify consumers whom they believe have the best credit quality in the

target market. CompuCredit believes these consumers are under-served by

more traditional providers of consumer credit and hence provides them

instant credit cards and financial services.

HBOS

HBOS is a major UK company. The Group provides retail, business and

corporate banking, and insurance and investment services through its multi-

brand strategy in UK and internationally. This has the biggest private

shareholder base in UK and is the fourth-largest bank in UK.

HBOS is the UK's largest mortgage and savings provider and the number

one provider of new investment products. The Group is one of the UK's

leading general insurers and has a reputation for excellence in the

provision of business banking and corporate finance, delivering innovative

funding solutions across range of markets.

HBOS plc, holding company of the HBOS Group, has four direct

subsidiaries, including Halifax, the Bank of Scotland, HBOS Insurance and

Investment Group Limited, and Halifax Share Dealing Limited. Halifax

provides banking services and the Bank of Scotland offers banking,

financial and related services.

Northern Trust

Northern Trust Corporation is an international financial services

company headquartered in Chicago, Illinois, USA.Northern Trust Corporation

is a leading provider of investment management, asset and fund

administration, fiduciary and banking solutions for corporations,

institutions and affluent individuals worldwide..

Northern Trust counts over 20% of the U.S.'s wealthiest families as

its clients. It is also one of the largest global custodians in the world,

serving the asset servicing needs of corporate and public retirement,

foundations, endowment, fund managers, insurance companies and government

funds

Relevant Project Experience

Compucredit - Non-Mon Validations

Duration 4 months

Operating Win XP

System

Databases Oracle 9i

Abstract The Non-Monetary process sends updates to the source

systems Monday through Friday for many critical

processes. There are different circumstances that could

cause those updates not to post onto the system of

record, including: multiple processes updating the same

field, invalid update value passed, file not processed,

etc. To make sure these updates successfully post to the

source system, system of record BAs are manually

verifying the updates on the source system. Due to the

large volume of processes inserting into MNM, as well as

the large number of records they insert, the BAs are

unable to verify everything which has sometimes caused it

to go unknown that job run's updates did not post to the

system of record.

This process shall automate the validation of the records

posting next day to the system of record. This will

ensure all updates are validated, as well as alerting the

appropriate parties when updates do not post so the issue

may be researched.

Role Involved in developing the database scripts.

Involved in creating and testing the PL/SQL packages and

debugging process of the queries.

Responsible for preparing the Test specification

document, Unit Test Plan and implementing the same

Compucredit - Python

Duration 4 months

Operating Win XP,UNIX

System

Databases Oracle 9i

Languages Python

Abstract The Risk group currently kicks off many SAS jobs on a

daily basis. All of their jobs are dependent on database

loads. They use the Business Objects database load

report to know when certain loads are complete. They

would like to stop using that report and have an email

sent to the group once each of the database loads are

complete. This will enable them to know when a database

load is complete and they can kick off their jobs. This

solution will alleviate the Risk group from refreshing

the Business Objects report and waiting on multiple

emails.

Role Involved in Python coding, preparation and review of

design documents for the program.

Preparation of test cases, producing bug free codes and

error free documents

Compucredit - Fortia

Duration 3 months

Operating Win XP

System

Database Oracle 9i

Tool Informatica

Abstract A new portfolio named Fortiva was introduced. The

existing process is to be modified to load the new

portfolio data also into the CCDS database.

Role Involved in modifying and testing the UPSERT scripts

Involved in modifying and testing the Informatica

mappings

Involved in modifying the oracle PL/SQL procedures

in FDR-conversion process.

Compucredit - Informatica Development

Duration 4 months

Operating Win XP

System

Database Oracle 9i

Tool Informatica

Abstract This process is the analysis and documentation of the

Informatica mappings and workflows in production

repository for future reference. Analysis, resolution and

implementation of the resolution for data issues in

production, involving Informatica and Oracle.

Role Involved in Informatica Repository Analysis.

Analysed different mappings and workflows and thereby

analysed different source tables, target and lookup

tables.

Analysis and resolution of production issues involving

Informatica and Oracle within the stipulated time

HBOS - Aggregate Accounting

Duration 9 months

Operating Win XP, Unix

System

Database Oracle 9i

Abstract Aggregate Accounting is the process of consolidating

Faster Payment Services (FPS) transactions from the

Payment Engine for posting into CBS. This is required so

that only the relevant total figures are sent to CBS, not

all the FPS transactional data. The Aggregate Accounting

work stream is a key component of the Accounting and

Settlement work stream. Its key function is to take

transactions from RGW database and bulk them into Control

and Settlement Database based on specific aggregation

rules and then send them through for Settlement into the

CBS system in a flat file. It also has an important

ancillary function, which provides a transaction based

extract, the Reconciliations work stream to be uploaded

into Corona.

Role Involved in developing Oracle PLSQL scripts and UNIX

scripts.

Involved in testing the PL/SQL packages and debugging

process.

Responsible for preparing the Technical Design Document,

Test specification document, Unit Test Plan and

implementing the same

Developed bug free codes and error free documents

Have performed management activities.

Understood the requirements and gave knowledge transfer

to the other team members

HBOS - MI Reporting

Duration 7 months

Operating Win XP, Unix

System

Database Oracle 9i

Abstract MI Reporting (Management Information Reporting) is a

critical component of the FPS delivery. It provides

facilities to consolidate operational business statistics

pertaining to FPS activity, thereby providing management

feedback on real time payments activity in the bank from

an FPS perspective. The aim of the FPS MI Reporting is to

provide a reporting facility that is relevant to

management activity both from a daily and monthly

operations perspective. MI Reports are created from

Control & Settlement and RGW Database and transfer the

static reports to Share point for static reports and

extracts to a Windows share which is accessible by

Division.

Role Involved in developing Oracle PLSQL scripts and UNIX

scripts.

Involved in testing the PL/SQL packages and debugging

process.

Responsible for preparing the Technical Design Document,

Test specification document, Unit Test Plan and

implementing the same

Developed bug free codes and error free documents

Responsible for team delivery.

Understood the requirements and gave knowledge transfer

to the other Team members

HBOS Faster Payment Services - Test Support

Duration 8 months

Operating Win XP, Unix

System

Database Oracle 9i

Abstract FPS was having four Releases (R1, R2, R3 & R4) out of

which R3 and R4 were the major releases. R3 involved

Inbound / credit payments from all the Banks to HBOS and

R4 involved Outbound / debit payments from HBOS.

Aggregate Accounting and MI Reporting were part of R2, R3

and R4. Each release involved System Testing, Integrated

Testing, User Acceptance Testing, Performance Testing and

Operational Acceptance Testing.

Role Being the team lead/team member, I was responsible in

Responsible for monitoring the jobs running in test

environments (ST, CIST, UAT, OAT, NFT).

Analysis and resolution of issues within the stipulated

time according to the criticality of the issue.

Updating the Test Director and Analysis documents and