Portfolio Project: Contract Management System

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

Contact Us

Call 07 3607 3843 or use the form below.