Georgia Bureau of Investigation November Monthly Report FY2014 Presented to the Board of Public Safety January 9, 2014 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 - 18 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 32 17 14 14 12 16 17 15 16 17 17 10 9 9 10 9 10 12 12 13 13 22 21 21 22 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 873 306 254 218 226 228 244 346 264 240 317 49 42 38 37 38 924 941 1,033 1,078 1,187 160 129 86 82 95 0 0 0 0 0 649 683 791 722 916 62 46 61 46 71 2,840 3,225 3,278 3,174 3,725 4 GBI Administration Office of Privacy & Compliance/Open Records Open Records Request Archives November 2013 250 13 Total FY2014 1,328 112 Personnel Employee Totals November 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 24 0 52 Total 332 105 306 45 788 Total State Funded Positions Vacant Investigative Division 22 Georgia Crime Information Center 17 Division of Forensic Sciences 32 Administration 9 Total 80 State Funded Vacancies Under Active Recruitment 5 15 22 6 48 5 INVESTIGATIVE DIVISION November 2013 Fiscal YTD Total Sworn Employees 235 (filled-includes grant) Total Investigative Hours Expended 21,705.25 132,341.75 Crimes Against Persons, includes Death Investigations Child Abuse Sex Crimes Missing Persons Assault, Kidnapping, Robbery, Terrorist Acts, Fugitive, Human Trafficking, etc. 6,810.00 3,139.50 1,870.00 168.75 34.00 1,597.75 42,206.50 21,227.00 10,501.00 2,037.75 407.00 8,033.75 Property Crimes, including Theft, Burglary, Forgery 2,039.00 12,585.75 Drug Investigations 4,416.00 28,978.00 Meth Lab Investigations 34.00 241.00 Polygraph Examinations 860.00 5,283.00 Background Investigations 254.00 1,179.00 Other Investigations, including Preliminary Investigations 3,658.25 20,753.00 Bomb Disposal Services 691.00 4,459.00 Crime Analysis 23.00 346.50 Crime Scene Specialists 2,920.00 16,310.00 All figures above represent Investigative Hours Total Seizures $263,259.50 $2,517,816.30 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 Total amount expended over the life of the grant: $987,046.50 New grant award for 2013-2014: $693,211.00 Total Expended in November 2013: $24,880.00 Total remaining: $654,116.00 $7,000.00 $6,000.00 $5,000.00 $4,000.00 $3,000.00 $2,000.00 $1,000.00 $0.00 $3,535.00 Carroll Meth Lab Waste Disposal Grant Expenditures By County November 2013 $6,475.00 $4,460.00 $4,415.00 $3,072.50 Cherokee Cook Grady Murray $2,922.50 Pierce 8 Crime Lab Medical Examiners (includes all laboratories) November 2013 FY2014 YTD Autopsies Consultations Total ME Cases Managed 256 1,277 140 652 396 1,929 Clayton County Death Certificates 23 191 Percentage of Cases Released in 90 days: 86% Medical Examiner Activity, FY2014 Consultations 31% Autopsies 69% Confirmed CODIS Hits for November 2013 State Offender Hits 42 State Forensic Hits 6 National Offender Hits 11 National Forensic Hits 0 Total 59 Samples entered into CODIS for November 2013 1,642 Profiles in CODIS Forensic Casework Profiles Convicted Offender Profiles Missing Person/Unidentified Human Remain Profiles Total 9 14,901 269,539 21 284,461 Laboratory Production Report Turnaround for November 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 2,998 3,799 79% 276 296 93% 95 199 48% 193 269 72% 1,207 1,362 89% 97 142 68% 205 240 85% System-wide Totals 5,071 6,307 80% Note: 95.3% 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 16,430 20,585 80% 1,467 1,767 83% 971 1,656 59% 1,219 1,602 76% 8,853 9,504 93% 651 816 80% 1,082 1,285 84% System-wide Totals 30,673 37,215 82% 10 Crime Laboratory Reports Processed for November 2013 Department Requested Total Released Chemistry (includes Drug ID) Firearms Forensic Biology Impressions Latent Prints Medical Examiners Toxicology Trace Evidence 2,072 266 1,560 7 159 396 1,865 99 2,202 398 1,781 5 67 326 1,767 87 Total 6,424 6,633 Crime Laboratory Reports Processed FY2014 Department Requested Total Released Chemistry (includes Drug ID) Firearms Forensic Biology Impressions Latent Prints Medical Examiners Toxicology Trace Evidence 12,448 1,667 11,779 25 886 1,925 10,250 501 11,917 2,014 12,218 30 582 1,943 9,974 480 Total 39,481 39,158 11 Georgia Crime Information Center NOVEMBER 2013 1. SYSTEM AVAILABILITY: Max Hours Possible for Month Downtime (Hours) Degraded (Hours) Percent Available for Month AFIS 720.00 Enterprise GoNET/ Network 2200 Infrastructure 720.00 720.00 IBM System 720.00 0.00 63.25 0.00 18.00 0.00 0.00 0.00 0.00 100% 91.22% 100% 97.50% NCIC Files 720.00 4.00 0.00 99.44% NICS NLETS 720.00 4.00 0.00 99.44% 720.00 3.00 0.00 95.83% 2. AUDITS: During the reporting month there were 16 full service audits conducted. There were 9 on-site audits conducted for agencies with "inquiry only" access from the CJIS network; 18 criminal justice E-Audits; and 70 fingerprint/disposition audits. The total number of audits conducted during FY2014: 283. 3. TRAINING: GCIC personnel provided 221.25 hours of training to 850 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 the Sex Offender Registry staff switched over to the Integra Image Archive system and a final conversion of the CBM Archives data was performed. Microfilm records received through November have been converted and are ready to search and retrieve via TNET. 5. SEX OFFENDER REGISTRY REDESIGN 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. 12 Monthly Update: Application Development and Sex Offender personnel continue to monitor SORT transactions. Accomplishments This Reporting Period IBM implemented change to correct load balancer persistence method Modified SORT Public Website software to resolve issues associated with inaccurate search results SORT Public Website deployed to production environment Geocoded SORT Primary Residence addresses Tasks in Progress Working with Unisys to resolve issues associated with NCIC supplemental transactions SORT project team continues to test SORT Public Website; changes and/or corrections are made as needed Geocoding of school and employment addresses Project Issues/Risks and Mitigation Special characters not accepted by NCIC. Field edits will be implemented to match NCIC. Resolution of NCIC supplemental issues. Currently supplemental information not being sent to NCIC. Items Requiring Management Attention/Escalation: None 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: Last Business Council meeting held on November 20, 2013; the next Business Council meeting will be December 18, 2013. Accomplishments This Reporting Period On-going progress by Agency on applications installation/remediation Continued analysis for firewall security lock-down Resolved CCH-Oracle DB cluster issues on Prod Tasks in Progress Finish application installs & remediation Begin 1st UAT on second group of SCON servers 13 Project Issues / Risks and Mitigation Progress has been made in the legacy environment but AT&T has significant work to accomplish to correct configuration issues with the SSLX. Steady state support issues need to be addressed prior to the 2nd production cut over of the major applications in May 2014. Issues with Mitigation Plan Several connectivity issues must be resolved with major applications prior to starting 1st UAT. Each month that production cut over is delayed it pushes the cut over date out another month. Production cut over is now scheduled for May 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. SCON Vendor access to LEM via Portal XL Items Requiring Management Attention/Escalation: None Critical Path Tasks / Milestones/Deliverables Final approval of SCON-GBI (Affinity #1) DAD #4 UAT Ops Readiness IBM continues remediation on 2nd group of servers Execute Testing Scripts 1st UAT (2nd production cut over) 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 Cut over (Major Applications) 7/25/2013 Projected End Date 2/28/2013 Start 5/05/2013 End 1/24/2014 Start 1/24/2014 End 3/07/2014 4/24/2014 5/07/2014 Status Will resubmit when DB's are installed and reported as monitored and backed-up. IBM continues progress on remediating applications. These dates are dependent on IBM correcting all access concerns for LEMS, CCH and SORT Expect late start date due to late OP's readiness. The major application cut over date May 2014 is now planned due to missed commitments to remediate CCH, LEMS and Portal SSLX issues. 14 7. ADVANCED AUTHENTICATION Project Description GBI is working with RSA to implement a solution that will meet requirements outlined in the FBI CJIS Security Policy 5.2 for advanced authentication. The RSA product will integrate seamlessly with the State of Georgia's existing SSL VPN and will offer a comprehensive multi-factor layered protection for all users. Monthly Update: The GBI continues to make progress in the implementation of the Advanced Authentication services to integrate with the SSL VPN product. Accomplishments This Reporting Period GBI discovered ports were being blocked and network traffic was not making it to the server. Meetings were held with AT&T and IBM to determine what network services, processes or security features were preventing traffic from passing through. The project team reviewed the Data Application Flow version 6 and discovered discrepancies in what was in the original version provided to GBI. Issues were found with the set-up of the Juniper Adapter SA6500 communication with the Radius. AT&T created a new diagram that documented the correct Radius Server information. The path for the configuration changes were completed by AT&T that enabled Radius connectivity between AT&T Retail's Juniper-based SSL VPN offering and the GETS Hosting Environment. Tasks in Progress Currently testing the work that was completed by AT&T Developing UAT plan for each test case scenario Project Issues/Risks and Mitigation The testing completed by GBI was unsuccessful. GBI is working with RSA to review the logs and configuration to determine why the authentication is failing when testing the user IDs. While RSA has provided continued support to the GBI in the software configuration, as the project progresses RSA will be engaged with other projects and limited time will be committed to being on stand-by for the GBI. FBI deadline of September 30, 2013 not met. Items Requiring Management Attention/Escalation As the testing and configuration continues, change requests will need to be escalated to eliminate continued project delays. 8. SORNA REALLOCATION GRANT PROJECT Project Description - GBI received a Sex Offender Registration and Notification Act (SORNA) grant award from the Criminal Justice Coordinating Council (CJCC) to assist the State in moving towards compliance with the SORNA portion of the Adam Walsh Act. One of the line items within this grant is the purchase of live scan devices to be used by the Georgia Department of Corrections (GDC) to capture fingerprints and palm prints to verify the identity of individuals entering the State Prison system. Another item included in this grant is the configuration of CCH to accept information from the GBI Automated Fingerprint Identification System (AFIS). 15 Accomplishments This Period The DOC is in the process of selecting a vendor for the purchase of livescan devices. The GBI met with Unisys to discuss the business requirements for the file transfer process. Tasks in Progress The GBI is progressing with the development of further business requirements and planning for the following: 1) Modify AFIS to incorporate a new transaction type to capture and retain sex offender finger and palm prints. (Task Projected End date: February 2014). 2) Create a Project Change Request (PCR) to modify CCH to accept profiled DNA information from CODIS. (Task Projected End date: January 2014). 3) Work with Unisys on data file transfer routines. Unisys will create the Statement of Work (SOW) to be approved by the GBI by December 13, 2013 and the work is planned to be completed by February 2014. 4) GBI believes that a contract worker will not be required to compare CODIS records with SORT records since an electronic comparison method has been established. Grant funds will need to be returned or the grant modified to reallocate funds to support other initiatives identified within the grant request. (Task Projected End date: January 2014). 5) Develop specifications for an interface between SORT and the SORNA exchange portal. (Task Projected End date: March 2014) Project Issues/Risks and Mitigation Delays by DOC with the procurement process will result in the grant funds being reallocated or returned. Items Requiring Management Attention/Escalation None 9. FILE SERVICES TRANSFORMATION/CONSOLIDATION PROJECT Project Description Move identified GBI File Server data from existing legacy hardware to new operationally stable and supportable hardware. Monthly Update: Three site surveys have been completed to date out of thirty-four (34) possible sites included in the project. Accomplishments This Reporting Period GBI provided IBM contact list information Gathered server and site information Scheduled weekly checkpoint meetings Three site surveys completed by OnePath Scheduled presentations for GBI TEAM with Dell, TIG and Presidio to review backup vendor options and possibilities Scheduled "Lessons Learned" meeting with DNR to learn their perspective on SCON, File and Print Services Projects Tasks in Progress Continue coordinating site surveys Weekly checkpoint meetings 16 Review alternative backup options and possibilities to increase efficiencies and decrease costs Project Issues/Risks and Mitigation Failure to restore data in a timely manner Project expense Items Requiring Management Attention/Escalation None 10. CRIMINAL HISTORY/IDENTIFICATION SERVICES a. Fingerprint Cards Received/Processed Document Criminal Cards Electronic Criminal Juvenile Cards Electronic Juvenile Applicant Cards Electronic Applicant TOTAL Received November 333 40,085 30 203 181 26,329 67,161 Received FY2014 1,877 216,130 206 963 857 158,554 378,587 Processed November 317 38,061 39 178 170 25,387 64,152 Processed FY2014 1,711 207,979 190 875 797 153,607 365,159 b. Significant Productivity Data AFIS Searches (Criminal, Applicant & Juvenile) AFIS Hits (Criminal, Applicant & Juvenile) November FY2014 64,392 364,914 35,131 (55%) 192,874 (53%) c. AFIS Latent Activity Inquiries November: Inquiries FY2014: Hits November: Hits FY2014: 64,485 366,448 29 227 d. CCH Record Corrections (Specials) Status November Total Received 720 Total Rejected 24 Total Completed 664 Total Still in Process 4 e. Defense Attorney Requests for Criminal History Records for Criminal and Civil Cases November FY2014 Total Requests 191 1,254 Revenue Collected $780.00 $6,240.00 17 11. SEX OFFENDER REGISTRY a. Sex Offender Registry Records Added During the Month TOTAL November FY2014 157 892 b. Sex Offender Program Statistics 1. Total number offenders on file = 23,957 2. Predators = 451 3. Juvenile (treat as adult) = 16 4. Total records with images = 22,363 (93%) c. Registered Anniversary Letters Total Letters mailed: November FY2014 1,332 6,746 12. PROTECTION ORDER REGISTRY Records and Images Added During the Month Contributing Counties Records Added Records Added November November FY2014 103 1,743 9,578 Images Added November 11,744 Images Added FY2014 69,548 Total orders on file: Active: Inactive: 263,711 8,918 254,793 18