We provide IT Staff Augmentation Services!

Senior Oracle Apps Techno-functional Consultant Resume

5.00 Rating

SUMMARY

  • Over 10 years of experience as an Oracle EBS Techno - Functional Consultant.
  • Has worked for 7.5 yrs at Confidential as a Team Lead, Senior Lead Developer and Senior Programmer/Analyst. Also, has experience working as an on-site coordinator managing off shore development and resources
  • Techno/functional in AR, FA, AP, PO, Service Contracts. Extensive experience with Procure-to-Pay (P2P).
  • Expertise in Design, Development and Customization of RICE using SQL, PL/SQL, UNIX Shell scripts and SQL*Loader
  • Extensive experience in Requirements gathering, Analysis and understanding of AS IS and TO BE models, Documentation and High Level Design. Experience in preparing Functional requirement Document and Test cases.
  • Extensively worked on AIM documents like BR100, TE040, MD050, and MD070 & MD120.
  • Knowledge of data flow in the different modules of Oracle Applications. Involved in Implementation, customization of several Oracle Financial Applications, Data mapping of Oracle functionality with Business requirements, historical conversions, interfaces and customizations.
  • Worked extensively on Trading Community Architecture (TCA) and Multi-Org Environment. Knowledge of Multi organization Access control (MOAC) architecture.
  • Involved in performance tuning in Oracle using Explain plan and Tkprof.

TECHNICAL SKILLS

Oracle Apps Financials Releases (11i and R12): Worked on AP, AR, FA, PO, GL, Service Contracts, Cost Management, AOL

Oracle Tools: Forms, Reports, SQL, PL/SQL, SQL Developer, XML Publisher, Endeca

Other Products: TOAD, PVCS, Kintana, QC.

PROFESSIONAL EXPERIENCE

Confidential

Senior Oracle Apps Techno-Functional Consultant

Responsibilities:

  • Impact Analysis and Feasibility analysis of various change requests for AR,AP,FA & PO
  • Prepared design document using AIM
  • Customized Other Receipt Application report and Billing and Receipt History Report by adding new parameters in the report and displaying the report in Excel format.
  • Customized 4 and 5 Aging report according to the business requirement.
  • Worked on Payment Data Inbound Interface From API System (External system ) contain the following
  • Used the Concurrent program to execute the shell script for copying the file from the API Server directory to Oracle Application Server using secure FTP connection.
  • Used Concurrent Program to Execute the Sql*Loader scripts for transferring the Payment Data from Flat File to Staging Table.
  • Use a Concurrent program to Execute the PL/SQL Stored Procedure for validating the Data in Staging table and to mark them ready to be processed.
  • The validation program will also has the Error Logging mechanism.
  • Use a concurrent program to execute a plsql stored procedure to call standard Receipt creation API to create receipts and apply it to the Invoices.
  • Effort Estimation
  • Customized Sales Adjustment Excel Report.
  • Created report to extract Journal Entries according the date parameters.
  • Prepared MD50’s for customizing Endeca Functionalities for AR.

Environment: Oracle Applications R12- AR, AP, PO, FA, SQL, PL/SQL, XML Publisher, API

Confidential, Keene, NH

Senior Oracle Apps Techno-Functional Consultant

Responsibilities:

  • Impact Analysis and Feasibility analysis of various change requests for PO & AR
  • Prepared design document using AIM
  • Customer Conversion (Release 12) - The conversion uses the interface tables and the standard API’ to load the data into the base tables.
  • Customized PO form using custom library for unit price validation.
  • Worked on XML Publisher report to get the Reconciliation of PO’s between Oracle and different external system.
  • Customized Purchase Order layouts for Standard Purchase Orders for use with the standard program PO Output for Communication’ and creation of a Custom concurrent program for initiating the communication of PO on demand basis.
  • Worked on Vendor Interface from Oracle system to External system contain the following
  • Vendor Master Information from Oracle.
  • Vendor Site Information which corresponds to Buyer Vendor in Legacy system (Main Frame).
  • All buyer vendor Additional fields dat are defined as User Defined Attributes (UDAs) in Oracle.
  • Worked on Purchase Order Interface from Oracle to WCSS system (External system) which enabled the WCSS system to import the purchase orders from Oracle application contains the following.
  • Extract Program from Oracle - extracts PO headers, lines, shipment and distribution information.
  • File transfer protocol (as per IS standards) from source to target application WCSS (into specified target directory path).
  • Import Program in WCSS - import extracted purchase orders information to WCSS system.
  • Worked on Vendor Program data from the source system: Mainframe instance to the target system: Oracle Supplier master.
  • Effort Estimation
  • Provide weekly status updates to all stake holders
  • End User Training

Environment: Oracle Applications R12.1.3-Oracle Receivables (AR), Purchasing (PO), SQL, PL/SQL, XML Publisher, Winscp,Toad.

Confidential, Waukegan, IL

Lead Oracle Apps Techno-Functional Consultant

Responsibilities:

  • Impact Analysis and Feasibility analysis of various change requests for AR, Cost Management, Install Base and Service Contracts Modules.
  • Requirement Analysis of the new business requirements and change requests
  • Prepared design document (AIM) MD-50 for the below enhancements:
  • Customized the Shell Contract Creation process to handle scenarios where Partial qty shipment & Partial lines are shipped later (Dual & Regular Contracts) needs to be added to existing contract and to populate Payment terms on the contract header based on mapping defined.
  • Customized the Pricing Attribute functionality to derive the theme from Contract instead of Install base.
  • Personalized the Billing Pre-validation Program to derive the theme from Contract instead of Install base
  • Personalized the QA Check Validation to activate the contract if theme is present at contract level
  • Personalized the AR Interface Update Program to derive the theme from Contract and update the Trx date to the max value of transaction date
  • Personalized the AR Invoice Printing program to derive the theme from Contract level and modified the Invoice template to show Contract Group
  • Personalized the me-Receivables templates to show Contract group information and theme derivation from Contract level
  • Personalized the Update Item Cost Program to check the accounting period
  • Personalized the Update Standard Cost of Items for Used and Participation Games
  • Customized the 80/20 Template to derive the theme from Contract level
  • Unit testing and supporting business testing
  • Provide weekly updates to business and stake holders on the progress of the changes
  • Trained end users

Environment: Oracle Applications R12.1.3-Oracle Receivables (AR), iReceivables, Purchasing (PO), Service Contracts (SC), Cost Management (CM), SQL, PL/SQL, XML Publisher, Toad.

Confidential, San Jose CA

Lead Oracle Apps Techno-Functional Consultant

Responsibilities:

  • Impact Analysis and Feasibility analysis of various change requests for AR, FA, and Service Contracts Modules.
  • Gatheird requirements for various RICE elements from the Business users.
  • Requirement Analysis of the new business requirements and change requests
  • Prepared design document (AIM) MD-50 & MD-70 for various RICE elements
  • Data Conversion from multiple legacy systems
  • Estimation of the Changes and scoping the changes to Monthly or Quarterly Releases
  • Review of Technical Design Documents and Code
  • Functional set up for AR Transaction Source for Brazil Entity
  • Functional set up for AR Transaction Type for Brazil Entity.
  • End User Training
  • Unit testing and SIT of the modules dat are developed.
  • Provide weekly updates to Business and stake holders on the progress of the changes
  • Training the Team Members
  • Team Management, Task Assignment, Performance Review for team members

Environment: Oracle Applications R12 & 11i-Oracle Receivables (AR), Fixed Assets (FA), Service Contracts (SC), SQL, PL/SQL, Toad.

Confidential

Senior Oracle Apps Techno-Functional Consultant

Responsibilities:

  • Gatheird requirements for various RICE elements from the Business users and created functional technical design documents.
  • Performed functional set up for Fixed Asset module as per the Business requirement
  • Functional set up for FA Key Flexfields as per the Business requirement
  • Functional set up for FA Depreciation methods as per the Business requirement
  • Functional set up for FA Book Controls as per the Business requirement
  • Developed Custom Customer Creation FORM.
  • Developed Supplier and Customer Interface
  • Developed SQL*Loader files to load data from legacy system into the Account Receivables (AR) staging tables for importing Customer data.
  • Developed reports in AR modules using Reports 6i.
  • Developed concurrent programs and scheduled jobs as per the requirement
  • Unit testing of the modules dat are developed.
  • Review deliverables (Technical Design, Code, Unit Test Plan)

Environment: Oracle Applications R12 -Oracle Receivables (AR), Fixed Assets (FA), FORMS, Reports 6i, SQL, PL/SQL, Toad.

Confidential

Senior Oracle Apps Technical Consultant

Responsibilities:

  • Functional Design, Technical Design
  • Review deliverables (Technical Design, Code, and Unit Test Plan)
  • AR Customers Conversion (Release 12) - The conversion uses the interface tables and the standard interface program to load the data into the base tables.
  • FA Conversion (Release 12) - The conversion uses the interface tables and the standard interface program to load the data into the base tables.

Environment: Oracle Applications R12 -Oracle Receivables (AR), Fixed Assets (FA), SQL, PL/SQL, Toad.

Confidential, Piscataway NJ

Oracle Apps Techno-Functional Consultant

Responsibilities:

  • Gatheird requirements for various RICE elements from the Business Users and created functional & technical design.
  • Developed Customer Interface using TCA APIs
  • Developed a conversion program to convert fixed assets from legacy system into the Oracle Fixed Assets.
  • Developed Conversion program to import Information into Purchasing by loading data into staging tables from legacy system, validating data using PL/SQL API and then loading the data into standard table.
  • Preparation of Test Cases and carrying out Unit Testing
  • Peer Review Testing
  • Code Review
  • Preparation of Setup Documents and User Training Documents
  • End User Training
  • Patch Upgrade Testing
  • Created several Requests and Request Set to attach the PL/SQL procedures, SQL*Loader routine and Reports with Application.
  • Oracle India Localization Functional setups for the following modules were completed and tested: Payables (AP), Receivables (AR), Assets (FA), and Purchasing (PO).

Environment: Oracle Applications 11i (Applications Version 11.5.10) - Oracle Payables (AP), Oracle Receivables (AR), Fixed Assets (FA) and Purchasing (PO), Developer2000, HP-Unix, SQL (Database Version 9.2.0.6.0), TOAD, Putty, Appworx.

Confidential, Tustin CA

Oracle Apps Technical Consultant

Responsibilities:

  • Concurrent Programs: Developed new PL/SQL concurrent programs
  • Value Sets: Created new value sets which are used in Parameters for various concurrent programs
  • Developed Model BOMs using Oracle Configurator Developer tool.
  • Worked on the Design, Build and Unit Test of EDI inbound component which collects the data from inbound directory of Oracle database and performs the validations according to the functional design and update the ORACLE tables with the validated data.
  • Configuration management for different modules such as Inventory, Service Contracts and Advanced Pricing to maintain the stability of the different instances in Oracle Applications.

Environment: Oracle Applications 11i (Applications Version 11.5.9) - Inventory, Service Contracts and Advanced Pricing, Developer2000, HP-Unix, SQL (Database Version 9.2.0.6.0), TOAD

We'd love your feedback!