Our Work:

Reliant feels that its work history speaks for itself. Below is a partial list of our recent development efforts.

Projects:

• www.GetDocsNow.com
• NetEffect
• ProSolutions

ProSolutions

Reliant is currently engaged in a comprehensive project to build an entire suite of applications and server side code to manage a collections agency. As we do with every applicable project, Reliant is leveraging many of its existing business level components to bring the customer proven functionality without the cost of developing it from scratch.

Our customer is currently running their back office using an MS Access Application that has become inadequate as their business has grown. The customer has had to supplement the limited workflow and data storage capabilities of the Access application with paper files which track the info that Access won’t. ProSolutions' business involves many different types of correspondence and the Access application only produces a small number of documents necessary for day to day operations. The remaining documents are generated by company staff from word templates. To further complicate this problem the documents that the Access program does produce are created by Access reports. Making any change to their wording or dynamic fields requires a significant understanding of Access Reports which will require consultant hours since ProSolutions doesn’t have that skill set in house.

ProSolutions currently tracks all deadlines using a shared outline calendar which is manually updated. This approach has also proven to be problematic since busy staff sometimes fails to update the Access application, the paper file, and the shared calendar. For example, a staffer may negotiate a payment plan with a debtor and update the Access application and paper file but forget to remove an appointment to call the customer from the shared calendar. The result is that another staffer makes three attempts to reach the debtor only to finally discover that the matter has already been resolved.

Reliant was brought in to consult as to possible solutions to the problem and recommended a two front approach to the problem. Microsoft Access allows very quick and easy development of simple applications but was really only designed to perform these relatively simple tasks. Consequently, as a programmer tries to implement more complicated features such as an integrated scheduling system, the simplicity of the system actually works against him/her and makes the task extremely costly in both time and money. ProSolutions had outgrown a scope where Microsoft Access is an appropriate solution and Reliant recommended that it be replaced with a .NET 2.0 windows form application. A windows form application was selected since it would allow a much richer set of pre-existing controls and libraries to be leveraged to deliver the functionality needed while offering the best value per hour of programming time. Since the effort to develop the windows form application will take several months, however, Reliant also recommended certain critical fixes to the Access application which would make the several month wait much less painful.

The first contract was signed in November and Reliant immediately began gathering requirements for the windows form application. At the same time, Reliant programmers began making the (hopefully) short lived changes to the Access application. By the first week of February the changes to the Access application were complete and Reliant had a design in place for the windows form application.

Development commenced the second weekend of February. To date, the customers have the following functionality deployed to their offices for testing:

• Database built to hold their data running on PostgreSQL which will allow transactional and multi-user queries
• Click Once deployment. This allows reliant to “publish” a new version of the client application and have all of the clients automatically update themselves eliminating the need for IT to go to each workstation and deploy a new version of the application.
• The main client application which allows them to create and track clients (who hire company to collect debts), debtors, accounts on which debtors owe, and charges which are owed on each account. Complicated actions like the creation of a new account to be collected are done through easily understood wizards to minimize the retraining ProSolution's staff will need. The application already has most screens which will be used in later portions of the effort so that the customer can comment on the look and feel now.
• Comprehensive Auditing system which can be set to record any change to the database. In general this system will be used to track changes to financial data, but a configuration change will allow it to track any table in the database. Using this system, a system administrator can see who has changed any value on any account and can retrieve the old values if necessary.
• The client application includes integrated scheduling. If a debtor enters into a payment plan, all scheduled calls to the debtor are automatically removed. Additionally the system will automatically create appointments for automatic tasks. Any appointment may be clicked through to get at the relevant data. For example, clicking through on an appointment to call a debtor will open the debtors file and bring their information, including contact info, onto the screen.
• A Data migration application which will allow Reliant to bring all data from the currently running Access application into the new application within about 20 minutes. It is currently being used to bring current data from the Access application into the test database so that the customers can compare how accounts are represented side by side.
• Integrated Security model using user roles which will allow it to grow to fit almost any security need.

The following features are still in development:

• Automated scheduling service which will automatically advance periodic schedules and insert appointments for tasks that require them. For example, if no payment has been logged in a payment plan for a certain period of time, this process could insert an appointment to call the debtor at the 30 day overdue mark.
• Automated financial management service which will automatically append fees for recurring charges, calculate interest on principles, and maintain balances owed on each account.
• Exporting financial data to integrate with Quickbooks.
• Automated document generation using word templates. The new software will take MS word templates (which are easily modifiable by company staff) and insert data from the software to automatically generate the documents needed for almost any transaction. This approach is superior because company staff can change the wording of the templates without any programmer support and this will modify the final documents. User accounts will have signature files in the database and documents which can legally be automatically signed will be generated with signatures already in the document. This system will also automatically print the envelopes used for mailing.
• Flexible workflow system. The documents will be created within the context of a workflow system which is modifiable and extensible. The result is that adding a step to the process or allowing a new option to the staffer will require a very small amount of programmer time.
• Custom Reports. Reports are almost always the last thing written because it is helpful to know everything that the system can do before you decide what questions to ask.