A Customer Relationship Management tool is the core product we are delivering to the NCC. However, we have to amalgamate existing systems in order to get the data and bring in new technology or products to deliver this project. Below is the architecture we have been working on for this project.
NCC Call Script - Hackney's custom front-end application delivered using latest technologies such as Angular.
Hackney NCC API - Middle tier for all interactions from font-end to back-end applications and integrations to other systems will be done using our APIs. APIs are developed using C#, MVC and Swagger using Test Driven Development as a methodology. We are also reusing a lot of existing Hackney APIs developed from other projects such as Pay My Rent and Manage-a-Tenancy making sure we are not rewriting any APIs.
GOV.UK Notify - We are using GOV.UK Notify for Email, SMS, and Post functionality for this system.
Paris - Hackney's online payment system built by Northgate.
Microsoft Dynamics CRM 365 - We are extensively using this On Cloud Microsoft CRM system, which holds all the clean Universal Housing (UH) data and will eventually replace some aspects of UH. We are avoiding any direct calls to UH except notes data, which the back office team requires for business continuity.
Universal Housing (UH) - The existing housing back-office system that will receive alerts; required NCC data from UH will be imported to CRM 365 on a daily basis.
Qlikview - A business intelligence system providing data analytics of all the calls recorded from the NCC call script that will be grabbed from a Microsoft Azure SQL Server. Zappysys is used to migrate the data to the replica database for reporting.
Microsoft Azure SQL Server Replication - On Cloud; all data from the main CRM is replicated on each update so that Business Information can pull data as and when required without hindering the main CRM application performance.
cete Dynamic PDF - PDF generator software for printing or emailing rent statements to callers.
Puzzel - Telephony system for the NCC. This will not be part of this MVP but we may integrate it with our application at some point.