GOVERNMENT
CASE MANAGEMENT SYSTEM AT DEPARTMENT OF JUSTICE
KARIBE is our new web application solution developed for the Department of Justice of Puerto Rico. The application is a database that not only connects the land registry’s 29 sectors and its parent agencies, but also the Treasury Department, Planning Board, Municipal Tax Collection Center (CRIM), and the Permits Management Office (OGPe).
The Department of Justice of Puerto Rico is the institution responsible for enforcing Puerto Rican law, aspiring to the highest principles of equality and human dignity.
CHALLENGE
Be it for a prospective buyer trying to close a deal on a property in Puerto Rico, or a lawyer investigating current owners in an inheritance settlement, title searches were often the case of frustrating delays. Obtaining a clean certification or registering any real estate transaction required an in-person visit to any of the locations of Puerto Rico’s Property Registry where the land record or deed was registered.
DISADVANTAGES
Puerto Rico’s Property Registry had a decade-old system that served sectors individually without a centralized place to access the information. Likewise, the system was extremely complicated with over 300,000 documents waiting to be processed, resulting in loss of revenue as lawyers withdrew documents before they were registered.
FACTS
THE SOLUTION
BENEFITS
NEW AND POWERFUL INTEGRATIONS
The new Puerto Rico Digital Registry now connects:
Land registry’s 29 sections
It’s parent agency the DOJ
Treasury Department
Planning Board
Municipal Tax Collection Center (CRIM)
Permits Management Office (OGPe)
TECHNOLOGIES
CLIENT
HTML5
CSS3
Bootstrap
Javascript
Backbone
Node
Jade
JSON
JQuery
API
RESTful API architecture
.Net, C#
Entity Framework
LINQ
JSON
TOOLS
Microsoft Visual Studio
Microsoft SQL Server
Reporting Services (SSRS)
IMPLEMENTATION
For this project, we implemented the Microsoft SQL Server 2014 over a Windows Server Failover Clustering cluster, while the AlwaysOn Availability was also enabled. INVID developed stored procedures for all data queries, CRUD and data business logic. Reporting Services, a web service used to obtain a PDF instead of using a report viewer component, was implemented for generating reports, receipts, and other necessary documents.
The API application is hosted on a dedicated IIS server web farm with load balancing. All data is transmitted using JSON format.
Karibe’s web application is hosted on another dedicated IIS server web farm with load balancing. It’s a single-page web application that uses HTML templates with MVC as its architectural development pattern. Jade was also used to create HTML and CSS files faster. It uses a Bootstrap framework for a responsive adaptation to mobile or desktop browsers. Cloud Backup is provided by Microsoft Azure to protect data and critical applications in case of natural disasters.
THE IMPACT
TESTIMONIALS
This project not only means a significant service improvements for citizens, lawyers, financial institutions and other government agencies, but it also has the potential of increasing revenue by allowing us to capture approximately $5 million that were lost annually due to inefficiencies.
The system now streamlines processes and automatically assigns cases preventing arbitrary selection of documents presented for processing. Registrars access documents pending their approval with their digital fingerprint.
DOWNLOAD OUR SUCCESS STORY
Get this awesome success study today!