Georgia Bureau of Investigation April Monthly Report FY2012 Presented to the Board of Public Safety No Meeting Scheduled for June 2012 Vernon M. Keenan Director Table of Contents I. Staffing and Backlog................................. 3 - 4 II. Administration Office of Privacy & Compliance/Open Records Personnel Staff Services........................................... 5 III. Investigative Division.................................. 6 - 7 IV. Crime Lab.............................................. 8 - 10 V. Georgia Crime Information Center................. 11 - 15 2 Vacant State Positions FY2012 Total Vacant Positions in DOFS Vacant Scientist Positions Total Vacant Positions in GCIC Total Vacant Positions in Admin Vacant Sworn Agent Positions Total Vacant Positions In the Investigative Division Jul Aug Sept Oct Nov Dec Jan Feb Mar Apr May June 21 25 25 23 25 25 27 26 27 26 7 10 8 9 7 7 9 8 8 8 66 66655522 55 66675554 19 20 22 19 19 18 19 23 22 23 32 35 36 32 32 30 27 30 29 29 3 DOFS Backlog Chart Unworked Cases over 30 Days Old FY2012 Discipline Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Chemistry 2,343 2,316 3,150 3,229 3,072 2,202 1,568 1,121 907 1,126 Firearms 1,322 1,333 1,364 1,408 1,324 1,335 1,320 1,309 1,272 1,259 Forensic Biology 273 203 353 397 431 639 677 581 503 684 Latent Fingerprints 731 713 739 842 908 947 975 1,023 1,050 1,032 Medical Examiners 161 179 104 98 119 134 162 163 143 128 Questioned Docs/Photography 275 275 274 278 285 283 279 282 291 298 Toxicology 2,294 1,999 1,798 1,679 1,813 1,749 1,433 1,615 1,387 1,266 Trace Evidence 213 169 177 200 220 243 236 220 221 216 Total 7,612 7,187 7,959 8,131 8,172 7,532 6,650 6,314 5,774 6,009 4 GBI Administration Office of Privacy & Compliance/Open Records Open Records Request Archives April 2012 261 29 Total FY2012 2,747 375 Personnel Employee Totals Investigative Division Georgia Crime Information Center Division of Forensic Sciences Administration Bureau Total *Vacancies are State Funded Positions April 2012 Positions State Funded Grant Funded 319 38 91 9 250 57 46 0 706 104 Total 357 100 307 46 810 Current Vacancies* 29 2 26 4 61 5 INVESTIGATIVE DIVISION April 2012 Fiscal YTD Total Sworn Employees 248 (filled-includes grant) Total Investigative Hours Expended 27,540.00 275,000.50 Crimes Against Persons, includes Death Investigations Child Abuse Sex Crimes Missing Persons Assault, Kidnapping, Robbery, Terrorist Acts, Fugitive, Human Trafficking, etc. 8,585.50 4,950.00 1,685.00 287.00 49.00 1,614.50 88,292.25 47,167.50 19,884.75 3,136.00 833.00 17,271.00 Property Crimes, including Theft, Burglary, Forgery 2,423.00 26,781.25 Drug Investigations 6,999.00 65,021.50 Meth Lab Investigations 191.00 1,408.00 Polygraph Examinations 915.00 9,692.00 Background Investigations 2,259.00 5,066.00 Other Investigations, including Preliminary Investigations 3,281.50 46,003.50 Bomb Disposal Services 645.00 7,430.00 Crime Analysis 15.00 1,164.00 Crime Scene Specialists 2,226.00 24,142.00 All figures above represent Investigative Hours Total Seizures $3,111,345.59 $65,682,261.49 6 Investigative Hours Expended YTD FY2012 Bomb Disposal Services Other 3% Investigations 17% Crime Analysis >1% Crime Scene Specialists 9% Crimes Against Persons 33% Background Investigations 2% Meth Lab Investigations 1% Polygraph Investigations 4% Drug Investigations 25% Property Crimes 6% 7 Crime Lab Medical Examiners (includes all laboratories) April 2012 FY2012 YTD Autopsies Consultations Anthropology Total ME Cases Managed 269 2,584 105 1,289 0 1 374 3,874 Clayton County Death Certificates 31 305 Medical Examiner Activity, FY2012 Consultations 34% Anthropology >1% Autopsies 66% Confirmed CODIS Hits for April 2012 State Offender Hits: 33 State Forensic Hits 4 National Offender Hits 18 National Forensic Hits 0 Total 55 Samples entered into CODIS for April 2012 Headquarters 68 Cleveland 998 Savannah 24 Total 1,090 Profiles in CODIS Forensic Casework Profiles Convicted Offender Profiles Missing Person/Unidentified Human Remain Profiles Total 12,291 236,377 13 248,681 8 Laboratory Production Case Turnaround for April 2012 Laboratory Headquarters - Atlanta Central Regional - Macon Coastal Regional - Savannah Eastern Regional - Augusta Northeastern Regional Southwestern Regional - Moultrie Western Regional - Columbus # Released Total % Released in in 45 Days Released 45 Days 2,358 3,675 64% 127 150 85% 260 533 49% 212 239 89% 942 974 97% 99 143 69% 166 203 82% System-wide Totals 4,164 5,917 70% Note: 82.6% Casework Reports were released within 90 days. Case Turnaround for Year-to-Date, FY2012 Laboratory Headquarters - Atlanta Central Regional - Macon Coastal Regional - Savannah Eastern Regional - Augusta Northeastern Regional Southwestern Regional - Moultrie Western Regional - Columbus # Released Total % Released in in 45 Days Released 45 Days 18,840 37,259 51% 398 2,252 18% 1,626 4,195 39% 1,582 3,279 48% 17,285 19,614 88% 447 902 50% 1,762 2,308 76% System-wide Totals 41,940 69,809 60% 9 Crime Laboratory Cases Processed for April 2012 Department Requested Total Released Chemistry (includes Drug ID) Firearms Forensic Biology Latent Prints Medical Examiners Questioned Documents/Photography Toxicology Trace Evidence 1,990 154 2,223 133 386 17 1,778 68 2,071 143 1,320 160 402 18 2,144 61 Total 6,749 6,319 Crime Laboratory Cases Processed FY2012 Department Requested Total Released Chemistry (includes Drug ID) Firearms Forensic Biology Latent Prints Medical Examiners Questioned Documents/Photography Toxicology Trace Evidence 21,339 2,718 24,246 1,693 3,917 160 19,218 766 22,314 2,630 22,654 1,383 3,863 114 19,997 717 Total 74,057 73,672 10 Georgia Crime Information Center 1. SYSTEM AVAILABILITY: APRIL 2012 Max Hours Possible for Month Downtime (Hours) Degraded (Hours) Percent Available for Month Enterprise GoNET/ AFIS Network 2200 Infrastructure* 720.00 720.00 720.00 IBM System 720.00 0.00 45.25 0.00 4.00 0.00 0.00 0.00 0.00 100% 93.72% 100% 99.44% NCIC Files 720.00 5.50 0.00 99.24% NICS NLETS 720.00 5.50 0.00 99.24% 720.00 2.00 0.00 99.72% 2. AUDITS: During the reporting month there were 10 full service audits conducted. There were 7 on-site audits conducted for agencies obtaining "inquiry only" from the CJIS network; 2 criminal justice E-Audits; 19 non-criminal justice audits; and 6 fingerprint/disposition audits. The total number of audits conducted during FY2012: 752. 3. TRAINING: GCIC personnel provided 330.75 hours of training to 1,633 criminal justice agency employees during the month. 4. AFIS REPLACEMENT Project Description: GCIC is replacing the Georgia Bureau of Investigation's 22 year old Automated Fingerprint Identification System (AFIS). The AFIS replacement enhances fingerprint identification services to permit identification of criminals more rapidly through the use of state of the art alternative search methods and information sharing. Monthly Update: Weekly AFIS Replacement Project Manager and Monthly Executive status meetings are held to assure that the project remains on track. The NIST conversion of slap prints is complete. The switchover date has been pushed back to June 18th due to issues with internal vendor processes. Tenprint and Latent Acceptance Test have begun. The Implementation Plan was approved and signed. A purchase order for the expansion of the image archive system was requested. 5. SEX OFFENDER REGISTRY RE-DESIGN PROJECT Project Description: Georgia's Sex Offender Registry (SOR) was created in 1996 and the purpose of the SOR is to provide law enforcement with an efficient and effective method of monitoring sex offenders. In 2010, the Georgia Department of Audits and Accounts Performance Audit Operations conducted an audit on the Georgia SOR and their findings indicated that the SOR is an outdated and inflexible computer system; the registry does not fully meet the needs of law enforcement monitoring and investigating sex offenders and that the public website should provide more complete and accurate information. The information contained in the audit validated issues GBI had noted for some time regarding the need to improve and modernize the SOR. 11 To remedy the current database limitations, the Georgia Bureau of Investigation (GBI) seeks to modernize and replace the SOR using web technologies, which will allow GBI to accommodate requests from sheriffs and other customers. Moving to web technologies will ensure greater flexibility for the State to incorporate future updates or enhancements as dictated by state or federal legislation, operational needs, or public demands. Increased capabilities would also allow the sex offender database to link to other databases to help improve record accuracy or offender tracking, such as address verification or developing a link with the Department of Corrections for information on re-incarceration of offenders. Offender images would be stored in a format allowing sharing with the Federal Bureau of Investigation's (FBI) National Crime Information Center (NCIC) Convicted Sex Offender File for use by all criminal justice agencies throughout the United States. Access to the public registry would be real time instead of 24 hours old as with the current process of providing a daily update for public web presentation. Monthly Update: A new Project Change Request (PCR) was submitted to extend IBM's involvement through May 28, 2012. The original closure date for IBM was January 13, 2012. The SOR unit continues to work resolving the issue of matching charge codes entered on the registry with the corresponding NCIC code. The Georgia Sex Offender Registry will send notifications to NCIC to update Sex Offender data on the national registry. A meeting with Unisys, the vendor contracted to implement the web services integration, was held to discuss how the new Sex Offender Registration Tool (SORT) would submit updates to NCIC and exchange data with the Georgia Department of Corrections (GDOC). The meeting included representatives from the Georgia Department of Corrections (GDOC), Pardons and Parole, Probations and Sex Offender Registry Review Board (SORRB). Also discussed at the meeting were the required formats and data fields that will be used to receive and submit data to the SORT application. Unisys presented a proposed method of using "LEMS Services" of web services to communicate between SORT & LEMS/JX and between GDOC and LEMS/JX to allow messages between the SORT and GDOC's SCRIBE system. The specifications for the message format and structure will use XML and where no XML exist, the format will be developed in the standard Information Exchange Package Documentation (IEPD) that conforms to the National Information Exchange Model (NIEM). Jim McNeal, contractor hired to customize SORT, has completed customization of the SORT application in the following areas: Added SRN (System Registration Number) to Offender Summary Bar The SRN has been added to the offender summary bar the 1st field in the 1st column. The "Active" status has been moved to the last field in the 2nd column. Added "State Incarcerated" field to Offender Main Form Added a checkbox field "State Incarcerated" to the offender's main form and integrated this field into the auditing process. 12 6. SERVER CONSOLIDATION PROJECT Project Description: The Georgia Technology Authority (GTA) will be consolidating production, test and developmental servers to the NADC. Consolidation and virtualization will enable the state to reduce the number of servers being supported. The team will identify which servers can be consolidated and the timeframe to complete the move. Monthly Update: April SCON Business Council Meeting was held on April 30, 2012. We are currently following up on two critical items that came out of the Business Council meeting. We are meeting with Courtview and GTA on May 3, 2012 and will have an RFS inputted into the system for an Upgrade of Oracle 10 to 11 by May 7, 2012. We are also providing the analysis required to include within an IBM PCR for SCON server changes from small to medium. This must be done by close of business May 3, 2012. Critical Path Tasks/Milestones/Deliverables Projected Baseline End End Date Status Milestone: Test Scripts Complete 6/27/12 6/27/12 In Progress Major Milestone 09: HLD Completed and Distributed 6/12/12 6/12/12 In Progress Major Milestone 11: GTA SCON-GBI (Affinity #1) Initial Server Build Out Completed 7/12/12 7/12/12 Not Started Complete Ops Readiness Documentation Check list SO Approval to turn over to Agency 7/26/12 7/26/12 Not Started Accomplishments This Reporting Period: Completed 3rd White Board session for SCON HLD interim reviews Continued progress on HLD 58% Completed base line of project plan and requested agency approval No late tasks Completed Network Requirements reviews Planned Accomplishments Tasks in Progress: Complete Network LLD Completed scheduled application white board sessions by May 2nd Received ETA for BOM 7. WEBSITE RE-DESIGN PROJECT Project Description: The GBI website will be re-designed to better enable the public to find relevant, accurate, up-to-date information. In addition, each division will have a focal point identified to update their websites to improve efficiency. The new website will be consistent with the State of Georgia's website design using Drupal. 13 Monthly Update: The GBI website is scheduled to be migrated to Drupal in July. The migration will include a redesign of the website using one of eight style tiles that the GTA has created for State Agency websites. A meeting will be held with GTA representatives in June to choose GBI's design and finalize other details before the migration. The team continues to: Improve readability to meet the e-government's recommendation of content being at a 5th 8th grade reading level. Add pictures to complement existing text. Delete any old/expired content. Identify content that links to external sites and add an alert to notify the public that they are leaving the GBI website. 8. CRIMINAL HISTORY/IDENTIFICATION SERVICES a. Fingerprint Cards Received/Processed Document Criminal Cards NATMS Criminal Juvenile Criminal Applicant Cards NATMS Applicant TOTAL Received April 820 41,471 286 281 22,769 65,627 Received FY2012 11,633 422,886 2,763 3,154 256,508 696,944 Processed April 731 41,413 275 272 23,478 66,169 Processed FY2012 11,339 420,684 2,610 3,089 255,945 693,667 b. Significant Productivity Data AFIS Searches (Criminal, Applicant & Juvenile) AFIS Hits (Criminal, Applicant & Juvenile) April 62,615 35,096 (56%) FY2012 752,034 360,698 (48%) c. Live Scan (Electronic Submissions) Activity - April 1. Agencies transmitting electronically 347 (466 devices) 2. Agency added: Glennville PD, Swainsboro PD, Floyd County Probate Court 3. These 347 live scan agencies submit electronic fingerprints cards for approximately 746 agencies. 4. On average, during the month, live scan represented 98% of total electronic and hard card criminal receipts. 5. On average, during the month, live scan represented 99% of the total applicant electronic and hard card receipts. d. AFIS Latent Activity Inquiries April: Inquiries FY2012: Hits April: Hits FY2012: 65,062 686,518 56 696 e. AFIS Remote Activity Inquiries April: 571 14 Inquiries FY2012: TI Hits April: TI Hits FY2012: LI Hits April: LI Hits FY2012: 5,564 1 48 75 818 f. CCH Record Corrections (Specials) Status Total Received Total Rejected Total Completed Total Still in Process April 1,301 79 1,285 257 g. Defense Attorney Requests for Criminal History Records for Criminal and Civil Cases April FY2012 Total Requests 253 2,922 Revenue Collected $1,050.00 $12,089.70 9. SEX OFFENDER REGISTRY a. Sex Offender Registry Records Added During the Month TOTAL April FY2012 146 1,714 b. Sex Offender Program Statistics 1. Total number offenders on file = 21,301 2. Predators = 310 3. Juvenile (treat as adult) = 18 4. Total records with images = 21,088 (99%) c. Registered Anniversary Letters Total Letters mailed: April FY2012 1,052 11,418 10. PROTECTION ORDER REGISTRY Records and Images Added During the Month Contributing Counties Records Added Records Added April April FY2012 122 1,786 18,151 Images Added April 12,312 Total orders on file: Active: Inactive: 226,086 8,550 217,536 Images Added FY2012 127,189 15