P R I M E

Capital Markets

Fund Management

Banking

FinTech

About Us

Technology

How Avanda met MAS’s new QDC deadline without rebuilding its data foundation.

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

CUSTOMER CASE STUDY · MAS REGULATORY REPORTING

A new mandatory return that exposes
how scalable a firm’s data layer really is.

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

A RAAE-driven extension on top of the Investment Data Warehouse.

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.

Quote Open Block

Finance and Operations Director
Avanda Investment Management

Winston Choo

CUSTOMER CASE STUDY · MAS REGULATORY REPORTING

Six automated stages, end-to-end.

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.

arrow3
arrow3
arrow3
arrow3

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

THE RESULTS

One foundation. Day-to-day
reporting and regulatory return.

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

Why the foundation matters.

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

Regulatory returns rarely
arrive one at a time.

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.

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