PROFESSIONAL SUMMARY:

• Over 5 Years of experience in Oracle Applications as a Technical Developer in implementation, upgradation and customization of Oracle E - Business Suite Release.
• Strong experience in Oracle R12 Financials in AP, PO, AR, and GL with Full Cycle Implementation Design, System Administration and iPayment.
• Having extensive experience in programming with Oracle Tools/Libraries such as Forms, Reports 10g, PL/SQL, SQL*Loader. Good technical knowledge in developing new Reports, Interfaces, Forms.
• Developed Reports on XML Publisher and BI Publisher enterprise.
• Having Exposure to functional modules like AP, PO, OM, GL, INV, AR.
• Experience in Procure to Pay (P2P), Order to cash (O2C) life cycles and Supply Chain business flows.
• Strong Knowledge of Application Implementation Methodology (AIM), Application object Library (AOL) implementation standards and Trading Community Architecture (TCA).
• Expertise on designing and implementing Oracle Alerts and Lookups.
• Experience in importing data from legacy systems to Oracle Applications using Oracle Interfacing, SQL LOADER, UTL FILE, Oracle APIs and strong knowledge in OAF (Oracle Application Framework).
• Excel in team collaboration, quick adaptation and problem solving with good communication skills.

TECHNICAL SKILLS:

Application Development Tools: Oracle Forms, Oracle Reports, XML Publisher, Oracle Application Framework

Application Package: Oracle Applications EBS 11i & R12

Database/DB Tools: Oracle 9i/10g, TOAD, SQL*Plus, SQL Developer

Programming languages: SQL, PL/SQL

Desktop Tools: MS Office suite 2003 and 2007

Operating Systems: Windows NT, Windows 98/2000/XP/Vista/7

Document Methodologies: MD.050, MD.070, MD.120, TE.020, CV.040

ERP Modules: GL (General Ledger), AP (Account Payables), AR (Account Receivables), PO (Purchasing), OM (Order Management), INV (Inventory), AOL (Application Object Library), P2P, O2C, and System Administration

PROFESSIONAL EXPERIENCE:

Confidential, WI

Oracle EBS Apps Technical Developer

Responsibilities:

• Development & Customization of Reports, Forms and workflow as per client Requirement
• Implementation, supporting, and development of EBS 11.5.10.2/R12 andConfiguring EBS-BIP bursting for reports in Oracle EBS 11.5.10.2.
• Created SQL*Loader control programs and PL/SQL validation scripts.
• Activating/Creating the Database objects.
• Developed SQL queries to obtain specific information as per requirements
• Review the code and test the functionality of the applications.
• Worked on Inbound/Outbound Interfaces in AR, AP, and Projects and issues with Auto Lock Box.
• Worked on Enhancements with the Journal Import in GL.
• Oracle Global Techno-Functional Production Support in Oracle Modules like Procure-to-Pay (P2P), Order to Cash (O2C).
• Development of XML Publisher reports as per the requirement.
• Configured Payment terms, Payment types, and Payment process profiles.
• Prepared Unit test Plans.
• Developed technical designs for conversion of Oracle EBS extensions utilizing OAF systems.
• Discussed with design team to clarify module intent, identifying problems, feasible changes.
• Developed RICE components.
• Worked on Unit Testing.
• Defined financial options, and payables options
• Defined distribution set, expense report, recurring invoice, and payment terms
• Involved in supplier setups and bank setups.
• Defined in creation of MOAC setups.
• Preparation of Technical Documents for developed components.

Environment: Oracle EBS Apps R12, GL, AP, AR, OM, INV, Projects, Oracle 11g, TOAD, Pl/Sql, Forms 11g, Reports 11g, BI PUBLISHER, Oracle Discoverer 10g,Windows 2K.

Confidential, FL

Oracle EBS Apps Technical Developer

Responsibilities:

• Hands on experience on Oracle EBS R12 P2P ( iProcurement, AP, PO, iSupplier ) modules.
• Development and customization of Reports.
• Development and customization of Interfaces.
• Development of Conversions.
• Involved in registration of concurrent programs, executables, Creation of responsibilities, request groups, menus, value sets, and function in System Administration & AOL.
• Involved in writing Control Files for SQL Loading.
• Executing concurrent programs from PL/SQL.
• Defining Menu, Reports.
• Development of Interface to import the Sales Order Legacy using interface method.

Environment: Oracle EBS Applications11.5.10.2/R12 INV, PO, OM, AP, AR, PA, GL, Oracle 9i, PL/SQL, TOAD, SQL*PLUS, SQL*LOADER, Forms 6i, Reports 6i, Discoverer10g.

Confidential

Oracle EBS Apps Technical Developer

Responsibilities:

• Developing new Reports as per client requirement.
• Hands on experience on Oracle EBS 11i/R12 modules like AP, AR, PO, and OM.
• Developed PL/SQL programs for validations.
• Developed Procedures, Packages, Triggers and Functions.
• Development of Customer and Reports.
• Created packaged procedures, triggers validation procedures.
• Created and tested reports, packages, and triggers for the system.
• Developed validation scripts for the complex business rules using PL/SQL.
• Unit and acceptance testing for all the developed forms and reports according to the client requirement.
• Designed the Test Case documents for the product.
• Tested product Performance and Functionality.
• Created test cases at all phases of unit and acceptance testing for all the developed forms and reports according to the client requirement.

Environment: Oracle EBS Applications 11i/R12 (12.0.3), Oracle 10g, PL/SQL, SQL*PLUS, Oracle Reports, SQL* Loader, TOAD, Windows 2000/XP, UNIX.

Oracle Report Developer

Responsibilities:

• Developed GL Interface to upload journals into oracle Apps Tables.
• Installing and administering Oracle Business Intelligence Enterprise Edition 10/11g and creating BI Publisher reports.
• Worked in Customer Conversions to import the data of Customer data, Customer profile, Customer contact, Customer Bank information. The data was imported from the legacy data to the Oracle applications.
• Prepared Technical Design Documents (MD: 070).
• Developed XML Reports as per the requirements of the client.
• Developed New Forms as per client Requirement using Template.fmb
• Creating Concurrent Programs and Executables,
• Creating Value sets, Registration of Forms and Reports.
• Registrations of Tables and Forms for custom applications.
• Coordinated with the functional team to understand the business and user requirements and to perform data mapping.

Environment: Oracle Applications (11.5.9), AP, AR, GL, OM, INV, Oracle 10g, Forms 6i, Reports 6i, Discoverer 4i, XML publisher, SQL*Loader, PL/SQL developer, UNIX.