We provide IT Staff Augmentation Services!

Oracle Apps Financial Techno Functional Consultant Resume

Rockville-mD

SUMMARY

  • Over 7 years of experience as in Analysis, Design, Development, Testing, Implementing and upgrading Oracle Applications R12.1.3, R12.0.6, R12.0.4, 11.5.10, 11.5.9, 11.5.8.
  • Expertise in developing reusable modules in ORACLE 11g/10g, SQL, PL/SQL, Forms & Reports 10g/6i, Discoverer 10g/4i.
  • Extensive experience in Designing, Implementing, Migrating, Customizing of Account Receivables (AR),Account Payables (AP), General Ledger (GL), Order Management (OM), Inventory (INV), Oracle Purchasing (PO), Fixed Assets (FA), Trading Community Architecture (TCA) Oracle Approvals Management (AME), Application Object Library (AOL), Oracle Application Framework (OAF).
  • Experience in Implementations, which includes full - cycle implementations.
  • As well as provided support during go live critical times and post-production maintenance phase to different clients.
  • Extensive expertise in Reports, Interfaces, Conversions and Extensions (RICE).
  • Good working experience on Procure to Pay (P2P), Order to Cash (O2C) business flows.
  • Expertise in Customizing Oracle reports and developing new reports on Oracle Report 6i/10g and Discoverer 4i /10g and XML Publisher (BI Publisher).
  • Experienced in Customizing Oracle Forms with Forms Personalization, Custom.pll on Forms 10g/6i.
  • Proficient in customizing Oracle Workflow.
  • Well versed with client server environment and tools like Developer/2000, SQL*Loader, SQL* Navigator, SQL Developer and TOAD.
  • Through in preparing Technical specifications (MD070), Functional Specification (MD050), Conversion Mapping Documents (CV050), user training manuals, test procedures document preparation.
  • Adept in PL/SQL Procedures, Functions, Packages, Data Base Triggers and UNIX shell scripts.
  • Experienced in interacting with users, fixed teh bugs, developed test plans and provided daily production support.
  • Experience in debugging, testing and deploying teh applications designed and developed interactive GUI screens and reports using oracle forms/reports.
  • Adroit with analytical skills, strong verbal and written communication skills.

TECHNICAL SKILLS

Oracle Applications: Oracle Applications 11.5.10, 11.5.8, 11.5.9, R12.0.6, R 12.0.4, R12.1.3

Oracle ERP Financials: Accounts Payables (AP), Account Receivables (AR), General Ledger (GL), Cash Management (CM), Fixed Assets(FA), TCA, iExpenses, PaymentsOracle ERP Manufacturing Inventory (INV), Purchase Order (PO), Order Entry/Order Management (OM), Shipping (WSH), Advanced Pricing

Operating Systems: MS-DOS, UNIX, Linux, WINDOWS NT/XP/2000/98

Languages: SQL, PL/SQL, Java, C, C++

RDBMS: Oracle 11g, 10g, 9i

Development Tools: Developer 2000, XML Publisher, Oracle Forms 10g/6i, Reports 10g/6i Discoverer 10g/4i, Reports, Work Flow Builder 2.6.3

Database Tools: SQL*PLUS, SQL*Loader, TOAD, Sql Developer

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

PROFESSIONAL EXPERIENCE

Confidential, Rockville-MD

Oracle Apps Financial Techno functional Consultant

Responsibilities:

  • Defined teh Technical specifications for setups and reports and transformed teh specifications to teh Technical Team.
  • Defined teh functional specs for modification of coding in customizations of interfaces, reports and processes to run. Designed, documented and developed staging tables, conversion routines, Custom PL/SQL API’s for converting Open AP Invoices, Suppliers, Supplier Sites, Supplier Contacts, Customers using TCA, Open AR Invoices, Open Purchase, Open Requisition from legacy system (Mainframe) to Oracle Applications.
  • Performed Root Cause Analysis (RCA) for various repetitive problems and provided suggestions for speedy problem resolution.
  • Customized teh PO Requisition Account Generator Workflow based on teh Business Requirement.
  • Customized teh Oracle Purchase Order form using Forms Personalization.
  • Developed various Custom reports including AR Invoice Print and Customer balance summary reports.
  • Customized BI Publisher report for AR invoice in teh client specified layout.
  • Worked with Administrative and Desktop Edition of Oracle Discoverer 10g.
  • Developed various Custom reports, Customized existing reports according to teh functional specifications including Uninvoiced Receipt Report, Invoice on Hold Report, Invoice Aging Report using Oracle Reports 10g
  • Maintained teh regular interaction with teh Client, End users, Technical team, participated in teh meetings on regular basis and followed up teh progress of work.
  • Trained super users, users and Preparing User Manuals for teh Different levels of Management hierarchy.
  • Did daily production support.

Environment: Oracle Applications (R12.1.3), AP, AR, PO, GL, FA, CM, OM, INV, TCA, Work Flow, Oracle Approvals Management (AME), Oracle 11g, Forms 10i, Reports 10i, Discoverer 10g, XML publisher, SQL*Loader, PL/SQL developer, UNIX.

Confidential, TX

Oracle Apps Financial Techno functional Consultant

Responsibilities:

  • Responsible for Analyzing, Designing, Development and Implementation of various software’s systems and Applications, researching delivering and enhancement in HR/AP/AR/OM/INV applications.
  • Designed and implemented teh plan for upgraded from 12.0.6 to 12.1.3.
  • Involved in setups for Approvals and Approval Assignments for PO Approvals.
  • Involved in setups for Payment Methods, Payment Documents, Bank, Bank Accounts, and Payment Process Profile. Receipt Class, Receipt Methods and setups for Items, Items Categories.
  • Developed programs for creating of new items and update new items using Items Interface.
  • Developed an interface program to load data from custom tables to interface tables and tan created journals into Oracle General Ledger as per business requirements.
  • Responsible for providing production support for Account Receivables (AR) and Account payables (AP).
  • Designed, documented and developed interface to Oracle Cash management Interface.
  • Designed, documented and developed for running teh Open Interface to import data from OM interface tables into teh base tables and Auto lockbox Interface in AR.
  • Introduced and documented teh process for Bank Account transfer facility in oracle Cash Management.
  • Developed teh Shell Script Program to move teh files between different Servers.
  • Did trouble shoot of teh Exceptions in Auto invoice Interface.
  • Responsible for training Users and designed training documents for users.
  • Customized teh Invoice Report template using Bill Presentment Architecture (BPA).
  • Customized teh PO Requisition Workflow based on teh Business Requirement.
  • Did teh implementation of Invoice Approval Work flow using AME.
  • Resolved Problems using related technologies, defining and determining business and system requirements, coding, reviewing, repairing, testing, and modifying software programs to ensure technical accuracy.
  • Designed and developed complex Discoverer reports by communicating and interpreting end-user business requirements.
  • Registered customized Oracle reports and XML Publisher (BI Publisher) reports.
  • Developed Pl/sql packages, procedures in 11g.
  • Provided daily production support.

Environment: Oracle Applications (R12.0.6), AP, AR, PO, GL, FA, CM, OM, INV, TCA, Workflow, Oracle Approvals Management (AME), Oracle 11g, Forms 10i, Reports 10i, Discoverer 10g, XML publisher, SQL*Loader, PL/SQL developer, UNIX.

Confidential, Milwaukee, WI

Oracle Apps Financial Techno functional Consultant

Responsibilities:

  • Involved In teh Upgrade of Oracle Applications from 11. .0.4.
  • Designed and developed an interface using Pl/Sql package to create Supplier/Supplier sites from legacy systems.
  • Designed and developed teh Reconciliation process for GL module.
  • Written an API for Converting teh Invoice Payments (AP) and was able to convert all teh Historical Invoice Payment History into Production.
  • Written an Interface for Account Payables (AP) Invoice Upload, which creates invoices from a CSV file.
  • Implemented PO Approval workflow using AME (Approvals Management Engine).
  • Extensively involved in teh following areas: Order-to-cash and Procure to Pay.
  • Customized Account Payables (AP) reports like Payables Accounting Entries Report, Accounts Payable Trial Balance Report, Payables Account Analysis Report, Payables Accounting Entries Report, Payables Accounting Process Report, Period Close Exceptions Report, Posted Invoice Register, Posted Payment Register, and Unaccounted Transactions Report.
  • Developed parameterized reports using Discoverer Plus in Order Management.
  • Designed new templates and enhanced teh existing templates using BI Publisher.
  • Performed system administration functions such as creation of users, Responsibilities and Menus and Functions.
  • Involved in Unit testing and wrote test cases for QA, also involved in UAT (User Acceptance Test).
  • Involved in bug fixing reported from QA and End users.
  • Provided training to business user community for Post- Production support issues & daily and month-end closing of accounting periods for GL.

Environment: Oracle Applications (R12.0.4), AP, AR, PO, GL, FA, CM, OM, INV, TCA, Work Flow, Oracle Approvals Management (AME), Oracle 10g, Forms 10i, Reports 10i, Discoverer 10g, XML publisher, SQL*Loader, PL/SQL developer, UNIX.

Confidential, Atlanta, GA

Oracle Apps Financial Techno functional Consultant

Responsibilities:

  • Did teh Implementation of Oracle Financials 11.5.10, Purchasing, Account Payables, Accounts Receivables, General Ledger.
  • Designed customizations, interface/conversion mapping, pre production testing, and related documentation.
  • Responsible for converting all teh Historical Purchase Order Receipts using Receiving Open Interface into Production.
  • Responsible for converting all teh Historical Invoices using Payables Open Interface Import into Production.
  • Developed an interface program to load data from custom tables to interface tables and tan created journals into Oracle General Ledger as per business requirements.
  • Customized teh PO Requisition Account Generator workflow as per teh requirement using Oracle Workflow Builder.
  • Customized reports in General ledger (GL) GL Audit report, GL Review report and GL Exception report Using XML Publisher/BI Publisher
  • Customized various Oracle Payable Reports by adding new fields as per teh business requirements.
  • Created reports from teh scratch as per user’s requirements in AP and AR.
  • Customized Reports in General Ledger (GL) such as -Trial Balance Reports, to keep track of inter company revenues.

Environment: Oracle Applications (11.5.10), AP, AR, PO, GL, FA, CM, OM, INV, TCA, Work Flow, Oracle Approvals Management (AME), Oracle 10g, Forms 6i, Reports 6i, Discoverer 4i, XML publisher, SQL*Loader, PL/SQL developer.

Confidential

Oracle Apps Financial Techno functional Consultant

Responsibilities:

  • Analyzed requirements of teh client for various legacy applications dat 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 teh standard Auto Invoice Interface to import teh customer invoices.
  • Prepared high-level and low-level designs for bridging and migrating data to AP, AR modules.
  • Imported teh journal entries from legacy system to Oracle General Ledger using SQL*Loader, PL/SQL package and populated teh data into teh GL interface.
  • Customized teh 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.
  • Customized workflow PO Account Generator Workflow based on teh Business Need.
  • Used CUSTOM.pll to implement teh 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 teh guidelines of MD70 and MD50.

Environment: Oracle Applications (11.5.9), AP, AR, PO, GL, FA, CM, OM, INV, TCA, Work Flow, Oracle Approvals Management (AME), Oracle 10g, Forms 6i, Reports 6i, Discoverer 4i, XML publisher, SQL*Loader, PL/SQL developer, UNIX

Confidential

Oracle Apps Financial Techno functional Consultant

Responsibilities:

  • Created an interface to import Order Management data from teh legacy system to Oracle Order Management. Used SQL* Plus and PL/SQL to load and validate teh data.
  • Invoked standard API’s within custom packages for creating and updating Customer, Sites and Contacts. Responsible for converting teh entire Historical Purchase Orders (PO) using Import standard Purchase Orders into Production.
  • Responsible for converting teh entire Historical Purchase Orders (PO) using Import standard Purchase Orders into Production.
  • Involved in Requirements Analysis, Design, Data Mapping and Client Interaction.
  • Mapping, Design and Development of Invoice Interface from Legacy Entities to Oracle Payables.
  • Designed and Implemented Auto Lockbox to load receipts into Oracle Receivables.
  • Designed and developed PL/SQL packages to validate and import invoices into Oracle Receivables.
  • Worked on Purchase Open interface and receivables interface by loading data into staging tables from teh legacy system.
  • Wrote PL/SQL code to validate and dump teh data into interface tables. Tan running import programs to load data from interface tables into base tables.
  • Developed new forms using TEMPLATE.fmb and customized existing forms in teh OM module according to teh client’s requirements.
  • Created descriptive flex fields for standard forms to allow users populate extra information.
  • Involved in entering transactions like Regular Orders and Inter Company Invoicing.
  • Developed Discoverer reports for Accounts Payables and Accounts Receivables.
  • Customized teh Journal Entries Report in GL which is used to review teh details dat make up teh general ledger journal entries.
  • Customization of Oracle Purchase requisition account generator workflow.
  • Designed and Implemented PO approval workflows and configured approvals using Oracle Approvals Management.

Environment: Oracle Applications 11.5.10 (INV, OM, PO, AP, AR, TCA), Work Flow, AME, Oracle 9i, Reports 6i, Forms 6i, XML Publisher, PL/SQL, SQL*Loader, Toad, UNIX.

Hire Now