Enterprise Investment Data Integration and Distribution Platform
Implementation
Our team undertook a strategic initiative to consolidate investment data from disparate sources into a centralized golden source platform using Eagle PACE. This transformative project established a robust data foundation supporting various mission-critical downstream applications while ensuring data consistency and reliability across the enterprise.
Data Integration Framework
The solution addressed several key challenges in investment data management:
Upstream Data Sources Integration
- Custodian Data Processing
- State Street: Daily positions, transactions, and tax lots
- IBT: Trade date and settlement date cash flows
- Mellon: Securities positions and transaction history
- Market Data Integration
- Bloomberg Back Office feeds for comprehensive security master data
- RIMES for index and benchmark data
- Advent Geneva for fund accounting data
- Fund Master for investment vehicle and performance returns information
Security Master Consolidation
Implemented a sophisticated security composite engine that:
- Created golden source records for all held securities
- Maintained source system lineage
- Applied field-level precedence rules
- Supported override capabilities
- Tracked data quality and exception metrics
Data Distribution Architecture
Developed comprehensive data distribution framework serving multiple downstream systems:
Trading and Portfolio Management
- Blackrock Aladdin integration for portfolio management
- CRD OMS start-of-day position seeding
- Black Mountain/Allvue Everest position synchronization
Client and Revenue Management
- Broadridge Revport integration for fee calculation and billing
- Sales Page CRM system for SMA performance reporting
- Varden Reporting for client statements and fact sheets
Analytics and Reporting
- OBIEE Intelligence snowflake data mart
- Self-service performance reporting
- Investment analytics dashboards
Technical Architecture
The implementation leveraged years of experience building information delivery solutions to build robust capabilities:
- Real-time data processing engine
- Data quality framework
- Exception management
- Audit trail maintenance
- Reconciliation workflows
Key Innovations
Several architectural innovations were introduced:
- Field-level data lineage tracking
- Sophisticated data quality rules
- Flexible distribution framework
- Comprehensive audit capabilities
The project transformed enterprise data management by:
- Consolidating multiple data sources
- Establishing golden source records
- Supporting diverse downstream applications
- Enabling real-time data distribution
- Maintaining data quality and lineage
The implementation serves as the backbone of the firm’s investment data, providing reliable, timely, and accurate data across the enterprise while supporting critical business functions from trading to client reporting.