Providentia Wealth Advisory Ltd (Providentia), a Singapore-based fund manager and multi-family office, specializes in wealth planning, succession, and investment solutions for global clientele. As their high-net-worth clients maintain relationships with multiple private banks, custodians, and brokers, investing in a diverse range of asset classes—including equities, fixed income, private equity, and Providentia needed a sophisticated, automated portfolio management system for data aggregation, performance tracking, and risk analysis.
With the support of the Monetary Authority of Singapore’s Financial Sector Technology & Innovation (FSTI) Digital Acceleration Grant (DAG) – Industry Pilot, Providentia partnered with Optimai to enhance the Optimai Portfolio Management & Analytics System. This collaboration sought to reduce manual data handling, and offer advanced performance and risk metrics previously attainable only by large fund management firms.
Case Study
/optimai-v2/images/image-4-3.png)
Introduction
Optimai extended Avanda’s existing Investment Data Warehouse to handle the new regulatory return — and delivered the 4Q 2025 submission on schedule.
Case Study
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)
Manual Data Handling
Previously, the team was manually consolidating private bank statements, leading to inefficiencies.
Diverse Asset Classes
Clients held cash, equities, fixed income instruments, loans, dual-currency deposits, structured products and private equity. Consolidating and analyzing these varied holdings required a robust, flexible platform capable of handling complex investment data.
Advanced Performance & Risk Analytics
To offer top-tier advisory services, Providentia sought sophisticated metrics—such as net returns, volatility, value-at-risk, Sharpe ratio, and more.
Automate Data Ingestion
Optimai Portfolio Management & Analytics System established direct feeds and automated PDF parsing from multiple private banks, aggregating all asset data into an investment data warehouse. This eliminated the need for manual extraction and significantly reduced errors.
Extend the Investment Data Model
Optimai advanced investment data model transforms & checks diverse asset classes. Furthermore, error alerts and support for in-system rectifications ensure data integrity - a unique feature that helps to improve data integrity over time.
Interactive Dashboard & Metrics
Portfolio Management & Analytics System delivered a comprehensive dashboard for interactive performance and risk analysis—covering net return, volatility, downside risk, value-at-risk, Sharpe ratio, maximum drawdown, correlation, covariance, beta, tracking error, R-squared, information ratio, Jensen Alpha ratio, Sortino ratio, Treynor ratio, and upside / downside capture ratios.
/optimai-v2/images/cspv-1.png)
/optimai-v2/images/cspv-3.png)
/optimai-v2/images/cspv-2.png)
/optimai-v2/images/sc.png)
Optimai Portfolio Management & Analytics System - Interactive Dashboard
Enhanced Operational Efficiency
Automation of data consolidation freed Providentia’s team from manual tasks, allowing them to focus on value-added activities like high-level advisory work and client relationship management.
Centralized “Single Source of Truth” with Comprehensive Analytics
By unifying all assets under management in a single investment database, Providentia can conduct deeper performance and risk assessments. This data-driven approach supports more timely and informed recommendations for high-net-worth clients.
Interactive Dashboard
The investment professionals are able to gain richer insights into the performance, attribution and allocation data, through single or multi-period selections.
Natural Language Queries
Portfolio managers can pose questions on the portfolios and receive prompt data driven responses augmented by internet search.
AI-assisted Portfolio Commentaries
The system generates concise, customized summaries covering key portfolio metrics, notable market updates, and relevant company news. These summaries enable portfolio managers to prepare for client engagements with minimal effort, ensuring consistent and high-quality communication.
Following the successful Portfolio Management & Analytics System implementation, Providentia is now embarking on Phase 2, introducing a Portfolio AI Copilot with two primary enhancements:
/optimai-v2/images/pat-wd4c5.png)
Through the adoption of Optimai’s Portfolio Management & Analytics System, Providentia has established a data-centric platform for portfolio tracking, performance & risk assessment, and client reporting. As the firm advances to Phase 2 with AI-assisted insights, it stands poised to deliver even more comprehensive and timely advisory services—a critical advantage in the evolving landscape of wealth management.
“At Providentia, we needed a portfolio management solution to help us analyse client portfolios across all of our custodians and banks. With Optimai’s Portfolio Management & Analytics System, client portfolio data is aggregated and uploaded efficiently, and we are now better able to visualise client data across a range of performance and risk metrics, enabling us with deeper portfolio insights. The AI-driven capabilities enabled us to generate relevant and timely commentaries, thus enhancing portfolio reporting processes for our clients. We are impressed with Optimai’s constant motivation for innovation.”
Managing Director
Providentia Wealth Advisory Ltd
Benjamin Lee
“At Optimai, we are proud to partner with Providentia and deeply appreciate the trust and support they have shown us. Working with an organization that shares our commitment to innovation and client-centric solutions has been both rewarding and inspiring. We look forward to strengthening this collaboration as we continue empowering wealth managers with transformative, data-driven analytics.”
Ng Khim Peow
CEO & Co-founder
Optimai Pte Ltd
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.
Book a Demo