Global Asset Management company with AuM c USD 100bn. Centralisation of retail, institutional and private wealth management businesses on a corporate data warehouse integrated with all major operational systems, web sites and business intelligence.
Top 5 global bank. Leading fund administrator with over 20,000 funds under administration on 14 platforms. Employed as Data Architects to design target data infrastructure and data feed specifications for
- Integration of client and asset data
- Transformation and normalisation of financial transactions
- Aggregation of client positions held across back end platforms
- Analysis and drill through of client holdings
- Delivery of data for internal applications and client facing web site.
Top ten UK investment house. Market leader in Index products. Use of SPUD data model for design and implementation of the corporate data repository. Integration and testing of data feeds from investment accounting systems.
Top 5 global bank. Hedge fund administration services.
- Analysis of hedge fund structures share tranches and mandates.
- Leadership in workshop program to analyse impact of integrating hedge funds into existing data warehouse strategy
- Enhancement of fund accounting interface specifications to incorporate hedge funds
Prime Brokerage data warehouse design and implementation.
- Analysis and integration of data feeds from Reuters and Bloomberg.
- Integration of multiple trading systems for equities, fixed income, delta 1, futures and options
- Integration of custody and stock lending systems.
- Delivery of reference data platform to support all other business functions; margin, risk, collateral, compliance, client reporting and client facing web sites
Leading life assurer requiring integration solution for Solvency II risk calculations. Utilised SPUD data model and data warehouse as n integration hub for multiple fund manager feeds.
Set up and implemented SPUD data warehouse for leading UK fund manager with c USD 100bn assets under management. Supports multiple third party administrators for different geographic regions and fund types. Extremely successful integration. The company has acquired other fund management companies and attributes the relative ease of integrating the acquisition to the effectiveness of the data warehouse.
Specialist High Net Worth fund manager utilised SPUD as the core data repository for the segregated and multi-manager product model. The repository supported Transfer Agency, Investment Accounting, Front Office systems and delivered portfolio information via Client and Intermediary web sites.
Leading UK fund manager selected SPUD and Business Objects as the Business Intelligence solution to support the fund administration services. Integration of GFAS Transfer Agency data with internal systems.
Specialised data architecture studies for various fund managers and hedge funds. Short assessment of data quality and coverage. Fast-track recommendations for short, medium and long term data improvements. Development of data strategies and architectural guidelines.
Data cost studies and implementation of cost reduction programs for leading UK fund manager. Involved detailed analysis of market data feeds, costs and usage at attribute level. Establishing detailed requirements and proposing and implementing changes to data vendor product mix and integration approach to reduce overall costs.