Inmate Tracking Remote Booking Project Status Report

Document Sample
Inmate Tracking Remote Booking Project Status Report Powered By Docstoc
					                                   Inmate Tracking / Remote Booking
                                         Project Status Report
                                                  Ursula Kaunas

                                               November 30, 2007

Reporting Period

 November 1, 2007                                                           Issue Date: 11/30/07

 Steering Committee             Name                              Phone              Email
 Project Sponsor                Dan Peterca                       216-443-2170
 Administrative Sponsor         Linda Lingler                     216-443-5974
 Sheriff’s Office Project SME   Warden Ronald Shobert             216-443-4105
 Court of Common Pleas SME      Thomas Pokorny                    216-443-8560
 CCISC Project Technical SME    Eric Paliwoda                     216-443-5980
 Sheriff’s Office Project
                                Nadine An-Noor                    216-443-6122
 Technical SME
 Co-Project Manager             Ursula Kaunas                     216-443-8022
 Co-Project Manager             Cathy McKenna                     216-443-5865

Status Summary

We are pleased to announce the release of the Cuyahoga County Sheriff’s Inmate Tracking System (ITS),
which is one of the many Cuyahoga County Criminal Justice System Reform projects preparing for Go
Live! December 3, 2007 is the Go Live date for “Bind Over” module.

Sentence Misdemeanor module Go Live date is pending additional training and will be announced at a later

The “Pilot Project module is in progress of designing this module. The information entered in the Pilot
Project module will provide a real time view notification for all project participants to begin investigations for
the early dispositions of these cases. Target date for completion and Go Live is 1st quarter 2008!

What is ITS?

ITS will provide all Cuyahoga County Justice Partners; Bond Commissioner, Common Pleas Court,
Criminal Clerk’s Office, Pre Trail Services, Probation Office, Prosecutor’s Office, Public Defender’s,
Sheriff’s Office and TASC/DJA with an application that functions as an electronic interface between the
Sheriff’s IMAC data system and suburban full time correction (jail) facilities beginning with Bedford Heights
and eventually all arresting authorities within Cuyahoga County jurisdiction.

   Page 1 of 4                                4/18/2008                                               Kaunas
                                  Inmate Tracking / Remote Booking
                                        Project Status Report
                                                 Ursula Kaunas

                                              November 30, 2007

ITS provides the ability to "Search” for the Inmate's location addressing the immediate need for real time
prisoner location, ITS also captures specified booking, sentencing, and demographic data.

In preparing for our Go Live we scheduled training dates for all Justice Agencies. We conducted the
training in the Justice Center in the Common Pleas 12th floor training room beginning November 5th thru
November 9th, within the 3 ½ days scheduled over 200 Justice Agency Employees were trained on ITS.

Below is the ITS Link:

On October 22, 2007 Eric Paliwoda conducted Sentenced Misdemeanor training for the Sheriffs Office;
Donna Tulcewicz. Ursula Kaunas discussed the project Go Live plan with Sheriff’s Office Supervisor Karyn

The plan is as follows; we will need to need to pick a date to stop entering in the current Misdemeanor
Access database as there will be a data conversion for Misdemeanors. Eric Paliwoda would do the data
conversion while no data is being entered, this should only take one day worth down time for entering
Misdemeanors. It is recommended that once this conversion is completed and Sheriff’s Office is satisfied
that ITS Misdemeanors module Go Live immediately thereafter, because the system and users reside inside
the county network there possesses no security risks. In addition we are recommending that both the current
Access system and ITS for Misdemeanors run side by side for a period of two weeks to insure data is
accurate, in sync and the system is operating completely functional.

At the request of the Sheriff’s Budget and Fiscal Management Office we will conduct an additional training for
Donna Tulcewicz and Karyn Neiman tentatively within the first week of December. Go Live would then be
set the following week. Notification for Sentence Misdemeanor will be sent prior to actual date.


The SSL certificate was ordered and received. The total cost for this configuration was $399.00.
The issue of providing security for ITS has been resolved see network diagram below:

   Page 2 of 4                               4/18/2008                                              Kaunas
                                                            Inmate Tracking / Remote Booking
                                                                  Project Status Report
                                                                             Ursula Kaunas

                                                                         November 30, 2007

    Bedford Hts.                                                                                                                                                                                                                 DMZ#1-SwP                                                         CATALYST 3550        DMZ #1 VLAN
    Police Dept.                                                                                                                                                                                                                                                                                                        Public DMZ –
                                                                                                                                                                                                       MODE                                                                                                        11
                                                                                                                                                                                                                 UTIL        1       2       3       4       5       6       7       8    9   10

                                                                                                                                                                                                                                                                                                                        Provides public access the Inmate
                                                                                                                                                                                                                                                                                                                        Tracking System application.
  Bedford Hts IP Network Address:
                               Internet                             Cuyahoga
                                                                                            Firewall e2                                                                                                                                                                        
                                                                                                                                  CISCO SECURITY PIX 525 SER IES
                                                                                                                                         F I R E W A L L
                                                                                                                                                                                                                                                                                         This server hosts the front-end application

                                                                              POWER   ACTIVE

                                                                                         e1                                              e3                                                                                                                                                                              DMZ #2 VLAN
The county firewall is configured to allow access
                                                                                                                                                                                                                                                                                                                         Management DMZ
to the server in the
                                                                                                                                                                                                                                                                                                                         Provides County management
DMZ only if it is sourced from the network
                                                                                                                                                                                                                                                                                                                         access for posting and database
address of the Bedford Hts. Police Department.
                                                                                                                                                                                                                                                                                                   CATALYST 3550

                                                                                                                                                                                                                                                                                                                                                              - VM: CuysterWeb09
This allows only the police department to access
                                                                                                                                                                                                     MODE                                                                                                          11
                                                                                                                                                                                                               UTIL      1       2       3       4       5       6       7       8        9   10
                                                                                                                                                                                                                                                                                                                                                              - VM: CCSTVWebQA
the inmate tracking application. No one else on                                                                                                                                                                                  DMZ#2-SwP
the Internet can access the server. This access
requires use of a SSL certificate to ensure the
data traffic is encrypted across the Internet.

Only the application resides in the DMZ, not the
inmate tracking data. This allows the
authentication and application screens to be
displayed from the DMZ application server.
                                                                                                                          Internal County WAN
The inmate tracking data resides inside the
county WAN and is not accessible from the                                                                                 County
outside Internet. The firewall does not allow                                                                            Core Router
                                                                                                                                                                                CATALYST 3550
outside Internet traffic inside to the County WAN.
                                                                                               MODE                                                                                             11
                                                                                                        UTIL     1   2    3   4    5            6            7     8   9   10

The firewall is configured to allow only the                                                          DUPLX
                                                                                                                                                                                                12 application server to
retrieve data from the inmate tracking database
on the SQL server in the internal ISC network.
The application server in the DMZ performs the                                                          Sheriffs Database Replicated to ISC
SQL data retrieval on behalf of the user              Sheriffs SQL                                                                                                                                                                                                                                                                    ISC SQL Server
accessing the application.

                                                           Sheriff Network                                                                                                                                                                                                                                                   ISC Network

Project Cost

 Service/Materials                                                                                                                                                                                                                                                                                                      Hours                Cost
 Phase I
 ISC, Professional Services Total Cost (Refer to Project Charter for
                                                                                                                                                                                                                                                                                                                        115                  $13,453.80
 detailed breakdown)
 SSL Certificate                                                                                                                                                                                                                                                                                                                             $399.00
 Phase II
 TAC, Bedford Heights RMS Vendor Professional Services for Electronic
                                                                                                                                                                                                                                                                                                                        160                  ROM: $21,600.00
 Phase III
 Intellitech, IMAC Vendor Professional Services for Electronic Transfer                                                                                                                                                                                                                                                 160                  ROM: $35,500.00

     Page 3 of 4                                                       4/18/2008                                                                                                                                                                                                                                                                            Kaunas
                                   Inmate Tracking / Remote Booking
                                         Project Status Report
                                                  Ursula Kaunas

                                                November 30, 2007

Key Accomplishments Last Period

The following tasks have been accomplished since last status:
   1. ITS users were assigned and notified with their ITS User ID’s and Passwords.
   2. Cuyahoga County Justice Agencies training session were completed the week ending November 9th.
   3. Training for ITS Users at Bedford Heights Correction Facility was completed November 19th.

Tasks Planned Next Period

   1.   Go Live! December 3, 2007.
   2.   Begin talking to Craven and the Prosecutor IT staff about electronically feeding ITS.
   3.   Begin pilot testing Misdemeanors.
   4.   Begin work on adding “Pilot Project” inmates to system.

   Page 4 of 4                                4/18/2008                                         Kaunas