Discover how we transformed a custom-built contract management system by re-platforming it from MS Access to a cloud-based application. This project highlights our expertise in improving data integrity, enhancing security, and increasing efficiency through a streamlined data model, secure web application, and integrated change tracking.

Challenges:

• Outdated custom-built software for contract management (MS Access)
• Data integrity issues due to poor DB design and lack of data validation
• No multi-user access, no individual logins, no logging of user actions
• Local data and file storage, high risk of data loss or corruption

Solutions:

• Streamlined and improved data model
• A data migration tool (MS Access to Azure SQL)
• New secure web application hosted at Microsoft Azure
• Integrated change tracking for the most critical entities
• User accounts with Microsoft Single Sign-On (SSO) integrated
• A light-weight mobile version of the web app for using in the field
• Outlook Add-in for easier management of contract-related correspondence
• Comprehensive search options for easier access to the required information

Benefits:

• Significantly better system performance and data integrity
• Increased efficiency and accountability of the application users
• Major security improvements (app access, data storage, backups)
• Baseline for future improvements, new features and reports

Technologies:

Microsoft Azure Azure SQL Server Azure App Service Application Insights ASP.NET Core MVC Entity Framework Outlook Add-in Microsoft SSO

Interested in modernising an outdated application?

Let us show you how re-platforming can enhance data integrity, security, and efficiency for your business.

Contact Us

Call 07 3607 3843 or use the form below.