Tanmoy Roy.
← Projects

Single family investment office · Public securities, private equity and hedge funds

My role: Product owner and senior consultant

One operating model across public and private investments

Bringing analytics, trading and accounting together so the family office sees the whole portfolio in one place.

3
asset classes joined up
4
core systems integrated
1
operating model
  • Sophis
  • FactSet
  • Cobalt
  • Prospero

From

SophisIn-house tools

To

FactSetCobaltProsperoData warehouse

The situation

Investments were run on a mix of Sophis and in-house tools, while new systems for analytics, private equity and accounting were arriving at the same time.

What I did

  • Acted as subject-matter lead for integrating brokers, custodians and market data with FactSet, Cobalt and Prospero.
  • Wrote the requirements for a whole-portfolio returns engine (Modified Dietz) covering equities, fixed income, FX, derivatives, cash, hedge funds and private equity.
  • Built the target operating model: process maps, responsibilities and data flows into an operational data warehouse that feeds reporting.

By function

Front officeMiddle officeBack officeFactSetCobaltProsperoData warehouseOne agreed data flow from trade to accounting

Operating model

Who does what, with which data

Process maps, responsibilities and data flows across FactSet, Cobalt and Prospero, feeding one data warehouse.

What changed

Before · 01

Sophis plus in-house tools

After

FactSet, Cobalt and Prospero working from agreed data flows

Before · 02

Public and private books reported separately

After

Performance, holdings, risk and accounting from one source

Before · 03

Unclear ownership across teams

After

Front, middle and back office on one operating model

Facing something similar?

Operating model, data & AI readiness

For making the stack you already own work harder.

Start a conversation

More engagements