Loan origination and service system (Best Finance, Inc.)
The ultimate goal was a complete system, written in C# and SQL Server. Since those aren’t our primary development tools, we looked for ways to leverage our skills in ways that would help us, and also help their internal developers. In addition, the existing system had some issues that could be improved, if not solved entirely, while the new system was under development.
Ultimately, we built custom code generators for C# classes, and SQL definitions and stored procedures, prototyped some Windows custom controls in C#, and mocked up some user interface prototypes; laying a design and infrastructure foundation so the final development could be done in-house.
We also created a number of interim tools (a.k.a. band-aids) to help users, while main system was being developed.
- Simple Amortization schedule
- Simple Interest Calculator
- Clipboard quick-paste utility
- Automation for existing credit card processing software
- Mail Merge System update - The old system used WordPerfect and custom file formats and required manual mail merge input. The new system uses MS Word, uses existing data format, and added a UI for complete merge visualization and automation.
- Redraft system handler - replaced paper process for failed payments that needed to be reprocessed.
- Interest Calculator - REBOL - The first utility we built was a quick interest calculator. We did a REBOL version initially.
- Interest Calculator - C# - Then did a version in C#.
- Amortization Schedule - The Am. Schedule was done later, but turned out rather well.
- Mail Merge Controller - The front end for the mail merge process concealed all the details of data import/export, file formats, and automation control of Word.
- Credit Card Software 'Extension' - This utility was just four buttons on a screen (not shown here). The help tells you what each one did. Most small utilities had a built-in help screen like this.
- Clipboard Utility - Users could create their own text snippets for hot-key access via the clipboard. Very handy since they had to enter certain information in different programs in specific formats.
- Reprocessing Manager 1 - This was written to replace a manual, paper-based process.
- Reprocessing Manager 2