Pooling Portal — A Case Study

TL;DR

We built Pooling Portal, a centralized commercial management platform for a leading maritime organisation managing vessel pooling operations across multiple fleets. Built on Microsoft Azure and integrated with BITMAP, Oracle Finance, and Azure Identity Services, the platform automates complex distribution calculations, delivers real-time TCE performance analytics, manages scrubber savings, and provides self-service access to revenue and reconciliation data for pool managers and pooling partners alike. The result: a transparent, auditable, and scalable digital ecosystem that has replaced spreadsheet-based operations and significantly reduced manual administrative overhead across maritime pooling operations.

Problem Overview

Managing commercial vessel pools requires precise coordination between ship owners, pool managers, finance teams, and operational stakeholders. Revenue generated across multiple vessels must be accurately calculated, adjusted, and distributed based on complex pooling agreements, operating performance, vessel characteristics, penalties, scrubber savings, and other business rules. Traditionally, these activities relied on spreadsheets, manual calculations, disconnected reporting systems, and extensive stakeholder coordination.

• Spreadsheet-based reporting created inconsistencies and increased operational risk
• Manual distribution calculations involving multiple business variables were time-consuming and error-prone
• Pool members had no direct access to distribution data, leading to increased dependency on manual support
• Fragmented data sources across enterprise systems made consolidation and reporting difficult
• Limited visibility into scrubber savings, penalties, and pool performance hindered transparency
• Email-driven communications slowed reconciliation and created governance gaps

Role & Responsibilities

• Role: Full-stack development team
• Responsibilities:
  • Design and build the full pooling management platform end-to-end
  • Integrate with BITMAP Data Platform, Oracle Finance Systems, and Azure Identity Services
  • Build automated revenue distribution calculation and reconciliation engine
  • Develop self-service dashboards and TCE performance analytics
  • Implement Azure AD B2C and OAuth 2.0 authentication with role-based access control
  • Deliver scrubber savings management and penalty adjustment capabilities
  • Build fleet administration module with audit logging and historical change tracking

Project Context

• Client: Leading maritime organisation operating commercial vessel pools
• Industry: Maritime — vessel pooling, commercial operations, and revenue management
• Purpose: Provide a centralized, secure, and scalable digital platform to manage vessel pooling operations, automate distribution calculations, and empower stakeholders with real-time financial and operational visibility
• Constraints: Complex multi-variable distribution calculations, integration with multiple enterprise systems, strict data accuracy and auditability requirements, and the need to support both internal pool managers and external pooling partners securely

My Approach

We started by mapping the full lifecycle of a pooling operation — from vessel onboarding and pool point administration through to monthly distribution calculation, financial reconciliation, and stakeholder reporting. The architecture was designed around two priorities: automated accuracy for complex calculations and transparent self-service access for both internal and external users.

• Discovery: Identified every business variable involved in distribution calculations and mapped how data moved across BITMAP, Oracle Finance, and operational systems
• Integration Strategy: Designed a centralised data ingestion layer to consolidate fragmented sources into a single source of truth
• Automation-first Design: Built the calculation engine to eliminate manual spreadsheet processes while preserving full auditability
• Self-service Architecture: Gave pool members direct, role-appropriate access to their distribution, performance, and reconciliation data without relying on manual reporting

Research & Insights

Key Findings from Discovery

• Pool managers needed a single source of truth for distribution data to reduce reconciliation disputes and support requests
• Pool members expected transparent, real-time access to their own revenue allocations and performance metrics
• Scrubber-equipped vessels required dedicated savings tracking and reporting that existing tools could not support
• Fleet administration activities — vessel onboarding, pool point changes, penalty management — generated significant manual overhead
• Auditability was a non-negotiable requirement for both internal governance and external trust

Competitive Research

• Existing pooling operations relied heavily on spreadsheets and manual processes with no centralised platform
• No off-the-shelf solution adequately handled the complexity of multi-variable maritime distribution calculations
• Scrubber savings management and pool-level TCE analytics were unsupported by legacy tools

User Persona

• Name: James
• Role: Pool Manager, maritime commercial operations
• Goals: Accurately calculate and distribute monthly revenues, manage fleet administration efficiently, provide transparent reporting to pooling partners
• Pain Points: Manual spreadsheet calculations, time-consuming reconciliation, limited visibility for pool members, audit gaps in fleet change management

Information Architecture

• Dashboard & Performance Analytics — real-time TCE trends, revenue performance, monthly and yearly comparisons, fleet-level analytics with owner and sub-pool filtering
• Distribution Management — core module providing full visibility into operating days, distribution amounts, revenue, Pool In/Out values, management fees, overhead, bunker costs, scrubber savings, and penalty adjustments
• Scrubber Performance Management — dedicated tracking of scrubber days, scrubber points, monthly savings, and year-to-date automated savings calculations
• Fleet Administration — vessel onboarding, updates, sub-pool management, pool point administration, penalty management, activation and deactivation, and historical change tracking
• Financial Reconciliation — owner-level reconciliation covering gross cash, management fees, overhead, commissions, bunker adjustments, beginning and ending balances, payment tracking, and statement generation
• Audit & Governance Layer — comprehensive audit logging across all fleet administration and distribution activities for full operational accountability
• Self-Service Reporting — exportable reports for both pool managers and external pooling partners with role-based access controls

Visual Language

The interface was built to make complex financial and operational data accessible to both technical pool managers and non-technical pooling partners. Clear data hierarchies, structured distribution tables, and interactive analytics kept the experience clean despite the underlying calculation complexity. The UI was designed so that pool members could immediately understand their earnings position without requiring additional explanation or manual reports from the operations team.

Wireframes & Early Ideas

Early wireframes centred on the distribution view and the dashboard — the two areas where both pool managers and pool members spent the most time. A key decision was to surface scrubber savings and penalty adjustments inline within the distribution breakdown rather than in a separate report, making the calculation transparent at a glance. The fleet administration module was scoped early to include audit logging from the outset, recognising that governance was a first-class requirement, not an afterthought.

Designing Solutions

Problem: Complex, multi-variable distribution calculations performed manually in spreadsheets

• Built a dedicated distribution calculation engine that processes operating days, pool points, sub-pool allocations, revenue contributions, management fees, overhead, bunker costs, scrubber savings, and penalty adjustments automatically each month
• Calculations are driven from consolidated enterprise data ingested from BITMAP and Oracle Finance, eliminating manual data entry entirely

Problem: Pool members had no direct access to their distribution and performance data

• Delivered a self-service portal with role-based access, giving each pooling partner secure, direct visibility into their own distribution data, TCE performance, scrubber savings, and financial reconciliation statements
• Reduced dependency on manual reporting and support requests from pool managers

Problem: Scrubber-equipped vessels had no dedicated savings tracking or reporting

• Built a dedicated Scrubber Performance Management module that tracks scrubber days, calculates scrubber points, and provides monthly and year-to-date savings visibility
• Automated savings calculations ensure accurate and consistent allocation without manual intervention

Problem: Fleet administration activities generated significant manual overhead and lacked auditability

• Delivered a comprehensive Fleet Administration module supporting vessel onboarding, sub-pool management, pool point administration, penalty management, and activation status changes
• Every administrative action is logged with full audit trails, providing accountability and governance for all fleet changes

Tech & Implementation

• Cloud Platform: Microsoft Azure — providing high availability, scalability, security, and operational resilience
• Authentication & Security: Azure AD B2C with OAuth 2.0; role-based access control; API security controls; data protection controls
• Enterprise Integrations: BITMAP Data Platform for operational data; Oracle Finance Systems for financial data; Azure Identity Services for secure access management
• Architecture: Cloud-native, secure-by-design framework with API security controls and comprehensive audit logging
• Data Management: Centralised data ingestion layer consolidating fragmented enterprise sources into a single source of truth
• Reporting: Self-service exportable reporting for internal and external stakeholders with role-based data scoping

Real-world Features & Highlights

• Automated distribution calculations → complex multi-variable revenue allocation processed accurately every month without manual spreadsheets
• Self-service portal for pool members → direct, secure access to distribution data, TCE analytics, scrubber savings, and reconciliation statements
• Scrubber Performance Management → dedicated savings tracking and automated calculations for scrubber-equipped vessels
• Fleet Administration module → vessel onboarding, pool point management, penalty administration, and full historical change tracking
• Financial Reconciliation → owner-level statements covering all financial variables from gross cash to ending balances
• Comprehensive audit logging → full accountability for all fleet administration and distribution activities
• Enterprise integration → live data ingestion from BITMAP and Oracle Finance eliminates manual data entry
• Cloud-native scalability → Azure-based architecture capable of supporting future fleet expansion and evolving pooling models

Results & Impact

• Established a single source of truth for vessel pooling operations across multiple fleets, replacing fragmented spreadsheet-based processes
• Automated monthly distribution calculations, significantly reducing manual effort and operational risk for pool management teams
• Provided pool members with transparent, self-service access to their distribution and performance data, reducing manual reporting requests
• Delivered dedicated scrubber savings management, bringing accuracy and visibility to a previously untracked area of pool revenue
• Strengthened operational governance through comprehensive audit logging and fleet administration controls
• Created a scalable digital foundation capable of supporting future fleet growth and evolving commercial pooling models

Challenges & Learnings

• Calculation complexity at scale — maritime distribution calculations involve a large number of interdependent business variables; designing a reliable, auditable calculation engine required deep domain understanding and rigorous testing
• Data consolidation from fragmented sources — integrating BITMAP, Oracle Finance, and operational data sources into a single coherent data layer was the foundational architectural challenge the entire platform depended on
• Balancing access control with transparency — different stakeholders (pool managers vs pooling partners) needed different views of the same underlying data; role-based scoping had to be precise without compromising usability
• Auditability as a first-class concern — building audit logging into every administrative action from the outset, rather than retrofitting it later, was a critical governance decision that shaped the fleet administration module architecture
• Scrubber complexity — scrubber savings calculations introduced additional variables and tracking requirements that required a dedicated module rather than a simple extension of the distribution engine

Takeaways

• Domain depth is the foundation: Maritime pooling calculations are highly specialised; no platform could be built without a thorough understanding of pool points, TCE mechanics, scrubber economics, and reconciliation requirements
• Automation eliminates risk, not just effort: Replacing spreadsheet-based calculations with an automated engine didn't just save time — it removed a whole category of calculation error and reconciliation dispute
• Self-service builds trust: Giving pool members direct access to their own data reduced friction, improved transparency, and shifted the relationship between pool managers and partners from reactive reporting to collaborative visibility
• Governance must be designed in: Audit logging and change tracking were not optional extras — they were central to stakeholder trust and commercial accountability in a revenue-sharing environment
• Integration is the hard part: The quality of the platform's outputs was entirely dependent on the reliability of its data inputs; investing in a robust integration layer with BITMAP and Oracle Finance was what made accurate calculations possible

Next Steps

• Expand TCE analytics with predictive performance modelling to support forward-looking commercial planning
• Add portfolio-level sustainability and emissions reporting aligned with maritime decarbonisation frameworks
• Mobile application for on-the-go access to distribution data and performance alerts for pooling partners
• Deeper Oracle Finance integration for automated payment reconciliation and real-time balance updates
• Expand platform to support additional pool types and evolving commercial pooling structures

Client Feedback

"Pooling Portal has transformed how we manage our commercial pooling operations. The transparency it brings to distribution calculations and the self-service access it gives our pool members has significantly reduced the time our team spends on manual reporting and reconciliation."

— Pool Manager, Leading Maritime Organisation

Pooling Portal is now a critical commercial platform supporting pooling operations across multiple fleets, providing accurate, auditable, and transparent revenue-sharing insights for all stakeholders across the maritime ecosystem.

Call to Action

If you're looking to build a centralized operations platform or automate complex financial calculations for your business, contact us at WhizCloud — we'd love to partner with you.