PSA from The Software Practice: Please be careful about your online privacy
Members of the public have alerted us that they’ve received suspicious calls and text/whatsapp messages from people claiming to be from The Software Practice. Our initial correspondence will be via Email or a phone call - never via SMS or Whatsapp. If in doubt, please contact us here to verify the legitimacy of a job advertisement or any person attempting to reach out to you.
For more information on this type of scam, please refer to: https://scamalert.sg/scam-details/job-scam.
Case Studies

Business Rules and Routing Engine with Geospatial Information System (GIS) Integration

Client
Our Contribution
Design and development of system with business rules and routing workflow engine based complex enterprise Geospatial data
Technology
.NET Core; VueJS; Fortify; Enterprise Geospatial Information System (eGIS)

THE QUICK LOOK

The system is a case management system to streamline and automate the routing and responses of cases submitted to the Government Agency.

The System is managed by a bespoke workflow and business rules engine, to automatically route case submission to the appropriate department and automatically generate consultation responses through a set of pre-defined business rules, which check against over 100 Geospatial Information System (GIS) layers.

Public Sector
Business Rules Engine
Routing Engine
Geospatial Information System (GIS)
CICD
DevOps

THE CHALLENGES

The existing case management process was managed through manual activities and use of numerous excel spreadsheets. The as-is process was inefficient and time consuming, through the use of excel formulas, and sharing of documents among various Agency departments and stakeholders. Collaboration through these manual processes were made even more tedious as users had to manually obtain, review and consolidate responses from various departments. The lack of a system also meant that tracking and monitoring of the case management may be inaccurate and often time consuming.

The system was to be hosted in the Government Private Cloud (GPC), which meant that pre-deployment activities – reservations, approvals and etc – had to be planned in advance to avoid bottlenecks and delays.

SOLUTION

Our newly designed case management system, which was tightly integrated with the Agency’s Geospatial Information System (GIS), streamlined and automated the routing and responses to cases submitted to the Agency.

For every consultation case, the system checks against over 100 Geospatial Information System (GIS) layers and then based on the type of case and mapping rules, the case will routed to specific user groups for processing. These routing rules are all user-defined and can be hierarchically applied.

The end result of this process was the automatic creation of case replies, where the system consolidates consultation notes and recommendations made by various Officers, together with approval or rejection remarks. Each reply is typically between 6 to 10 pages long.

Dashboard and reports made available in the portal also allowed the Agency’s management to track and monitor outstanding cases efficiently and effectively.

To streamline the complex deployment processes in the Government Private Cloud (GPC), we even created a bespoke Continous Integration and Continuous Delivery (CICD) pipeline, as part of our continued focus on DevOps.