About the Client:
Client was created by an Act of the State Legislature on March 15, 1738/39 separating it from Hunterdon County, one of the state’s largest counties of the period. There are 39 municipalities in the 477.8 square mile county, varying in size from tiny Victory Gardens Borough with 1,314 residents to Parsippany-Troy Hills Township, with almost 48,500 residents. All together more than 421,000 persons reside in the county
Background:
Client county manages 39 municipalities which falls under different programs such as historic preservation, open space, flood mitigation, farm lands, trail construction, PresTrust Admin. Each program has 1 program manager who will interact with several municipalities for assigning the projects. The bureaucratic work carried out internally, was still paper driven and required physical documentation. Client was looking for a single one stop platform to manage all the documents which it receives from several municipalities.
Challenges:
Client has been facing a three-pronged challenge with their Visual Analytics
- Cumbersome approval practice
- Multiple audience at different location with disparate systems
- Issue with missing documentation
Approach:
- Right Angle Solution Business Analyst and consultants approached different business functions (Programs) in Morris County to understand their issues
- Define a target architecture and data model for a complete data strategy
- Recommend tech stack for building a web-based application
- Gave a high-level estimate of effort, cost and timeline for building a web-based application in phases
- Finalized the proposed solution with the client after few discussions
Framework Used
Angular 12+
Authentication Service
IdentityServer4
APIs Used
SendGrid’s Email API, ArcGIS API
Architecture
Microservice
Tools Used
Dapper
Solution:
- RAS developed web interface using Angular 12+ web framework
- RAS used IdentityServer4 authentication service where clients requesting tokens at the token endpoint and APIs validating references at the introspection endpoint.
- CQRS with Mediator pattern has been implemented to solve complexity while injecting multiple API controllers.
- Object Relational Mapping (ORM) tool Dapper has been used to quickly and easily access data from database without need to write tedious code.
- Microservice architecture has been implemented in order to achieve scalability improvements, improved isolation, reusability across different areas of business and simpler to deploy.
- RAS used SendGrid’s Email API to build transaction email communications.
- RAS uses ArcGIS API to pinpoint properties and openlands
- RAS used Microsoft SQL Server as a database to achieve faster query processing, highly interactive, portability.
Outcome:
- Single point of contact between municipalities and the program manager
- Central data infrastructure with a web application as top layer to store all the documents at one location
- Ease of access for municipalities and client’s program manager