We provide IT Staff Augmentation Services!

Oracle Techno-functional Consultant Resume

Aliso Viejo, CaliforniA

SUMMARY:

  • Over 8 year s of experience in the software industry and experience in Analysis, Design, Development, Testing, Implementation of Software Applications and Technical aspects of Oracle Applications E - Business Suite (SCM, Financial) Version 9i,11i/11.0.3/R12.
  • 5+ years of extensive experience working as Oracle Applications Techno Functional consultant in modules PO, OM, INV, BOM, AR, Confidential .
  • 6+ years of Strong experience AOL, Oracle D2k, PL/SQL, SQL, SQL*Plus, Oracle Forms 6i/10g, Oracle Reports 6i/10g, Oracle10g/9i/8i/7.3 under Windows 2000/NT/98/95/XP.
  • Good functional knowledge in Order to Cash cycle and Procure to Pay Cycle.
  • Good experience in Implementations and Upgrade Projects.
  • Knowledge and hands on experience of web service modules like iStore, iPayment and iProcurement.
  • Extensive experience in writing conversion scripts for migrating legacy data into Oracle Applications using Oracle Open Interface and Oracle API’s.
  • Extensive experience in Oracle Stored Procedures, Packages, Functions & Triggers using Toad as development tools.
  • Worked extensively on XML Publisher and BI Publisher.
  • Very good hands on experience with Oracle OAF10g
  • Project exposure in OAF personalization.
  • Extensive experience in registering Concurrent Programs, Form Functions, Reports, Applications, Creating Users and Defining Profile values by using Application Object Library (AOL), System Administration.
  • Extensive experience in customization of workflows and in fine-tuning code for better performance.
  • Created and maintained Database Objects like Tables, Views, Indexes, Constraints, Sequence, Synonyms, Database link, Roles and privileges.
  • Ability to learn and adapt to new technologies, good team player in dynamic work group environments and also self-motivated to work independently with excellent communication skills

PROFESSIONAL EXPERIENCE:

Oracle Techno-Functional Consultant

Confidential, Aliso Viejo, California

Responsibilities:

  • Analyzing the requirements.
  • Prepare MD 70 for the SRS
  • Understanding of EBS architecture and underlying tables / columns in Oracle EBS R12.1.3.
  • Working on P2P module and worked in one complex PO conversion.
  • Identify the gaps in 11i and make changes to R12.
  • Working on RICE components.
  • Developed complex shell script program calling PL SQL from shell scripts
  • Helped the team in solving critical issues.

Environment: Oracle applications EBS 11i (11.5.10), R12, GL, PL/SQL, SQL*Plus, TOAD, Developer 2000(Reports 6i/10g and Forms 6i/10g), Oracle Designer 6i/10g, OAF, SQL Developer, XML Publisher, BI Publisher, SQL*Loader, Windows XP, JAVA.

Oracle Techno-Functional Consultant

Confidential, Ann Arbor, MI

Responsibilities:

  • Intercompany Accounting and Netting - A solution to handle Treasury transactions between multiple business units of Client
  • Worked with buyers, commodity managers, other associates, and suppliers as needed to resolve issues. Processed and completed payment batches
  • Completed voids, reissues, and stop payments as needed.
  • Worked on analysis and resolution of goods received not invoiced accounts.
  • Worked on the completion of account reconciliations
  • Analyzes and reconciles various AP general ledger (GL) liability accounts: Vendor liability, Goods Receipt/Invoice Receipt (GR/IR) clearing, Sales & Use Tax, Garnishment, etc.
  • Analyzes and prepares monthly past due blocked PO invoice report for distribution with roll-up to officer levels for different Line of Business.
  • Prepares monthly cost repost charge-back accounting entries and reporting for AP Manager and Payment Services Director.
  • Analyzes and runs ad-hoc reports for clients and AP management as needed.
  • User Access Management - An approval based automated tool to implement user account creation and role assignment
  • SOX - An audit based system to grant/revoke oracle system access to users
  • CAM, RM - Order to Cash solution for Yahoo to capture Customer and Order information, bill customers based on the sales and recognize revenue for Yahoo iExpense and iProcurement approval process and self-service screen customizations
  • Data loader and interface programs in AR and Treasury modules
  • Design, Develop, Review, Deploy RICE(Reports, Interfaces, Conversions, Extensions, Forms and Workflow) components and AOL objects as part issue fix and enhancement requests
  • Testing rdf /xml reports in client’s testing environment(Development, QA, Production)
  • XML reports on OM, AR, OPM and AP
  • Discoverer reports in development.
  • Workflow developments for OPM module
  • Developed Interfaces for OPM module
  • Handling Procurement to Pay process for Goods
  • Processing services
  • Data conversion from 11.5.10 production to R12
  • Modification of the P2P Process flow to replacing of PR Line in PO, which involved iProcurement requisitions OAF page, AME Change, Workflow Change
  • Engaged in Creation of new accounting rules to defer revenue, assigning the new accounting rule to existing transaction types

Environment: Oracle Applications 12.1.3, AP, iProcurement,OA Framework, AR Interface to GL from HSR, Automation of Receipts and Remittances, Oracle Collections, Oracle iPayment, OM, Java, SQL, PL/SQL, Discoverer, Workflow, Forms, Reports

Oracle Techno-Functional Consultant

Confidential, Atlanta, GA

Responsibilities:

  • Upgrade Development and Production support for Oracle E-Business Suite 12.1.3 version of Master Data Management and iStore modules using SQLPLUS, shell scripting, Oracle Components for Java (OC4J), Oracle Application Server,, Oracle Applications Framework, JDeveloper, Application Development Framework and BPEL Processes with Oracle Workflow
  • Customize standard Unmapped Subsidiary Accounts report using Oracle Reports as per the user requirements for General Ledger Consolidation purposes
  • Participated in R12 upgrade project - upgrading from 11.5.10.2 to R 12.1.3.
  • Customized forms to make changes related to R12 for MOAC changes and tables changes
  • Developed Custom Order Entry screen for user convenience and developed an interface to import these sales orders into OM
  • Developed major enhancements required for business process in Order to Cash and Procure-to-Pay cycles
  • Redeveloped various custom components for R12 upgrade which invoices PL/SQL packages, views, Triggers, Value sets, AOL componentsom
  • Involved in developing custom XML/BI Publisher reports like Open Sales Orders Summary, Purchase Order Summary
  • Worked on the technical design and implementation of custom CFS OM Blood Pricing application and the design of the eProgesa (Third party System) to CFS (Oracle e-Business Suite) interface
  • Involved in AP Check Printing Setups
  • Customized Order Management Header and Line workflows to meet business requirements
  • Developed forms using ZOOM functionality that pops up appropriate form based on the item context. Modified CUSTOM.PLL to activate zoom
  • Developed Shipping Report to show data from Install Base and Service Contracts data using Discoverer
  • Involved in creating Discoverer reports to generate Purchase Order reports
  • Worked on different interfaces like importing AR invoices from one of third party legacy system which validates and submits a standard interface program
  • Developed custom AR INTERFACE program which validates and modifies data in the interface tables. This program is designed to update Sales order based data in AR interface tables. Validations and changes based on different custom tables and forms
  • Experienced in project costing including Load project costs from sub ledger and Capture costs in atimely manner.
  • Implemented Work in Process for Discrete manufacturing (ODM) that interfaced with MES software
  • Developed an outbound Interface to export GL data to third party systems, also inbound Interfaces to import into GL by populating GL INTERFACE table
  • Designed and developed a program to convert Bill Rate Schedules of Project Accounting
  • Developed the programs for to convert projects, tasks, budgets, Agreement and funding, event and cost as a part of Project Accountings
  • Involved in setting up punch out stores in I-Procurement
  • Developed and customized various custom reports like PO Requisition Details Report, Open PO Report by Buyer, Open Receipts Report and PO Unsourced Requisitions Report in Reports 10g builder
  • Customized the program PRC-Generate Cost Accounting Events for Oracle Projects Integration
  • Customized the SLA Accounting Events Page with OAF personalization and Extensions
  • Quote creation using Oracle Quoting module
  • Selecting and Sizing customer flow meter products using a custom J2EE based web application called ‘GPSS’ deployed in Oracle APPS
  • Configuring the selected product using Oracle Configurator

Environment: Oracle Applications 12.1.3, REVPRO, AP, AR, GL, SLA,OA Framework, Core Java and Web Services, JSP, Servlet

Oracle Techno-Functional Consultant

Confidential, Chicago, IL

Responsibilities:

  • Analysis of Oracle E-Business Suite 11.5.10 existing systems to assess the cost and effort required for the upgrade to Oracle E-Business Suite 12.1.3 system for OLM modules, iProcurement, ESS
  • Responsible for gathering details of existing 11.5.10 systems from client
  • Upgrade system in various instances by upgrading the custom forms, reports and custom pl/sql programs/processes.
  • Involved in testing of the 11.5.10.2 upgrade system in various instances
  • Preparation of the High Customization listing documents following HCLT processes
  • Technical Assessment and Migration Plan
  • Support for AP, AR, GL, FA modules
  • Resolving day to day issues based on tickets or calls
  • Modified XML Publisher report for FA Asset listing Report (FA) to add few columns
  • Developed Conversion program for Importing Purchase Order
  • Worked on P2P Process
  • Modified Custom Foreign tax, US Tax and Tax settlement program for inbound interface
  • Logged, viewed, accessed, monitored, followed up, and closed Service Requests (SR) online - Oracle MetaLink
  • Developed Technical Documents (MD70) for various RICE objects as per RICE(Reports, Interfaces, Conversions, Extensions, Forms and Workflow) components design
  • Experience includes coding Interface Programs using PL/SQL procedures to load data into the interface tables from legacy systems
  • Involved in uploading historical GL Balances through conversion program for various entities
  • Worked on SQL*Loader scripts to migrate the data from the text files, Spreadsheet etc. and populated the intermediate tables
  • The PO approval hierarchy assignment as well as providing hierarchy details as per client request
  • Provided report that would show the remaining quantity details as of date for any PO as per
  • Design customizations to import invoices and customers into Accounts Receivable, receipts into Accounts Receivables
  • New Supplier creation and assigning bank to the corresponding supplier at site level.
  • Automation process for supplier Invoice upload
  • Customized oracle standard cheque print report to print cheque as per Indian rupee format and fields included as per client requirement
  • Bill Run process
  • Journal import and AR Period closure
  • Automated the process for assigning sales person to the corresponding customer site level
  • Monitoring and support of daily run customer interface

Environment: Oracle applicationsR11, R12, Finance modules (GL, AP, AR, CM, FA, PO, INV, OM), Goal Management, Performance Management, Compensation Workbench, JDeveloper, Install Base (IB), Service Contracts (SC), Field Services (FS), Oracle Quoting and Inventory (INV) modules and uploading the data to Accounts Receivables (AR), Order Management (OM).

Oracle Applications Technical Consultant

Confidential, Minneapolis, MN

Responsibilities:

  • Involved in building interfaces between Oracle Accounts Payables (AP), order management (OM), Purchasing (PO), Accounts Receivables (AR) and Third party systems and provided functional input
  • Design and Developed OM Sales Order Interface to bring in Sales orders on a regular basis from the legacy system.
  • Proficient in Confidential to create customers in Oracle Receivables
  • Designed, documented and developed staging tables, conversion routines, Custom PL/SQL API’s for converting Inventory Items, AR Invoices and Receipts, Customers using Confidential, Open Purchase Orders, Open Requisitions, AP Open Invoices, Suppliers, Supplier Sites, and Supplier Contacts from legacy system to Oracle Applications
  • Worked on Order Import to convert all open orders from Legacy to Oracle
  • Worked on customization on Receivable interface as per the client requirement to split the freight lines into multiple freight lines
  • Setup Tax Codes, Expenditure Type, Payable Options, Payables/ Purchasing Lookups, Signing Limits, Employee as Suppliers, Expense Report templates, Payment terms, Banks, Bank Accounts, Payables Payment Documents, Automatic Payment Programs, Payment Formats, Flex Fields
  • Customized Sales Order form and was also involved in developing new form to display Delivery Information in Oracle Order Management
  • Worked on iPayments and developed an interface from AP to bank to transmit payment file for various payments
  • Designed and developed process to calculate Average cost per sub-inventory and update the information on transactions
  • Customized many reports like Pick Slip, packing Slip, Mailing Label for shipping and Credit Order Detail, Orders by Item, Order Detail & Summary Reports, Payments Overdue Report, Orders for Suspense Account, and Sales Quote for Order Management and Credit memo Account verification report, AR Revenue extract report for AR and also created new reports as per client requests.
  • Designed and developed Confidential Discoverer reports

Environment: Oracle Applications Release R12 / 11i / 11.5.10, FA, AP, PO, GL, Oracle 10g, SQL, SQL*PLUS, SQL*Loader, UTL Scripts, TOAD, PL/SQL, Shell Scripting, SDLC Source Control, Discoverer10g

Oracle Applications Technical Consultant

Confidential

Responsibilities:

  • Business Process and User Requirement analysis and preparation of specification document.
  • Mapping the requirements in financials
  • Defining Suppliers, Supplier Sites, Supplier Bank Account Assignment, Payables Batch Source, Payment Terms and distribution Sets
  • Defining Journal Sources, Categories and Document Sequences for each journal Category. Defining Security Rules, Cross-validation rules, Account-Combinations
  • Involved with cycles like Procure to Pay (P2P) and Order to Cash (O2C) functionally and then technically
  • Unit Test Cases for Testing of above modules and moving the same to production environment
  • Creating Users, various Responsibilities and assigned to respective users, created Menus, Request Groups, Data Groups, and Request-set. Also created Value-set, DFF’s and changing Profile Option as per requirement
  • Resolving the issues on PO components like Requisitions, Purchase Orders and Receiving
  • Similarly, resolving the issues on AP components like Invoices, Payments, and Banks & Suppliers
  • Month end Closing Process (P2P Cycle)
  • Involved with developing Items data migration, AR Invoices and AP invoices data migration and Lot Migration
  • Worked on Item Interface with assigning Item categories, On-Hand Quantity Conversions, PO Requisitions Inbound Interface, Purchase Order Inbound Interface, Customer Interface, AP Invoice Interface, GL Journal Import Interface and Supplier, sites and supplier contacts conversion
  • Customized sales order form to book an order only on weekdays and Customized PO form to do not generate a PO if the price is less than some amount
  • Customized Workflow to apply the holds whenever order is booked for particular customer and Customized Workflow to send the notification whenever order is booked for particular customer. Customized AP Remittance workflow in Payables
  • Involved with Unit testing and system integration testing during testing phase. Followed AIM methodology to build TE20, TE40, CV 60, MD120, MD 70 documents

Environment: Oracle Applications Financial Suite R11.5.10 (AP, GL, AR, OM, PO, INV, HR, CM) Oracle database 10g. XML Publisher, Discoverer Reports, Oracle Alerts and UNIX

Oracle Applications Technical Consultant

Confidential

Responsibilities:

  • Involved in handling various assignments in development/maintenance/support role in an Oracle Financials 11i implementation
  • Involved in transferring the Suppliers, Products & Services, Business Classifications and Supplier Users in to the Production instance
  • Involved in migrating the data from the legacy systems to oracle for Parties, Customers, AP Invoices, AR Invoices, Install Base, OKS Contracts, Purchase Orders, GL Periods, Quotes, Projects, Items and Bill of Materials
  • Developed custom workflows in different modules like PO approval, AP Invoices
  • Developed a report for MHM Commission Approval for sales representatives
  • Setting up employees and roles in the Oracle Self Service module
  • Created interfaces for BOM, Routing, WIP and Items
  • Involved in functional setups of OM,PO, PA, INV, BOM, WIP and Routing
  • Analyzed and Designed the DB schema using Oracle 9i database to include Header, Lines and other table in all the modules
  • Creating Forms and Reports to accommodate the business functionality of the MHM
  • Prepare high level design documents, DLD and User manuals
  • Composing and testing the business rules for the components designed
  • Involved in the personal and technical training activities
  • Personalization of components using Oracle Forms Personalization and OAF
  • Provided support for conversions Customers, AR Invoices, Vendors, Items, Categories, Purchase Orders, Requisitions, iSupplier User, Supplier Products & Services, GL Account details, GL Budget details and interfaces ACH Payments, UMS, Maximus, CIS/Enquesta, Lockbox in different instances like CRP5, SIT, UAT and Production
  • Developed and Customized Customer Statement Printing, Dunning Letter Printing using XML Publisher
  • Involved in various activities like Technical Design, Unit Test Design, Development, Testing and Release Pack and participated in Code walkthrough sessions, also involved in reviewing the technical Design Documents, Test Cases, Build and Release Pack reviews. And also involved in coordinating with offshore team in daily status calls
  • Involved in supporting the delivered conversions and Interface objects. Involved in meetings with users and onsite team
  • Involved in importing Open PO Closed Invoices and Payments from the legacy system to Oracle Payables system. Open PO Closed Invoices Conversion is the process to create Invoices (matched to open POs) and related Payments for imported invoices
  • Developed various outbound interfaces for HRMS Module like AFLAC awfnd CIGNA
  • Involved in importing Invoices from legacy system UMS to 11.5.10 Oracle Payables system using Payables Open Interface import Program

Environment: Oracle Database 8i, Oracle Forms and Reports and XML Publisher, OAF, Java, JSP, XML, XSL, OAS, Oracle 10g, Oracle AQ, Workflow Builder, TOAD. SQL, PL/SQL, Reports 6i, TOAD, SQL*LOADER, Designer 2000.

Oracle Applications Technical Consultant

Confidential

Responsibilities:

  • Design and develop various RICE (Reports, Interfaces, Conversions, Extensions, Forms and Workflow) components part of critical Oracle iProcurement Implementation
  • Development of Oracle SOAP API for validating the external data from a web service
  • Involved various other customizations using PLSQL, forms, reports development which are part of Direct Fulfillment.
  • Created Custom solutions around the Receiving Interface and Requisitions of the iProcurement Implementation using Oracle Application Framework
  • Developed BI/XML publisher reports/XML Reporting in DF & Purchasing Modules
  • Application maintenance. Provided fixes to production issues under support
  • Analyzed and Designed the DB schema using Oracle database to include Header, Lines and Approvers table in all the modules Inventory, Order Management and Purchasing
  • Creating the Return Orders and validating the data for testing purposed in OM
  • Design of the components with help of MD 70 design document
  • Design and Develop the complex SQL Queries, Reports, Oracle & Java API’s
  • Developed Confidential Queries and Reports for Users to check status at various levels
  • Interacting with the business team to provide the best possible technical solution
  • Providing Unit Test Results for the components designed and developed

Environment: Oracle E-Business Suite R11i (11.5.10), Solaris OS(Unix based), Windows XP, PL/SQL, SHELL SCRIPT, Java/J2ee, Oracle 6i Forms and Reports, Oracle Discoverer, Oracle 9i, Workflow Builder, TOAD, Oracle Application Framework, Oracle Application Server, Oracle 11i Quoting Module.

Hire Now