Developer Oracle

Location:

Austin, TX, 78729

Posted:

September 29, 2010

Contact this candidate

Resume:

Keerthana Raman

*****.*********@*****.***

512-***-****

Professional Summary:

. More than 5 extensive Software Development Life Cycle experience.

. Strong development experience with Oracle SQL, PL/SQL and JAVA

. Experience in Performance Tuning of Queries.

. Worked with a team which Upgraded Oracle DB 8i to Oracle 10g.

. Have hands on experience in UNIX shell scripting and basic Informatica

knowledge.

. Created complex functions, stored procedures and packages, Triggers by

using PL/SQL

. Experience in conducting Requirement and Systems Analysis, Feasibility

Studies,

Design reviews, Plan Reviews, Implementation, and Post Implementation

surveys.

. Good Knowledge in data extraction, transmission and loading.

. Worked under Agile Scrum Methodology

Technical Summary :

Operating Systems UNIX, DOS, Windows family

Network Operating Windows NT

Systems

Languages SQL, PL/SQL, Unix Shell Scripting, C,

UML, Java, JSP, Servlets

Web HTML, DHTML, XML

Multimedia Flash 5.0, Dream Weaver, Adobe Photo

Shop

Relational Database Oracle, MS-Access, SQL Server 7.0

Quality Control System, Integration, Black Box, White

Box, Regression, Functional

Tools Batch / Shell scripting, Data

warehousing (Abinito), Caliber,

Dimension, Eclipse, and Toad.

Lean Agile SCRUM, Visual Controls.

Experience:

Client : Citi Bank North America

Duration : Sep 2009' - Mar 2010

Project : Citi North America.

Role : Oracle Developer (PLSQL)

CBK is part of the Core Banking Unit of the domestic customers of Citibank.

CBK consists of various units like Account Opening, ATM, Fund Transfer,

citiphones etc. I was part of the Citiphones Unit. Citiphones were

responsible for developing and maintaining the information needed for the

Phone Banking officers of Citi-North America.

Responsibilities as Developer:

. Created complex functions, stored procedures and packages by using PL/SQL

. Sub-queries and joins were extensively used in stored procedures

. Involved in extensive coding in Oracle forms/reports 6i/10g.

. Worked with and developed scripts for Team leads, QA and Business Team to

ensure the Quality of the applications.

. Created Shell scripts for certain scenarios.

. Rectification of errors reported during System Test and User Acceptance

Test.

. Documentation of the work assigned.

. Extensive testing was done on the programs for achieving accuracy, timely

processing of data.

. Worked on tuning of SQL after analyzing the table

Environment :

Windows NT, Sun Solaris, Oracle 8i/10g, PL/SQL (Stored Procedures,

Packages, Triggers, REF Cursors ) Oracle Application Server 10g, Oracle

Enterprise Manager, SQL*Plus, Unix Shell Scripting, Toad.9.0.

Client : Target Corporation, USA

Duration : Oct 2008 - Aug 2009

Project : CEA (Consumer Electronic Advisor)

Role : Oracle Developer (PLSQL, SQL)

Created the CEA web service which is used to retrieve the details of the

items by passing the DPCI or category. Developed a tool to add, modify, add

attributes for the existing as well as new Items to the CEA database. It

also involves a batch process which would retrieve the data from Amazon web

services and update to the CEA database.

Responsibilities as Developer :

. Wrote Stored Procedures for effective insertion and updation of the data

in to the tables.

. Sub-queries and joins were extensively used in stored procedures

. Involved in extensive coding in Oracle forms/reports using PL/SQL.

. Worked with a team which is responsible for Oracle 10g Upgrade to make

the required changes in the coding and testing.

. Created Packages to automate transactions from the Developer 2000

Applications.

. Worked with and developed scripts for Team leads, QA and Business Team to

ensure the Quality of the applications.

. Used Collections like variable arrays, nested tables extensively.

PL/SQL was extensively utilized for coding and writing complex stored

procedures and

Packages.

. Worked to maintain Oracle software, worked with development team to

fulfill there requirements like design and creation of objects

. Worked on performance tuning of SQL, PL/SQL and analyzed Tables

. Experience in Creation of Table/Index etc

. Worked on Table partition

. Creation of users, roles and procedures for data clean up to protect the

database security consumer payment information.

Environment :

Windows NT, Oracle 8i/10g, PL/SQL (Stored Procedures, Packages, Triggers,

Cluster, Containers, REF Cursors), SQL*Plus, Unix Shell Scripting,

Toad.9.0.

Client : Qwest, USA

Duration : Sep 2005 - Sep 2008

Project : Qwest Corporate Marketing Strategy Organization

(MSO)

Role : Oracle Developer

Qwest is a telecom service provider in 14 states of the US. It owns

companies involved in

domestic and international telecommunications, cable and wireless networks,