Oracle Database Developer

Kilaru S

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

510-***-****

SUMMARY

. Over 8+ years of experience as Oracle 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, B2B and Claims

Management.

. Extensive experience in Integrating DAC and OBIEE with Oracle

Applications (R12 and 11.5.10) to implement financial analytics, Supply

chain and Order management Analytics.

. Used DAC (Data Warehouse Administration Console) to configure,

administer, load and monitor ETL jobs utilized for data warehouse

applications.

. Experience in performance tuning of sources, mappings, targets and

sessions.

. 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.

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

database and file systems.

. Experience in developing, customizing, modifying forms, reports 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 work individually as well as in a team with excellent problem

solving skills, troubleshooting capabilities, learn new tools and

concepts.

. 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 7/XP/95/98, Windows NT, UNIX

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

scripting, 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, OBIA, DAC.

Contact this candidate