SQL, PL/SQL Resume

PROFESSIONAL SUMMARY

Oracle Certified Professional with 2.5+ years of experience in effective implementation of Enterprise Applications Software (Oracle E - Business Suite). Currently working with Apps associates as Associate consultant in Oracle
Rich 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 Expertise in System Administration responsibility and Application Object Library (AOL) Responsibilities
Advanced level of expertise 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 with 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

SQL, PL/SQL

Responsibilities:

Development of database objects (packages, procedures, triggers, views, etc.) to provide custom functionality within Oracle Applications.
Customization of Inbound Data Migration using SQL* Loader in GL, INV, CRM modules.
Involved in Development of Oracle Reports in various modules.
Involved in Customization of Standard Reports.
Involved in Discoverer Reports.
Perform creating Concurrent Program, Executables, Responsibilities, Request groups for different types of programs in Oracle Applications.
Created Value Sets, Request Sets for different Programs.
Code review and testing and fixing the problems and resolving the on-going production issues.
Creation of Forms, Functions Menus and Sub Menus in Oracle Apps.
Preparation of Technical design documents MD70, MD120 and CV60.