Developer Oracle

Kilaru S

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

510-***-****

SUMMARY

. Over 8 years of experience as Database Developer in Analysis, Design,

Data Modeling (Logical and Physical), Implementation of Business

Applications using the Oracle Relational Database Management System.

. Experience with the Software Development Life Cycle (SDLC) process -

performing detailed analysis, collecting requirements, technical

specifications, development and unit testing, integration and production

install and support.

. Extensive experience in Design, Development, Customization and

Implementation of business applications using Oracle Applications, SQL,

PL/SQL, Oracle 11g/10g/9i/8i/7.x, Developer 2000/6i.

. Proficient in Implementing and customizations of Oracle Financials and

Oracle Supply chain modules which include AR, AP, GL, FA, CM, Purchasing,

Inventory, Order management, WIP, BOM, Shipping and Claims Management.

. Strong programming experience in creating Procedures, APIs, Packages,

Functions, Triggers, Views, collections (nested tables and arrays),

records, sequences, Materialized views, Constraints and other database

objects using SQL and PL/SQL.

. Proficient in Application Development, Data modeling, Data Conversion and

Interface Programming.

. Proficient in Data conversions between Modules via interfaces and APIs,

using SQL*loader, PL/SQL procedures to transfer data from Legacy systems

to Oracle tables.

. Experience with RICE (Report, Interface, Conversions and Extensions) in

Manufacturing and Financial modules.

. Experienced in writing UNIX Scripts to update, regulate, validate

database and file systems.

. Experience in developing, customizing, modifying forms, reports existing

in Oracle Applications according to the business requirements and

specifications using Oracle Developer Suite 10g/9i(Forms, Reports) and

other front-end tools.

. Good understanding of the Oracle database, related utilities and tools.

. Web service technology, XML expertise

. Extensively involved in SQL tuning, troubleshooting, debugging and fixing

the codes/scripts.

. Experience in Performance Tuning & Optimization of SQL statements.

. Ability to meet deadlines and handle pressure in coordinating multiple

tasks in a work environment

. Ability to work individually as well as in a team with excellent problem

solving skills, troubleshooting capabilities, learn new tools and

concepts.

. Involved in preparing the SQL and PL/SQL coding convention and standards.

. Involved in preparing the functional specification, technical

documentation, schema

Documents, test cases, flow charts, production support and user support

documents using AIM methodologies.

TECHNICAL SKILLS

Operating Systems : Ms-Dos, Windows 95/98, Windows NT, UNIX,

Windows XP

Languages : C, HTML, XML, Java, SQL, PL/SQL, Shell

scripting,T-SQL

Databases : Oracle 11g/10g/9i/8.x/7.x,SQL SERVER

2005/2008

Tools/Utilities : TOAD 10.5/10.6, CVS, PVCS, SQL*Loader,

Export, Import, Developer Suite 10g/9i/6i,Discoverer

10g,BI Publisher4.5.6,MS Visio, IBM Clear Case

7.0/7.1.1, Kintana, Lotus Notes, Putty, PL/SQL

Developer, Remedy, Windows Host Script, Hyperion,

JavaScript, Reports 10g/6i/2.5, Forms

10g/6i/4.5,Active Directory, SNAG IT,CITRIX, SQL

PLUS,Project Tracking System(PTS),Citrix, SSIS,

Active Directory, Forms Personalization, Oracle Web

Center Imaging, Oracle Web Center Capture and Oracle

Web Center Forms Recognition. Web ADI.

Contact this candidate