We provide IT Staff Augmentation Services!

Oracle Apps Technical Consultant Resume

AtlantA

SUMMARY

  • Over 9+ years of extensive experience as Oracle Application Technical Developer in Implementation, Testing and upgrading Oracle E - business suite Applications (R12 and R11i). This includes system Analysis, Design, Development and production support of Oracle EBS.
  • Extensive experience in Design, Implementation, Migration, Customization and Production support of various modules in Oracle Applications such as Oracle Financials ( Account Receivables (AR),Account Payables (AP), General Ledger (GL), Sub-ledger Accounting (SLA), Fixed Assets (FA), ),Order Management (OM), Inventory (INV), Oracle Purchasing (PO), Bill of Materials (BOM), Project Accounting(PA), Warehouse Management System (WMS) and Shipping (WSH), Human Resource (HRMS), Application Object Library (AOL) and Oracle Application Framework (OAF).
  • Expertise in Oracle 11g/10g/9i/8i, SQL, PL/SQL, Forms10g/6i/4.5, Reports 10g/6i/4.5, Discoverer 10g/4i.
  • Strong Technical/Functional knowledge in Business flows like Order-to-cash (O2C), Procure-to-pay (P2P) cycles and Supply Chain business flows.
  • Experience in Forms, Reports, Interfaces, Conversions & Extensions (FRICE).
  • Experience working on Toad, SQL Developer, SQL*Loader, SQL*Plus, SQL* Navigator and Oracle Import/Export utilities.
  • Experienced in Oracle PL/SQL Development in Stored Procedures, Packages, and Functions & Triggers.
  • Expertise in writing PL/SQL APIs and customization of Client Extensions in Oracle Applications
  • Experienced in registering PL/SQL procedures, Reports, Forms, XML/BI publisher Reports, and SQL*Loader scripts as concurrent programs in the APPS front end.
  • Extensive hands on experience with Oracle Application Framework (OAF) and customizing Oracle Workflow.
  • Experience in developing new forms, Forms Personalization and customizing standard Oracle forms with the use of TEMPLATE.fmb, Custom.pll.
  • Experience in debugging, testing and deploying the applications designed and developed interactive GUI screens and reports using oracle forms/reports.
  • Knowledgeable in using Oracle utilities FNDLOAD and WFLOAD.
  • Strong knowledge of Unix Shell Scripts, bash and Perl Scripts. Development using tools like WinSCP and Putty.
  • Strong knowledge of Application Implementation Methodology (AIM), Application Object Library (AOL) implementation standards and Trading Community Architecture (TCA).
  • Experienced in handling, installing and effective troubleshooting and up gradation of EUL from Discoverer 4i to 10g.
  • Experienced in preparing Technical design documents (MD070, DS140), Functional Specifications (MD050), Technical Test documents (TE020), Conversion Mapping Documents (CV050), Migration documents (MD0120) and Installation Instructions document (IM090).
  • Experience in full-cycle implementations, Production Support & Maintenance.
  • Excellent analytical skills, strong verbal and written communication skills. Excellent team player.

TECHNICAL SKILLS

ERP: Oracle apps R12, 11i (OM, INV, PO, AP, AR, GL, P2P, O2C cycles).

Oracle tools: Forms6i/10g/4.5, Workflow Builder, Oracle Discoverer 10g/4i, XML Publisher, Oracle Reports6i/10g/4.5.

Document Méthodologies: MD.070, MD.050, CV.060, MD120

Tools: SQL* Plus, SQL* Loader, Toad, SQL Developer.

Languages: SQL, PL/SQL, C, Java, HTML, UNIX Scripting, XML.

Operating systems: SUN Solaris, Linux, UNIX, Windows.

PROFESSIONAL EXPERIENCE

Confidential, Atlanta

Oracle Apps Technical Consultant

Responsibilities:

  • Developed Custom Program to create and submit calculation batches for the OIC module.
  • Developed inbound interfaces and outbound interface for the modules OIC, AP,AR which run on periodic basis.
  • Involved in performance tuning of various packages and reports. Also, have done code fixes to improve the performance using Explain Plan, TKPROF & Trace.
  • Using the standard Oracle OIC(Oracle incentive compensation) API's CN CALC SUBMISSION PUB created a Involved in development of inbound interface custom package to validate and import Order details data into Oracle Applications OM Order interface tables from external system.
  • Involved in Order Management setups for transaction types, document sequencing, profile options, defaulting rules, and processing constraints
  • Involved in Customization of Cancelled Orders Report, Orders Summary Report.
  • Involved in Open Sales Order conversion based on client specifications.
  • Imported Items from legacy system into Oracle Inventory (INV) base tables using the Standard Item Interface program. Developed Item conversion program for assigning Items to Item category set and Categories.
  • Responsible for converting the entire Historical Purchase Orders (PO) using Import standard Purchase Orders into Production.
  • Developed an Outbound interface program to transfer the data from oracle PO base tables into the flat file.
  • Define user responsibilities, set up custom menus based on user responsibilities during Procure to Pay (P2P) implementation.
  • Performed Data Validation on Invoice, Payment, Suppliers, Employee Suppliers and Expense Reports data during Conversions as part of Procure to Pay (P2P) implementation.
  • Worked on Material Transactions, Material Distributions, and Resource Transactions in Procure to pay.
  • Developed a package that validates invoice information and load the invoices into AR by running auto invoice daily.
  • Customized AP Invoice on Hold Report, AP Payment Register Report using Oracle Reports.
  • Conversion of Oracle Reports to XML/BI Publisher Reports like AP Check Printing Report and AR Invoice Report.
  • Customized the standard AR Aging Report and Invoice History Report by using XML/BI Publisher.
  • Designed and developed Forms using Forms 10g as per the business requirements, provided Zoom functionality using CUSTOM.pll.
  • Designed and developed custom forms and reports in AP, AR as per business requirements.
  • Customized the Journal Line Report in Oracle General Ledger and Invoice Aging Report in Oracle Payables.
  • Developed FSG reports to give department managers a high level view of their current operating revenue and expense categories compared to their budgets using FSG and ADI.
  • Modified the Print Statements report and Invoice report as per the formats/layout of the client using Reports 10g.
  • Developed Oracle Workflow with I-Expenses to automatically route expense reports for approval, and enforce reimbursement policies.
  • Developed custom workflow for sending oracle workflow notifications.
  • Extended View Object (VO) and Controller Object (CO) of the Select Source Page Using Oracle Applications Framework (OAF) in iProcurement.
  • Personalized in Hiding/Displaying/Disabling/Re-ordering Attributes on iSupplier pages using Oracle Applications Framework (OAF).
  • Extended iProcurement Shopping Cart Page to added available quantity and Backorder flag fields using Oracle Applications Framework (OAF).
  • Performing various stages of testing during the Support Change fixes that include Unit Testing, Integration Testing and Regression Testing supporting the defined solutions.
  • Production Support Techno-Functional Consultant with hands on experience in the OIC Module.

Confidential, PA

Oracle Apps Technical Consultant

Responsibilities:

  • Analysis for the type of technical changes required for upgrading from 11i to R12, like table name changes, code changes..etc related to existing custom forms, custom reports and interfaces. Development of form customizations, Purchase Order Form, Sales Order forms using forms builder.
  • Participated in R12 upgrade project - upgrading from 11.5.10.2 to R 12.1.3.
  • Design, configuration, and testing of Oracle 12.1.3 AP, AR, INV, PO, OM modules, and all associated documentation using the AIM methodology.
  • Upgrade, maintain and troubleshoot Oracle Forms and Reports.
  • Using the standard Oracle OM (Order Management) API OE ORDER PUB created a custom PL/SQL package. This custom DB object used to create a new sales order, update/cancel an existing sales order.
  • Performed the whole Order Cycle in Order Management (OM), which includes Booking, Pick Release, Ship Confirming, and Interfacing to Receivables, Complete Line and Complete Order.
  • Involved in Importing the Orders 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
  • Imported ITEMS from legacy system to Inventory base table MTL SYSTEM ITEMS B using the standard Item Import program through a custom package that validates individual records.
  • Developed Shipping Interface program to receive shipments, which are in In-Transit for more than given number of days without having any financial impact.
  • Modified existing Sales order Interface and Ship confirm Interface, in order to consolidate and split the order lines.
  • Worked towards Future business flows, Identification of Gaps, Workarounds in order to provide an Integrated Procure to Pay (P2P) business flow.
  • Worked on implementing Oracle Inventory to Cash business flow as part of Procure to Pay (P2P).
  • Tuned SQL queries to enhance performance, using the method Explain Plan both at backend and in Toad.
  • Developed form customizations for Purchase Order Form, Import Journals form and Sales Order Form using forms builder for Oracle Financial applications.
  • Involved in handling all issues on Purchase Order Interface and Create standard purchase order and blanket releases.
  • Worked onOpen Item Interfaceto convert Purchased Item Information from Custom Purchasing System to Oracle INV module.
  • Developed PL/SQL program to be used to create Ship Confirm with delivery details using shipping API.
  • Developed custom interface program to load Inventory (INV) Adjustment data from external feeder system into MTL TRANSACTION INTERFACE and MTL TRANSACTION LOTS INTERFACE tables.
  • Design and configuration of the Oracle Accounts Receivable (AR) module as per Order to Cash process.
  • Developing and customizing interfaces with legacy systems using PL/SQL.
  • Developed custom forms usingTEMPLATE.FMBto fulfill the business requirements.
  • Customized the Customer Form using CUSTOM.pll to Activate/Inactivate the Active check box based on the users and the responsibilities.
  • Customized the standard forms in application modules usingCUSTOM.PLLfor hiding the fields, changing the visual attributes & prompts of the fields.
  • Designed and Developed E&O Inventory Transaction Summary Report to transfer the data from EBS to JDE.
  • Designed and Developed Daily Claims reports, Sales Order Status Report in Order Management, Customized existing Dunning report in Account Receivables Using XML/BI Publisher
  • Developed various reports like Bill of Lading, Master Bill of Lading, Pick slip and Packing Slip in Shipping Module.
  • Production Support Techno-Functional Consultant with hands on experience in the Order to Cash (OTC) modules: OM, Inventory, Warehouse, Purchasing, Receiving and module integrations withOM, GL, AP, AR, PO, INV, BOM, WSH withinthe EBSSystem.
  • Worked on Material Transaction Conversion and Interface programs to merge the lot numbers with Item in Oracle Inventory (INV).
  • Extended the View Objects and personalized the Requisition page and Requisition details page to display Only Approved PO numbers to the Requisition Using Oracle Applications Framework (OAF).
  • Extended and personalized existing AP HOLD Notification View more details Page Using Oracle Applications Framework (OAF).
  • Developed an OAF Page to display the sales order details based on the Sales Order Number search and after that we can edit the order details and Unit Testing of all OA Framework Pages.
  • Developed OA Framework Page to view rejected and cancelled Invoices from Account Payables.
  • Strong knowledge of Functional and technical design documents like AN100,DS140,IM90,CM50,TE20, Testing documents and preparing code packs throughout multiple Projects.

Confidential, Atlanta, GA

Oracle Apps Technical Consultant

Responsibilities:

  • Design and development of the Project Accounting customization form from the standard Project Accounting form.
  • Development of form customizations using forms builder for Oracle Project Accounting applications, Purchase Order Form
  • Worked on Auto Invoice Interface to import Customer Invoices, Credit & Debit Memos in Receivables. Materialized views, Collections for Forms.
  • Development of PL/SQL scripts to load data from the database to customized form.
  • Developing Oracle Alerts to send the notifications to the users based on the business requirements.
  • Develop and debug SQL, PL/SQL scripts including Packages, Procedures, and Functions & Triggers in Oracle 10g database to perform various form tasks.
  • Debugging, testing and deploying the Oracle Project Accounting applications using oracle forms.
  • Reviewing unit test cases, unit test results and validating as per the business requirements.
  • Preparing Technical specifications (MD070) from the Functional Specifications (MD050).
  • Developed Billing events and revenue events creation program by using APIs in Oracle PA module
  • Developed form customizations for Purchase Order Form, Import Journals form and Sales Order Form using forms builder for Oracle Financial applications.
  • Involved in performance tuning of various packages and reports. Also, have done code fixes to improve the performance using Explain Plan, TKPROF & Trace.
  • Using the standard Oracle OM (Order Management) API OE ORDER PUB created a custom PL/SQL package. This custom DB object used to create a new sales order, update/cancel an existing sales order.
  • Imported the Journal Entry Transactions into GL INTERFACE table using SQL*Loader and successfully created the Journal Entry's in General Ledger (GL) using Journal import.
  • Developed SQL*Loader control programs and PL/SQL validation procedures to load legacy GL Code Combinations into Oracle General Ledger.
  • Worked on custom program to perform Address Validation of the Address to be Imported to TCA tables against the Vertex provided seeded data.
  • Developed Custom Program to interface Customer locations provided by AT&T to TCA Base Tables. This includes loading of Addresses, Sites, Business purpose (Bill-to, Ship-to) etc from the AT&T file which provided on a weekly basis
  • Customized standard AP Invoice aging report, Check printing report in Account Payables.
  • Developed AP Invoice Interface to upload items into the Oracle Payables.
  • Designed and developed custom forms and reports in AR, AP as per business requirements.
  • Provided analysis, design, installation, and rollout of Accounts Payable.
  • Developed PL/SQL Procedures for Customer interface in Accounts Receivables (AR).
  • Worked on the Credit Memo issues in the Project Billing (PB) Module. For this developed a script to store the TAID provided by Vertex for the original project Invoice in a Custom Descriptive Flex Field (DFF) in Receivables (AR) lines table.
  • Developed an UNIX Shell Script to send the Output & Log file of the custom interface as an attachment notification to the end users.
  • Developed a custom program to perform data cleansing on the Description Column of PA TASKS table in Project Accounting (PA). This program is used to cleanse control characters which may cause problems for certain EDI transactions.
  • Worked on Vertex, eB-Tax base tables to retrieve the Vertex O Series TAID for a corresponding Original Project Invoice.

Confidential, NY

Oracle Apps Technical Consultant

Responsibilities:

  • Writing the functional design and technical design for all customizations (forms, concurrent programs), so that business users and technical developers had a common understanding of the solution.
  • Extensively worked on Project Accounting (PA) module to set up Project WBS Templates, Tasks, and Billing Event types.
  • Developed Project Conversion Program to import the projects from the legacy system into Oracle Project module by using the API.
  • Imported Active Project labor Hours from Legacy system into Oracle Projects.
  • Developed Billing events and revenue events creation program by using APIs in Oracle PA module
  • Modified standard Project Billing Extensions to generate the revenue as per the client requirement.
  • Developed Customer interface in Accounts Receivables (AR) by using the TCA APIs.
  • Customized standard PO print report by using XML Publisher.
  • Developed form customizations for Purchase Order Form, Import Journals form and Sales Order Form using forms builder for Oracle Financial applications.
  • Customized standard AP Invoice aging report, Check printing report in Account Payables.
  • Provided analysis, design, installation, and rollout of Oracle 11i General Ledger, Accounts Payable, Fixed Assets and Purchasing.
  • Developed PL/SQL Procedures for Customer interface in Accounts Receivables (AR).
  • Developed custom workflows for specialized AR transactions.
  • Developed control Files to load the data from legacy System to Oracle Staging Tables using SQL Loader, from which data is transferred to the base tables using the conversion programs.
  • Developed form customizations using forms builder for Oracle Financial applications, Purchase Order Form, Oracle Financials Import Journals form, Sales Order Form.
  • Customized standard packing slip report to show the bar codes and individual component serial numbers.
  • Developed Supplier conversion program to convert the supplier from legacy system into Oracle EBS TCA.
  • Customized Standard FSG reports (Balance Sheet, Income Statement and Department Expenses) in General Ledger module.
  • Implemented Web ADI to import journals by using the Journal import templates.
  • Developed custom forms in AP usingOracle Applications Frame Work (OAF).
  • Worked on personalization and extensions of Oracle standard pages usingOracle Applications Frame Work (OAF).
  • Customized supplier inquiry page using VO Extension and controller extension of OA Framework
  • Worked on customizations and extensions of oracle seeded web pages using OAF.
  • Developed custom reports such as Schedule Outstanding Bills, custom invoices and statements.
  • Created XML Publisher reports from existing oracle reports.

Confidential, Jamesburg, NJ

Oracle Apps Technical Consultant

Responsibilities:

  • Involved in designing of Conversion/Interface projects Implementation Strategy for Accounts Payable, Accounts Receivable and General Ledger.
  • Migrated GL and AP custom interfaces and reports, during Oracle financials upgrade project from 11i to R12.
  • Imported the data from legacy systems into the temporary tables in Account Receivables (AR).
  • Defined customer profiles, customers, payment terms, payment methods and tax structures, including tax exemptions and exceptions in Accounts Receivables (AR).
  • Imported data from Legacy system to Account Payables tables using SQL*Loader and validated them using PL/SQL Procedures.
  • Developed interfaces to load the GL Data from legacy system into GL JE BATCHES, GL JE HEADERS and GL JE LINES base tables using journal import concurrent program.
  • Worked extensively on the customization of Auditor Reports using BI/XML Publisher and resolved open issues with the existing custom reports and also involved in the development of new ones.
  • Designed wide variety of reports in Order Management with BI/XML Publisher.
  • Developed reports in Payables to send a Notification to AP/Buyer/Requestor of Invoices on Hold.
  • Designed Invoice Received and Approval Hold (with 2/3/4 way matching) in Payables based on Client Specification using BI Publisher.
  • Developed Open Purchase Requisitions, Blanket & Contact Notifications in Purchasing Module.
  • Generated a Payables Invoice Workflow, this can send Invoice attachment to approver’s email.
  • Experienced with working on Receipt API to bring an Unapplied Receipts and Conversion Receipts for Open Debit items to reduce the balance to the original amount due.
  • Wrote PL/SQL packages for different validations, for processing data in order to create valid POs and Receipts and for populating the PO interface tables and called the seeded import programs to populate the base tables.
  • Experienced with working on Auto Invoice Interface to import Customer Invoices, Credit & Debit Memos in Receivables.
  • Developed AP Invoice Interface to upload items into the Oracle Payables.
  • Worked with Sales Orders Open Interface in Oracle Order management module to import Sales Orders from flat files.
  • Developed a custom page using OA Framework to register new suppliers and submit for approval.
  • Worked on customizing a webpage to initiate custom workflow from OA Framework webpage.
  • Customized supplier inquiry page using VO Extension and controller extension of OA Framework
  • DevelopedOAF Screens for OE (Open Enrollment) for client associates.
  • Have extended oracle seeded OAF Pages to meet additional business requirements.
  • Developed PL/SQL scripts to load data from external system to Fixed Assets interface tables.

Confidential, Salt Lake City, Utah

Oracle Apps Technical Consultant.

Responsibilities:

  • Imported Sales Order data from legacy system into Oracle Order Management by using the standard OE ORDER PUB API.
  • Developed the Purchase order and PO Receipt interface programs to load the Purchase orders and receipts from the legacy system.
  • Customized FSG reports in Oracle General Ledger.
  • Worked on performance tuning to increase the performance of reports and stored procedures.
  • Developed Custom Overdue Sales Order report in XML Publisher report.
  • Interacted with end users and functional architects for mapping the legacy data to the Oracle tables.
  • Developed Replenishment Interface in Oracle Inventory (INV) based on data sent from warehouse in flat file.
  • Used Loader program to load the data into the staging table, and then performed PL/SQL validations to load the data into the interface tables.
  • Wrote the Program to insert data into Receiving Interface tables based on the different Transactions and Receiving Transaction Processor process data from the interface tables and the quality updates are done.
  • Defined payment terms, Locations, Invoice Approvals and setting up Bank Account information in Accounts Payables.
  • Created Sets of Books in GL by defining Key Flex Fields, segments, value sets, accounting calendars, currencies.
  • Modified existing reports by creating additional joins and designed and developed many reports by using lexical parameters in before, after parameters and before report triggers.
  • Customized several oracle standard forms using CUSTOM .PLL.
  • Develop Custom Alerts to send mails to related users to notify process of PO and error codes.
  • Involved in customization of various reports as per the user requirements, which includes customized mailing label report, sales order acknowledgement report, Order Status Summary report, printed purchase order and packing slip report, Vendor Performance report.
  • Developed a customized weekly inventory report that gives details of pending orders and available quantity of the items in inventory.

Confidential, San Diego

Oracle Apps Technical Consultant

Responsibilities:

  • Responsible for the technical and user documentation of the customizations, conversions and reports.
  • Developed PL/SQL scripts to load order data from external legacy system to OM by using the order import open interface program
  • Involved in developing a custom package for importing Orders from web-based system COPS (Conference of Parties)through Order Import Open Interfaces PL/SQL API in Order Management
  • Customization of Oracle forms like, Order Entry, Item Master, Material Transactions and various other forms using Custom.pll, as per the client requirements.
  • Developed a customized workflow in Order Entry to keep track of the sales order and sending the notifications correspondingly when the order is fulfilled
  • Involved in implementation of Order to Cash cycle including Order Entry, Order Booking, Pick Release, Ship Confirm, and Interfacing to Receivables.
  • Worked on Item import Open Interface in Inventory Module (INV). Oracle Inventory provides Item Open Interface to easily populate the items in flat files into Oracle Applications.
  • Oracle Inventory provides Customer Item Open Interface (INV) to easily import Customer Items from external systems to Oracle Applications.
  • Worked on AOL to register new reports, forms, functions, and created validation sets, request sets and concurrent programs.
  • Developed and customized standard Oracle Apps Reports in Inventory, Shipping, Order Management and AP Modules.
  • Modified existing reports by creating additional joins and designed and developed many reports by using lexical parameters in before, after parameters and before report triggers.
  • Registered newly created forms with Oracle Applications, Customized several oracle standard forms using CUSTOM .PLL.
  • Performance Tuning of Custom PL/SQL Packages.

Confidential

Oracle Apps Technical Developer

Responsibilities:

  • Analyzed requirements of the client for various legacy applications that needed migration and integration with Oracle Applications.
  • Developed SQL*loader script and PL/SQL script to load and validate Customers data into Oracle Receivables.
  • Responsible for running Receivables open interface, imported data into RA interface tables and used the standard Auto Invoice Interface to import the customer invoices.
  • Prepared high-level and low-level designs for bridging and migrating data to AP, AR modules.
  • Imported the journal entries from legacy system to Oracle General Ledger using SQL*Loader, PL/SQL package and populated the data into the GL interface.
  • Customized the Journal Line Report in Oracle General Ledger and Invoice Aging Report in Oracle Payables.
  • Developed custom reports such as Commitment Balance Report, Orders by Item Report and Credit Order Summary Report in Oracle Order Management.
  • Used CUSTOM.pll to implement the change in behavior of Standard Oracle Applications forms in Order Entry.
  • Registration of new forms and reports using Application Object Library (AOL).
  • Involved in managing concurrent programs, application user setup, defining responsibilities.
  • Documented the guidelines of MD70 and MD50.

Confidential

Oracle Developer

Responsibilities:

  • Worked on Database Schema design and User Interface screens. Designed ER diagram of database using Microsoft Visio.
  • Developing GUI using Oracle Form Builder - Object Library, Object Groups, PL/SQL Library, Menus and Data Entry screens
  • Extensively worked in Oracle SQL, PL/SQL, SQL*Plus, SQL*Loader, Query performance tuning, Created DDL scripts, Created database objects like Tables, Views Indexes and Sequences.
  • Used partitioning and sub partitioning of tables to improve performance.
  • Developed Shell scripts and SQL control files to load data through SQL*Loader.
  • Developed Complex SQL queries using various joins and developed various dynamic SQL’s thorough out the projects.
  • Used Bulk Collect feature to improve performance.

Hire Now