Automating data operations to enable growth: How one wealth manager scaled efficiently
OMBA Advisory & Investments is a global macro manager specialising in ETF portfolio construction for family offices, high-net-worth clients and independent financial advisors. Founded in 2017, OMBA manages wealth management portfolios, runs advisory services, and operates as asset manager to three UCITS funds.
The firm chose FINBOURNE to create their core data system and power their operations as they scaled rapidly. They needed to maintain the lean, efficient team that’s core to their business model while handling data from multiple custodians across thousands of portfolios.
Variable data quality threatened growth and client trust
The firm’s multi-custodian operating model meant receiving hundreds of different data files daily from over a dozen custodians. The quality and accuracy of custodian data varied dramatically, creating significant operational challenges.
To ensure client positions were reflected accurately, they needed to identify errors quickly and efficiently for accurate portfolio analysis, trading and reporting. Without an automated, scalable data platform to power their portfolio and operations teams, tackling this data challenge would be impossible.
We knew that if we were going to scale, we needed to have a very firm grip on our data. The quality of data from custodians varied dramatically. Without an automated solution, achieving accurate portfolio analysis, trading, and reporting would be impossible.
How FINBOURNE helped
After evaluating multiple vendors through an extensive RFP process in 2022, OMBA chose FINBOURNE and signed in March 2023. After evaluating multiple vendors through an extensive RFP process in 2022, OMBA chose FINBOURNE and signed in March 2023. Beyond data quality, the standout capability was bitemporal reconciliation: the ability to backdate a transaction and move a position forwards and backwards in time. For a business built on custodian data that arrives late, gets rebooked, or gets corrected after the fact, that was critical for accurate reporting.
They deployed FINBOURNE’s cloud-native platform as their operational data hub. The implementation included migrating 1.2 million positions and thousands of historic transactions, then establishing automated workflows across 15+ custodians and thousands of multi-asset portfolios.
The platform enabled OMBA to:
Reconcile custodian data automatically
OMBA automatically ingests, checks and challenges custodian data. The firm runs a daily reconciliation process across more than 2,500 portfolios on an exception basis. On a typical day, around 50 fail to reconcile cleanly and are routed to analysts, who work the breaks directly with the relevant custodians and banks. Portfolios with unresolved breaks don’t feed into downstream reporting until they’re cleared, so a client never receives a report built on data OMBA hasn’t already checked.
That discipline has caught errors that would be hard to spot manually. During a recent transfer of a large commodity position between banks, the inbound bank had booked the inverse of the foreign exchange rate on the book cost. Left uncorrected, it would have had a material impact on the client.
Rebalance portfolios efficiently
FINBOURNE’s portfolio management system enabled the team to quickly and accurately rebalance portfolios and leverage Straight Through Processing for real-time trade execution. They also automated their pre- and post-trade compliance checks and performance calculation processes.
Deliver accurate data to clients
The firm uses FINBOURNE’s data virtualisation to provide their client portal and reporting solutions with high-quality reconciled data. Rigorous quality control prevents inaccurate data being presented to clients, maintaining trust and confidence. The LUSID IBOR system also allowed the business model and value multiple complex asset classes including equities, fixed income, private equity and carry, property, physical assets and commodities to give clients an accurate valuation of their entire portfolios daily.
Using the two-way reconciliation process allows me to filter out any contested data and check the data's lineage on a single screen. It's much more user-friendly than other systems I've used. With FINBOURNE, I know the data I present to clients is accurate and up-to-date.
You have to have your data in a good position, otherwise the results that you get back are completely untrustworthy.
Scaling capacity without expanding headcount
FINBOURNE enabled OMBA to establish a highly automated operations management framework. This allowed them to substantially increase capacity and accommodate a fast-scaling client base and AUM value, without needing to significantly expand their core team.
Thousands of positions corrected
In less than a year with FINBOURNE’s platform, the firm identified and rectified multiple discrepancies in custodian data. The team can be confident their valuation data is current, accurate and robust.
Significant time savings across operations
The operations team saves at least 2 hours daily on morning processes that previously involved manually importing hundreds of files in different formats. Monthly reporting tasks that took 10-12 hours are now largely automated. Quarterly fund reporting has been streamlined, saving 20+ hours each quarter.
My operational time in the morning has been cut by at least two hours daily. Tasks that previously took 10-12 hours monthly now happen automatically. At quarter end, I'm saving approximately 20 hours of manual work.
Faster client service delivery
Client queries that previously required 1-2 days while waiting for custodian data can now be answered same-day. The firm can pull reports immediately in professional, branded formats that maintain quality standards.
This has allowed me to pull reports and send them same day in a beautiful, laid out Excel format. Previously, trustees were waiting one to two days for data because we were so dependent on custodians.
Accelerated portfolio management
The investment team reduced their rebalancing cycle from multiple days to 1-2 days. Real-time portfolio views replace end-of-day updates, enabling faster response during market volatility.
We can check clients very quickly and make changes to portfolios within a 1-2 day cycle, which is very quick for industry standards. When there's volatility in markets and a client wants a live view of their portfolio, FINBOURNE alongside live pricing feeds can provide a very up-to-date, trustworthy view.
Reduced total cost of ownership
FINBOURNE’s data virtualization layer eliminated the need for static data warehouses and legacy data stores. The SaaS-based cloud product removed large-scale implementations and upgrade projects, allowing the firm to focus their change budget on business transformation rather than system maintenance.
Enhanced data quality and risk mitigation
The implementation of FINBOURNE identified serious data discrepancies that posed significant risk. The bitemporal reconciliation engine provides a strong handle on potential data issues that could materially impact client trading and tax decisions.
Built for innovation and flexibility
Open architecture for continuous improvement
OMBA integrated FINBOURNE with Azure Active Directory, built scheduled data load architecture using data virtualization, and established a continuous integration pipeline. This enables rapid deployment of changes to production without complex build weekends.
FINBOURNE's technical platform is robust. I use data virtualization almost daily to quickly respond to time-sensitive tasks. The extensibility of FINBOURNE's data model also offers immense flexibility in data manipulation.
From reconciled data to autonomous agents
That same clean, reconciled data is now the foundation for OMBA’s AI work. Instead of writing queries or calling APIs directly, OMBA’s team can now describe what they need in plain language and get it back. They’ve used this to build an autonomous agent that watches its error logs around the clock. It surfaces issues as they arise, summarizes them, identifies where the problem sits, suggests a fix, and flags who’s responsible. Work that used to mean a developer reading through a log file by hand now runs continuously in the background, freeing hours of development time each day. The next step is letting that agent open a ticket for a second agent to act on, with a human approval step at the end.
The investment team has applied the same approach to a different problem: building reporting on the fly. Analysts can ask for a given period’s performance and specify how they want it shown, as a chart or a table, and the platform generates it directly. What used to take hours of developer time and testing now happens in the moment a client meeting needs it.
Every query runs through a structured, auditable path. The platform isn’t generating position data or doing its own math, it’s calling FINBOURNE’s existing functions and returning what they produce, which is what keeps the output trustworthy enough to act on.
Unlike almost all of the industry, we have an exact knowledge and understanding of data reconciliation issues. This places us in a strong position to use IBOR data with future AI products and LLMs.
No vendor lock-in
OMBA wasn’t forced into a vendor-led operating model. The system’s flexibility allowed the firm to design their own screens and systems while remaining compliant. Getting data into and out of the product is straightforward, unlike many front-to-back products with lengthy onboarding and offboarding.
At the heart of operational excellence
By establishing a highly automated operations framework with FINBOURNE, the firm transformed their ability to scale efficiently. The platform’s data accuracy and operational efficiency enabled the firm to keep costs and fees low while delivering exceptional service to their growing client base.
FINBOURNE’s flexible, cloud-native architecture continues to support their expansion, providing the foundation for future innovation including AI integration and enhanced client experiences.
