15th November 2023
Client
Brent’s Local Authority
Department
IT & Transformation
Project
Integration of Registration Processes using the GovService Platform
Background
Before our involvement, the registration service relied heavily on cumbersome manual processes, managing their operations through a maze of 10-15 spreadsheets. These spreadsheets encompassed crucial functions such as payment management, and certificate records (including allocation, non-allocation, and spoiled certificates), all of which contributed to significant delays and backlogs within the system.
Our brief
JBM Digital was tasked with overhauling the registration service’s operations, focusing on integrating registration processes using the GovService platform.
What we achieved
- Development of New Forms with Integrated Database Connections:
- We engineered a suite of new forms seamlessly connected to a centralized database, streamlining the registration process.
- Enhanced User Experience:
- Our solution enabled the registration office to efficiently handle user requests and process them promptly.
- Efficient Data Storage:
- Applications were systematically stored within the database, facilitating quick retrieval upon customer request.
- Accurate Information Management:
- Our system ensured the meticulous tracking of essential information, including dates, payments, and application statuses.
Administrative Control:
- Creation of Additional Administrative Forms:
- Supplementary administrative forms were developed to manage spoiled certificates and maintain stock records, offering comprehensive oversight.
- Integration with Microsoft Power BI:
- The database was seamlessly integrated with Microsoft Power BI, enabling the creation of interactive dashboards that replaced outdated spreadsheets.
- Cost Savings and Efficiency Gains:
- Our streamlined solution resulted in substantial cost savings, with £10,000 saved in software licensing fees alone. Moreover, manual labor and operational efforts were significantly reduced.
- Administrative officers were granted access to process applications, update statuses, and facilitate refunds, enhancing operational efficiency.
Our meticulous approach modernized the registration service and revolutionized its efficiency and cost-effectiveness. By seamlessly integrating digital solutions with administrative processes, we have set a new standard for operational excellence within Brents Local Authority’s IT & Transformation department.
Contact JBM Digital to streamline your business today.