Client
A U.S.-based investment bankGoal
Improve data collation and information quality for enhanced marketing and client reporting functionsTools and Technologies
Composite C1, Oracle DB, PostgreSQL, Vermilion Reporting Suite, Python, MS SQL Server, React.jsBusiness Challenge
The client’s existing investment data structure lacked a single source of truth for investment and performance data. The account management and marketing teams were making significant manual efforts to track portfolio performance, identify opportunities and ensure accurate client reporting. The time-consuming and manual processes of generating marketing exhibits and client reports were highly error-prone.
Solution
Iris implemented a comprehensive investment data infrastructure for a single source of truth and improved reporting capabilities for marketing content and client report generation.
An automated Quality Assurance process was instituted to validate the information in critical marketing materials, such as fact sheets, snapshots, sales kits, and flyers, against the respective data source systems.
Retail and institutional portals were developed to provide a consolidated view of portfolios, with the ability to drill down to underlying assets, AUM (Assets Under Management) trends, incentives, commissions, and active opportunities.
Outcomes
The new data infrastructure delivered a holistic, on-demand view of investment details, including performance characteristics, breakdowns, attributions, and holdings, to the client's marketing team and account managers with:
- ~95% reduction in performance data and exhibit information discrepancies
- ~60% improvement in operational efficiency in core marketing and client reporting functions