Georgia Bureau of Investigation October Monthly Report FY2014 Presented to the Board of Public Safety December 12, 2013 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 - 8 IV. Crime Lab.............................................. 9 - 11 V. Georgia Crime Information Center................. 12 - 16 2 Vacant State Positions FY2014 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 Jun 31 28 28 28 17 14 14 12 17 15 16 17 10 9 9 10 10 12 12 13 22 21 21 22 3 DOFS Backlog Chart Unworked Reports over 30 Days Old FY2014 Discipline Chemistry Firearms Forensic Biology Impressions Latent Prints Medical Examiners Miscellaneous Services Toxicology Trace Evidence Total Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun 446 784 787 743 306 254 218 226 244 346 264 240 49 42 38 37 924 941 1,033 1,078 160 129 86 82 0 0 0 0 649 683 791 722 62 46 61 46 2,840 3,225 3,278 3,174 4 GBI Administration Office of Privacy & Compliance/Open Records Open Records Request Archives October 2013 242 22 Total FY2014 986 99 Personnel Employee Totals October 2013 Investigative Division Georgia Crime Information Center Division of Forensic Sciences Administration Total State Funded Positions 318 91 282 45 736 Grant Funded Positions 14 14 18 0 46 Total 332 105 300 45 782 Investigative Division Georgia Crime Information Center Division of Forensic Sciences Administration Total Total State Funded Positions Vacant 22 17 28 10 77 *As of November 22, 2013 State Funded Vacancies Under Active Recruitment* 5 10 22 5 42 5 INVESTIGATIVE DIVISION October 2013 Fiscal YTD Total Sworn Employees 235 (filled-includes grant) Total Investigative Hours Expended 26,228.50 110,636.50 Crimes Against Persons, includes Death Investigations Child Abuse Sex Crimes Missing Persons Assault, Kidnapping, Robbery, Terrorist Acts, Fugitive, Human Trafficking, etc. 7,755.50 3,526.00 2,229.00 253.00 131.00 1,616.50 35,396.50 18,087.50 8,631.00 1,869.00 373.00 6,436.00 Property Crimes, including Theft, Burglary, Forgery 2,514.00 10,546.75 Drug Investigations 5,745.00 24,562.00 Meth Lab Investigations 8.00 207.00 Polygraph Examinations 976.00 4,423.00 Background Investigations 141.00 925.00 Other Investigations, including Preliminary Investigations 5,037.00 17,094.75 Bomb Disposal Services 895.00 3,768.00 Crime Analysis 75.00 323.50 Crime Scene Specialists 3,082.00 13,390.00 All figures above represent Investigative Hours Total Seizures $449,734.45 $2,254,556.80 6 Investigative Hours Expended YTD FY2014 Crime Analysis Bomb >1% Disposal Services 3% Other Investigations 16% Background Investigations 1% Crime Scene Specialists 12% Crimes Against Persons 32% Polygraph Examinations 4% Meth Lab Investigations >1% Drug Investigations 22% Property Crimes 10% 7 Meth Lab Waste Disposal Grant Total amount expended February 2012 through September 2013: $947,951.50 New grant award for 2013-2014: $693,211.00 Total Expended in October 2013: $14,215.00 Total remaining: $678,996.00 $6,000.00 $5,000.00 $4,000.00 $3,000.00 $2,000.00 $1,000.00 $0.00 Meth Lab Waste Disposal Grant Expenditures By County October 2013 $5,445.00 $3,027.50 Berrien $1,640.00 Cook Glynn $4,102.50 Murray 8 Crime Lab Medical Examiners (includes all laboratories) October 2013 FY2014 YTD Autopsies Consultations Total ME Cases Managed 255 1,021 139 512 394 1,533 Clayton County Death Certificates 42 168 Percentage of Cases Released in 90 days: 85.3% Medical Examiner Activity, FY2014 Consultations 32% Autopsies 68% Confirmed CODIS Hits for October 2013 State Offender Hits 46 State Forensic Hits 2 National Offender Hits 11 National Forensic Hits 0 Total 59 Samples entered into CODIS for October 2013 1,584 Profiles in CODIS Forensic Casework Profiles Convicted Offender Profiles Missing Person/Unidentified Human Remain Profiles Total 14,778 268,020 21 282,819 9 Laboratory Production Report Turnaround for October 2013 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 3,363 4,290 78% 333 462 72% 226 386 59% 350 441 79% 1,812 1,954 93% 170 212 80% 250 277 90% System-wide Totals 6,504 8,022 81% Note: 95% Casework Reports were released within 90 days. Report Turnaround for Year-to-Date, FY2014 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 13,432 16,786 80% 1,191 1,471 81% 876 1,457 60% 1,026 1,333 77% 7,646 8,142 94% 554 674 82% 877 1,045 84% System-wide Totals 25,602 30,908 83% 10 Crime Laboratory Reports Processed for October 2013 Department Requested Total Released Chemistry (includes Drug ID) Firearms Forensic Biology Impressions Latent Prints Medical Examiners Toxicology Trace Evidence 2,785 232 2,940 6 208 394 2,161 123 2,737 267 2,545 4 117 334 2,250 102 Total 8,849 8,356 Crime Laboratory Reports Processed FY2014 Department Requested Total Released Chemistry (includes Drug ID) Firearms Forensic Biology Impressions Latent Prints Medical Examiners Toxicology Trace Evidence 10,371 1,282 10,243 18 727 1,531 8,393 404 9,715 1,616 10,437 25 515 1,617 8,207 393 Total 32,969 32,525 11 Georgia Crime Information Center OCTOBER 2013 1. SYSTEM AVAILABILITY: Max Hours Possible for Month Downtime (Hours) Degraded (Hours) Percent Available for Month AFIS 744.00 Enterprise GoNET/ Network 2200 Infrastructure 744.00 744.00 IBM System 744.00 5.00 42.50 0.00 4.00 0.00 0.00 0.00 0.00 99.33% 94.29% 100% 99.46% NCIC Files 744.00 7.00 0.00 99.06% NICS NLETS 744.00 7.00 0.00 99.06% 744.00 4.00 0.00 99.46% 2. AUDITS: During the reporting month there were 15 fingerprint/disposition audits and 20 on-site audits conducted for agencies with "inquiry only" access from the CJIS network. The total number of audits conducted during FY2014: 170. 3. TRAINING: GCIC personnel provided 298 hours of training to 903 criminal justice agency employees during the month. 4. AFIS REPLACEMENT Project Description: GCIC has replaced the Georgia Bureau of Investigation's 22 year old Automated Fingerprint Identification System (AFIS). The AFIS replacement enhanced fingerprint identification services to permit identification of criminals more rapidly through the use of state of the art alternative search methods and information sharing. Phase II of the project focuses on the Image Archive system expansion. The expansion allows divisions within GBI to store documents and easily retrieve when needed. Monthly Update: During this reporting period all major issues with the Image Archive system were resolved. All units have been trained and have the ability to use the system. The conversion of the microfilmed documents started with approximately 3.4 million documents loaded. 5. SEX OFFENDER REGISTRY RE-DESIGN PROJECT Project Description: In October 2012, GBI implemented a new sex offender management application, Sex Offender Registry Tool (SORT). SORT is a more modernized system that uses the latest web technologies to provide local law enforcement access to centralized up-todate information of sex offenders in their jurisdictions. Local agency staff has direct access to offender data with limited administrative authority to manage users. The remaining phases of the project are the implementation of the Public Sex Offender Registry using the current (SORT) database and the integration of the SORT with the Department of Corrections' SCRIBE system. Additional phases also include the integration of the SORT system with the newly enhanced Automated Fingerprint Identification System's Image Archive (AFIS/IA) and customized photo and reporting enhancements. Monthly Update: The Application Development Support unit and the Sex Offender unit continue to monitor SORT transactions. 12 The SORT Public website was deployed and a load balancer issue was discovered. A ticket has been submitted to IBM for resolution. Code changes for Google Maps were also made and have been deployed. To ensure all addresses were geocoded properly a batch process was run against the SORT database records. The SORT Public Website will run parallel with the existing Sex Offender Public Website hosted by GANet until the National Sex Offender Public Website (NSOPW) has been successfully integrated with the SORT Public website. 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: We are now on a once a month schedule for the SCON Business Council meetings. The last meeting was held on October 16, 2013 and the next meeting is scheduled November 20, 2013. Accomplishments This Reporting Period On-going progress by Agency on applications installation/remediation Continued analysis for firewall security lock-down Continued progress to prep for Group #1 production cutover - On target for 11/08/13 production cutover event Planned Accomplishments Tasks in Progress Finish application installs & remediation Begin UAT Project Issues / Risks and Mitigation Progress has been made in the legacy environment but AT&T has significant work to accomplish to correct configuration and connectivity issues with LEMS and Portal applications in the SCON environment. Steady state support issues need to be addressed prior to the 2nd production cutover of the major applications in April 2014. Issues with Mitigation Plan: Several connectivity issues must be resolved with major applications prior to starting 1st UAT. Each month that production cutover is delayed it pushes the cutover date out another month. Production cutover is now scheduled for April 2014. Risks: Issues which must be resolved by AT&T are as follows: 1. Metro Header access to CCH 2. SSLVPN SCON Access to internal GBI applications 3. Vendor SCON vendor access to LEM via Portal XL. Items Requiring Management Attention/Escalation: None 13 Critical Path Tasks / Milestones/Deliverables Final approval of SCON-GBI (Affinity #1) DAD #4 UAT Ops Readiness Agency begins application rebuilds on servers Execute Testing Scripts 1st UAT (only six servers are in 1st production cutover) Agency Formal Approval of UAT Test as Complete for first six servers (2nd UAT) Baseline End 12/18/2012 Start 1/14/2013 End 2/18/2013 Start 2/19/2013 End 3/26/2013 5/29/2013 2nd Production Cutover (Major Applications) 7/25/2013 Projected End Date 2/28/2013 Start 5/05/2013 End 7/20/2013 Start 9/04/2013 End 11/08/2013 11/10/2013 April 2014 Status Will resubmit when DB's are installed and reported as monitored and backed-up. GBI continues progress on installing applications. Expect late start date due to late OP's readiness 20 UAT's are in the testing process. Expect late start date due to late OP's readiness. The major application cutover date April 2014 is now planned due to missed commitments to remediate CCH, LEMS and Portal SSLX issues. 7. ADVANCED AUTHENTICATION Project Description - The CJIS Security Policy is published by the FBI in partnership with the CJIS Advisory Policy Board (APB). The CJIS Security Policy integrates presidential directives, federal laws, FBI directives and the criminal justice community's APB decisions along with guidance from the National Institute of Standards and Technology (NIST) and the National Crime Prevention and Privacy Compact Council (Compact Council). The goal of the Security Policy is to provide a unified set of standards and best practices to ensure that criminal justice information (CJI) is kept secure and only accessed by authorized personnel in the performance of their duties and that appropriate controls are in place to protect CJI, from creation through dissemination; whether at rest or in transit. In order to meet the obligations outlined in the FBI CJIS Security Policy 5.2 (CJISD-ITS-DOC-08140-5.2), GBI will implement an advanced authentication solution that will integrate seamlessly with the States' existing SSL VPN solution. GBI is working with RSA the Security Division of EMC to implement the RSA Adaptive Authentication (On-Premise) application. This solution offers a comprehensive multi-factor layered protection for all users. This risked-based authentication (RBA) technology will conduct a risk assessment to positively assure the user's identity and to detect fraudulent activity. Monthly Update: The GBI continues to make progress in the implementation of the Advanced Authentication services to integrate with the SSL VPN product. AT&T recently resolved issues around the load balancer and the firewall. The GBI plans to begin testing the week of November 11th and engage RSA for the completion of the configuration of the Advanced Authentication On-Premise software. 14 8. SORNA REALLOCATION GRANT PROJECT Monthly Update GBI received a Sex Offender Registration and Notification Act (SORNA) grant award from the Criminal Justice Coordinating Council (CJCC) to assist the Georgia Department of Corrections (GDC) in moving the State towards compliance with the SORNA portion of the Adam Walsh Act. The GDC is working on a Request for Proposal (RFP) to begin the solicitation process for selecting a vendor. The GBI project planning sessions continues as the exact amount of work is determined for application development and business requirements to support the grant. 9. CRIMINAL HISTORY/IDENTIFICATION SERVICES a. Fingerprint Cards Received/Processed Document Criminal Cards Electronic Criminal Juvenile Cards Electronic Juvenile Applicant Cards Electronic Applicant TOTAL Received October 362 44,192 64 213 181 30,925 75,937 Received FY2014 1,544 176,045 176 760 676 132,225 311,426 Processed October 364 42,279 50 196 163 30,024 73,076 Processed FY2014 1,394 169,918 151 697 627 128,220 301,007 b. Significant Productivity Data AFIS Searches (Criminal, Applicant & Juvenile) AFIS Hits (Criminal, Applicant & Juvenile) October 72,884 39,093 (54%) FY2014 300,522 157,743 (52%) c. AFIS Latent Activity Inquiries October: Inquiries FY2014: Hits October: Hits FY2014: 73,102 301,963 52 198 d. CCH Record Corrections (Specials) Status October Total Received 1,061 Total Rejected 88 Total Completed 1,062 Total Still in Process 30 e. Defense Attorney Requests for Criminal History Records for Criminal and Civil Cases October FY2014 Total Requests 236 1,063 Revenue Collected $1,230.00 $5,460.00 15 10. SEX OFFENDER REGISTRY a. Sex Offender Registry Records Added During the Month TOTAL October FY2014 224 735 b. Sex Offender Program Statistics 1. Total number offenders on file = 23,824 2. Predators = 442 3. Juvenile (treat as adult) = 17 4. Total records with images = 22,223 (93%) c. Registered Anniversary Letters Total Letters mailed: October FY2014 1,251 5,414 11. PROTECTION ORDER REGISTRY Records and Images Added During the Month Contributing Counties Records Added Records Added October October FY2014 118 2,034 7,835 Images Added October 14,454 Images Added FY2014 57,804 Total orders on file: Active: Inactive: 261,689 8,853 253,016 16