About the Client
The client is an insurance service provide based in the US, offering insurance services to individuals and families.
The client’s existing “Settlement Application” managed the insurance claims and settlements, integrating with a database of the insured individuals and their family. The application used different algorithms to calculate and approve settlement amounts depending upon the claim details
The original application was developed in VB 6.0 with a Microsoft Access backend, and encountered limitations such as:
- Performance & Compatibility
- Database issues
Need help with a Microsoft.NET Application Modernization project?Contact Silicus Sales
The team who developed the original application wasn’t around anymore, so there was no technical help or documentation for Silicus development team to refer and understand the workflow. The team reverse engineered the existing source code to understand functional and technical flow, and then created a plan to migrate the code from VB to VB.NET and the database from MS Access to SQL Express.
As part of the modernization, the team implemented the following contemporary features:
- Robust, Stable and secure application development
- Enhanced Code manageability with quick error and exception handling
- Role Based Application Security
- Manage database systems with minimal code
- Retrieve large amounts of records from a database quickly and efficiently
- Ease of linking front end computers and back-end databases, thus enabling client-server architecture
SQL Server Express Edition 2008
Visual Studio 2013
The use of latest technologies i.e. VB.NET and SQL Server Express improved the overall performance of the settlement application by eliminating the portability, memory space and compatibility issues faced earlier.
Technology Compatibility & Easy Upgradation
Moving to .NET and SQL Express ensured compatibility with the larger editions of SQL Server, facilitating down the line enhancements by just having to upgrade to any of the latest editions.
Accelerated Product Development
Silicus' proven development methodologies, strong coding standards and comprehensive documentation achieved a high-quality application delivered at an accelerated rate. The platform also ensured that future updates and features could be easily added.