Calsoft was engaged to develop a derivatives trading analytics platform for a large German global bank.
The engagement primarily involved:
End-to-end architecture design and development, including data sourcing from multiple disparate sources [Oracle, AS400, message queues, flat file extracts, LDAP]
Staging and ODS design and development
Dimensional modelling, OLAP cubes and ETLs to integrate all components
Improved and predictable profitability of trades for institutional clients
Single version of truth for internal and external reporting requirements