Client type
Large corporate trust business
Key stakeholders
Multiple business lines
Location
Global
Project outline
- Our client required a streamlined process for accessing and managing their CMBS Investor Reporting Package (IRP) data across their portfolio of deals.
- They faced significant operational challenges pulling comprehensive monthly IRP data for over 70 active deals. In addition, they needed to add new deals at a minimum rate of 2 per month. The aim was to create an operational data store that seamlessly handles backdated data and enables efficient SEC financial reporting and portfolio monitoring.
The Challenge
Our client, a global leader in the Commercial Mortgage-Backed Security industry, reached a critical stage in their data management journey. Specifically, they needed to extend their reporting and portfolio monitoring processes to meet growing SEC requirements. They required complete monthly IRP data for all deals within days of payment dates in their data store.
Moreover, this included historical data dating back to the issuance of their active deals. Internal technical bandwidth challenges further complicated this data timeliness requirement.
Unfortunately, existing market data options fell short of their overall vision. These solutions could not provide a consistent replica of IRP data crucial for their financial and monitoring excellence. Furthermore, they managed a large and growing portfolio of over 70 deals. They added 2 deals each month. Therefore, they required a robust and scalable data solution.
How StructureIt helped
Our client needed a thoughtful technology partner focused on delivery and accuracy. First, StructureIt kicked off the project by providing strategic planning. The team focused on our client’s vision and specific business needs.
As a starting point, the goal was to capture raw IRP files from trustees. This would collect all key data points. These included deal, bond, loan, property, financials, watchlist, REO (Real Estate Owned), and Delinquent Loan Status Report (DLSR).
The second step ensured data integrity. StructureIt implemented robust data movement controls to detect any modifications in transit. Then, the team worked on cleaning and normalizing IRP data. This included all historical data for each deal. As a result, this facilitated seamless integration into their operational data store.
To future-proof their operations, they also opted for a secure API delivery system. This ensured easy and reliable data access. Ultimately, StructureIt completed the first phase of this transformative CMBS data management automation project in just four months.
The Results
Our client’s initiative yielded impressive results. Specifically, it cemented their position as commercial real estate and credit market leaders. They praised the quality of the data. Indeed, they noted it surpassed all competitive standards of accuracy and reliability.
Moreover, their newly created operational data store significantly reduced time and effort. Consequently, our client can now focus on strategic business growth. The CMBS data management automation solution now processes over 70 active deals. Furthermore, it delivers complete monthly IRP data within days of payment dates.
In addition, the system handles historical backdated data seamlessly. This enables efficient SEC financial reporting and portfolio monitoring. The scalable architecture supports continuous portfolio growth. Thus, it easily accommodates 2+ new deals monthly.
The results demonstrate clear operational improvements:
- Processing capacity: Over 70 active deals managed efficiently
- Data delivery speed: Complete IRP data within days of payment dates
- Data accuracy: Surpassed all competitive standards
- Time savings: Significant reduction in manual effort
- Scalability: Seamless addition of 2+ new deals monthly
Collaboration, on your terms
We collaborate with you to develop personalized software solutions that contribute to your business growth in the capital markets
