Challenge
This client’s investment team faced a common challenge: too much time spent wrangling data and not enough time making decisions. Each month, they spent more than a week on manual reporting, downloading data from various providers, linking spreadsheets, troubleshooting formulas, and formatting slides. The process couldn’t keep up with the growing complexity of a portfolio managed by 16 external managers.
The client needed a solution that could be deployed quickly with minimal internal disruption — one that could consolidate data from multiple sources and automate investment reporting, while supporting granular time series analysis and real-time visibility into key investment metrics. The team’s most pressing priorities included:
- Monitor and report portfolio performance across managers and benchmarks
- Improve investment decision-making with timely, trusted data
- Manage diversification and overlap among external managers
- Automate compliance monitoring for SAA targets
Solution
They partnered with Rivvit to replace their legacy Excel models and manual processes with a purpose-built investment data platform designed for insurance asset managers.
Rivvit delivered a tailored implementation that included:
- Deployed a secure, cloud-based data warehouse supporting multi-asset portfolios, accounting, risk, and performance across the client’s underwriting companies, managed accounts, and private funds
- Integrated and normalized data from 3 underwriting companies and 16 external managers
- Launched a self-serve portal with customized dashboards and automated reports
- Delivered flexible dashboards summarizing book yield, duration, and credit quality by manager, fund, underwriting company, and asset class
- Re-engineered book yield calculations over a 30-month history, aligned with statutory reporting guidelines
- Implemented data governance and exception workflows to monitor data quality and availability
Outcomes
Rivvit automated more than 90% of the company’s board reporting process, cutting production time from over a week to less than a day. The team eliminated Excel dependencies, reduced operational risk, and gained confidence in the quality and completeness of their data.
With Rivvit in place, the client can now:
- Track SAA targets in real time
- Identify overlap and concentration across 16 external managers
- Perform time series trend analysis for any attribute or metric
- Compare book yield, duration, and credit quality across managers and portfolios
- Surface performance outliers and proactively engage with external managers
- Improve oversight with real-time validation and workflows
- Scale seamlessly to onboard new data sources and meet future needs
Today, Rivvit serves as the data foundation for the client’s investment function and a cornerstone of the company’s broader innovation story.