We provide IT Staff Augmentation Services!

Oracle Finance Functional Consultant Resume

5.00/5 (Submit Your Rating)

New, YorK

SUMMARY:

  • Oracle Finance Functional Consultant with over 8+ years experience implementing Oracle ERP projects. Experienced business solutions analyst with in - depth knowledge of Oracle ERP applications with focus on Operations, Distributions, Planning, and Financial modules.
  • Strong Business Analyst Experience in implementation, upgrading, customization and testing of Oracle Applications Financials R12 and 11i.
  • Strong partnership skills include working cross functionally with implementation partners, internal IT organizations, and business leaders to drive large scale implementations globally.
  • Extensive experience in General Ledger, Account Payables, Account Receivables, PO, SLA, FA, AGIS, INV, EB-Tax, CE, iProcurement, iExpense, iSupplier.
  • Experience in defining Business process, risk analysis, cost-benefit analysis, base-lining acceptance criteria, deliverables
  • Specific strengths include:
  • Implementing complex Oracle ERP applications
  • Migrating solutions from Legacy to Oracle Applications
  • Integrating applications across business tower
  • Experience with project life cycle, from business requirement gathering to product/solutions implementation
  • Extensive experience in Legacy system integrations
  • Coach, guide and mentor off-shore and vendor techno-functional teams
  • Experienced in application support, and issue management
  • Ability to prioritize and remain focused on the essence of an issue
  • Excellent written and communication skills
  • Experienced in Business Process flows for Procure-to-Pay (P2P), Order-to-Cash (O2C), Record-to-Report (R2R) by using AIM Methodology.
  • Functional knowledge in implementation and system testing of core financial modules in R12 & 11i versions.
  • Proficiency and ability to follow through with projects from inception to completion.

TECHNICAL SKILLS:

ERP: Oracle E-Business Suite R12 and 11i.

Financial Modules: General Ledger, Account Payables, Account Receivables, Fixed Asset, Cash Management, iExpense, SLA

Distribution Modules: Purchasing, Inventory, Order management, iProcurement

Tools: Toad, Dataloader, Web ADI, Microsoft office.

Methodology: AIM, OUM

PROFESSIONAL EXPERIENCE:

Confidential, New York

Software: Oracle Applications R12.1.3

Oracle Finance Functional Consultant

Modules: GL,AGIS, AP, PO,SLA, EB-Tax, Treasury

Responsibilities:

  • Globally Rolled out the Oracle Financials R12 modules, along with developing other Custom applications integrations’ to Oracle and reports related to procure to pay and order to cash process flows.
  • Business Systems Manager supporting Oracle Financials, Projects, HR, OTL, and Distribution modules
  • Integration of external applications such as salesforce.com and ADP Payroll
  • Direct and manage the Oracle corporate goals and strategies from the accounting, production and IT perspectives
  • Supervise the monthly business systems strategy meeting with upper management
  • Perform cost/benefit analysis and risk assessment
  • Develop validation test plans, user and system procedures, training materials and project plans for upgrades and patches
  • Manage compliance: SOX and ISO and develop/revise SOPs as appropriate
  • Develop the system audit/modifications, security and access abilities
  • Re-engineer existing business/system processes to leverage the applications
  • Hire and manage the consulting staff, DBA services, and additional resources as necessary
  • Develop and manage the project and department resources, budgets and goals
  • Troubleshoot production issues to resolution: SQL code, patch, user data modification
  • Actively involved in implementation and integration activities with modules such as- Account Payables, General Ledger, Cash Management, FA and Advance collection, Account Receivables.
  • Automated procurement processes significantly and Leveraged Buyers work center and i-Procurement to perform daily procurement activities.
  • Designed COA and Configured GL, AP, iExp, AR, SLA, AGIS for R12 Implementation.
  • Implemented AGIS to create invoices in payables and receivables sub ledger from intercompany transactions.
  • Implemented Multi Org - design,configuration the multi-org set up with multiple operating units.
  • Implemented A ccounts R eceivable to process Auto Invoices from Project Billing, Receipts(Payments) in Multi-currency transactions.
  • Customized SLA (Subledger Accounting) functionality in R12 to provide better matching of Liability and Expense accounting transactions on Payables invoices. For AR subledger to provide better matching of Receivables and Cash Receipt accounting.
  • Implemented Electronic Payments(SEPA,DMTCHIP,AUTOFX) using EDI.
  • Configured the Internal and External Banks for Fund Disbursements and Captures.
  • Implemented iExpense to streamline and automated travel spend management and

Confidential, LA, CA

Software: Oracle Applications R12.1.3

Oracle Finance Functional Consultant

Modules: GL, PO, AP, AR, INV, CE, WebADI, Treasury

Responsibilities:

  • Designed Chart of Account ( COA ) to provide Flexibility for Recording and Reporting Accounting Information.
  • Worked on the entire Financials business process.
  • Reviewed and assisted with SOX compliance
  • Analyze, design and test custom applications, interfaces and conversion programs
  • Project Manager for the implementation of Oracle applications release 11i intercompany functionality and development of custom software for the Accounts Receivable and Accounts Payable interfaces
  • Performed all of the setups for i-Procurement, PO,GL, Sub Ledger Accounting, Project Accounting, Project Billing, Project Costing, AP, AR, Advance Collection and i-Expense modules
  • Developed several enhancements to the Business Processes on the Finance side.
  • Implementation of Electronic Funds Transfer (ACH and Wire) FT for US and Hungary.
  • Configured Accounting Flexfield, Account Maintenance, Calendars, Currencies, Ledger and Legal Entity Setups, Data Access Sets, Document Sequences, Mass Allocations, GL Profile options and Transactions Processing.
  • Configured the FSG to Create Balance Sheet and Profit Loss/Income Statements.
  • Implemented iSupplier portal to View/Changes POs, Acknowledgements, Submit ASN, Create and View Invoices.
  • Implemented Purchasing (PO) with 3-way match, INVENTORY, CM, Cash Management modules.
  • Configured AP Financials, Payable System and Payables options, Vendors and Sites, Bank and Bank Account for Fund Disbursements.
  • Implemented the Third Party Payments feature in AP.
  • Created Mapping Documents for Supplier Sites, Items, OPEN PO, AP Invoices, conversions.
  • Prepared Project Documentations, AS IS documents, Solution design document, BR100.
  • Prepared Cutover Plan document, Monthly Closing Procedure etc.
  • Used WebADI to Load Journals to the GL.

Confidential, Seattle, WA

Software: Oracle Applications R12.1.3

Oracle Finance Functional Consultant

Modules: GL, AGIS, AP, AR, SLA, FA

Responsibilities:

  • Implemented a Highly Automated Financial processing system using Oracle EBS.
  • Configured Accounting Flexfield, Account Maintenance, CVR's, Calendars, Currencies, Journal Controls, Journal Approvals, Ledger and Legal Entity Setups, Secondary Ledgers, Data Access Sets, Document Sequences, GL Profile options and Transactions Processing.
  • Configured Mass Allocations, AGIS Setups in GL.
  • In second phase of the project, implemented EBTax for 19 countries including Canada, Brazil, India, Europe and Asia Pacific.
  • Multi Org set-up - Responsible for implementing the multi-org set up with multiple operating and inventory orgs.
  • Configured AR System options, Transaction Types, Receivable Activities, Receipt Classes, Receipt Method, Bank Accounts and Remittance process.
  • Configured AP Financials, Payable System and Payables options, Vendors and Sites, Bank and Bank Account for Fund Disbursements.
  • Automated the AP Payment Process by using the Electronic Fund Transfer (ACH) to reduce the load on Check Payment Process.
  • Configured Approvals Management (AME) for AP Invoice Approval and Hold Notifications.
  • Customized SLA (Subledger Accounting) functionality in R12 to provide Multiperiod Accounting for Deferred Expenses.
  • Providing support to users after implementation is done and fixing all issues related to set ups
  • Fixing the issues for converted data for GL, AP, PO, i-Procurement, Project Accounting, Project Billing, Project Costing, AR modules
  • Implemented Revenue Recognition program to generate the revenue distribution records for invoices and credit memos using Invoicing and Accounting Rules.

Confidential, Austin TX

Software: Oracle Applications R12.1.3

Senior Business Analyst

Modules: PO, AP, AR, GL, FA, SLA, iExpense

Responsibilities:

  • Prepared Project Documentation, Requirement Document, Future Requirement Document, Solution Design Document, Test Scripts, Setup Documents and Training documents.
  • Customized Standard Purchase Orders to communicate Report (Print) the purchase details to the suppliers.
  • Designed interface for Asset Movement transactions from Oracle eBusiness Suite to Vertex O Series and creating automated accrual journal entries. Vertex O Series setups and migration. Setup eBTax and Vertex O Series integration. Develop customizations for integration to Vertex O Series at invoice distribution level. implemented Vertex Returns 9.x.
  • Configured AP Financials, Payable System and Payables options, Vendors and Sites.
  • Configured Bank, Branch, Account, Payment Processing Profile (PPP) Setup for Funds Disbursements and Capture.
  • Automated the AP Payment Process by using the Electronic Fund Transfer (ACH) to reduce the load on Check Payment Process.
  • Customized SLA (Subledger Accounting) functionality in R12 to provide better matching of Liability and Expense accounting transactions on Payables invoices.
  • Implemented the accounting rules using SLA functionality is modified for Accum Depreciation, Revaluations transactions in FA using standard SLA configuration and setups.
  • Configured AR System options, Transaction Types, Receivable Activities, Receipt Classes, Receipt Method, Bank Accounts and Remittance process.
  • Configured AP/AR Netting automatically compares Payables to Receivables and created the appropriate transaction in each system to net supplier invoices and customer invoices.

Confidential, Santa Clara, CA

Software: Oracle Applications R12

Senior Business Analyst

Modules: AP, PA, AR, GL, SLA, FA, CE, iExpense.

Responsibilities:

  • Coordinated and led the entire phase of the project which included initial operations analysis, business process re-evaluation, testing, training, conversions, customizations and documentation and implementation of modules in R12 environment.
  • Designed rollup groups, Security rules, Data Access Set, Intercompany accounts, summary accounts, account aliases. Defined currency translation.
  • Implemented AR Invoices and Credit Memos are interfaced from iHub to EBS.
  • Customer Information are interfaced to EBS.
  • Implemented Lockbox to apply Receipts to AR Invoices.
  • Implemented Revenue Recognition program to generate the revenue distribution records for invoices and credit memos using Invoicing and Accounting Rules.
  • Configured AP Financials, Payable System and Payables options, Vendors and Sites.
  • Lead Role in the Internet Expense (iExpense) project that involves gathering user requirements, planning the road map for the implementation
  • Performed detailed setups in Internet Expense involving defining templates, policies, rules based on business requirements
  • Implemented the credit card functionality into Internet Expense with Confidential .
  • Customized Account Generator Oracle Workflow process using Workflow Builder for Project Accounting to default the line level expense account from the project
  • Created MD50 using AIM Methodology for conversion of employee type supplier in Payables for iExpense.
  • Implemented Project Costing and Accounting: actuals (expenditures) are incurred for a project. Type of expenditure: Pre-approved expenditure and expenditures from Oracle Payables.
  • Customized Subledger Accounting (SLA) ADR, JLD, Application Accounting Definitions for Accounts Receivables.
  • Monitored UAT Process and solved Functional issues related to AP, AR, GL and iExpense.
  • Worked with Oracle Support to fix various issues while implementing AP, AR, Internet Expense

We'd love your feedback!