Xtreme was engaged by Microsoft Financing (MSF) to eliminate the massive workload that required manually validating, importing, processing, and reconciling transaction data for hundreds of thousands of financing deals, and to integrate these files with Microsoft internal management and reporting systems.
Making it happen
Over the course of eighteen months, Xtreme developed a new “FeePlus” system that leveraged formatted data from De Lage Landen (DLL), a global provider of leasing, business and consumer finance solutions, in the very large OMNI data warehouse. The client required that all data be migrated to a dedicated FeePlus database. The integrity of this data was critical, as the data in the new FeePlus data base provided decision support for over $50 million in monthly transactions.
The migration proceeded according the plan and the new FeePlus system stores status information about each of the 100,000 financings with both DLL and Microsoft. The system is aware of other databases in the OMNI DW universe and continuously correlates business checks in that system against FeePlus data.
Technologies used included: SQL, ASP.NET, SSRS reports.