Enterprise Platforms Success Story

Microsoft Data Warehouse for Asset Securitization Reporting

Business Situation

• The client is a leader in fleet management, grossing more than $1.5 billion in sales.
• The fleet management operations include procuring vehicles, managing the leasing contracts, fueling the vehicles and handling the maintenance with the lowest possible cost to customers.
• The client decided to securitize the thousands of vehicles they purchase to obtain a better interest rate. The securities are subject to numerous public reporting requirements.

Key Issues

• The field of asset securitization has developed many ways to characterize the value of securities, resulting in numerous unique and complicated financial formulas. These formulas can change on a bi-annual basis.
• The client’s data warehouse design had to be flexible enough to accommodate these future changes.
• The previously existing manual process reached into many disparate source systems. 
• Since the previous system was manual, there was significant risk for pulling the wrong values – specifically, the auditors had expressed concern with the reliability of the manual system.

Outcomes

• The time required by the users to compile the monthly reports was reduced from seven business days to one business day.
• The users now know where to go for correct and consistent values.
• The improved data warehouse has such accurate and clearly labeled values, that internal applications are being rewritten to pull their values from the warehouse.