Limbo Loans

Clients requirement was to find the loans those were imported ino the loan originating system and not priced (hence the term Limbo Loans). These are the loans those were entered into the LOS (therefore a real loan), uploaded into clients system(s) but for some reason was not submitted or priced.

There was no mechanism for the follow up of these loans. There was no track kept of such loans. There was no information about why the loan was not submitted till now or whether they could still be submitted. Effectively these were potential loans, which were lost due to the lack of the "follow up" mechanism.

We develop the Limbo loans project with following functionalities
Searching the loan files in the file system and uploading them into the Blob server.
Check, which loan added in the Blob server, is priced by comparing it with the loan tables. If match is found then delete the loan from the blob server. If not found then mark the loan as a Limbo Loan.
Display the Limbo Loans in proper format to the user.

The logic of identifying a limbo loan was build in a component which will run on NT scheduler.

Technology:
Visual Basic 6.0 for COM, ASP 3.0, MS-SQL Server 2000.

Duration:
2 Months

Team Size:
One Project Manager and Two Software Engineers