Oracle Functional Analyst

Vista previa de la oferta

Oracle Functional Analyst

senior · Investment Banking

Business Unit:

Industry:

Overview

Scope

The Oracle Functional Analyst will serve as the primary functional and technical resource for Oracle Cloud Cash Management, Payments, and Fixed Assets. This role is responsible for supporting and enhancing global banking, payment processing, bank reconciliation, and asset-accounting processes within Oracle Fusion Cloud.

The position requires strong knowledge of domestic and international payment methods, including ACH, BACS, SEPA, and wire payments. This individual will partner closely with Treasury, Accounts Payable, Accounting, Tax, Finance, banking partners, and IT teams to design secure, scalable, controlled, and supportable solutions. The role supports the complete application lifecycle, including requirements gathering, solution design, configuration, payment-file development, testing, deployment, production support, documentation, continuous improvement, and knowledge transfer.

Key Responsibilities

Oracle Cash Management

• Provide day-to-day functional and technical support for Oracle Cloud Cash Management.

• Configure and maintain banks, bank branches, internal bank accounts, transaction codes, reconciliation rules, tolerances, and cash-management setups.

• Support automated and manual bank-statement reconciliation processes.

• Configure and troubleshoot bank-statement imports, including BAI2, CAMT, MT940, and other applicable bank formats.

• Investigate and resolve unmatched transactions, reconciliation exceptions, missing or duplicate transactions, and integration failures.

• Support cash-positioning, cash-forecasting, and bank-balance reporting requirements.

• Partner with Treasury and Accounting to improve the timeliness and accuracy of bank reconciliations.

• Support the setup and testing of new banks, bank accounts, currencies, legal entities, and business units.

• Monitor scheduled bank-statement and reconciliation processes and resolve failures within required timelines.

• Maintain appropriate controls over bank-account setup, changes, approvals, and access.

Oracle Payments and Payment Processing

• Administer and support Oracle Payments and Accounts Payable payment-processing activities.

• Configure and maintain payment methods, payment process profiles, payment formats, disbursement bank accounts, payment documents, and payment-system accounts.

• Support domestic and international payment methods, including ACH, BACS, SEPA Credit Transfer, domestic and international wires, and other country-specific electronic payment methods.

• Configure and maintain payment templates and bank-specific payment-file formats.

• Support payment-file generation, transmission, acknowledgment, rejection, confirmation, and settlement processes.

• Troubleshoot payment-process requests, payment-file failures, formatting issues, rejected payments, bank-validation errors, and transmission issues.

• Partner with banks, Treasury, Accounts Payable, and integration teams to test and certify payment files.

• Support payment-file changes resulting from new banks, banking requirements, regulatory changes, entity expansions, or acquisitions.

• Review payment-file specifications and translate banking requirements into Oracle configuration or technical-development requirements.

• Ensure payment files include required beneficiary, bank, remittance, regulatory, and reference information.

• Support prenotification, positive-pay, payment-confirmation, and payment-status processes where applicable.

• Maintain payment controls, approval requirements, segregation of duties, and audit documentation.

Payment Templates and Bank Integrations

• Design, configure, develop, and maintain Oracle payment templates for ACH, BACS, SEPA, and wire payments.

• Work with BI Publisher payment templates, XML data, formatting logic, and bank-specific file requirements.

• Review and interpret bank implementation guides, payment-file specifications, and validation rules.

• Support ISO 20022 payment standards and related formats, including applicable pain.001 and payment-status messages.

• Coordinate secure transmission of payment files through SFTP, host-to-host connections, banking portals, middleware, or other approved methods.

• Partner with Oracle Integration Cloud and technical teams to design and support payment integrations.

• Perform end-to-end payment testing from invoice selection through bank acceptance and settlement.

• Develop test scenarios covering domestic, international, foreign-currency, urgent, high-value, and exception payments.

• Maintain version-controlled documentation for payment templates, mappings, bank specifications, and technical configurations.

• Coordinate with banks and internal teams to resolve payment-format and transmission issues.

• Ensure payment solutions are scalable and reusable while accommodating required bank- and country-specific differences.

Oracle Fixed Assets

• Provide day-to-day functional and technical support for Oracle Cloud Fixed Assets.

• Configure and maintain corporate and tax books, asset categories, depreciation methods, prorate conventions, calendars, depreciation rules, and accounting setups.

• Support the complete asset lifecycle, including additions, mass additions, capitalization, adjustments, transfers, reclassifications, unit changes, retirements, reinstatements, impairments, and depreciation.

• Support asset additions originating from Accounts Payable, Projects, leases, acquisitions, conversions, and manual entry.

• Troubleshoot mass-addition, accounting, depreciation, transfer, retirement, and reconciliation issues.

• Support monthly, quarterly, and year-end asset-close processes.

• Run and validate depreciation, Create Accounting, and transfer-to-General-Ledger processes.

• Partner with Accounting and Tax to maintain accurate corporate-book and tax-book reporting.

• Support fixed-asset conversions, mergers, acquisitions, new entities, and chart-of-account changes.

• Assist with construction-in-progress and capitalization processes where applicable.

• Support physical inventory, asset tracking, and asset verification requirements.

• Reconcile Fixed Assets to General Ledger and investigate discrepancies.

• Maintain asset-accounting rules and ensure accurate generation of cost, depreciation, reserve, gain, loss, clearing, and retirement accounting.

Financial Integrations and Accounting

• Support integrations between Cash Management, Payments, Fixed Assets, Accounts Payable, General Ledger, Procurement, Projects, and external banking systems.

• Troubleshoot data, accounting, interface, and reconciliation issues across Oracle Financials modules.

• Review Subledger Accounting results and assist with the resolution of incorrect or incomplete accounting.

• Partner with technical teams to support Oracle Integration Cloud, REST APIs, file-based integrations, BI Publisher, and scheduled processes.

• Monitor inbound and outbound interfaces and resolve production failures.

• Ensure transactions are transferred and accounted for accurately and within financial-close timelines.

• Support new legal entities, business units, ledgers, banks, and operating models.

Security, Controls, and Compliance

• Support role and data-access design for Cash Management, Payments, and Fixed Assets.

• Ensure access follows least-privilege and segregation-of-duties principles.

• Coordinate access provisioning and removal based on approved requests.

• Support periodic user-access reviews and internal and external audit requests.

• Maintain documentation for payment configurations, bank-account changes, security assignments, approvals, and control procedures.

• Partner with Treasury, Accounting, Information Security, and Internal Audit to maintain appropriate controls over banking and payment processes.

• Support sensitive-access reviews related to bank accounts, payment processing, supplier bank details, and payment-file generation.

• Ensure production changes follow approved change-management, testing, and deployment procedures.

Projects and Enhancements

• Gather and document requirements for Cash Management, Payments, and Fixed Assets projects and enhancements.

• Translate business and banking requirements into functional and technical designs.

• Evaluate enhancement requests and recommend scalable, controlled, and supportable solutions.

• Prepare estimates, solution options, risks, dependencies, and implementation plans.

• Configure, test, and deploy approved solutions.

• Develop test plans, detailed test scripts, expected results, and deployment documentation.

• Coordinate system integration testing, user acceptance testing, bank testing, and production validation.

• Support Oracle quarterly updates, regression testing, release-readiness reviews, and post-deployment validation.

• Identify opportunities to automate manual banking, payment, reconciliation, and asset-accounting processes.

• Serve as the primary escalation point for complex production issues in the assigned areas.

Documentation and Knowledge Transfer

• Maintain configuration workbooks, solution designs, process flows, integration diagrams, payment-format specifications, and support procedures.

• Create operating procedures, troubleshooting guides, control documentation, and end-user training materials.

• Provide training to Treasury, Accounts Payable, Accounting, Finance, and IT support teams.

• Lead knowledge-transfer activities from implementation partners and external consultants.

• Document consultant-supported processes and transition ongoing system ownership to the internal team.

• Develop sustainable support processes that reduce reliance on external resources.

Required Qualifications

• Bachelor's degree in Accounting, Finance, Information Systems, Computer Science, or a related field.

• Seven or more years of experience supporting or implementing Oracle Financials applications.

• At least three years of hands-on Oracle Fusion Cloud Financials experience.

• Strong hands-on experience with Oracle Cash Management, Oracle Payments, and Oracle Fixed Assets.

• Demonstrated experience configuring and supporting electronic payments, including ACH, BACS, SEPA, and wire payments.

• Experience developing, configuring, or supporting Oracle BI Publisher payment templates and bank-specific payment formats.

• Experience with bank-statement formats and reconciliation processes.

• Strong understanding of payment processing, banking operations, cash reconciliation, asset accounting, depreciation, and financial-close processes.

• Experience configuring payment methods, payment process profiles, bank accounts, reconciliation rules, asset books, asset categories, and depreciation methods.

• Experience troubleshooting payment-file, bank-integration, asset-accounting, reconciliation, and Subledger Accounting issues.

• Experience supporting monthly, quarterly, and year-end financial-close activities.

• Strong analytical, problem-solving, documentation, and communication skills.

• Ability to work directly with Treasury, Accounts Payable, Accounting, Tax, IT, auditors, banks, and external service providers.

• Ability to manage multiple priorities and provide support during critical payment and financial-close periods.

Preferred Qualifications

• Experience with Oracle Accounts Payable, General Ledger, Procurement, Projects, and Subledger Accounting.

• Experience with ISO 20022 and XML-based payment formats.

• Knowledge of BAI2, CAMT, MT940, and other bank-statement formats.

• Experience with Oracle Integration Cloud, REST APIs, SFTP, host-to-host banking connections, or other integration technologies.

• Experience with BI Publisher, XML, XSL, XSLT, or payment-format development.

• Experience supporting global banking and payment requirements across the United States, United Kingdom, and European Union.

• Experience with multicurrency payments, cross-border wires, regulatory payment information, and country-specific banking requirements.

• Experience supporting mergers, acquisitions, new legal entities, bank transitions, or global system rollouts.

• Knowledge of financial controls, bank-account governance, payment fraud prevention, and segregation of duties.

• Oracle Financials Cloud certification is preferred.

Compensation and Benefits

$120,000–$150,000

Houlihan Lokey provides a competitive benefits package. Our current benefits offerings can be found here:

2026 Benefits

We are an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability, gender identity, sexual orientation, protected veteran status, or any other characteristic protected by law.