Depowise logo

Depowise Core

  1. Fund Industry
  3. Data Warehouse

Key modules for our clients

Order Management System

Investment Limit Checks

Full NAV Reconciliation

Data Warehouse

Managing a convoluted system

The operational model of investment managers is gradually becoming more elaborate due to changes in compliance regulations and numerous 3rd party fund service providers being used by the industry. Multiple jurisdictions, master-feeder structures, a wide range of custodians and sub-custodians, a variety of instruments, outsourced services (e.g. management company and administration) all contribute to the ever-increasing complexity. In this industry, the most valuable asset of any investment manager is their data.

It is quite common for investment managers to rely primarily on data received from partnered 3rd parties. Administrators provide a dataset for each calculated NAV, but usually, these files end up only as historical entries in a server, rather than being actively leveraged for operational advantages. A data warehouse has become a “must–have” component for fund managers with a complex product setup and/or multiple/out-sourced administrators with different IT solutions and reporting formats.

Data Warehouse (DWH)

Depowise DWH provides fund managers, management companies with a sustainable way to store, archive, and process data for various reasons. Our solution can read administrator NAV reports, custody/bank statements, and market data in all different formats and standardizes them into one master format.  All your post-NAV data processing activities will be based on one single format providing efficiency and scalability.

Depowise will also act as your securities master data solution as you will be able to handle all your reference data in one, proven platform.

Depowise DWH is a mandatory component of our suite of business modules. Shadow NAV, OMS, Investment limit monitoring all operate on top of Depowise DWH. But there are also other use–cases for our DWH to provide value to its users: 

  • DWH combined with MS Power BI provides a powerful platform for in–house reporting. Our interface has a designated tool for custom report format creation and generation. 
  • Often fund managers need to supply fund–data to different providers – market data aggregators, investors, providers of investor reporting services, KIID provider, risk analytics systems, etc. You will be able to create custom output formats and automate the data flow to your providers across all your funds at once. 

Depowise DWH will also play an important role in mitigating your operational risks. You will always have your data under control despite any service breakdowns your partnered providers might face. With historical data in your DWH, you will be able to switch service providers or switch/upgrade internal operational systems without having to deal with the migration of historical data. 

External Integrations and Data Standardization

Depowise is a modular end-to-end IT platform built on a modern and extendable system architecture – microservices. With Depowise, adding new functions, checks, reports, etc. requires no effort and has minimal effect on the existing setup.
We have established a proper ETL (data extract, transform, load) solution that is the basis of all integrations. Our ETL tool allows Depowise to rapidly and securely add new integrations with any counterparty. All ETL and business processes are supported by a comprehensive log and audit trail, ensuring nothing happens without traces stored in the system history. 

Depowise ETL  is split into two areas (staging and production) that separate the aggregating and processing of data from daily business processes. With such a split, we provide step-by-step data lifecycle management options and transparency for each data object and guarantee that all business processes are run on cleansed, validated, and standardized data. No Depowise business operations and reports are run on preliminary and unproven data. 

Positions, cash, prices/rates, fees, other assets/liabilities, and securities data received from multiple providers and in different formats are eventually standardized into a single master format. 

With each implementation project, we add adapters with new administrators, custodians, and banks. Depowise uses industry standards like SWIFT 535, 536, 537, and MT940 to exchange data with custodians and banks. GP3 and other systems have integrations with Depowise for exchanging data with administrators. We have existing active integrations with Bloomberg, KIID providers, and market data aggregators. Our growing third-party provider ecosystem helps enable seamless interoperability with your preferred risk analytics, data, applications, and liquidity venues, directly from our platform.

Contact Us

Fill out this field
Fill out this field

Want to see the benefits of using Depowise with your own eyes?

Give us two weeks and we will use the data from one of your funds to create a solution. Interested? Send us a message and we can start now.

  1. Fill out the contact form.
  2. We will contact you within a day to discuss the next steps.
Menu