CloverLeaf Solutions specializes in Projects

"CSI staff took extra time to really learn the business requirements...
CSI is extremely proficient at system design and produces an excellent product.
I would recommend CSI to any business."

Jane Tucker, Section Manager (California Department of Justice/BCII)

CloverLeaf Solutions specializes in developing and delivering state of the art multi-tiered computer systems to various agencies within the State of California.

Methodology Focus

Our methodology is simple in concept, and incorporates industry best practices and standards for software development. We divide the big problem into several smaller problems and then iterate the methodology for each of the smaller problems during the project’s lifecycle. We take a highly disciplined approach that ensures the methodology is executed appropriately.

Disposition Processor

State of California · Department of Justice (BCII)

"The Disposition Processor is such a powerful tool that processing time has been cut drastically, transactions are being processed more efficiently and our existing backlog has been eliminated."

David Woo, Section Manager (California Department of Justice/BCII)

Overview

The Disposition Processor processes records for dispositions of arrests and court actions. Disposition records are received from the various courts and law enforcement agencies throughout the state of California. The following components automate all of the disposition work for the Department of Justice.
· Disposition Processor
· Disposition Research Processor
· Dismissal Processor

Benefits

These systems automated a largely manual process that was costing the Department of Justice many hours of overtime.

Technologies

The application was developed using MVC architecture and included JSP, AJAX, jQuery, Struts, Java Beans, Java, XML/XSL with an Oracle database and Jetty Application Server. CloverLeaf's CLETS Gateway is used for Criminal History queries.

PERT Workshops Registration

State of California · CalPERS

The Public Employer Readiness Team (PERT) Workshops Registration application was quickly developed to solve an urgent business problem: registering agencies for workshops.

Overview

CalPERS is implementing a new system that will extend the self-service capabilities of their existing site for both members and employers. As part of the process for providing awareness and training for the new system, CalPERS is holding workshops for the participating agencies. A new registration application was needed to:
· Allow the agency to enter attendee information (up to 4 attendees)
· Display a list of available workshops
· Update the list of available workshops as registrations progress
· Provide registration information to the workshop leaders (rosters, etc.)

Benefits

The original process was manual. Phone calls and/or emails were used to gather registrations. Automation provides more accurate information, and makes the process easier for both agency registrants and workshop leaders.

Technologies

The application was developed using the existing CalPERS On-Line architecture and included JSP and Javascript for the user experience, ASP to generate the administration pages, with a MySQL database.

Automated Record Error Correspondence

State of California · Department of Justice (BCII)

The Automated Record Error Correspondence Processor automates the previously manual, labor-intensive, paper-based update process for correcting Criminal History records.

Overview

The Automated Record Error Correspondence Processor automates the previously manual, labor-intensive, paper-based update process for correcting Criminal History records.

Benefits

AREC off-loads the manual workload of entering corrections received by paper from law enforcement agencies to the law enforcement agencies.

Technologies

The application was developed using MVC architecture and included JSP, AJAX, jQuery, Struts, Java Beans, Java, XML/XSL with an Oracle database and Jetty Application Server. CloverLeaf's CLETS Gateway is used for Criminal History queries and updates.

Subsequent Arrest System

State of California · Department of Justice (BCII)

"CSI staff took extra time to really learn the business requirements...
CSI is extremely proficient at system design and produces an excellent product.
I would recommend CSI to any business."

Jane Tucker, Section Manager (California Department of Justice/BCII)

Overview

CloverLeaf designed, developed, tested and implemented a system to assist the Department of Justice in providing subsequent arrest information to agencies that have provided licenses to applicants. Agencies are notified of subsequent arrests using e-mail, ftp, CLETS and/or US Mail.

Benefits

This system automated a largely manual process that was costing the Department of Justice many hours of overtime. Californians are also safer because...

Technologies

The Subsequent Arrest System was developed using a combination of Pro*C, Java, Oracle and PL/SQL/ stored procedures. CloverLeaf's CLETS Gateway was used for Criminal History queries.

Criminal Processing System

State of California · Department of Justice (BCII)

"CloverLeaf staff took the time to fully understand our business needs, and to translate those needs into a tool that more than met our expectations. The Criminal Processor has proven to be completely reliable with virtually no down time."

Darren Frame, Administrator (California Deptartment of Justice/BCII)

Overview

CloverLeaf developed a post processing system for criminal finger print cards. The system provides back-end processing including:
· Automated CLETS inquiries
· Automated Criminal History & VCIN updates
· Automation of DNA collection
· Data Validation & Error Resolution
· Reporting

Benefits

This system automated a largely manual process that was costing the Department of Justice many hours of overtime. It also provides timely reporting and automated VCIN updates.

Technologies

The Criminal Processor was written entirely in Java with many of the business rules implemented in Oracle PL/SQL stored procedures. CloverLeaf's CLETS Gateway was used for Criminal History queries.

QUES Hybrid Notification

State of California · Department of Justice (BCII)

QUES Hybrid Notification is an electronic system to support the processing of hybrid CII numbers by comparing and removing duplicate hybrid CII (Criminal Information Identifier) numbers.

Overview

CloverLeaf developed an interface between the Criminal Processing System and the Subsequent Arrest Processing System that compares and removes duplicate hybrid CII (Criminal Information Identifier) numbers. The remaining hybrid CII numbers are displayed on a web page that allows users to track the process of gathering the hardcopy data and convert it into an electronic format.

Benefits

This system automated a largely manual process that was costing the Department of Justice many hours of overtime.

Technologies

The application was developed using MVC architecture and included JSP, AJAX, Web Services, jQuery, Struts, Java Beans, Java, XML/XSL with an Oracle database and Jetty Application Server. CloverLeaf's CLETS Gateway is used for Criminal History queries.

Applicant Response Interfaces

State of California · DSS, DORE, BSIS, CTC

The Applicant Response Interfaces are tailored for each receiving agency.

Overview

CloverLeaf developed several custom inter-agency interfaces for delivering Criminal History, FBI, Firearms and Child Abuse search results to various agencies.

Benefits

Each of these interfaces required special coordination between the Department of Justice and the external agency due to special technical considerations and differing security requirements. CloverLeaf provided this while delivering a quality technical solution.

Technologies

CloverLeaf designed, developed and implemented these interfaces using various technologies unique to each receiving agency.

ACHS DataMart Project

State of California · Department of Justice (Hawkins Data Center)

The ACHS DataMart provides critical data for statistical calculations.

Overview

CloverLeaf Solutions assisted with the development of the ACHS DataMart as a tool used throughout the Departmentof Justice to perform ad-hoc queries on Criminal History data.

Benefits

This data warehousing solution strips data from the Automated Criminal History System legacy database and stores it in a highly available Oracle database for general statistical calculations and queries.

Technologies

This system was written using Oracle and Sagent Tools.

CJIS Migration / CJIS Control

State of California · Department of Justice (Hawkins Data Center)

CloverLeaf Solutions is co-developing middleware to support the migration to the new system.

Overview

CloverLeaf Solutions is co-developing the replacement of the current legacy system on an open environment based on Oracle database. CJIS Control is a middleware application responsible for routing messages from CLETS to newly converted CJIS applications.

Benefits

The new CJIS Control middleware provides common functions such as security, parsing, validation, journaling and application integrity.

Technologies

The tools used for this project are: Oracle RDBMS 9.2, Designer 9i, Oracle Application Server 10g, and Java.

Applicant Processor

State of California · DSS, DORE, BSIS, CTC

The Applicant Processor provides critical features for handling applicant data.

Overview

CloverLeaf developed a client server based system that performs backend applicant fingerprint post-processing. CloverLeaf worked with the Department of Justice closely through all phases of the software development lifecycle. Upon completion and delivery of the system, CloverLeaf continued to work with Department of Justice to enhance and maintain the system.

Benefits

This system is responsible for all back-end processing including Agency Notification, Criminal History Update, Billing, Statistics Generation, Reporting, Automated Criminal History searches through CLETS and User Workflow Management.

Technologies

This project was developed using Microsoft Visual Basic, PL/SQL stored procedures, Pro*C and Oracle.

Fingerprint Card Scan System

State of California · Department of Justice

The Fingerprint Card Scan System eliminated a six month backlog of finger print cards.

Overview

CloverLeaf designed and co-developed an image based system that automated the entry of finger print data into the Automated Criminal History system. The system provides a facility for the users to scan an image of a fingerprint card and display it to a user for entry of the data. An advanced error resolution and workflow design allows for streamlined data entry of the finger print data resulting in immense man-hour savings.

Benefits

As a result of implementing this system, Department of Justice eliminated a six month backlog of finger print cards.

Technologies

The Fingerprint Card Scan application was developed using Microsoft Visual Basic and Oracle and runs on CloverLeaf's Fingerprint Card Scanners.

FBI Response Processing System

State of California · Department of Justice (BCII)

The FBI Response Processing System provides correlated results from FBI queries and delivers results via CLETS.

Overview

CloverLeaf designed, developed, tested and implemented an automated system that retrieved FBI query data, matched it with California Criminal Fingerprint requests and delivered the results of these searches to various state agencies using CLETS.

Benefits

A front-end application was developed to allow in-house Department of Justice personnel to search the FBI Response database and determine the status of the FBI searches.

Technologies

This project was developed with Microsoft Visual Basic using Oracle as the database. CloverLeaf's CLETS Gateway was used for Criminal History queries.

Child Abuse Response Processor

State of California · Department of Justice (BCIA)

CARP provides timely agency notification of Child Abuse data.

Overview

CloverLeaf Solutions worked with the Child Protection Program Department of Justice to develop a system that captures and reports information about child abuse incidents and automates the process of notifying state agencies of certain job applicants who have been suspects in child abuse incidents. CloverLeaf is providing on-going support for this system.

Benefits

The CARP System provides the Department of Justice, as well as child welfare and law enforcement agencies throughout the state, with accurate and timely reporting of child abuse incidents. In addition, it provides schools, child welfare agencies, adoption agencies and the Department of Social Services with timely and accurate responses to requests for background checks of certain job applicants and people submitting requests to adopt children or become foster parents.

Technologies

The application was developed using MVC architecture and included JSP, Struts, Java Beans, Java, Jasper Reports with an Oracle database and Jetty Application Server.

DOJ Business Intelligence

State of California · Department of Justice (BCIA)

The DOJ Business Intelligence system provides pre-built dashboards and ad-hoc queries:
· Attorney General Dashboard (Correlated Crimes and Arrests)
· Crimes Dashboard
· Arrests Dashboard

Overview

CloverLeaf Solutions worked with the Crime Statistics unit at the Department of Justice to develop a business intelligence system that provides pre-built dashboards and ad-hoc queries and detail drill-down for Crime and Arrest data. CloverLeaf is providing on-going support for this system.

Benefits

The DOJ BI Dashboards include:
· Attorney General Dashboard - Correlated Crime and Arrest data for the 8 major crime categories
· Crimes Dashboard - Detailed Crime data for the 8 majors (plus data that can’t be directly correlated w/ arrests)
· Arrests Dashboard - Detailed Arrest data (plus data that can’t be directly correlated w/ crimes)

Technologies

The application was developed using Oracle Business Intelligence.

RACHS: User Acceptance Testing

State of California · Department of Justice (Hawkins Data Center)

CloverLeaf is providing consulting services for several RACHS Sub-Projects, including:
· RACHS: User Interface Project
· RACHS: User Acceptance Testing
· RACHS: Data Validation Project

Overview

The ACHS Redesign (RACHS) - Automated User Acceptance Testing project began with consulting services to help transform manual testing processes into repeatable automated processes. Test cases were migrated from word procesing documents into a database. A web application was developed that allows test analysts to upload test case data, submit test cases (individually or in groups), baseline the results, as well as automated regression testing.

Benefits

Automated testing is drastically reducing the time for testing a new system, saving the Department of Justice countless hours of staff overtime. At the same time, automation increases the accuracy and effiency of the testing results.

Technologies

This system has been developed in Java with Oracle as the database. Web services are used to submit queries and updates, as well as CloverLeaf's CLETS Gateway. Reports were built with XSLT & CSS using XML from Oracle.

RACHS: User Interface Project

State of California · Department of Justice (Hawkins Data Center)

CloverLeaf is providing consulting services for several RACHS Sub-Projects, including:
· RACHS: User Interface Project
· RACHS: User Acceptance Testing
· RACHS: Data Validation Project

Overview

The ACHS Redesign (RACHS) - User Interface Project leverages technology developed by CloverLeaf for several other Department of Justice projects, including CloverLeaf's CLETS Gateway. The user interface was designed as a web application that dynamically transforms the field definitions for each query and update into a web form. The field definitions are retrieved from a web service, and form-level validations are done by calling another web service.

Benefits

Using web services to dynamically create and validate each web form means that the application will not need to be changed if any of the field definitions or validations are modified. As the ACHS Redesigned system functionality is enhanced, the UI will not need any major code changes.

Technologies

This system has been developed in JSP, AJAX, Web Services, XML/XSLT, and CSS with Oracle as the database. CloverLeaf's CLETS Gateway is utilized for queries.

RACHS: Data Validation Project

State of California · Department of Justice (Hawkins Data Center)

CloverLeaf is providing consulting services for several RACHS Sub-Projects, including:
· RACHS: User Interface Project
· RACHS: User Acceptance Testing
· RACHS: Data Validation Project

Overview

The ACHS Redesign (RACHS) - System Migration Data Validation Project leverages technology and expertise developed by CloverLeaf for another Department of Justice datamart project. Data validation scripts have been developed to independently validate the data for each run of the Data Migration scripts (developed by another team).

Benefits

Data being migrated from the Legacy ACHS system will be verfied for accuracy before the new Redesigned ACHS system is deployed.

Technologies

This system was written using Oracle and Sagent Tools.

Packaged Business Solutions

"CSI staff took extra time to really learn the business requirements...
CSI is extremely proficient at system design and produces an excellent product.
I would recommend CSI to any business."

Jane Tucker, Section Manager (California Department of Justice/BCII)

Many projects are similar in nature, but each typically includes solution details that are quite unique. Sometimes a component of a solution developed for one project can be re-used on another, saving the customer significant time and money.

If you are interested in any of these solution components, please contact us.

CLETS Gateway

State of California · Department of Justice

CloverLeaf's CLETS Gateway is one of the best CLETS gateways available.

Overview

CLETS is the California Law Enforcement Telecommunications System maintained at the California Department of Justice for the state's Law Enforcement community. The CLETS Gateway is being used on many applicaitons at the Department of Justice, including the Criminal Processing System, the Subsequent Arrest System, the Disposition Processor, Automated Record Error Correspondence, and RACHS: User Acceptance Testing.

Benefits

CloverLeaf developed a CLETS Gateway for exchanging data between any computer system and the CLETS network. CloverLeaf's CLETS Gateway also provides interactive real-time monitoring.

Technologies

This software package is written entirely in Java and is therefore multi-platform compatible.

Fingerprint Card Scanners

State of California · Department of Justice

CloverLeaf's new hard card fingerprint scanner solution is extremely economical and scalable.

Overview

CloverLeaf Solutions Inc. developed a hard card scanner solution used by the Department of Justice. This solution is available for the Windows PC platform and is extensible for your needs.

Benefits

The solution uses scanners that are readily available, extremely affordable, and NIST certified.

Technologies

This solution incorporates Epson scanners, NIST certifited fingerprint software and was integrated using Microsoft Visual Basic.Net.