We provide IT Staff Augmentation Services!

Oracle Ebs Developer Resume

Edison New, JerseY

SUMMARY:

  • Over 9 years of experience in Customization, Extensions, Interfaces, Reports in various modules including Finance, Procure to Pay (Supply Chain Modules), Order to Cash (Distribution) Modules.
  • Oracle Applications (ERP) - Technical Consultant with sound functional knowledge in various modules.
  • Rich experience in Oracle Applications 11i and R12 module such as General Ledger,Accounts Receivables (AR), Inventory (INV), Purchasing (PO),Account Payables (AP),Application Developer, System Administration.
  • Worked on Oracle Applications (R12) RICEW components (Forms/Reports, AOL), PL/SQL
  • Experience in working with Custom Reports and developing the interfaces in AP, GL, AR,PO,OM.
  • Strong knowledge and experience in Procure to Pay (P2P), Plan to Manufacture (PTM) and Order to Cash (O2C) business flows
  • Developing Oracle Applications Reports, Interfaces and customization of Apps Reports and Enhancement of Interfaces.
  • Experience in programming with Oracle tools such as Forms&Reports10g, PL/SQL, SQL, SQL*Loader, UTL FILE Packages.
  • Experience in PL/SQL coding like Cursors, Packages, Collections, Stored Procedures and Functions.
  • Hands on Experience inXML Publisher and BI Report Development.
  • Worked on Forms Development, Forms Personalization and Custom.pll
  • Worked on Oracle XML Gateway/E-Commerce Gateway
  • Workedon Oracle Workflow Customizations.
  • Worked on Oracle Applications Framework(OAF) using JDeveloper.
  • Hands on Experience in developing Shell Scripts in Linux Environment.
  • Expertise in Creating Value sets, Lookup Codes, Messages, Alerts.
  • Registration of Concurrent Programs, Concurrent Executables, Request Groups, Menus, Functions.
  • Worked effectively oncustomizing existing approval workflows using Workflow Builderas per client requirements.
  • Knowledge on OBIEE Tool.
  • Knowledge on SOA and BPEL technologies.
  • Knowledge on Trading Community Architecture(TCA).
  • Exposure in design documents like MD70, MD60, RD60, MD120 and TE20.
  • Exposure toOracle AIM(Application Implementation Methodology).
  • Adapt at all stages of project lifecycle, from business requirements and technical definitions to development, testing, user accepting testing, production support, documentation and completion.
  • Significant experience in performing day-to-day maintenance and support of existing Oracle ERP applications in parallel with the analysis, design, development and co-ordination activities for new applications.
  • Collaborate well with project management, business analysts and department management teams.

TECHNICAL SKILLS:

ERP: Oracle Applications E-Business suite (EBS) 11i, R12 (Account Payables, Purchasing, Account Receivables, General Ledger, Order Management, AOL)

Oracle ERP: Versions 11. .0.3/12.1.1/12.1.3

RDBMS: Oracle 10g/9i

Programming Languages: SQL, PL/SQL, Java, Shell Script, XML, HTML,Awk Script

Development Tools: SQL*Plus, SQL-Loader,SQL Navigator/TOAD/SQL DeveloperXML/BI Publisher, Oracle Reports 6i/10g, Oracle Forms 6i/10gOracle Workflow Builder, JDeveloper.

Methodologies: Application Implementation Methodology (AIM)

Operating Systems: Windows 7/XP/NT/2000, Unix, Linux, Solaris

PROFESSIONAL EXPERIENCE:

Confidential, Edison, New Jersey

Oracle EBS Developer

Responsibilities:

  • Developed an Inbound interface to load external data from legacy system using SQL* Loader into PO HEADERS INTERFACE, PO LINES INTERFACE&PO DISTRIBUTIONS INTERFACE interface tables.
  • Developed drill-down report from scratch in General Ledger application.
  • Worked on EDI Outbound interface for 856 shipping template to generate XML.
  • Worked on EDI Inbound interface for 850/855invoice templates to generate XML.
  • Worked on production tickets to fix EDI Inbound and Outbound Interface Programs.
  • Daily coordinating with E-Commerce Gateway users to break fix EDI Transactions in Supply Chain areas.
  • Prepared unit test cases for EDI programs and participated in system integration testing with EDI team.
  • Developed Purchase Order Expected Receipts Repot using BI Publisher in Purchasing application.
  • Performed Unit testing and prepared TE20 documents
  • Developed Purchase order (PO) with matching type report in Purchasing.
  • Import items from legacy systems like developed interface program to import items from the legacy system to Oracle Inventory by creating staging tables.
  • Extensively worked on XML Publisher to generate custom reports.
  • Developed validation program to load Purchasing data into OE HEADERS IFACE ALL, OE LINES IFACE ALLtables. Then, the data loaded into OM standard tables.
  • Developed a shell script to invoke order import standard open interface in Order Management module
  • Extensively involved in developing Technical Design Documents (MD70) using Application Implementation Methodology (AIM).
  • Implemented Oracle Alerts to send the report output to email addresses.

Environment: Oracle Applications R12 (Purchasing, iProcurement, OM, INV, WMS), Oracle Applications Framework(OAF), Oracle XML Gateway, Sun Solaris Unix, Window NT, Oracle 11g, Reports 6i, Forms 6i, Discoverer, TOAD, SQL*Loader, PL/SQL, SQL* Plus, XML publisher.

Confidential, Columbus, Ohio

Oracle EBS Techno-Functional

Responsibilities:

  • Developed drill-down report from scratch in General Ledger application.
  • Developed anCustomerInvoice transactionsreport using BI Publisher in Order Management.
  • Customized Dunning Letters standard templates as per business requirements in Account Receivables
  • Customized standard PO Output for Communication template using XML/XSL/XSL-FO
  • Developed SQL* Loader program to import legacy data into AP INVOICES INTERFACE and AP INVOICE LINES INTERFACE Interface Tables in Account Payables module.
  • Developed and customized Reports as per business requirements in Accounts Payables, Purchasing and General Ledger using Reports 10G and XML publisher.
  • Developed a commonloaderprogram for interfaces using Shell Script and registered as HOST program in AOL.
  • Developed Purchase Order Expected Receipts Repot using BI Publisher in Purchasing application.
  • Performed Unit testing and prepared TE20 documents
  • Developed Purchase order (PO) with matching type report in Purchasing.
  • Designed and developed data migration scripts for the Vendor Master, Open Purchase Orders, Open Accounts Payables inR12
  • Import items from legacy systems like developed interface program to import items from the legacy system to Oracle Inventory by creating staging tables.
  • Developed a shell script to invoke order import standard open interface in Account Payables module
  • Extensively involved in developing Technical Design Documents (MD70) using Application Implementation Methodology (AIM).

Environment: Oracle Applications R12 (Purchasing, iProcurement, OM, INV, WMS), Oracle Applications Framework(OAF), Oracle XML Gateway, Sun Solaris Unix, Window NT, Oracle 11g, Reports 6i, Forms 6i, Discoverer, TOAD, SQL*Loader, PL/SQL, SQL* Plus, XML publisher.

Confidential, Des Moines, Iowa

Oracle EBS Developer

Responsibilities:

  • Oracle E Business Suite Up gradation from 11.5.10.2 to 12.1.3
  • Worked on oracle standard API using PL/SQL in Order Management and Advanced pricing modules
  • Involved in Importing the Order Management data from legacy system to Order entry Interface tables using SQL*Loader, validating the data using PL/SQL script and creating orders using Order Import Program.
  • Created SQL Loader scripts to load data from legacy systems to Oracle Apps.
  • Modifications of Procedures and Packages according to new Oracle standard tables in R12
  • Requisition Details loading using SQL * Loader and PL/SQL. Developed programs to insert, update and validate values into the PO REQUISITIONS INTERFACE ALL and PO REQ DIST INTERRFACE ALL table for each requisition line.
  • Developed CTL files for loading CSV files from shared drive to server using SQL * Loader into Staging Tables
  • Worked on Purchasing Approval Workflow as per the business requirements.
  • Modified existing workflow notifications to cater the charge account, cost centreinformation.
  • Developed packages to validate and to load data from staging table to Interface tables. Then, using standard Item Import program to load Items into Inventory.
  • Developed PLSQLpackages for Outbound Interface using UTL FILE utility.
  • Developed Shell Scripts to invoke multiple concurrent programs
  • Developed Shell Scripts to invoke SQLLOADER control files to push data to tables
  • Developed program to load into Item cross references and Item relation tables
  • Created Concurrent Programs and Request that calls individual concurrent programs.
  • Developed the program to import invoices into receivables using AR Auto invoice program
  • Creating Staging tables and sequences for loading the POs into Purchasing using SQL * Loader.
  • Developed validation program to load Purchasing data into PO HEADERS INTERFACE, PO LINES INTERFACE and PO DISTRIBUTIONS INTERFACE tables. Then, the data loaded into PO standard tables.
  • Played a role in Sysadmin Activities
  • Registering Request Sets in AOL
  • Registering Custom Applications, Concurrent Programs.
  • Defining Concurrent Programs and Executables in Application Object Library.

Environment: Oracle Applications 11.5.10.2/12.1.3 (AP,AR,GL,PO,OM,INV), Oracle 11g PL/SQL, Oracle Forms 10g,Oracle Reports 10g,Oracle XML Publisher,Oracle Applications Framework(OAF), UNIX.

Confidential

Oracle Apps Developer

Responsibilities:

  • Have played a major role in interacting with the client and coordinating with team
  • Preparation of Technical documentation like MD70, TE20 etc .
  • Ensuring quality deliverables in time, Technical design for report customization and written PL/SQL packages.
  • Involved in personalization, extensions and development of new web pages using OAF.
  • Created new BI reports using BI Publisher
  • Customized BI reports as per client requirements
  • Created new Bi reports using PL/SQL packages
  • Developed Shell Scripts to email the Concurrent request log and out files
  • Developed Shell Scripts to invoke multiple concurrent programs
  • Developed Shell Scripts to invoke SQLLOADER control files to push data to tables
  • Developed new employee signing limits form using Form Builder
  • Developed new charge account mapping form using Form Builder
  • Worked on Form Customizations
  • Developed SQL*Plus based reports
  • Resolved error workflows notifications
  • Technical design documents preparation and building objects as per client requirements.
  • Resolved many issues as per R12 standards.
  • Transferred AOL objects using ITG kintana and FNDLOAD
  • Peer review of the team objects as per functionality for final sign off delivery.

Environment: Oracle Apps Implementation Release R12 (Version), Modules: AP, GL, PO, INV, ZX and SQL, PL-SQL, Reports 10g/6i, Oracle Applications Framework(OAF), Forms Personalization, XML or BI Publisher, Oracle XML Gateway, Workflow, Putty, Winscp 3, Windows XP/2003 and Linux(Redhat) Server.

Confidential, Summit, NJ

Oracle Apps Developer

Responsibilities:

  • Have played a major role in interacting with the client and coordinating with team
  • Preparation of Technical documentation like MD70, TE20 etc .
  • Ensuring quality deliverables in time, Technical design for report customization and written PL/SQL packages.
  • Created new BI reports using BI Publisher
  • Customized BI reports as per client requirements
  • Involved in personalization, extensions and development of new web pages using OAF.
  • Created new BI reports using PL/SQL packages
  • Developed SQLLOADER control files to push data into staging tables.
  • Developed Inbound Interfaces in PO, AP, OM modules using PL/SQL Packages.
  • Developed Shell Scripts to email the Concurrent request log and out files
  • Developed Shell Scripts to invoke multiple concurrent programs
  • Developed Shell Scripts to invoke SQLLOADER control files to push data to staging tables
  • Developed SQL*Plus based reports
  • Worked on Workflow Customizations
  • Resolved error workflows notifications
  • Played a role in Sysadmin Activities
  • Developed PLSQL packages for Outbound Interfaces
  • Registering Request Sets in AOL
  • Registering Custom Applications, Concurrent Programs.
  • Defining Concurrent Programs and Executable
  • Technical design documents preparation and building objects as per client requirements.
  • Resolved many issues as per R12 standards.
  • Transferred AOL objects using ITG kintana and FNDLOAD.

Environment: Oracle Apps Implementation Release R12 (Version), Modules: AP, GL, PO, INV, ZX and SQL, PL-SQL, Reports 10g/6i, Forms Personalization, XML or BI Publisher, Oracle Applications Framework(OAF), Oracle XML Gateway, Workflow, Putty, Winscp 3, Windows XP/2003 and Linux(Redhat) Server.

Confidential

Oracle Apps Developer

Responsibilities:

  • Preparation of Technical Documentation like MD60, RD60
  • Ensuring quality deliverables in time, Technical design for report customization and written PLSQL packages.
  • Developed new BI reports using PLSQL Packages.
  • Customizations of Miscellaneous Accrual Reconciliation Report.
  • Developed Accrual Reconciliation Analysis BI Report.
  • Remediated Shell Scripts to work with Email functionality and FTP in Linux environment.
  • Remediated packages, procedures and functions for R12 environment.
  • Remediated packages using UTL FILE, UTL SMTP.
  • Remediated Oracle Reports as per R12 standards.
  • Prepared and reviewed MD60 documents based on functional documents.
  • Registration of custom applications, concurrent programs
  • Defining of concurrent programs and executables.
  • Customization of AP and PO Accrual Reconciliation Standard Report.
  • Customization of Miscellaneous Accrual Reconciliation Standard Report.
  • Developed Accrual Reconciliation Analysis BI Publisher Report.
  • Technical design documents preparation and building objects as per client requirements.
  • Registering Request Sets in AOL
  • Registering Custom Applications, Concurrent Programs.
  • Defining Concurrent Programs and Executable
  • Technical design documents preparation and building objects as per client requirements.
  • Resolved many issues as per R12 standards.
  • Transferred AOL Objects using ITG Kintana.
  • Peer review of the team objects as per functionality for final sign off delivery.

Environment: Oracle Apps Implementation Release R12 (Version), Modules: AP, GL, PO, INV, ZX and SQL, PL-SQL, Reports 10g/6i, Forms Personalization, XML or BI Publisher, Oracle XML Gateway, Workflow, Putty, Winscp 3, Windows XP/2003 and Linux(Exadata) Server.

Hire Now