SQL, PL/SQL Resume

SUMMARY

Oracle Certified Professional wif 2.5+ years of experience in TEMPeffective implementation of Enterprise Applications Software (Oracle E - Business Suite).
Sound experience in application development and customization of Oracle applications (GL, INV, PO OM, AR, AP and CRM) as well as Oracle Reports (6i/10g, Oracle Forms 6i/10g, XML Publisher, Oracle Discoverer) and Oracle forms (Template.fmb).
Expertise in Inbound Data Migration using SQL* Loader.
Strong Proficiency in System Administration responsibility and Application Object Library (AOL) Responsibilities.
Advanced level of knowledge in implementation of Oracle Finance, CRM modules in Oracle apps 11i/R12.
Possess functional knowledge in Oracle Purchasing, Oracle Inventory, Oracle Payables and CRM modules.
Proficiency in writing Stored Procedures, Packages and Functions using SQL and PL/SQL in multiple versions of Oracle database (8i/ 9i/10g).
Preparation of technical design documents MD70, MD120 and CV60 by using Oracle AIM’s methodology

TECHNICAL SKILLS

ERP: Oracle E-Business Suite 11i / R12

GUI Tools: Reports 6i/10g, Forms 6i/10g

RDBMS: Oracle 9i and 10g

Tools and Utilities: SQL* Loader, Toad, SQL * Plus

Languages: SQL, PL/SQL

Operating Systems: Windows Server 2003/XP, Linux

PROFESSIONAL EXPERIENCE

Confidential

SQL, PL/SQL

Responsibilities:

Development and Customization of database objects (packages, procedures, triggers, views, etc.) in Oracle applications to provide custom functionality.
Performing AOL activities such as creation of Concurrent Program and Value Sets, Form, Function and Menu Creations.
Customization of standard and XML reports along wif Oracle forms as per the client requirement.
Involved in development of interfaces and load the data from legacy system to Oracle Applications.
Provided required support to resolve issues, which were reported in the production instance.
Code review and testing and fixing the problem.
Preparation of technical documents MD70, MD120 and CV60 using AIM methodology.

Confidential

Responsibilities:

Developed database objects (Packages, Procedures, Triggers, Views, etc.) to provide custom functionality wifin Oracle Applications.
Customized Inbound Data Migration using SQL* Loader in GL, INV, CRM modules.
Established Oracle Reports in various modules.
Customized Standard Reports.
Involved in Discoverer Reports.
Performed in creating Concurrent Programs, Executables, Responsibilities, Request groups for different types of programs in Oracle Applications.
Created Value Sets, Request Sets for different Programs.
Code review, testing, fixed the problems and resolved the on-going production issues.
Created Forms, Functions, Menus and Sub Menus in Oracle Apps.
Prepared Technical design documents: MD70, MD120 and CV60.