The Challenge
Square International, a diversified business group headquartered in Dubai with operations spanning corporate travel management, MICE event services, visa facilitation, and import/export distribution, had accumulated a technology infrastructure that mirrored its growth history: organic, additive, and deeply fragmented.
By 2023, the company was operating three core systems that managed overlapping but non-integrated domains. A standalone travel booking system — a Amadeus-certified mid-office application licensed from a regional vendor — handled flight, hotel, and ground transport bookings. A separate Microsoft Dynamics 365 instance managed the company's financial accounting, vendor payments, and customer invoicing. And a third system — a custom-built PHP application developed in-house in 2017 — handled MICE event project management, including supplier contracts, event timelines, and venue coordination.
None of these systems shared data in real time. The practical consequence was that every booking made in the travel system required a manual accounting entry in Dynamics 365 — a process performed by the finance team daily, involving reconciliation of booking references, currency conversions, supplier credit terms, and customer invoice generation. This reconciliation consumed approximately 2.8 full-time equivalent hours per day across the finance team, or roughly 700 hours annually. Month-end close took 3–4 days of intensive manual work.
The absence of a unified data model also created a visibility problem at the executive level. Square International's group management had no real-time view of bookings, revenue, supplier liability, or receivables. Revenue reporting was produced weekly by the finance team from a combination of Dynamics exports and travel system reports, merged manually in Excel. Forecasting was largely intuitive.
The 2023 strategy review identified operational technology as the primary constraint on the company's growth plans. Square International's target — to double MICE revenue and expand the corporate travel division into Saudi Arabia — was operationally impossible under the existing architecture. The mandate given to SpYsR was not to optimise the existing systems but to replace them with a unified platform capable of supporting the business at 2x its current scale.
Our Approach
SpYsR's discovery engagement for Square International ran for 6 weeks — longer than standard — because the integration scope with Microsoft Dynamics 365 required detailed mapping of the client's General Ledger chart of accounts, AP/AR workflows, multi-entity structure (Square International operates 3 legal entities in UAE with shared cost centre allocations), and existing Dynamics customisations built by a previous implementation partner.
The architecture decision that defined the engagement was the choice of integration pattern for Microsoft Dynamics. SpYsR evaluated three approaches: a full Dynamics replacement (rejected — the client had significant embedded Dynamics customisations and a finance team fluent in the system), a data warehouse pattern with nightly sync (rejected — this would not solve the real-time visibility requirement), and a bidirectional API integration using Dynamics 365's OData REST API with event-driven sync via Azure Service Bus (selected). This third approach allowed the new unified platform to remain the system of record for travel operations while Dynamics 365 remained the system of record for financial accounting — with real-time synchronisation of financial events between them.
The MICE project management system — the bespoke PHP application — was replaced rather than integrated, as the codebase was unmaintainable and the data model was insufficiently structured to serve as an integration source. SpYsR designed and built a new MICE module natively within the unified platform, migrating 4 years of historical project data during a 3-week data migration phase.
Azure was selected as the cloud infrastructure platform given the client's existing Microsoft enterprise agreement and the Dynamics integration requirements. The application stack runs on Azure Kubernetes Service with PostgreSQL Flexible Server for the primary database and Azure Blob Storage for document management.
What We Built
The unified operations platform is a React-based web application serving four distinct user roles: travel consultants (booking and servicing), MICE project managers, finance team, and group management. Each role has a purpose-built interface reflecting their workflow, but all operate against a single shared data model — meaning a flight booking made by a travel consultant is immediately visible in the finance team's receivables dashboard and in the MICE coordinator's client history view.
The Amadeus mid-office integration replaced the legacy travel system's booking functionality. SpYsR implemented a full Amadeus Web Services integration covering PNR creation, fare calculation, ticketing, and post-ticketing services (refunds, reissuances, exchanges). The integration operates through a booking management service that translates Amadeus PNR data into the platform's normalised booking schema, applying Square International's configured business rules for approval workflows, preferred supplier priorities, and travel policy compliance checks. Corporate bookings above a configured threshold trigger an automated approval request to the designated approver, with mobile push notification via the Azure Notification Hub.
The Microsoft Dynamics 365 bidirectional sync is the most architecturally significant component. The synchronisation layer uses the Dynamics 365 OData API to write financial events from the travel platform — confirmed bookings, supplier invoices, customer billing triggers, credit note events — directly into the corresponding Dynamics entities (Journals, AP Invoices, Sales Orders) in real time via Azure Service Bus message queues. The queue architecture provides delivery guarantees and retry logic for cases where Dynamics is temporarily unavailable. Conversely, payment events recorded in Dynamics — supplier payment confirmations, customer remittance receipts — are synced back to the travel platform to update booking financial status. The reconciliation that previously required 2.8 FTE-hours daily is now automatic.
The Power BI executive dashboard is embedded within the platform's management console, consuming the PostgreSQL operational database via DirectQuery mode. Group management has real-time visibility into: booking volumes by entity and product line, revenue versus target by month, outstanding receivables ageing, supplier liability exposure, and MICE project margin by event. The dashboard refreshes every 15 minutes and supports drill-down from group-level aggregates to individual booking records. Prior to this implementation, equivalent reporting required 3–4 hours of manual spreadsheet assembly.
The MICE project management module handles end-to-end event servicing: RFP management, venue and supplier contracting, event timeline and milestone tracking, client communication logs, and post-event reconciliation. All MICE project financials flow directly into the Dynamics sync pipeline, eliminating the previous manual keying of event costs into the accounting system.
The Impact
The unified platform went live for Square International's Dubai headquarters in March 2025 after a 3-week parallel run period. The Saudi Arabia expansion entity was onboarded to the platform in May 2025, validating the multi-entity architecture built during Phase 1.
Three legacy systems — the Amadeus mid-office application, the Microsoft Dynamics standalone instance (replaced by the integration layer), and the bespoke PHP MICE system — were decommissioned following the transition. The combined licensing cost of the three legacy systems, approximately AED 340K annually, has been replaced by the new platform's running cost, representing a net saving of AED 180K annually after platform licensing.
Operational overhead — measured as the total staff time allocated to system administration, data reconciliation, and reporting tasks across finance and operations — fell by 44%. The finance team's month-end close process, previously taking 3–4 days, now completes in under 8 hours. The 89% reduction in reconciliation time reflects the elimination of the manual booking-to-accounting reconciliation process, which was the single largest time sink.
Real-time revenue visibility — the executive dashboard showing live booking and revenue data — has had a secondary strategic impact: the management team's weekly business review has shifted from retrospective reporting to forward-looking planning, supported by current data rather than week-old exports.
