Inbound financial statements from providers loaded into the system
An example application quickly developed to manage financial services commission payments and debt collection for a number of large financial networks in administration post financial crash and the end of commissions based services. The system supports the processing of 100,000s of transactions (guiding, rating, splitting etc.) and creation of 1000s of invoices (statements) with admin functions to enable maintenance. This data can then be used for a debt collection process with all the inherent tasks to chase, produce formal letters, court documentation and production of audit reports. The core of the system lies in a Microsoft SQL Server database with extensive use of Stored Procedures, SQL Server Integration Services (SSIS) and SQL Server Report Services (SSRS). The WEB based user interface has been built in Ruby Rails with a layer of WEB servers communicating via application servers to the database. The user interface performance is fast, even over a poor internet connection, searches across > 50,000 agency numbers taking less than a second.