We provide IT Staff Augmentation Services!

Oracle Application Consultant Resume Profile

Peachtree City, GA

Summary of qualifications

  • Directed, Managed, Implemented, Resolved, Trained and Supported Oracle Business Applications for multi-billion and multi-national corporations over seventeen 17 years from Oracle 10.5 to Oracle 11 series and Oracle Business Suite 12.1.2. General Ledger GL , Payables AP , Receivables AR , Fixed Asset FA , Order Management OM , Inventory INV , Purchasing PO , Cash Management, EBTAX and Sub Ledger Accounting SLA , Oracle Procure to Pay, Oracle Supply Chain / Financials in the Manufacturing Industry.
  • Over Twenty 20 years of consulting experience in Information Technology, business and financial analysis.
  • Over twenty eight 28 years experience in accounting and business with multiple set of books and financial management.
  • Industries: Information Technology, Manufacturing, Financial Services, Healthcare, Communication, Pharmaceutical, Automobile, and Retail, with International business operations.
  • IT focused, hard working, resourceful, highly analytical, achiever, goal and result driven
  • Good communication and presentation skills. Work well with others.

Employment

Confidential

Oracle Application

  • Upgrade of Oracle Business Suite EBS 12.0.6 to 12.1.2
  • Setup of Sub Ledger Accounting SLA in General Ledger Cash Management, Inventory, Account Payable, , and Account Receivable.
  • Organized and worked with team of people worldwide to setup EBTAX for different Operating Units across Multi-Org Structure.
  • Provided cross functional knowledge and information and compare Oracle EBTAX and Vertex and help both IT and User and executives make decision between the two systems.
  • Supported Oracle Accounts Payable and resolved complex issues related to Invoice and Batch processing.
  • Payment Processing such as Invoice Validation, Payment Process Requests, AP Trial Balance, Aging Report and interface issues.
  • The engagement included documenting the production processes, procedures, and interfaces, which enabled the development of a series of recommendations to stabilize and/or improve the monthly closing process process.
  • Open or filed Service Requests with Oracle to resolve problems with bugs, patches or datafix and worked with Oracle Analysts or/ and Development to resolve complex problems with the Oracle Applications E-Business Suite .
  • Download, review, tested and apply patches or datafix supplied by Oracle in different instances before applying them to Production.
  • Run and tested scripts on the backend to resolve some processing or functional issues.
  • Resolved problems or corrupted data and clean all the interfaces to improve performance.
  • Supported with different teams and track Payable transactions from across different modules and interfaces

Oracle Application Consultant

  • Responsible for managing the financials track on client engagements
  • Interviewed client personnel to determine requirements to create business process models based on the requirements
  • Gather business requirements, prepare, review and update functional and technical specifications.
  • Worked extensively to implement Oracle applications specifically related to the Procurement and Payables, Accounts Receivable, FA, iExpense, iSupplier modules.
  • Worked with a wide variety of clients and industries, from start-ups to multinational Fortune 100 companies
  • The engagement included developing business and system requirements for re-engineering the financial consolidation processes to meet the needs of the newly merged entities.
  • Identified and helped to gather data for the implementation. Setup concurrent requests for customized programs.
  • Set up and tested Oracle GL Journal Import, AP Invoice Import, PO Purchase Order Import CE Bank Statements. Used TOAD for investigating errors generated from file transfers to Oracle apps, update Apps tables.
  • Update PL/SQL procedures and packages to extract, validate and insert data into interface tables
  • Documented the production processes, procedures, and interfaces, which enabled the development of a series of recommendations to stabilize and/or improve the monthly reporting process.
  • Managed a comprehensive training and education curriculum on Oracle, which covers sales, service, technology product for new hires as well as tenured employees
  • Organize the work effort by developing project plans including tasks, deliverables, and due dates.
  • Work closely with Marketing, IT, Operations, Risk, and Legal to identify and resolve issues related to introduction of Oracle

Project Manager

  • Managed the design and implementation of Oracle Fixed Asset for Red Hat, CA.
  • Setup and implementation of Oracle Fixed Asset.
  • Gather business requirements, prepare, review and update functional and technical specifications.
  • Organized the work effort by developing project plans including tasks, deliverables, and due dates.
  • Reconciled all balances from legacy system with Oracle.
  • Documented business process for Self- Service Web Implementation.
  • Set up and tested Oracle GL Journals, Budgets ADI Journals, AR Receipts, Transactions, MRC functionality tested to ensure that it works.
  • Designed customized reports using Oracle Developer 6i. Modified and updated Customer Invoices, XML extracts
  • Prepared FSG Reports Trial Balance, Income Statement, Balance Sheet for reconciliation purposes
  • Tracked documents/deliverables for client signoff
  • Created Test scripts from functional specifications and assisted users with testing.
  • Defect resolution, raise change requests, review and revise test scripts.

Senior Consultant

  • Conducted business requirement analysis and compared clients' requirements with the available Oracle functions available with the module Oracle AP, AR, FA, GL, OM and PO .
  • Documented requirement analysis and worked with programmers on technical details.
  • Mapped and gapped requirements and specifications and advised on customization.
  • Prepared Chart of Accounts and Set of Books for Single and Multi-organization structures.
  • Prepared set-up document and carried out set-ups. Prepared module conversion design specification.
  • Prepared module test scripts and participated in CRP testing. Assisted with transfer, conversion and customization of legacy data to Oracle Database.
  • Supported Production migration. Carried out integration and performance testing.
  • Prepared training manuals and conducted presentations.
  • Project leader setup and configuration of Oracle Fixed Asset with MRC set of books for VISA International.
  • Assisted with the transfer of Fixed Asset data from different legacy systems into Oracle. Prepared and run test scripts for Fixed Asset module and the integrated systems.
  • Worked with DBA's and technical groups to apply patches and help to resolve technical issues with
  • Prepared FA documentation and trained Fixed Asset managers and heavy users.
  • Held meetings to reconcile Oracle FA balances with different legacy systems.
  • Assisted with the implementation of SSP 5.
  • Provided support and expert opinion for global implementation of Oracle 11.03 and transfer from 11.03 to 11i

Oracle Application Support Specialist

  • Provided System Administration function for different application modules OE/OM, PO, INV., AP, and AR in Oracle.
  • Assigned and modified responsibilities based on job descriptions and trained users on Oracle navigation.
  • Reviewed business processes especially in Order Entry / Order Management for improvement and efficient business operations.
  • Documented new business requirements and worked with programmers on technical details and customizations.
  • Researched processing errors and resolved them including review of bugs, patches and technical reference manuals to resolve different issues.
  • Resolved technical and procedural problems on Oracle applications and when necessary log TAR Technical Assistance Request with Oracle Corporation.
  • Collected patches from Oracle Corporation Technical Group to fix bugs in the system.
  • Resolved processing and data import errors during processing between modules.
  • Worked with DBA on system maintenance issues performance tuning, different application and concurrent managers scheduling for OE/OM.
  • Assisted different groups Sales, Accounting and Management within the organization with issues such as Order entries, scheduling, pick releases, reservations, and departures on Oracle.

Oracle Financial Consultant

  • Setup parent child relationships for ABC Activity Based Costing in GL and ADI.
  • Reviewed and analyzed accounts of subsidiaries in foreign countries.
  • Reconciled foreign subsidiaries account with the consolidated GL balances and multi-currency reconciliation.
  • Prepared custom reports on Oracle for different business segments and trained employees to use them for making business decisions.
  • Prepared monthly activity reports for different business segment with ADI.
  • Compared reports with database information. Front and back end analysis.
  • Trained staff on how to use Oracle Financial Analyzer OFA to report analyzes and create budget, forecast and run financial models.

Oracle Application Consultant

  • Evaluated initial implementation of Oracle 10.7 to resolve reporting problems.
  • Loaded missing data from the old system Oracle 10.5 into 10.7 Oracle 7/8 .
  • Assisted with the conversion from single set of book to Multi org structure.
  • Analyzed and reviewed business operations to design new chart of account GL to reflect the reporting needs of the organization.
  • Converted account balances from one set of book into different set of books.
  • Trained Executives, CFO's, and Controllers on the use of GLDI/ADI for budgeting, journals and creating reports.
  • Trained accounting staff on navigation and transactions on Oracle GL, A/P, and F/A, and providing help and assistance as help desk.
  • Demonstrated different functions on GLDI/ADI to analyze budget and actual balances.
  • Assisted with the preparation of budget data and upload them to the General Ledger with GLDI/ADI.
  • Provided classroom training that includes Presentations, Visual Aids, and Manuals for different Oracle Applications.
  • Assisted with end of the month closing and prepared actual and budget reports for printing.
  • Oracle Implementation Consultant.
  • Responsibilities as functional consultant include the following:
  • Conducted business requirement analysis. Compared clients' requirements with the available functions available with the module Oracle AP, AR, FA, GL, OE and PO .
  • Prepared Chart of Accounts and Set of Books for Single and Multi-organization structures.
  • Mapped and gapped requirements and specifications and advised on customization.
  • Prepared set-up document and carried out set-ups.
  • Prepared module conversion design specification.
  • Prepared module test scripts and participated in CRP testing.
  • Assisted with transfer, conversion and customization of legacy data to Oracle Database.
  • Supported Production migration.
  • Carried out integration and performance testing. Prepared training manuals and conducted presentations.

Hire Now