Oracle Financials Functional Consultant Resume
0/5 (Submit Your Rating)
Miamisburg, OH
SUMMARY:
- Over 5 years of experience as Oracle Financials Functional Consultant with hands on implementation and support projects in Oracle Applications EBS 11i, R12, Fusion Applications Cloud 10, 11 versions. Extensively Worked on Oracle Modules AP, AR, FAH, CE, GL, SLA and PO. Worked in Large Projects with P2P and O2C Implementations.
- In - depth technical and functional knowledge of Oracle Applications 11i, R12 and Fusion applications. Implemented Multiple Large Scale R12 Upgrade and Oracle Fusion cloud Projects as a lead Functional Resource. Involved in various key projects such as P2P (Procure to Pay), O2C (Order to Cash) Worked with ARIBA supplier Network methods and integrated with Oracle E-business Suite. Integrated ASN with Oracle Apps for daily P2P transactions.
- Worked across various modules of Oracle Applications including Sub-Ledger Accounting (SLA) in R12 and fusion, General Ledger (GL), Purchasing (PO), Account Payables (AP), Projects Accounting (PA) Account Receivables (AR), iReceivables, Billing and Revenue Management(BRM) Trading Community Architecture (TCA), Order Management (OM), Application Object Library (AOL), System Administration (Sys. Admin), Fusion Accounting Hub (FAH)
- Experience in Application Implementation Methodology, gathering business requirement, performing analysis, building RICE (Report, Interface, Conversion and Extension), configuration and setup of modules, testing, Developing, Enhancements and production support.
- Developed new application objects, Customization of the objects in Oracle Applications11i and R12, worked in Oracle Front-End programming and Back-End development using tools like SQL*Loader, PL/SQL, SQL*Plus, Oracle Developer 2000 (D2K) Oracle Forms 6i, Oracle Reports 6i, Oracle Discoverer, XML Publisher/BI Publisher
- Have extensive knowledge and implementation experience in Oracle Fusion Applications, coexistence Application functionalities, Fusion Accounting Hub.
- Experience in Oracle R12 Applications and Features such as Multi Org Access Control(MOAC) Implementation, Sub Ledger Accounting(SLA), GL features and TCA architecture
- Documented the R12 Upgrade gap analysis, R12 New functionalities, Proof of Concepts, Demo’s to the Client. Involved in R12 Project Support, Production Support, Customizations, Service Request (SR) with Oracle, Patch Analysis, Patch Application Testing, Documented the Patch Impact and Patch versions functionality analysis. Daily Transaction Activities, Meeting with Business Users and Finance Managers
TECHNICAL SKILLS:
Technology and Tools: Oracle Fusion Applications, purchasing (PO), Projects (PA), Payables (AP) Payments (IBY), Order Management (OM), Oracle Billing and Revenue Management (Oracle BRM), Receivables (AR) (Customers, Transactions, Revenues, Accounting, Lock Boxes), Advance Collections, SLA, Cash Management (CE), Fixed Assets (FA), General Ledger GL, SYSADMIN, AOL, MOAC, AME, Web ADI, OTBI, FRS, Smart View
PROFESSIONAL EXPERIENCE:
Confidential, Miamisburg, OH
Responsibilities:
- Defined Event model, process categories and Account event class options.
- Defined Source Assignments and Accounting attribute assignments.
- Defined Account Derivation Rules (ADR) for accounting of transactions as per client requirement.
- Defined the supporting s and tested in various environments.
- Gathered requirement and prepared the necessary documents.
- Worked with SOA team integration part from legacy to FAH.
- Prepared BR100, MD50 and TE40 documents.
- Worked with technical team for creation of custom tables and custom views.
- Worked with oracle support to resolve the issues in implementation process.
- Worked on Cost Management with integration to Financials and Supply Chain modules.
- Prepared process flow document to the users with step by step process.
- Performed CRP1, CRP2 and UAT testing with business and get the signoff
- Requirement gathering with the business owner
- Taxation requirements and resolved couple of issues
- Understanding the existing functionality
- Developing new interface and coordinating with technical people
- Explaining functionality to the technical team
- Prepared couple of FAH POC’s and test scripts documents
- Tested all functionalities in financial modules.
- Troubleshooting Journal sub ledger transfer and journal import issues
- Involved in QA CAB call for migration of customizations and changes.
- Configured setups in TCA for Supplier Life Cycle Management.
- Worked on TCA Data model as a team member.
- Developed and tested supplier import program and given support to technical consultants.
- Developed integration of supplier interface program for AGILE PLM with middleware technologies like SOA.
- Identified Supplier address update issue in Oracle Apps which is in development phase in Oracle Apps.
- Identified data load issues in interface tables and resolved the issues.
- Developed customers merge process in Oracle TCA for merging of duplicate records.
- Loaded successfully data for EAM Suppliers and developed chain sys templates for data load.
- Developed TCA Common service with GE Stores, Web Services UI, SFDC for create, update customer party, account, contact and address details.
- Developed TCA Common service with GEStore, Web Commerce, SFDC to manage merge party functions.
- Mapped TCA fields with others legacy and third-party systems like SFDC, AGILE, GE Store.
Confidential, Long Island NY
Responsibilities:
- Requirement gathering with the business owner
- Understanding the existing functionality
- Configure Fusion Functional Setup Manager
- Define Applications Configurations
- Configuring GL - Value sets, COA Structure and Instance, Accounting Hierarchy, Create Account Combination, Define Cross-validation Rules, Calendar, Currencies, Conversion Rates Type, Daily Rates, Ledger, Ledger Options, Legal Entities and Balancing Segments Assignments, Complete the Ledger Configuration, Data Access Set Security, Allocation Rule an Account Group.
- Configuring Business Units Data Sets
- Configuring Fusion Sub Ledger Accounting
- Configuring Fusion Payables - Supplier Model, Data Role, Create Payment Term, manage invoice options and payment options
- Configuring fusion payments - payables - Payments Activities, Payment System, Payments and submitting a payment process request.
- Configuring Fusion Receivables - Receivable Activities, Receivables System Options, Receipts, Customer and Profile Class.
- Configuring fusion payments - Receivables - Payments for funds Capture Activities, Setting Up Funds Capture for Receivables
- Prepared BR100, MD50 and TE40 documents.
- Prepared process flow document to the users with step by step process.
- Performed CRP1, CRP2 and UAT testing with business and get the signoff
- Tested all functionalities in financial modules.
- Troubleshooting Journal sub ledger transfer and journal import issues
- Built financial statements such as balance sheet and income statement using financial reporting studio (FRS), extensively worked on Smart View. Setup and installation of ADF desktop Integrator, Smart View and FRS on user’s machines
- Implemented Fusion Accounts payables, Fusion Accounts Receivables, Fusion Expense, Fusion Corporate Cards, Fusion Tax, Fusion Cash Management, Fusion General Ledger Intercompany as part of the financial implementations, enterprise performance manager (EPM).
- Configured All Common Financial setups for enterprise structures and other financials applications, created locations, business units, geographies, data template roles, Oracle Identity Manager(OIM), Sync Processes, user account creation, data sets creation and assignment to the business units
- Performed loading conversion data using external data integration functionality by populating spreadsheet templates, loaded suppliers, payables invoices, journals, budgets, cash management external transactions, COA values and hierarchy, code combinations etc. Worked on rapid implementation model.
- Worked on various applications as part of the fusion applications project, such as BPM work list to implement approval rulers, worked on task managers and modified tasks, notifications.
Confidential, Davidson, NC
Responsibilities:
- Designed and documented Application Interface between the Genco and AT&T Auction Business Process - Order import and Banking Statement interface
- Functional lead for the solution design - for the configuration and process - AR and OM modules
- Design and perfumed the test cases for the AR receipt /Credit card and reconciliation process
- Designed Oracle Multi-Organization structures and Oracle's intercompany order processing (Internal Requisition/Internal Sales Order and Internal Drop Ship, EDI order processing
- Lead the Product Scheduling and planning functionality
- Design and functional documentation for AR interface for Custom Account Receivable system
- Designed and documentation of test scenarios, test cases
- Oracle OM and Shipping Functional Production Support Role
- Order Management Functional setup and configuration
- Build and documented for the End-to-End Business flow testing scenarios for Production enhancement