Georgia Bureau of Investigation June Monthly Report FY2012 Presented to the Board of Public Safety No Meeting Scheduled for August 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 25 26 7 10 8 9 7 7 9 8 8 8 14 14 66 666555223 2 55 666755544 4 19 20 22 19 19 18 19 23 22 23 26 26 32 35 36 32 32 30 27 30 29 29 32 33 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 983 1,302 Firearms 1,322 1,333 1,364 1,408 1,324 1,335 1,320 1,309 1,272 1,259 1,261 1,269 Forensic Biology 273 203 353 397 431 639 677 581 503 684 794 638 Latent Fingerprints 731 713 739 842 908 947 975 1,023 1,050 1,032 1,012 1,040 Medical Examiners 161 179 104 98 119 134 162 163 143 128 110 81 Questioned Docs/Photography 275 275 274 278 285 283 279 282 291 298 300 309 Toxicology 2,294 1,999 1,798 1,679 1,813 1,749 1,433 1,615 1,387 1,266 1,039 931 Trace Evidence 213 169 177 200 220 243 236 220 221 216 181 181 Total 7,612 7,187 7,959 8,131 8,172 7,532 6,650 6,314 5,774 6,009 5,680 5,751 4 GBI Administration Office of Privacy & Compliance/Open Records Open Records Request Archives June 2012 277 69 Total FY2012 3,285 472 Personnel Employee Totals Investigative Division Georgia Crime Information Center Division of Forensic Sciences Administration Bureau Total *Vacancies are State Funded Positions June 2012 Positions State Funded Grant Funded 319 38 91 10 250 61 46 0 706 109 Total 357 101 311 46 815 Current Vacancies* 33 2 26 4 65 5 INVESTIGATIVE DIVISION June 2012 Fiscal YTD Total Sworn Employees 245 (filled-includes grant) Total Investigative Hours Expended 28,227.00 331,678.25 Crimes Against Persons, includes Death Investigations Child Abuse Sex Crimes Missing Persons Assault, Kidnapping, Robbery, Terrorist Acts, Fugitive, Human Trafficking, etc. 8,711.00 3,900.00 2,400.00 372.00 121.00 1,918.00 106,589.25 55,650.50 24,773.75 4,048.00 1,091.00 21,026.00 Property Crimes, including Theft, Burglary, Forgery 2,924.50 32,035.25 Drug Investigations 7,983.00 80,319.50 Meth Lab Investigations 144.00 1,732.00 Polygraph Examinations 1,041.00 11,718.00 Background Investigations 669.00 6,191.00 Other Investigations, including Preliminary Investigations 3,708.00 54,112.75 Bomb Disposal Services 665.00 8,952.00 Crime Analysis 49.50 1,225.50 Crime Scene Specialists 2,332.00 28,803.00 All figures above represent Investigative Hours Total Seizures $4,810,946.86 $71,974,518.96 6 Investigative Hours Expended YTD FY2012 Bomb Disposal Other Services Investigations 3% 16% Crime Analysis >1% Crime Scene Specialists 9% Crimes Against Persons 32% Background Investigations 2% Meth Lab Investigations >1% Polygraph Investigations 4% Drug Investigations 24% Property Crimes 10% 7 Crime Lab Medical Examiners (includes all laboratories) June 2012 FY2012 YTD Autopsies Consultations Anthropology Total ME Cases Managed 234 3,079 92 1,505 0 1 326 4,585 Clayton County Death Certificates 41 386 Medical Examiner Activity, FY2012 Consultations 34% Anthropology >1% Autopsies 66% Confirmed CODIS Hits for June 2012 State Offender Hits: 33 State Forensic Hits 5 National Offender Hits 16 National Forensic Hits 1 Total 55 Samples entered into CODIS for June 2012 Headquarters Cleveland Savannah 72 1,434 18 Total 1,524 Profiles in CODIS Forensic Casework Profiles Convicted Offender Profiles Missing Person/Unidentified Human Remain Profiles Total 12,510 239,797 13 252,320 8 Laboratory Production Case Turnaround for June 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,452 3,582 68% 94 131 72% 277 436 64% 207 299 69% 2,035 2,344 87% 81 156 52% 162 193 84% System-wide Totals 5,308 7,141 74% Note: 83.1% 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 23,903 44,829 53% 665 2,598 26% 2,260 5,255 43% 2,026 3,903 52% 21,353 24,242 88% 681 1,273 53% 2,144 2,770 77% System-wide Totals 53,032 84,870 62% 9 Crime Laboratory Cases Processed for June 2012 Department Requested Total Released Chemistry (includes Drug ID) Firearms Forensic Biology Latent Prints Medical Examiners Miscellaneous Services Questioned Documents/Photography Toxicology Trace Evidence 2,209 332 2,401 188 330 1 19 1,894 93 1,680 514 2,720 158 410 0 2 1,997 70 Total 7,467 7,551 Crime Laboratory Cases Processed FY2012 Department Requested Total Released Chemistry (includes Drug ID) Firearms Forensic Biology Latent Prints Medical Examiners Miscellaneous Services Questioned Documents/Photography Toxicology Trace Evidence 25,836 3,465 29,171 2,050 4,629 1 190 23,229 921 26,497 3,386 28,041 1,691 4,727 0 130 24,240 885 Total 89,492 89,597 10 Georgia Crime Information Center 1. SYSTEM AVAILABILITY: JUNE 2012 Max Hours Possible for Month Downtime (Hours) Degraded (Hours) Percent Available for Month *New AFIS System was installed. Enterprise GoNET/ AFIS Network 2200 Infrastructure* 720.00 720.00 720.00 IBM System 720.00 76.00* 14.25 0.00 4.00 0.00 0.00 0.00 0.00 89.44% 98.02% 100% 99.44% NCIC Files 720.00 3.00 0.00 99.58% NICS NLETS 720.00 3.00 0.00 99.58% 720.00 0.00 0.00 100% 2. AUDITS: During the reporting month there were 16 full service audits conducted. There were 2 on-site audits conducted for agencies obtaining "inquiry only" from the CJIS network; 2 criminal justice E-Audits; 39 non-criminal justice audits; and 1 fingerprint/disposition audits. The total number of audits conducted during FY2012: 871. 3. TRAINING: GCIC personnel provided 463.50 hours of training to 1,950 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. On June 18th the new AFIS became operational. The User Acceptance Testing and Implementation Plans are completed. Daily AFIS status meetings held after switchover to live system. AFIS connections to Image Archive, live scan, CCH, GAPS, FBI and AFIS Remotes have been restored and are running smoothly. As part of the AFIS replacement live scan vendors had to certify that their software met the requirements of the new AFIS before installing on the local agency device. All vendors met the certification requirements and have begun the installation process. In order for agencies to continue to submit to AFIS all live scan systems must have the newly certified software installed and operational by December 19, 2012. 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 11 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. 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: The issue of matching charge codes entered on the Sex Offender Registry with the corresponding NCIC code was resolved by developing a foreign key relationship program to conduct the code conversion. The SOR unit has begun corresponding with the Georgia Department of Corrections (GDC) to provide information required for the GDC to transmit offender data into the SORT system via their SCRIBE system. The Sheriff's Association Sex Offender Task Force began User Acceptance Tests (UAT) for the SORT system. UAT is scheduled for completion in July. A Computer Based Training (CBT) module is being developed by the Customer Support Unit (CSU). The CSU is also working with the Sex Offender Task Force to develop SORT training sessions for the Georgia Sheriff's Association Conference in August, 2012. The Georgia Department of Corrections' (GDC) SCRIBE system will submit new offender entries directly to SORT for a system to system integration; however, due to legislative priorities the connection between the two systems will be implemented during a different phase of the SOR redesign. The following tasks are pending completion: Completion of the webservices connection between SORT and LEMS/JX SORT system notifications to the local Sheriffs Offices o Set up of SMTP on the mail server Electronic submission of SORT transactions to NCIC Set up of SORT production server o SORT production URL o SORT Link on SSL/VPN menu 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. 12 Monthly Update: June SCON Business Council Meeting was held on 6/18/12. We are currently following up on the items listed below that came out of the Business council meeting: Determine SCON schedule implications once estimated date for server arrival is established. Determine effects on user acceptance testing of planned Oracle 10g upgrade to 11g during migration. Evaluate RFS for upgrading operating system on servers to be migrated to NADC. GTA reviewing server decommission plan from GBI. SCON high level design and network low level design approvals expected from GETS design board in June. GBI and IBM project leaders continue to monitor demands on GBI resources to perform migration Critical Path Tasks/Milestones/Deliverables Baseline Projected End End date Actual End Status Milestone: Test Scripts Complete Major Milestone 11: GTA - SCON-GBI (Affinity #1) Initial Server Build Out Completed Complete Ops Readiness Documentation / Check list SO Approval to turn over to Agency 6/27/12 08/24/12 09/7/12 6/27/12 08/24/12 09/7/12 7/27/12 In progress Re-baseline moved date from 07/12 to 08/24 Re-baseline moved date from 07/26 to 09/7 Accomplishments This Reporting Period Submitted DAD#2 (HLD approved) to GTA for approval Rack & Stack & Cabling of NADC servers on-going Confirmed ship date of 06/28 for 10 medium servers Received data to complete server build sheets Continued progress on HLD 73% - 1st Document review completed Completed NAS documentation milestone GTA approval for DAD #1 received Documented \ Reviewed NADC Rack assignments with AT&T 7. CRIMINAL HISTORY/IDENTIFICATION SERVICES a. Fingerprint Cards Received/Processed Document Criminal Cards NATMS Criminal Juvenile Criminal Applicant Cards NATMS Applicant TOTAL Received June 623 42,616 226 351 23,890 67,706 Received FY2012 12,887 509,036 3,321 3,710 307,653 836,607 Processed June 740 42,485 225 361 24,093 67,904 Processed FY2012 12,716 504,646 3,148 3,854 306,530 830,894 13 b. Significant Productivity Data AFIS Searches (Criminal, Applicant & Juvenile) AFIS Hits (Criminal, Applicant & Juvenile) June 81,729 36,397 (45%) FY2012 900,950 434,177 (48%) c. Live Scan (Electronic Submissions) Activity - June 1. Agencies transmitting electronically 347 (466 devices) 2. Agency added: None 3. These 347 live scan agencies submit electronic fingerprints cards for approximately 739 agencies. 4. On average, during the month, live scan represented 99% 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 June: Inquiries FY2012: Hits June: Hits FY2012: 65,968 823,490 74 823 e. AFIS Remote Activity Inquiries June: Inquiries FY2012: TI Hits June: TI Hits FY2012: LI Hits June: LI Hits FY2012: 364 6,434 5 60 46 953 f. CCH Record Corrections (Specials) Status Total Received Total Rejected Total Completed Total Still in Process June 1,299 107 1,351 103 g. Defense Attorney Requests for Criminal History Records for Criminal and Civil Cases June FY2012 Total Requests 327 3,506 Revenue Collected $1,421.50 $14,846.20 8. SEX OFFENDER REGISTRY a. Sex Offender Registry Records Added During the Month TOTAL June FY2012 192 2,070 14 b. Sex Offender Program Statistics 1. Total number offenders on file = 21,559 2. Predators = 324 3. Juvenile (treat as adult) = 18 4. Total records with images = 21,383 (99%) c. Registered Anniversary Letters Total Letters mailed: June FY2012 1,078 13,611 9. PROTECTION ORDER REGISTRY Records and Images Added During the Month Contributing Counties Records Added Records Added June June FY2012 123 1,958 22,059 Images Added June 11,395 Total orders on file: Active: Inactive: 230,140 8,661 221,479 Images Added FY2012 152,977 15