Case Management System at Department of Justice

Project Description

GOVERNMENT

KARIBE, the new web application solution, is composed of a database that connects not only the land registry’s 29 sections and its parents agency the DOJ but also the Treasury Department, Planning Board, Municipal Tax Collection Center (CRIM) and Permits Management Office (OGPe).

DOWNLOAD SUCCESS STORY

Department of Justice is the executive department of the government of Puerto Rico responsible for the enforcement of Puerto Rican law, the administration of justice, among other.

CHALLENGE

For prospective buyers trying to close a deal on a property in Puerto Rico, or for lawyers investigating current owners in an inheritance settlement, title searches often caused frustrating delays. Obtaining a clean certification or registering any real estate transaction required a visit in person to the specific section of the Puerto Rico Property Registry (PRPR) where the land record or deed was registered.

Download the full “Case Management System at

Department of Justice” case study.

DOWNLOAD SUCCESS STORY

DISADVANTAGES

The PRPR’s legacy application acquired a decade ago was a disconnected system individually serving each of the registry’s 29 sections, housed in 17 locations throughout the island.

The system was so complicated that PRPR could have as many as 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)

Loading...

IMPLEMENTATION

The Microsoft SQL Server 2014 was implemented over a Windows Server Failover Clustering cluster, and AlwaysOn Availability was enabled. INVID developed stored procedures for all data queries, CRUD and data business logic. Reporting Services was used for reports, receipts, and other documents generation. Reporting Services is accessed via web service to obtain a PDF instead of using a report viewer component.

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 is a single page web application that uses HTML templates. The architectural development pattern used was MVC. Jade was used for creating HTML and CSS files faster. It also uses a bootstrap framework for 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.

Cesar Miranda, Former Justice Department Secretary

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.

Mayra Huergo, Former Department of Justice Associate Secretary

DOWNLOAD OUR SUCCESS STORY

Get this awesome success study today!