The Grants and Contracts (GCA) team needed a solution that modernized how they interacted with hundreds of active contracts. Their legacy system was complex, making data entry inconsistent and data retrieval difficult. For reporting purposes, other organization members had to go through the GCA team to access contract details, creating a bottleneck.

They turned to us to implement a new system allowing a consistent and intuitive overview of their contracts while simplifying reporting methods.

We implemented a solution to transform their legacy system and bolster productivity, emphasizing an easy and intuitive end-user experience. We approached this challenge using SharePoint Framework webparts integrated with a powerful Azure SQL database to display a fullfledged business application within a SharePoint site.

The app provided a concise overview of the organization’s contracts while ensuring data entry and extraction was quick yet consistent. It transformed the reporting process through a report generator functionality. We also used Logic Apps to automate contract lifecycle reporting and mandatory tracking emails.

Notable features:

• Homepage filters to search for and display contract details, with built-in contract editing functionality
• Quick view panel to provide frequently needed contract information
• Report generator to pull reports as needed or create custom report

The new system uncovered the value of shared information for our client. With our solution, they now had a single place to capture, view, and use their contract data throughout the lifecycle of an agreement. With end-to-end visibility and broader access to reporting, users now have easy and intuitive access to the information they need daily.