We provide IT Staff Augmentation Services!

Oracle Apps Technical Consultant Resume

New, JerseY

SUMMARY:

  • Over 8 years of experience in the IT industry IT industry mainly implementing Oracle ERP systems primarily using, PL/SQL, Oracle Forms and Reports, XML publisher and Oracle Applications. Successfully completed 3 Full life cycles projects with Oracle Applications 11i (11.5.10) and R12.
  • Worked on all stages of SDLC (Software Development Life Cycle) including requirement analysis, design, development, testing and implementation.
  • Expert on Oracle Supply chain modules and Oracle Financial Modules.
  • Experience in Advance Pricing (QP), Purchasing (PO), Order Management (OM), Inventory (INV), Account Payables (AP), Account Receivables (AR), General Ledger (GL), Cash Management (CM) and AOL modules.
  • Strong knowledge on Tables involved in P2P as well as O2C.
  • Strong knowledge on tables involved in Sub ledger Accounting (SLA) as well as General Ledger (GL).
  • Strong knowledge on Interfaces using API's.
  • Extensive experience in developing and customizing Reports 10g/9i/6i/4.5/2.5, Discoverer 10g/4i and XML/BI publisher 5.6.3/5.6.2 and Forms using Oracle Forms 10g/9i/6i/4.5.
  • Extensive Experience with AOL to develop Flex fields, Reports, and Validation sets and Concurrent programs and registered in AOL.
  • Proficient in Developing and Customizing Oracle Reports using Report Builder 6i/10g, XML/BI Publisher and Discoverer, Outbound Interfaces, Shell Scripts using UNIX ShellScripting and Forms in Oracle Applications.
  • Proficient in Procure to Pay (P2P,AP/PO), Order to Cash (O2C,OM/AR) and Supply Chain Modules.
  • Good understanding of data flow in the different modules of Oracle Applications.
  • In - Depth knowledge of the Apps data model, which helps in all aspects of development cycle such as building Custom Reports, data validation, data import etc.
  • Involved in Implementation, customization of several Oracle Financial Applications, Data mapping of Oracle functionality with Business requirements, historical conversions, interfaces and customizations.
  • Good knowledge on TCA, Multi-org, SLA and MRC (multiple reporting currencies) implementation.
  • Expertise in design and development of Interface/Conversion programs to import data from legacy systems and integrate it into Oracle Applications using Oracle open interfaces and Oracle Public API’s.
  • Experience in developing new forms with great complexity and customizing standard Oracle forms with the use of Template.fmb, Custom.pll.
  • Involved in writing documents MD50, MD70, CV40 etc using AIM (Application Implementation Methodology).
  • Integration of Modules and Business rules along with Setups, Standard and Custom Interfaces, custom reports and other customizations in Oracle Applications have been successfully implemented using strong technical and functional understanding of modules.
  • Technically proficient in RICE (Reports, Interfaces, Conversions, and Extensions) methodologies including Implementation, Interfacing, Conversion and Data Migration, experience in Upgradation to Oracle Apps 11i.
  • Experience in using XML Publisher for reports generation.
  • Expert in SQL, PL/SQL, Developer 6i/9i (Forms 6i/9i/10g/Reports 6i/9i/10g), Workflow Builder 2.6, SQL* Loader, Shell Scripting etc.
  • Expert in troubleshooting and fixing the bugs, creation of SR/TAR with metalink, obtaining patches from oracle support and applying patches with coordination of Apps DBA.
  • Knowledgeable in using Oracle utilities FNDLOAD.
  • Expert on Oracle Applications 11i/R12 experience includes AP, GL, AR, FA, CM, PA, PO, OM and INV modules.
  • Good Knowledge on Oracle Applications 11i/R12 Functional in Finance modules.
  • Expert on third party tools which are integrated to eBS like REVPRO, SABRIX and XML GATEWAY.

TECHNICAL SKILLS:

Oracle ERP: Oracle E-Business Suite (11i and R12).

Functional Modules: Payables (AP), Receivables (AR), General Ledger (GL), Advance Pricing (QP), Cash Management (CM), Purchasing (PO), Order Management (OM), Inventory (INV), iProcurement.

Tools: TOAD, SQL*Loader, SQL Developer, D2K, Discoverer 10g, XML Publisher, BI Publisher, Workflow Builder

Technical Modules: INV, PO, OM, iProcurment, AP, AR, GL, FA and PA

Operating Systems: Windows 8/7/XP, UNIX, LINUX

Languages: C, C++, JAVA, SQL, PL/SQL, Shell Scripting.

RDBMS: Oracle 11g/10g

Tools: SQL*Loader, Report Builder, BI Publishers, Workflow Builder, JDeveloper, PLSQL Developer, TOAD, SQL * Plus Meteor, CA WorkStation, Portfolio Project Management (PPM), Service now, Service desk, Citrix, SVN tortoise repository and winCVS repository.

PROFESSIONAL EXPERIENCE:

Confidential, New Jersey

Oracle Apps Technical Consultant

Responsibilities:

  • Designed and developed an interface between third party billing system (INTUIT) and Oracle Receivables (AR) to load external invoices data on daily basis. Used SQL*Loader for import INTUIT invoices into Staging tables, and developed PL/SQL API for complete validation of data and inserting into Interface tables.
  • Developed custom process for daily extracts from AP & GL
  • Developed FTNT Warranty Shipment Feed Report.
  • Participated CRP, User Acceptance Test & User Training. Go Live
  • Experience in Procure to Pay, Order to Cash and Supply Chain business flows.
  • Configure, test and train on global Oracle Trade Management processes.
  • Involved in Production Support for Oracle R12 Invoicing and Suppliers related issues.
  • Design and developed an interface between Confidential and (AR) Oracle Receivables for Cash Receipts (Auto Lockbox).
  • Wrote Functional (MD50), Technical (MD70) and Conversion Mapping document (CV40) for importing Legacy Purchase Orders into Oracle Purchasing, Legacy (AP)Payable Invoices into Oracle Payables, Journal Imports Interface from external Payroll, Items into Inventory, Bills of Material into BOM from legacy system.
  • Worked with interfaces from AP to PA (Project Accounting).
  • Developed Pricing Modifier uploading program which loads the modifiers data into Oracle QP from excel file using API.
  • Developed Rework tool in Order Management, which consists Custom form as well as Report. This Rework tool provides information of order numbers, reason and responsible person details for the rework.
  • 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.
  • 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.
  • Designed customizations, interface/conversion mapping, pre-production testing, and related documentation.
  • Developed Internal Inventory web service using Oracle SOA. This web service extract the incoming future PO’s for inventory items.
  • Responsible for converting the entire Historical Purchase Orders (PO) using Import standard Purchase Orders into Production.
  • Responsible for creating an interface for Purchase Order upload, which creates PO from a CSV file.
  • Involved in complete Procure to Pay (P2P, AP/PO) and Order to Cash (O2C, OM/AR) life cycle.
  • Worked with Sales Orders Open Interface in Oracle Order management module to import Sales Orders from flat files.
  • Designed wide variety of reports in Order Management with BI/XML Publisher.
  • Developed a PL/SQL API (Interfaces) to import data from sales orders interface tables into OM base tables and PL/SQL API to close sales order Headers.
  • 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.
  • Design and developed an Auto Lockbox interface to transfer receipts into Oracle Receivables
  • Developed AP Invoice Interface to upload invoices into the Oracle Payables.
  • Production Support -- Implementation issues, Month end, yearend activities in AR,AP and GL Modules.
  • Developed GL Interface to import the journals into Oracle General Ledger.
  • Worked on Bank Statement Upload into Oracle Cash Management (CE Interface)
  • Developed the Report TP AP Check Wire Payments by using Data Template .It lists all or specific Payments Details when the payment method is through ‘Check’ or ‘Wire’
  • Experienced with working on Auto Invoice Interface to import Customer Invoices, Credit & Debit Memos in Receivables.
  • Customized the Standard Workflow Items and process such as Order Header, Order Line and Change Order
  • Created a custom credit memo form and integrated with custom Approval workflow process and interfaced them to AR using Open Interfaces.
  • Developed the Report TP AP Invoice on Hold Report by using Data Template .This Report will lists all the Invoice on Hold Report to review detailed information about invoices on hold.
  • Developed the Report TP Vendor Detail Report by using Data Template .This report is used to get details for all the Vendors based on the GL date
  • Developed and customized complex XML reports by communicating and interpreting end-user business requirements.
  • Customized and developed various reports in AR, AP, GL, PO, OM modules using Reports 10g
  • Modifying PL/SQL Packages, Procedures, Functions for data population and updating as per user requirements.
  • Loading AR Invoices data from Spreadsheet to Interface table and then importing them into base table by using Auto invoice Master Program..
  • Extensively worked on RICE Components to view, transfer and modify the data in the same or different system.
  • Personalized many Oracle standard Forms as per the Client requirements.
  • Developed many reports and designed to view output in different formats like PDF, EXCEL, RTF and HTML using BI/XML Publisher. .
  • Generated a Payables Invoice Workflow, this can send Invoice attachment to approver’s email.
  • Experienced working with Workflow attributes, Functions, Notifications, Messages, Roles and related packages using Workflow builder.
  • Experienced with Data Migration with Master data (Items, Customers, Employees and Suppliers) & Open Transactions data (Invoices) for various Financials Modules.
  • Involved in migrating the data into Oracle Apps from the Excel Sheets using open interface / API, Oracle utilities and third party tools (Data Loader)
  • Developed various technical components like SQL, PL/SQL, Procedures, Functions, Packages, views, and materialized views, Collections for Forms, Reports, Interfaces and Conversions.
  • Developed PL/SQL scripts to load data from external system to Fixed Assets interface tables.
  • Developed several Procedures and Database Triggers as per Business requirement.
  • Used EXPLAIN PLAN, ANALYZE, HINTS to tune queries for better performance and also Extensive Usage of Indexes.
  • Developed Extracts in GL and AR modules and the extracted files are sent via FTP to other systems using the UNIX Shell Script.
  • Created MD070 and MD120 for the Custom Form.
  • Customized forms using CUSTOM.PLL file to meet the specific requirements

Environment: Oracle Applications R12/11i (11.5.10), GL, AR, AP, FA, HRMS, OTL, Oracle 10g, D2K (Forms 10g & Reports 10g), REVPRO, SABRIX, XML Gateway, TOAD, SQL *Loader, Putty, Winscp3, XML Publisher, Perforce Version Control and Workflow Builder.

Confidential, Medford, MA

Oracle Apps Techno Functional Consultant

Responsibilities:

  • Involved in Item Conversion to import items, and its attributes from legacy system into Oracle Applications
  • Involved in complete Procure to Pay (P2P, AP/PO) and Order to Cash (O2C, OM/AR) life cycle.
  • Designed and customized On-hand Quantity reports using Oracle Reports Builder 6i for INV
  • Customized reports in OM and Inventory such as: Pick Slip Report, Warehouse Performance Report, Open Orders with deliveries, Inventory Reserve Report.
  • Customized PO Workflow to hide attachment if the PO is not approved.
  • Customized Purchase Order Approval workflow for adding email notification workflow function for changed PO's.
  • Worked on Creating and Applying Holds on Sales Order during Order Import and Pick Release.
  • Customized of PO Requisition Charge Account Generator workflow to take a standard charge account based on the customer using Workflow Builder.
  • Responsible for creating an interface for Purchase Order upload, which creates PO from a CSV file.
  • Designed and developed an Inbound Interface between web based Order management systems to Order Management (OM) for import Sales Orders.
  • Developed a Custom Interface in OM that accomplishes Pick Release and Ship Confirm Process in Oracle using APIs.
  • Developed Item Conversion to load the data from legacy system to Oracle Inventory.
  • Created Data Definitions and Data Templates.
  • Involved in Building Customizations and Enhancements using Reports and Forms.
  • Developed Inventory Volume Report
  • Customized Account Payables (AP) Reconciliation Reports like Accounts Payable Trial Balance report, Posted Invoice Register, Posted Payment Register, Unaccounted Transactions report and consolidation journal report in General Ledger (GL).
  • Written an Interface for Account Payables (AP) Invoice Upload, which creates invoices from a CSV file.
  • Written PL/SQl packages with cursors, functions and procedures for inserting the data into vendors, invoices and purchase orders interface tables from various staging tables while validating the data.
  • Responsible for running Receivables open interface, imported data into RA interface tables and used the standard API Auto Invoice to import the customer invoices.
  • Analyzed requirements of the client for various legacy applications that needed migration and integration with Oracle Applications.
  • Developed and customized Financial Modules (GL, AR, AP, PO), Interacted with end users to gather requirements and Draft specifications for development Phase.
  • Designed and developed the conversion process for historical AR transactions into Receivables during the implementation process.
  • Developed a package that validates invoice information and load the invoices into AR by running auto invoice daily.
  • Developed a custom report to daily list all the rejected invoices(AR) based on the interface table.
  • Developed PL/SQL Procedures for Customer interface using TCA in Accounts Receivables according to Client Requirements.
  • Customized forms using CUSTOM.PLL file to meet the specific requirements.
  • Developed Invoice Ageing Report.
  • Involved in Code Review Process to make sure that code is in compliance with AIM methodology.
  • Analyzed an SR on interface trip stop program and modified and executed the script for different internal requisitions and sales orders (OM). Converted the same script into Concurrent request.
  • Used XML publisher to print, email and fax the reports.
  • Developed PL/SQL packages for Automation of Reconciliation project.
  • Developed reports using XML publisher for POO-850, POCO-860, INI-810, ADVO-824 transactions having multiple parametes.
  • Designed XML Templates, XML publisher reports. These are configured to generate output in PDF formats.
  • Used DB-links to capture data from external sources.
  • Developed Unix scripts for capturing File names and File size for Inbound and Outbound file sent/received from Oracle.
  • Worked on Auto invoice interface to load invoices automatically from legacy systems to Oracle Receivables interface tables.
  • Involved in functional document review and prepared technical requirement specification based on the business requirement.
  • Involved in Production Support for Oracle R12 Invoicing and Suppliers related issues.

Environment: Oracle Applications 11.5.10.2, OM, INV, BOM, WIP, TOAD, jDeveloper, Forms 6i and Reports 6i, XMLP, UNIX, Shell scripts, PL/SQL, TOAD, JDeveloper, Forms 10g and Reports 10g, SQL Developer,SQL*Loader

Confidential, New York

Oracle Apps Technical Consultant

Responsibilities:

  • Designed, documented and developed Staging tables, Conversion routines, and Custom PL/SQL API for Suppliers, Supplier Sites, Supplier Contacts, Customer Import (Parties, Party Sites, Party Accounts, and Party Account Uses) using TCA, Order Import from legacy system to Oracle Applications.
  • Providing the suggestions/options of the best way to implement their need in Oracle Applications with the SOX approval.
  • Developing Generic Packages using PL/SQL to build flat files to manage transmissions across Legacy and Oracle Systems.
  • Prepared various AIM documents like MD50, MD70, CV40 etc.
  • Involved in complete Procure to Pay (P2P, AP/PO) and Order to Cash (O2C, OM/AR) life cycle.
  • Designed, documented and developed Staging tables, Conversion routines, and Custom PL/SQL API for Suppliers, Supplier Sites, Supplier Contacts, Customer Import (Parties, Party Sites, Party Accounts, and Party Account Uses) using TCA, Order Import from legacy system to Oracle Applications.
  • Wrote a package containing different procedures and functions using PL/SQL to cross validate invoice information and load automatically invoices into auto invoice interface tables.
  • Created Invoices against Purchase orders using Payable Invoice Interface program.
  • Developed validation programs to validate the data before loading into interface tables from staging tables.
  • Prepared Technical specification documents (MD70) for Reports customized.
  • Involved in creating Views for Custom Reports.
  • Developing Generic Packages using PL/SQL to build flat files to manage transmissions across Legacy and Oracle Systems.
  • Developing Flexible PL/SQL Scripts/Packages for Data Objects Creation such as Tables to store legacy data and to maintain data for staging interim phase.
  • Developing SQL Loader control scripts to process the legacy data and to load them into Temp Staging Area.
  • Developed PL/SQL Scripts/Packages for Payables Invoice Import, AR Auto-Invoices Interface
  • Defined Customer Profiles, Customers, Payment terms, Payment methods and tax structures including tax exemptions and tax exceptions in Accounts Receivables.
  • Insured that TCA (Trading Community Architecture) was implemented properly and all the customers are loaded in HZ Tables.
  • Design and development of Auto Lockbox interface so that the bank file will be automatically imported into Accounts Receivables.
  • Defined various lookups/quick codes which can be used in different data conversions from legacy systems to Oracle system

Environment: Oracle Applications R12 GL, AR, AP, PO, iReceivables, PL/SQL, TOAD, Forms 6i and Reports 6i, Discoverer 10g, Jdeveloper, SQL*Loader, SQL*Plus, UNIX, Shell scripts.OAF Framework

Confidential

Oracle Apps Technical Consultant

Responsibilities:

  • Involved in generating forms, developing procedures and packages, writing database triggers etc. Used post query trigger to retrieve the employee information. Check boxes, Radio buttons, list items and LOV’s were used to make the system more users friendly.
  • Interacted with the end user during production support by helping them to develop user required reports and modify the existing as per the requirement.
  • Involved in writing technical design documents for conversion and customization
  • Creation of SQL*Loader control programs and PL/SQL validation procedures to execute along with Customer Interface (AR), and Order Import Interface (OE) programs to support the interface requirements.
  • Involved in Implementation of many developmental projects in Oracle and D2K.
  • Gained experience in writing SQL, SQL*Plus, PL/SQL procedures in Oracle.
  • Customized many Forms and Reports according to the business requirements of the clients.
  • Security measures at the back end were implemented using Database triggers, validation and Navigational triggers to enforce security at the front end.
  • Customized PL/SQL Packages and written PL/SQL Procedures.
  • Responsible for development of Purchasing & Inventory Control Modules for implementing security based roles, created users in Oracle also involved in development of Financial Accounting System, production, Dispatch & Maintenance System.
  • Created Tables & Views and referential integrity constraints using SQL.
  • Wrote Database Triggers, Procedure & Functions using PL/SQL.
  • Developed SQL*Loader files to load data from legacy system into the RA CUSTOMERS INTERFACE ALL tables for importing Customer data.
  • Responsible for development of Purchasing & Inventory Control Modules for implementing security based roles, created users in Oracle also involved in development of Financial Accounting System, production, Dispatch & Maintenance System.
  • Created Tables & Views and referential integrity constraints using SQL.
  • Customized the Inventory (INV) Item Report using Reports (6i).
  • 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 complete Procure to Pay (P2P, AP/PO) and Order to Cash (O2C, OM/AR) life cycle.
  • Involved in Item Conversion to import items, and its attributes from legacy system into Oracle Applications.
  • Developed XML and BI publisher reports.
  • Tuning SQL queries for better performance.
  • Involved in Form personalization.
  • Supported the CRPs, SIT and go-live activities.
  • Wrote Database Triggers, Procedure & Functions using PL/SQL.
  • Analyzed requirement of client and worked on developing and designing reports.
  • Implemented Security by creating different users/roles and assigning roles to users forms.

Environment: Oracle R12/11.5.10,Forms 10g/9i/6i, Reports 10g/9i/6i,Oracle 10g/9i,SQL* Loader, XML Publisher Developer 2000, PL/SQL, TOAD, SQL Developer, Windows 7/xp

Hire Now