Oracle Project

Swapna Savvana

Tata Consultancy [pic] Current Address:

Services 2000 New Rodgers Rd

Phone: 267-***-**** #C14,

Email:swapna.savvana@gm Levittown,

ail.com PA-19056, USA

Experience Summary

* Oracle Certified Professional with about 3 years of work experience at

Tata Consultancy Services.

* Extensive knowledge of BANCS, a most widely deployed core banking

solution from TCS-FNS .

* Proficient in Oracle PL/SQL programming, writing Stored Procedures,

Functions, Database Triggers etc. Well conversant in translating

business requirements into creation of database objects.

* Experience in database performance tuning and query optimization, data

integrity and statistics. Good knowledge in database management

systems (DBMS).

* Experienced in mentoring team members on development and getting

things done on time

* Strong analytical and problem solving skills with ability to work

within team environment and independently when needed.

* Good ability to quickly grasp and master new concepts and

technologies.

Qualifications

Degree and Date Institute Specializat Aggregate

ion

Percentag

e

Bachelor of Sarada Institute of Computer 73.91%

Engineering, Technology, Andhra Pradesh science and

May- 2006 information

technology

Technical Skills

Key Competencies

My Competency Profile includes the following

Competency Proficiency (E0 to

E4)

COBOL 400 E3

PL/SQL E2

Oracle Developer 6i- Forms E0

Oracle Developer 6i Reports E0

Unix E0

Analytical Ability L2

Communication L1

Continual learning L1

Network Security(ISM) E0

Organisation and Planning L1

Oracle Database programming E2

Team Skill L1

Professional Memberships / Certifications

Professional Society / Certification Member Since / Date

Certified

Oracle Forms: Build Internet Applications 09-May-2008

- 1Z0-141

Oracle PL/SQL Developer Certified 05-Sep-2008

Associate - Program with PL/SQL - 1Z0-147

Introduction to Oracle 9i- 1Z0-007 29-Dec-2007

Performance Engineering - Level 1.0 30-Mar-2007

Certification

NSE- Introduction to Financial Markets 09-Jun-2009

Training / Continuing Education Summary

Program or Course Coverage Dates

Creating Classes in Java Web 01/11/2009

Exception Handling and Web 01/12/2009

Assertions

Getting started with Java Web 01/08/2009

I-security and BCP Web 12/23/2008

quiz-2008-09

Operators and flow control Web 01/11/2009

in java

Reference Types and Web 01/12/2009

Threading

Working with classes in java Web 01/11/2009

Assignments

The details of the various assignments that I have handled are listed here,

in chronological order.

Project Core Banking Solutions

Customer State Bank of India

Period May-2007 to present

Descriptio SBI core banking project is the largest implementation of

n core banking in the world with more than 15500 branches on

core. "Bancs" is product developed by TCS-FNS and is used

by more than 115 leading banks all over the world. This

project dispels the oft-cited adage that UNIX based systems

cannot reliably scale for the world's largest banks.

Role

Team Member (Level 2 Implementation Support)

Analysing system behaviour and debugging programs,

identifying requirements for code-fixes and Investigating

critical problems faced by the SBI branches

Providing Technical solutions such as 'data-fixes' by

extensive use of core database (Oracle 9i)

Team Member (Level 1 Implementation Support)

Providing Online Support for Branch Migration and live

Production issues

Development and Implementation of batch utilities

Branch visits for monitoring the performance of the

application

Interacting with clients on a regular basis to communicate

the changes in the application

Data-fix supervisor

Responsible for verification and recording of Production

data-fixes (Oracle DML) from all the team members.

Trainer (Implementation Support)

Conducted formal sessions for knowledge sharing among

colleagues and "Bancs 24"

Client Correspondence training on new recruits.

Solution UNIX

Environmen Oracle 9i database

t

Tools MS-VSS (for source code control)

Highlights Client Interaction through out the entire span of project.

Received many client appreciations for the defect free

deliveries.

Career Profile

Dates Organization Role

12th March 2007 TATA Consultancy Asst. Systems

Services Engineer

Training / Continuing Education Summary

Program or Course Coverage

Core Banking (FNS) Banking Concepts, COBOL, B@ncs24,

B@ncsLink, SQL

Initial Learning Program Software Design Life Cycle, Java,

(TCS) UNIX, Testing and Debugging,

Inspections Reviews and Workflows.

Foreign Language French

Personal Details

Nationality Indian

Visa Status L2 ( EAD Approved)

Passport Details

Name as on Relationsh Passport Date of Expiry Place of

passport ip Number Issue Date Issue

Swapna Self F2102045 18-Feb-2005 18-Feb-201 VISAKHAPATNAM

Savvana 5

Domain Core Banking

Knowledge

Operating Windows XP, Unix, MS-DOS

Systems

Languages Oracle Forms, Oracle Reports, Oracle PL/SQL,

Cobol, Core Java, Unix .

Databases Oracle 9i

Project Library management systems

Period Mar-12-2007 to May -12-2007

Descriptio Library Management Systems is the project where in

n need to Segregate the books and maintain them in the

order of their renewal status and renewal details

Role Developer

Solution Main Frames

Environmen

t

Contact this candidate