Senior Oracle APEX & Fusion Integration Solutions Developer (Contract)

Primary Responsibilities

Solution Architecture

• Lead architecture and technical design of the Agent Billing Solution.
• Develop a scalable Oracle PaaS architecture utilizing:
  • Oracle APEX
  • Oracle Integration Cloud (OIC)
  • Oracle Fusion REST APIs
  • Oracle Database Services
• Define application architecture, security strategy, audit framework, and deployment approach.
• Collaborate with Finance, Accounting, Treasury, ERP, and business stakeholders to translate requirements into technical designs.

Custom Billing Engine Development

Design and develop custom capabilities including:

• Agent billing calculation engine
• Fee allocation and cost-split calculations
• Commission deduction prioritization logic
• Marketing Support Budget tracking
• Billing workflow and approvals
• Exception handling and validation
• Monthly billing cycle processing
• Audit trail and reconciliation processes
• Consolidated Agent Billing Statements

Oracle Fusion Integration

Design and implement integrations with:

• Oracle Accounts Receivable
• Oracle Accounts Payable
• Oracle Projects
• Customer Master
• Supplier Master
• Oracle Payments
• AP/AR Netting

Develop integrations utilizing:

• Oracle Integration Cloud (OIC)
• REST APIs
• SOAP Services
• FBDI
• BICC
• File-Based Interfaces

Project Fusion currently leverages Oracle Integration Cloud as the primary middleware platform for Oracle Cloud integrations.

Data & Financial Process Design

• Understand upstream and downstream AP and AR transaction flows.
• Design billing rules based upon historical transaction activity.
• Create reconciliation controls between:
  • Source charges
  • Billing calculations
  • Oracle AR invoices
  • AP/AR netting settlements
• Design robust exception management frameworks.

Technical Leadership

• Lead development activities.
• Perform code reviews and establish development standards.
• Mentor internal technical resources.
• Coordinate with Oracle implementation partners and third-party vendors.
• Support testing, deployment, and production readiness activities.

Required Qualifications

Education

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

Experience

• 10+ years of enterprise application development experience.
• 7+ years of Oracle technologies experience.
• 5+ years developing Oracle APEX applications.
• 5+ years of Oracle Fusion Cloud ERP integration experience.
• Proven experience leading solution architecture for custom Oracle applications.
• Experience designing large-scale financial systems.

Oracle Technical Skills

Required:

• Oracle APEX
• Oracle SQL
• PL/SQL
• Oracle REST APIs
• Oracle Integration Cloud (OIC)
• Oracle Database

Strongly Preferred:

• Oracle Visual Builder (VBCS)
• Oracle Identity Cloud Services
• Oracle Autonomous Database
• Oracle Data Integrator
• OCI Services

Oracle Functional Experience

Must have hands-on experience with:

Oracle Receivables (AR)

• AutoInvoice
• Customer Statements
• Customer Master
• Receipts
• Collections
• Balance Forward Billing

Oracle Payables (AP)

• Supplier Management
• Invoices
• Payments
• Supplier Relationships

Oracle Projects

• Project Billing
• Contract Billing
• Funding
• Budget Tracking

Integrations

• Fusion REST APIs
• FBDI
• OIC Integrations
• Financial data staging applications

Preferred Industry Experience

Strong preference for candidates with experience implementing or developing solutions involving:

• Commission Calculations
• Billing Engines
• Revenue Sharing Models
• Financial Services
• Real Estate Brokerage
• Insurance Brokerage
• Banking
• Wealth Management

Soft Skills

The ideal candidate will possess:

• Strong analytical and problem-solving capabilities
• Executive communication skills
• Ability to work directly with Finance leadership
• Ability to facilitate design workshops
• Strong documentation skills
• Strong stakeholder management capabilities
• Ability to work independently with minimal supervision
• Excellent written and verbal communication

Key Deliverables

The contractor will be expected to deliver:

Phase 1 – Architecture & Design

• Solution Architecture Document
• Technical Design Documents
• Data Model Design
• Security Architecture
• Integration Architecture

Phase 2 – Build

• Oracle APEX Application
• Billing Calculation Engine
• Approval Workflows
• Oracle Integration Cloud Interfaces
• Fusion API Integrations
• Reporting and Reconciliation Framework

Phase 3 – Testing & Deployment

• SIT Support
• UAT Support
• Production Migration
• Knowledge Transfer
• Operational Run Books

Ideal Candidate Profile

The ideal consultant has previously designed and delivered:

• Oracle APEX-based enterprise applications
• Oracle Fusion ERP extensions
• Financial subledger applications
• Billing engines
• Revenue allocation systems
• Commission management platforms
• Large-scale Oracle Fusion integrations

and can operate as a hands-on Solution Architect who is equally comfortable discussing API architecture with technical teams and billing/accounting processes with Finance executives.

Target Level: Senior Solution Architect / Principal Consultant / Lead Oracle APEX Architect.