Computer Solutions for Business Problems
CloverLeaf Solutions Inc. is a certified
California Small Business (SB #0019330) that specializes in developing and delivering state of the art multi-tiered computer systems to various agencies within the State of California. We are an approved
Master Service Agreement (MSA #5-06-70-41) and
California Multiple Awards Schedule (CMAS #3-09-70-1015D) vendor.
We pride ourselves in providing more than expected to our customers. We have developed a team of professionals that has a large body of leading edge skills, yet we stress a common sense approach to problem solving.
While many of our competitors prefer to confuse you with technical jargon, we feel it is our job to bridge the gap between the business problem and the technical solution. In order to do that it is imperative that our programmers and analysts actively explore and understand your business environment. This approach has been extremely successful for us and has led to a high rate of customer satisfaction.
CloverLeaf Solutions believes that good service builds good business. We are committed to satisfying our customers to ensure a long-term business relationship.
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)
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)
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)
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.
