Optimai extended Avanda’s existing Investment Data Warehouse to handle the new regulatory return — and delivered the 4Q 2025 submission on schedule.
CUSTOMER CASE STUDY · MAS REGULATORY REPORTING
CLIENT
AVANDA
Asset manager · Singapore
SOLUTION
Investment Data Warehouse
extended with RAAE
OUTCOME
4Q 2025 QDC filed
on schedule, auditable
SECTOR
Fund Management
MAS-regulated
/optimai-v2/images/image.png)
CUSTOMER CASE STUDY · MAS REGULATORY REPORTING
The Monetary Authority of Singapore introduced Quarterly Data Collection (QDC) as a new mandatory return for licensed fund management companies. It spans multiple sections drawing on data from custodians, brokers, and accounting systems that rarely speak the same language.
Standing up a new regulatory return on a fixed deadline is the kind of problem that exposes how scalable a firm’s data infrastructure really is. Where the underlying data layer can be extended cleanly, a new return is a few weeks of incremental work. Where it cannot, firms either rebuild parts of their stack or fall back to spreadsheets — estimated at two to four weeks of manual effort each quarter according to industry survey, with the corresponding error and audit risk.
Avanda Investment Management, a Singapore-based asset manager, already used Optimai’s Investment Data Warehouse as the foundation for its day-to-day data and reporting. The question for the new MAS return was not how to build it from scratch — it was how quickly the existing platform could be extended to handle it, in time for the 4Q 2025 submission window.
CUSTOMER CASE STUDY · MAS REGULATORY REPORTING
Optimai extended Avanda’s existing Investment Data Warehouse with a QDC reporting application — built on Optimai Rapid Application AI Expert (RAAE). RAAE is Optimai’s AI platform that generates new modules, data structures, and analytics, and even entirely new secured enterprise applications in days or weeks rather than months.
The QDC application reuses the consolidated portfolio, position, transaction, and reference data already curated in the Investment Data Warehouse, maps it to the MAS QDC structures, enriches it with Bloomberg reference data, validates it against the previous quarter, and produces a submission-ready file for the MAS-Tx platform.
The Optimai template leverages data from the Investment Data Warehouse system and significantly streamlined the data population process compared to our previous spreadsheet-based approach. The team has been very receptive to our feedback, demonstrating patience in addressing our comments and providing prompt responses to queries.
Finance and Operations Director
Avanda Investment Management
Winston Choo
CUSTOMER CASE STUDY · MAS REGULATORY REPORTING
The QDC application sits on top of the Investment Data Warehouse and turns the return into a six-stage automated pipeline. Each stage is configurable, observable, and rerunnable — so when source data changes, only the affected steps need to repeat.
01
Ingest
Pull from custodians, brokers, accounting
02
Transform
Map to MAS QDC structures
03
Enrich
Bloomberg reference & classification
04
Rectify
Catch issues; remember fixes
05
Report
Submission-ready CSV for MAS-Tx
/optimai-v2/images/05-4.png)
/optimai-v2/images/01-o1599.png)
/optimai-v2/images/03-5.png)
/optimai-v2/images/04-5.png)
/optimai-v2/images/02-f2c5c.png)
THE RESULTS
Avanda submitted its first MAS QDC return for 4Q 2025 on schedule, filed against a controlled, auditable data set rather than a manually assembled one. The same Investment Data Warehouse foundation that supports day-to-day data and reporting now also carries the new regulatory return — without parallel pipelines or duplicated logic.
MAS QDC questionnaire is populated end-to-end from Investment Data Warehouse data.
Delivered as a RAAE-driven extension — no rebuild of the underlying platform was required.
Full audit trail — every figure traceable to its source system — sits behind every submission.
Validation catches missing classifications and data gaps before they reach MAS; once an operator resolves an issue, the fix is captured and re-applied automatically every quarter after — and stays editable when the right answer changes.
WITH OPTIMAI VS. SPREADSHEET WORKFLOW
/optimai-v2/images/table-4.png)
WITH OPTIMAI
WITHOUT — SPREADSHEET WORKFLOW
Investment Data Warehouse
Incremental — only changed stages re-run
Pre-flight, remembers fixes across quarters
Every figure traceable to its source
Another RAAE extension on the same data
Spreadsheets assembled per quarter
2–4 weeks of manual work
Eyeballing, ad-hoc reconciliation
Files, emails, screenshots
Another bespoke build
Source of figures
Effort per submission
Validation
Audit trail
Next new return
WHY THIS MATTERS FOR MAS-REGULATED FIRMS
The firms that absorb a new return cleanly are the ones whose data foundation can be extended — not the ones that have to rebuild around each new requirement.
Avanda’s 4Q 2025 QDC submission landed on the same Investment Data Warehouse that already powers its day-to-day reporting, with RAAE doing the heavy lifting on the new application layer. The next return — and the one after that — starts from the same place, not from scratch.
/optimai-v2/images/image-2.png)
ABOUT OPTIMAI
Optimai builds investment data infrastructure for asset managers, wealth managers, and brokerages across Asia. Our Investment Data Warehouse gives regulated firms a single source of truth for portfolio, position, transaction, and reference data. RAAE extends that foundation — adding new modules and rapidly delivering entirely new secure enterprise applications. Our Wealth Insights Platform draws on the same warehouse to produce automated portfolio commentary that reads like letters, not numbers — rich analytics woven together with house views and market news.
optimai.com →
TALK TO US
Book a Demo