This ongoing project involves the development and maintenance of a large system (300+ screens) to assist in the running of a medium sized collected credit company. The system was originally developed in Advanced Revelation for DOS. In 1998 a new development was commissioned to update the application to a Windows based system. The system was run in parallel during September 2000 and went live in October 2000. The new interface was developed in Visual Basic with the back end database being run on a jBase multi-valued database. The following are some of the tasks that the system performs : - Entry and analysis of new business.
- Full customer enquiry system showing current and past business including payment history, payment performance, length of business, weekly terms and arrears. This information can be linked and cross referenced to allow enquiry of related customers in the same property.
- Analysis of customers and accounts based on account criteria, address and postcode locality.
- Suite of over 70 reports to analyse company, areas and individual agent performance.
- Electronic submission of customers details to debt-collecting agencies.
- Highlighting of under-performing accounts.
- Employee and car fleet database.
- Christmas hamper order and delivery processing system.
- Cash handling, processing and analysis.
The system also provides full online graphing facilities, allowing users to quickly analyse a visual representation of a customers credit history and payment performance. In 2003 the second phase of development began in moving the back-end database to Microsoft SQL Server. This project went live in the summer of 2004. | 
