Oracle PL/SQL developer resume

Gowthami .Kummarapurugu

Contact: 609-***-****

Email:xztjt3@r.postjobfree.com

Objective:

* ***** ** ********** ** systems Analysis, design and development of complex software systems in Finance and Educational sectors

Experienced in requirement analysis, coding and testing various modules in a software development life cycle

Substantial development experience in creating stored procedures, PL/SQL Packages, Triggers and Functions.

3+ years of experience in designed and deployment of UNIX Shell Scripts using K Shell.

Developed Client-Server applications using front-end tools like Oracle Developer 2000 - Forms 5.0/6i, Oracle Reports 2.5/6i,

Involved in designing numerous Oracle Forms and Reports by interacting directly with End Users and Business Analyst

1+ yrs Extensive experience with Business Intelligence Tools like Oracle Discoverer

TECHNICAL PROFICIENCY

Software:

Microsoft Office (Excel, Word, Power Point, and Access)

Operating Systems:

UNIX, Windows 95/98/NT/2000/XP, Linux

Languages:

PL/SQL, SQL, HTML, JavaScript,c,c++

Databases Environments:

Oracle RDBMS V7, 8, 8i, 9i, and 10g

Web Servers:

Oracle Application Web Server (OAS) 4, 9iAS, 10gAS

Tools:

Oracle Forms 10g, 9i, 6i, 6.0, 5.0, 4.5, 3.0, Reports 10g, 9i, 6i, 6.0, 3.0, 2.5, Designer 9i, SQL*Plus, SQL*Loader, Toad

Other:

Project management. Excellent problem-solving, organization and leadership skills. Quick learner.

TRAINING:

Intensive Training in Advance Database concepts using ERP package Oracle 11i at Genesis, Hyderabad, India

EDUCATION:

M.Sc in Computer Science, Nagarjuna University, Vijayawada, India, (2003-2005)

B.Sc in Computer Science, Nagarjuna University, Vijayawada, India, (2000-2003),

Primary Skills:

Sqlserver

Oracle reports

Unix shell scripts

PL/SQL

D2K

IBSS, New Jersey, USA July 2005-Present

Project: Workers' Compensation Application

Role: oracle developer

Environment: PL/SQL; SQL; SQL*Plus; Oracle 9i; Oracle Forms 6i; Sun Solaris Unix; Windows XP; TOAD; Oracle Reports 6i; Oracle Developer; QVCS

• Designed and created new modules for centralization of Notes and Addresses.

• Setup and utilized Address verification software.

• Provided a client-server reporting solution for dumping data into Excel spreadsheets from Oracle Forms.

Project: Genoa

Role: Oracle Developer

Environment: PL/SQL; SQL; SQL*Plus; Oracle 10g; Oracle Forms 10g; 10gAS; Oracle Designer 10g; Linux; Windows XP; TOAD; Oracle Reports 10g; Oracle Developer; PVCS Tracker; PVCS Version Manager

• Lead a team of 6 developers, assigned, advised and analyzed work.

• Worked with product managers to give work estimates and advised on design.

• Troubleshooted, fixed, and implemented bug fixes and enhancements within tight deadlines.

• Designed and generated database objects and Oracle Forms, Reports, and Libraries through Oracle Designer.

Project: Service Request and Work Order Applications

Role: Oracle developer

Environment: PL/SQL; SQL; SQL*Plus; Oracle 9i, 10g; Oracle Forms 10g, 6i; 10gAS; Sun Solaris Unix; Windows XP; TOAD; Oracle Reports 10g, 6i; Oracle Developer

• Designed and created an interface between custom application and accounting application, Summit.

• Mentored junior programmers in Oracle database design and development.

• Upgraded 6i client server Oracle Forms and Reports application to web based 10g and ran the application through Oracle Portal and Single Sign-on.

• Assisted in setting up the Forms and Reports Services on standalone 10g App Server.

Client: Lincoln Financial Advisors, Philadelphia, USA (mar 03-may 05)

Project: Client Asset’s Reporting & Classification (CARC)

.Net Developer Analyst

Description

The project consists of three parts:

· Methodology for asset classification

Asset classification process involves identifying securities held by LFA clients in Account aggregate database and classifying them based on the different parameters like asset type,

Asset class, Market location etc. As identified by Lincoln management. The asset classification will be based on data received from S&P on a regular basis. Assets that remain unclassified after the matching will be manually classified using data from the free resources available on the internet.

· Display Clients Holdings

A stand-alone application to display LFA’s client’s holdings. The application will be linked to the client’s access web site of LFA. All the required holdings data is present in Account Aggregation database and the external data will be provided by Cash Edge. The application will take Client’s Social Security number and display the holdings.

· Generating Advisory Reports

These reports are as follows:

o Account Balance.

o Balance by Holdings

o Transactions by Account

o Ownership & Titling

o Fund inflow / outflow

Responsibilities:

· Involved in analysing the data from Oracle database using Toad.

· Building stored procedures and triggers in Oracle.

Bug Fixing after Unit Testing and Integration Testing.

Environment

ASP.NET, ADO.NET, C#.Net, XML, Web Services, IIS, JavaScript, SQL Server, Nunit, Visual Studio.Net

Work Authorization:EAD

Contact this candidate