We provide IT Staff Augmentation Services!

Lead Oracle Apps Technical Consultant Resume

4.00/5 (Submit Your Rating)

West Palm Beach, FL

SUMMARY:

  • Having around 11 years of experience as an Oracle Applications Techno Functional Consultant (E - Business Suite 11i & R12) with expertise in Project Accounting (Costing & Billing), Oracle SCM Modules (OM, INV, PO and iProcurement) and Financials modules (AP, IBY and AR)
  • Involved in 8 full life cycle implementations of Oracle Applications 11i and R12
  • Involved in R12 Upgrade and Production Support Projects.
  • Work Experience as Functional Consultant in Project Accounting (Project Costing & Billing)
  • Good exposure on Order to Cash (O2C), Procure to Pay (P2P) business flows
  • Expertise in implementing FRICE (Forms, Reports, Interfaces, Conversions, Extensions) components in the area of technical design, development, Integration testing and deployment.
  • Experience in developing new forms with great complexity using Template.fmb
  • Customizing standard Oracle forms with the use of Custom.pll
  • Experienced in Forms Personalization
  • Experience in development of self-service pages using OAF
  • Experience in VO and CO Extensions and Page Personalization in OAF
  • Expertise in design and development of Interface/Conversion programs to import data from legacy systems and integrate it into Oracle Applications using open interfaces and APIs.
  • Work experience on Outbound Interfaces to extract the data from Oracle Application database to data files using UTL FILE utility
  • Experienced in creating new workflows and customizing seeded approval and account generator workflows
  • Experienced in customizing Oracle Client Extensions as per business requirements.
  • Experienced in creating custom Web ADI Integrators and documents and customizing existing ADI documents
  • Worked on developing and customizing reports as per client requirement using XML/BI Publisher and Reports Builder
  • Good experience in Payments module customizations like Positive Pay, Payment EDI, Check Printing, Separate Remittance Advice, etc using E-Text Outbound Reports and XML Publisher Reports
  • Experienced in UNIX shells scripting
  • Good Experience in creating new Discoverer Reports
  • Excellent knowledge of AOL (Application Object Library) and System Administration Modules
  • Substantial development experience in creating PL/SQL components like Packages, Stored procedures, Functions, Triggers, Indexes, Views and Materialized Views.
  • Good Knowledge on ALERTS
  • Good exposure on Approval Management Engine (AME).
  • Extensively worked on Application Implementation Methodology (AIM) documentation.
  • Experience in using Oracle tools like SQL*Loader, FND LOAD, SQL Developer and TOAD.
  • Good experience in Data loader (Classic & Professional)
  • Good experience in creating Unit Test documents
  • Good experience in resolving Performance Issues in Forms, Reports, Interfaces, Conversions and PL/SQL code.
  • Provided support for CRP, SIT (System Integration Testing) and UAT (User Acceptance Testing) test cycles.
  • Ability to support and manage mission critical business applications 24x7
  • Good Written, Verbal Communication Skills and Analytical Skills

TECHNICAL SKILLS:

ERP: Oracle Apps 11.5.10.2, 12.1.3, 12.2.3 and Oracle Fusion Cloud Rel11

Modules: Project Costing and Project Billing (PA), Payables (AP), Payments(IBY), General Ledger (GL), Purchasing (PO), iProcurement, Order Management (OM), Receivables (AR), Inventory (INV), iExpenses (iExp), Approval Management Engine (AME), Electronic Data Interchange (EDI) and Trading Community Architecture (TCA)

RDBMS: Oracle 12c/11g/10g/9i/8i

Oracle Products: SQL, PL/SQL, Forms 6i/10g, Reports 6i/10g, Workflow Builder 2.6, JDeveloper (OAF), Oracle Discoverer 10g and XML/BI Publisher Versioning Control Tools VSS, SVN and PVCSTools: Toad, SQL*Loader and Data Loader

PROFESSIONAL EXPERIENCE:

Confidential, West Palm Beach, FL

Lead Oracle Apps Technical Consultant

Responsibilities:

  • Designed and Developed Purchase Orders Interface to import open purchase orders from legacy systems to Oracle Purchasing.
  • Designed and Developed Payables Invoice Import Interface to import open invoices into the Oracle Payables.
  • Worked on Sales Orders Open Interface in Oracle Order management module to import Sales Orders from flat files.
  • Developed several Oracle reports using XML/BI Publisher and Oracle Report Builder and in Inv, AP, AR, PO and OM Modules.
  • Worked on Invoice Approval Workflow customization
  • Developed new Oracle Form (Sellers Workbench) as per client requirements.
  • Worked on VO and CO extensions in iProcurement.
  • Worked on OAF page Personalization in Supplier Page.
  • Created Database objects such as Tables, Views, Sequences, Procedures, Functions, Triggers and Packages.
  • Responsible for gathering business change requests and after extensive analysis determine (and document) scope of technical changes and implementation strategy.
  • Prepared unit test plans, implementation strategy.
  • Analyze, review code, perform bug fixings to optimize the performance.
  • Created custom folders, item classes in Discoverer Administration, cross tab, page detail reports, conditions, parameters, sharing of workbooks in Desktop 10g.
  • Trained users on how to use the workbooks to customize layout, generate output and view them in Discoverer Plus and Viewer.
  • Developed MD70 Technical Design Documents based on business requirements to include technical details for each deliverable such as input data format, table mapping, flow chart, concurrent program names and order of execution.

Environment: Oracle Applications R12 (General Ledger, Accounts Receivables, Accounts Payables, Purchasing, Inventory, Fixed Assets, Order Management), Oracle 10g, Forms 10g, Reports 10g, Discoverer 10g, XML/BI Publisher, SQL*Loader, Toad.

Confidential

Oracle Fusion Cloud Data Migration Lead

Responsibilities:

  • Interact with business users and understand / document current state business process
  • Involved since the Blue Print phase of the project
  • Prepare / review future state business process flow diagrams, perform Fit Gap Analysis and recommend customizations
  • Capitalization, demand forecasting, organize integration workshops with key end users to clarify business related issues
  • Delivered Data Migration Strategy document
  • Involved in Data Mapping between legacy system and Fusion apps.
  • Identified loader methods ( FBDI, HCM Data Loader, HCM Spreadsheet Loader, Payroll Batch Loader, ADFDi , etc) for data entities in scope
  • Identified reconciliation methods ( FBDI Process Output, HCM Extracts, Diagnostic Tests, Oracle BI Reports , etc) for data entities in scope
  • Loaded files using loader methods in Oracle Fusion for data entities in HCM, Financials and Procurement Cloud.
  • Prepared Reconciliation reports (using HCM Extracts and Oracle BI Reports) to reconcile the data back to legacy system.
  • Prepared documentation on each of the loader methods explaining detailed steps of how we can load the data into Fusion apps.
  • Prepared documentation on each of the reconciliation methods explaining detailed steps of how data can be reconciled after loading the data into Fusion Apps .
  • Prepared CV40 and CV60 conversion document for HCM, Financials and Procurement data entities.
  • Configure and demonstrate uploading of Payroll Elements using ADFDi
  • Developed custom Oracle BI Reports in Fusion Cloud

Environment : Oracle Fusion Cloud Rel 11, Inventory, Procurement, Receiving, Supplier Portal, Project Costing, AP, FA, Core HR, Payroll, Absence Management, GL, Cost Management, PL/SQL, SQL, ADF 11g, SQL Developer, OIM.

Confidential

Oracle Applications Technical Consultant

Responsibilities:

  • Involved in POC (Proof of Concept) in Service2Cash development.
  • Designed and Developed Rules Engine Custom Solution using OAF
  • Designed and Developed Rollup and Mapping Custom Solution using OAF
  • Involved in changes to Core Framework (which is third party Oracle e-Business Suite Integration Tool)
  • Designed and Developed SIS Outbound Program to extract the data in XML format as per IATA guidelines to transmit AR invoices to customers.
  • Used advanced Oracle concepts to dynamically fetch the SIS outbound columns definition from configurations like custom forms and lookups.
  • Developed new Rules as per business requirements in the Custom Rules library
  • Developed custom workflow to support the approval mechanism for all interfaces based on Core Framework configuration
  • Involved in Auto generating the code like interface package, staging tables, Indexes, etc using Dynamic SQL .
  • Developed Unix Shell Script to generate the UNIX directories based on the Interface configuration in Custom form.
  • Worked on AR Transmission Control Extension to mark whether invoices are eligible for transmission or not.
  • Personalized AR Transactions form to show the transmission status of invoice using special menu item
  • Developed custom report for AR Invoice Transmission via email and Paper to customers
  • Developed custom AR Audit summary report explaining the details of AR Invoice audit history
  • Developed custom program to update AR Interface table for credit and rebill scenarios
  • Developed custom report on Customer Master Extract
  • Developed Batch Summary Report in AR and OM modules
  • Developed SLA Summary report used to reconcile the data from GL to subledgers AR and OM.
  • Worked
  • Used FND REQUEST API to submit concurrent Programs from PL/SQL program.
  • Developed multiple SQL * Loader Control files for Inbound interface to load data from flat files into Oracle Staging tables.
  • Have Created PLSQL packages, procedures, functions as part of the interfaces development.
  • Customized the Oracle Seeded Order Management Transaction Type workflow to add workflow functions for email Notifications when the order is booked using Workflow Builder.
  • Involved in creating DS140, TE020 and IE090 documents for Interfaces, Workflows and Reports
  • Defects were tracked, reviewed, analyzed and compared using Quality Center.

Environment: Oracle Applications R12 (12.1.3) and Oracle 10g, OM and AR

Confidential

Oracle Applications Technical Consultant

Responsibilities:

  • Worked on Sales Order Interface related Order Management where the order data was feeding from multiple third party systems in fixed/delimited data files format.
  • Worked on SIS IATA XML Outbound interface, which will create the XML files, based on Customer Transaction and order management data and feed third party invoicing system IATA
  • Worked on ADB outbound interface , which is position based output text file needed to feed third party airport system
  • Created Purge Order program to purge sales orders from Order Management and other dependent staging tables.
  • Worked on Apply Hold Program to apply holds on Sales Orders based on the business Requirements.
  • Worked on Release Hold Program to release holds on Sales Orders based on the business requirements.
  • Worked on Mass Sales Order Booking Program to book multiple sales orders based on selection criteria parameters.
  • Worked on third party product called “Integration Framework” to create the inbound and outbound interfaces as per business requirements.
  • Worked on Invoice transmission UNIX program , which transmits the Invoice PDFs to customer email addresses.
  • Customized Sales Orders form to make Order Line and Pricing DFF read only based on the Profile setup using Custom.pll
  • Created UNIX shell script to create directories for the inbound and outbound interfaces.
  • Worked on multiple Web ADI Integrators and Templates. Created new Integrator and templates as per business requirements.
  • Worked on Workflow customizations related to third party product “Integration Framework”.
  • Worked on XML Publisher reports like Order Determination Report, AR Credit Memo Report, Charges Report.
  • Worked on AR Invoice Write off Extension program to write off / Cancel AR invoices based on certain business scenarios / user actions.

Environment: Oracle Applications R12 (12.1.3) and Oracle 10g, OM and AR

Confidential

Oracle Applications Techno Functional Consultant

Responsibilities:

  • Worked on PA Expenditure Type Harmonization Process (As part of this process, all old expenditure types which are OU specific in current system, will be replaced with global new expenditure types)
  • Identify the impacted areas (like Auto accounting, Non-Labor Overrides, Overtime Billing overrides and custom components like Cost Capping and Billing capping, etc) in relation to Expenditure type replacements.
  • Design and Develop the custom programs to replace old expenditure types with new expenditure types by using the Oracle provided public/private APIs for each of the affected components.
  • Unit test the end to end cycle for each business components for expenditure type changes.
  • Reconcile the data in excel for each of the business component before and after the expenditure type replacement.
  • Worked on remediating the custom PA and AP components from 11i and compile in R12 instance.
  • Involved in Account Generator Workflows (Requisition, Purchase Order and AP Invoice) customizations as per new Auto Accounting rules changes in Project Accounting.
  • Customized Check Printing format using IBY extensions and BI Publisher reports.
  • Worked on Form Personalization in Oracle Receivables (AR), where the user can’t update the last and first name of customer, when that record is validated.
  • Defined Auto Accounting for Miscellaneous, Time and Labor, Supplier Invoice, Expense Reports in PA module.
  • Configuration and Setups for Oracle Project Billing .
  • Developed a new custom report Project Level Revenue Audit and PL/SQL script associated to report.
  • Developed Project Actual to Budget Detail Report for PA using XML/BI Publisher.
  • Involved in writing UNIX Shell Scripts for moving and copying files from server to client and from client to server.
  • Prepared Technical Requirement Specifications MD70 based on MD50.
  • Involved in Cutover activities related to PA Expenditure Type Harmonization in all the test cycles.
  • Migrated Custom developments from 11.5.10 to R12, Forms, custom database views, generate new XML Publisher reports.
  • Involved in Production support to resolve the issues related to Project Accounting and Payables Modules.
  • Managed customer issues/escalations by working with Product management, support and product development team.

Environment: Oracle Applications R12 (12.2.3) and Oracle 10g, PA, PO, AP, AR and HRMS

Confidential

Oracle Applications Technical Consultant

Responsibilities:

  • Interact with Stanstead Airport Authority to understand business requirements and functional design
  • Collaborate with Business Analysts to translate business requirements into MD70 technical design document
  • Developed following Extract and Load programs related to Data Migration
  • GL Code Combinations Conversion
  • Supplier Conversion
  • Requisitions Conversion
  • Purchase Orders Conversion
  • Receipts Conversion
  • Projects Conversion
  • Budgets Conversion
  • Fixed Assets Conversion
  • Supplier Invoice conversion
  • Customized Custom Reports related to Project Accounting as per Stansted Requirements.
  • Design and build interfaces between legacy applications and Oracle AR / AP to interface invoice data
  • Design XML Schema (XSD) as per interface requirements of the participating applications
  • Interact with SMEs to arrive at common data file format for AR invoices created in different legacy applications
  • Prepare TE20, TE40 documents, create test data to test different business scenarios
  • Perform System Integration Testing and validate applications as per business requirements
  • Provide support during User Acceptance Testing and resolve defects, provide post go-live support
  • Contribute to Project Management related activities like effort estimation, assist in recruitment, maintain quality related artifacts, prepare weekly status reports

Environment: Oracle Applications R12 (12.1.3) and Oracle 10g, PA, PO, AP, AR, iExpenses and HRMS

Confidential

Oracle Applications Technical Consultant

Responsibilities:

  • Designed customizations, interface/conversion mapping, pre-production testing, and related documentation.
  • Interacted with end users to gather requirements and Draft specifications for development Phase.
  • Involved in Procure to Pay (PO, INV and AP) and Quality modules.
  • Developed Item Conversion in Inventory
  • Developed Raw Material Conversion in Quality Module
  • Worked on Label Master Conversion in Quality Module
  • Worked on Inspection Results conversion in Quality Module
  • Worked on Inspection Master Conversion in Quality Module
  • Designed and Developed RA (Regulatory Affairs) custom form in Quality Module
  • Designed and Developed Special Instructions custom form in Quality Module
  • Worked on Item Master Outbound Interface
  • Developed a package that validates invoice information and load the invoices into AP by running Open Interfaces daily.
  • Developed a custom report to daily list all the rejected invoices(AP) based on the interface table.
  • Responsible for converting the entire Historical Purchase Orders (PO) using Import Standard Purchase Orders into Production.
  • Customized forms using CUSTOM.PLL file to meet the specific requirements.
  • 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).
  • Responsible for creating an interface for Purchase Order upload, which creates PO from a CSV file.
  • Analyzed requirements of the client for various legacy applications that needed migration and integration with Oracle Applications.
  • 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.
  • Designed, documented and developed new workflow to send email notifications to group of people when updating items and supplier address.
  • Involved in functional document review and prepared technical requirement specification based on the business requirement.
  • Involved in Code Review Process to make sure that code is in compliance with AIM methodology.

Environment: Oracle Applications R12 (12.1.3) and Oracle 10g, AP, PO, INV, WIP, BOM, Quality and Shipping & Pricing

Confidential

Oracle Applications PA Techno Functional Consultant

Responsibilities:

  • Prepared Functional Requirement documents (MD050) for custom components related to Project Accounting.
  • Configured Project Accounting (Costing and Billing) setups as per BR100
  • Configured Intercompany setup in Project Billing.
  • Supporting custom solution US Clearing House , which is an integration solution of AP, PA, AR and GL for Intercompany Invoice Payments.
  • Unit tested Clearing House custom solution in Project Billing.
  • Prepared Unit Test Cases and performed unit testing on custom PA components.
  • 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, Invoice Import from legacy system to Oracle Applications.
  • Developing Generic Packages using PL/SQL to build flat files to manage transmissions across Legacy and Oracle Systems.
  • Developed Projects Conversion
  • Developed Budget and Financial Plan Conversion
  • Worked on Billing Client Extensions
  • Worked on PA Approval Workflow Extensions
  • Prepared various AIM documents like MD50, MD70, CV40 etc.
  • Wrote a package containing different procedures and functions using PL/SQL to cross validate invoice information and load automatically invoices into invoice interface tables.
  • Created Invoices against Purchase orders using Payable Invoice Import Interface program.
  • Developing SQL Loader control scripts to process the legacy data and to load them into Temporary Staging Area.
  • Ensured that TCA (Trading Community Architecture) was implemented properly and all the customers are loaded in HZ Tables.
  • 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 (12.1.3) and Oracle 10g, PA, AP, AR, GL, FA and CE

Confidential, Fresno, CA

Oracle Applications Technical Consultant

Responsibilities:

  • Developed new forms to implement Payment Solution to provide user the ability to approve supplier invoices based certain invoice selection criteria, before making the payment.
  • Worked on Development of new forms and PL/SQL to implement Debit Memo Research to either Cancel or Allow the Debit Memos.
  • Worked on Development of new forms to implement Returns to Vendor (RTV) transactions.
  • Developed XML/BI publisher Reports and utilizing bursting to communicate PDF output to supplier contact email addresses.
  • Worked on Payable Open Interface program to create Debit Memos related to RTV transactions.
  • Customized Payment EDI template to generate text output ( eText-outbound) .
  • Worked on customization of generating positive pay file as per client requirements for different banks and different currencies using eText-outbound.
  • Customized Separate Remittance advice template to generate PDF output.
  • Worked on EDI (Electronic Data Interchange) for Purchase Order Outbound and AP Invoice Inbound.
  • Designed and Developed custom OAF web page to upload the AP invoice CSV files from local desktop to Oracle Database tables. Perform validations on data base table and import the data into Application base tables.
  • Worked on documentation like MD070, TE020 and MD120 for each of the deliverables
  • Responsible for reviewing the code before promoting to test environments.

Environment: Oracle Applications R12 (12.1.3) and Oracle 10g, AP, IBY, AR, GL, OM, PO and INV

Confidential, Charlotte, NC

Oracle Applications Techno Functional Consultant

Responsibilities:

  • Responsible for PA Technical and functional (Support and Change Requests/Enhancements)
  • Worked on PA concepts like Budgets, expenditures, costing, allocations, burdening, capitalization, etc.
  • Supporting SCM (Inventory and PO) modules
  • Supporting Finance (AP, GL and iExpenses) modules
  • Working on Change Requests related to Finance and SCM modules
  • Worked on Interfaces ( Requisition Interface, ASL interface, Item outbound interface ) in SCM.
  • Worked on Interfaces ( Invoice interface, Journal Interface ) in Finance
  • Worked on Discoverer Reports related to Finance modules.
  • Customized Positive Pay and ACH reports.
  • Customized Standard PO Print Report using XSL-FO changes
  • Worked on enhancements related to Project and Budget approval workflows .
  • Developed scripts to monitor the concurrent programs and sending an email to list of users upon completion with error.
  • Worked on Form personalization .
  • Responsible for production defects analysis and providing the solution. Also, tracking the production defects on day to day basis and reporting to management about the open defects.

Environment: Oracle Applications R11i (11.5.10.2) and Oracle 10g, PA, AP, AR, GL, CE, FA, iExpenses, PO, INV, EAM & HRMS

Confidential, Charlotte, NC

Oracle Applications Techno Functional Consultant

Responsibilities:

  • Involved in conversion mapping between source and Target systems for Project, Budget and Expenditure Items Conversions.
  • Involved in Use Case Preparation for Project Accounting Module to identify the gaps in the system.
  • Developed Conversions like Project, Budget and Expenditure in Project Accounting module.
  • Worked on Inbound Interfaces ( Requisitions, Purchase Orders and On Hand Quantity ) in SCM module.
  • Worked on Client Extension ( Asset Allocation method client extension in PA).
  • Worked on Labor Cost Client Extension in PA.
  • Customized Project and Budget approval workflows
  • Customized Account Generator Workflows like Requisitions, Purchase orders, Supplier Invoice and iExpenses.
  • Worked on Discoverer Reports.

Environment: Oracle Applications R11i (11.5.10.2) and Oracle 10g, PA, AP, AR, GL, CE, FA, iExpenses, PO, INV, EAM & HRMS

Confidential, Stamford, CT

Oracle Applications Technical Consultant

Responsibilities:

  • Responsible for PA Technical Objects (Project Costing and Project Billing).
  • Developed Conversions ( Project, Budget, Expenditures and Events ).
  • Worked on Interfaces (Inbound & Outbound)
  • Worked on Client Extensions ( Budget client extensions, Labor cost Client Extension ).
  • Worked on Management Reports using materialized Views .
  • Developed SQL * Plus Reports .

Environment: Oracle Applications R11i (11.5.9) and Oracle 9i, PA, AR, AP, iExpenses and OTL

We'd love your feedback!