Fundstream helps asset and wealth managers consolidate and manage data, generate reports and build analytical models.
Before data collection can begin, vendor agreements need to be signed, a secure channel put in place and a security audit passed. We assist you with all steps of this process by tapping into our large network of contacts at the different data providers.
Data arrives in different formats and at different frequencies, and file formats can change without warning, causing loads to fail. Our data management team monitors every pipeline and contacts vendors when a data pipeline breaks.
Portfolios and instruments need to be mapped to master data records to prevent duplication, and family structures with their main members need to be configured.
Each provider sends its own classifications and transaction types, which must be mapped to your house view. We use a combination of AI and machine learning, internal rules and manual editing to ensure all records have been classified correctly and are ready for reporting.
We can integrate with any currency cross rates API which load automatically every day, allowing cross-currency conversions across every platform and portfolio. Our system also stores a full table of ISO currency codes, names, and symbols, which can be used on reports and dashboards.
Loading data gets you halfway there; the other half is automated data checks that run daily to pick up variances. Our data engineering team configures the checks to your tolerances so inconsistencies are caught early. Our system has a low code fully configurable rule builder that integrates with the data pipelines.
Fund-of-funds and multi-manager products hide underlying holdings. The Fundstream data management platform supports look-throughs with no limit to the level of drill-down. This allows classifications to be brought up to the top level.
Fundstream follows a three-tier architecture with bronze, silver, and gold layers. The bronze layer represents the raw files, the silver layer is the data warehouse where data is loaded and then validated and managed. It then gets pushed to the gold layer, which is a data mart ready for reporting and analysis.
The Fundstream data operations team sets up automated alerts and monitors pipelines that load data into the data warehouse. If a load is missing or fails, we communicate with the data provider to get new files or investigate failures.
During data loading, we run multiple validation checks to make sure there are no gaps in the data and that totals add up to expected amounts with thresholds.
Once data has loaded, the data operations team springs into action and classifies data (such as asset classes), maps transaction types to the internal house view, and links master data to create the required structures.
The reporting team creates bespoke reports based on your custom requirements, meeting your brand guidelines. The reporting system takes care of distribution to multiple channels.
Once data has been managed and checked, we set up semantic models for Power BI that can run locally or in the cloud. Dashboards can be shared across the team or customized per user.
We can build advanced calculation models such as performance (time and value weighted), compliance, and Black-Scholes valuations.
Define tables, load rules and validation checks through a visual builder, and the platform generates the pipelines behind them.
Set up and manage separate databases per client or entity, each with its own security, schedules and data checks.
Use ready-made models for portfolios, holdings, transactions and prices, built on industry best practice and extended to fit your needs.
Add your own classifiers, such as asset class, region or risk profile, with no limit on how many you create or how they are combined.
Browse loaded data, map classifications and transaction types to your house view, and review exceptions before reporting.
Configure checks for gaps, totals and tolerances that run with every load and flag variances for the team to resolve.
Don't see your platform? Let us know — we add new integrations continuously.
Ready to simplify your data operations? We'd love to hear from you.