Industry Served: Government
Rose Solution: Web Development
Case Study Overview

Business Problem
Integrate stovepipe systems into a single web-based application that performed end-to-end monitoring and reporting of DWI violations.

Rose Value Proposition
Integrated plan to coordinate requirements across multiple agencies utilizing technology to improve application performance.
Results
  • Reduced time for sharing DWI information across multiple agencies.
  • Reduced time for information on previous DWI convictions.
  • Improved system performance.
  • Award winning results.
Industry Served: Government
Rose Solution: Web Development

Business Problem
A state agency with a mission of improving highway traffic and public safety had three labor intensive legacy applications. The agency wanted a single, state-of-the-art DWI Tracking system with the capability to track a DWI offense from initial arrest, through prosecution, to the final court disposition. Additionally, the agency wanted to identify habitual DWI offenders and conduct statistical analysis. The goal was to reduce the time for an offender's conviction record to be shared across law enforcement and the courts, and to more effectively remove unsafe drivers from the highways.

Rose Value Proposition
The Rose project team developed a comprehensive project implementation plan with specific deadlines covering all aspects of the life cycle including design, construction, conversion, testing, integration and just-in-time training. The Rose analysis and design incorporated input from Mothers Against Drunk Driving (MADD), and required coordination across five state agencies (Highway Patrol, Courts, Revenue, State Prosecutors, and Mental Health). Rose utilized Java and DB2 technology to provide the performance needed to meet the customer's requirements.

Results
With the DWI Tracking system in place, the Justice Department and law enforcement agencies have reduced the time for an offender's driving under the influence conviction record to be shared across the Justice group. Where it used to take approximately two weeks for a law enforcement office to know if an individual had a DWI conviction, it now takes less than 24 hours to notify the officer. The system is currently storing over 10 million arrest records for the State, while processing around 100,000 transactions per week. A majority of those transactions are queries against the over 10 million row arrest record table. The typical query takes 0.2 seconds. An estimated 99.6 percent of all transactions in the system, including; online web queries, adds, updates and deletes process in less than one second. This system is taking irresponsible and unsafe drivers off the highways. The DWI system was awarded the National Safety Council's Best Practices Award.

Questions?
Contact our Business Development Team to learn more!