Optimized data and on-demand analytics deliver faster business insights and better user experience for asset management firm
Client
U.S.-based asset management company
Goal
Streamline and improve data and analytics capabilities for enhanced user experiences
Technology Tools
Java, React JS, MS SQL Server, Spring Boot, GitHub, Jenkins
Business Challenge
The client captures voluminous data from multiple internal and external sources. The absence of quick, on-demand capabilities for business users was inefficient in generating customized portfolio analytics on attributes such as average quality, yield to maturity, average coupon, etc.
The client teams were spending enormous amounts of manual effort and elapsed time (approximately 12-15 hours) to respond to requests for proposals from their respective clients.
Solution
Iris implemented a data acquisition and analytics system with pre-processing capabilities for grouping, classifying, and handling historical data.
A data dictionary was established for key concepts, such as asset classes and industry classifications, enabling end users to access data for analytical computation. The analytics engine was refactored, optimized, and integrated into the streamlined investment performance data infrastructure.
The team developed an interactive self-service capability, allowing business users to track data availability, perform advanced searches, generate custom analytics, visualize information, and utilize the insights for decision-making.
Outcomes
The solution brought several benefits to the client, including:
- Simplified data access to generate custom analytics for end users
- Eliminated manual processing and the need for complex queries
- Enhanced the stakeholder experience
- Reduced response time to client RFPs by over 50%
Our experts can help you find the right solutions to meet your needs.
Explore the world with Iris. Follow us on social media today.
Data warehouse enhances client communications
Client
A U.S.-based investment bank
Goal
Improve data collation and information quality for enhanced marketing and client reporting functions
Tools and technologies
Composite C1, Oracle DB, PostgreSQL, Vermilion Reporting Suite, Python, MS SQL Server, React.js
BUSINESS 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
Contact
Our experts can help you find the right solutions to meet your needs.
Get in touchCloud Data Lakehouse for Single Source of Truth
Client
A medical devices and fertility solutions company
Goal
Establish a cloud data warehouse for a single source of truth and timely month-end activities
Tools and technologies
Azure Data Factory, Azure Data Lake, Power BI, Synapse Analytics
BUSINESS CHALLENGE
The client had multiple instances of ERPs, sales systems, and warehouses built on obsolete technology and frameworks. The existing system siloed the data, resulting in inconsistent versions of the truth. The client's finance and sales teams were struggling to reconcile data offline and feed the same back into the ERPs, causing significant delays in month-end activities. As the record systems were also not synced and legacy reports were built on the interim warehouses, line managers and executive teams were not able to extract actionable and comprehensive insights. A solution to onboard and integrate new datasets on an ongoing basis was required to support the data merger and acquisition process.
SOLUTION
A transformation strategy to transform data and BI applications to MS Azure was finalized. The transformation was executed in phases and included discovery, report rationalization and foundational build of a global system of reporting.
The solution included the data ingestion process with Azure Data Factory, data storage and processing using Azure Data Lake and Synapse Analytics, reports and dashboards with Power BI. A utility to accelerate the onboarding of new data entities was conceptualized and delivered to onboard and integrate new datasets to support mergers and acquisitions.
OUTCOMES
Iris data practitioners helped the client overcome key challenges and advanced data warehousing capabilities by:
- Establishing a "single version of the truth" that enabled data-driven decisions and timely completion of month-end and other critical activities
- Delivering analytics to cash business processes, including subject areas of sales, inventory, shipping, finance, etc., on Power BI
- Facilitating the generation of actionable, insightful reports and dashboards, allowing "self-service" consumption for the business leadership
Contact
Our experts can help you find the right solutions to meet your needs.
Get in touchSFTR solution strengthened market leadership
Client
A leading provider of market data and trading services
Goal
Support complex regulatory reporting with automated solution
Tools and technologies
Java, Spring Boot, Apache Camel, CXF, Drools BRE, Oracle, JBoss Fuse, Elasticsearch, Git, Bitbucket, Sonar, Maven
BUSINESS CHALLENGE
SOLUTION
OUTCOMES
- Generating additional revenue from extending the new reporting services to 17 firms.
- Beating the industry benchmark (~91%), achieving a higher transaction acceptance rate (~97%), and match reconciliation at the trade repository.
- Supporting a high throughput of 6 million transactions per hour which is scalable up to 10 million.
Contact
Our experts can help you find the right solutions to meet your needs.
Get in touchCompany
