Georgia Bureau of Investigation July Monthly Report FY2015 Presented to the Board of Public Safety No Meeting Scheduled for September 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 - 19 2 Vacant State Positions FY2015 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 23 4 7 7 10 24 3 DOFS Backlog Chart Unworked Reports over 30 Days Old FY2015 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 1,241 402 232 36 1,789 65 0 911 151 4,827 4 GBI Administration Office of Privacy & Compliance/Open Records Open Records Request Archives July 2014 296 26 Total FY2015 296 26 Personnel Employee Totals July 2014 Investigative Division Georgia Crime Information Center Division of Forensic Sciences Administration Total State Funded Positions 318 40 284 44 686 Grant Funded Positions 18 66 24 0 108 Total 336 106 308 44 794 Total State Funded Positions Vacant Investigative Division 24 Georgia Crime Information Center 7 Division of Forensic Sciences 23 Administration 7 Total 61 State Funded Vacancies Under Active Recruitment 10 7 8 5 30 5 INVESTIGATIVE DIVISION July 2014 Fiscal YTD Total Sworn Employees 241 (filled-includes grant) Total Investigative Hours Expended 27,291.75 27,291.75 Crimes Against Persons, includes Death Investigations Child Abuse Sex Crimes Missing Persons Assault, Kidnapping, Robbery, Terrorist Acts, Fugitive, Human Trafficking, etc. 7,691.50 3,654.00 2,130.00 262.00 53.00 1,592.50 7,691.50 3,654.00 2,130.00 262.00 53.00 1,592.50 Property Crimes, including Theft, Burglary, Forgery 2,771.50 2,771.50 Drug Investigations 5,334.00 5,334.00 Meth Lab Investigations 34.00 34.00 Polygraph Examinations 1,128.00 1,128.00 Background Investigations 258.00 258.00 Other Investigations, including Preliminary Investigations 5,018.75 5,018.75 Bomb Disposal Services 730.00 730.00 Crime Analysis 32.00 32.00 Crime Scene Specialists 4,294.00 4,294.00 All figures above represent Investigative Hours Total Seizures $469,029.00 $469,029.00 6 Investigative Hours Expended YTD FY2015 Crime Analysis >1% Background Investigations 1% Bomb Disposal Services 3% Crime Scene Specialists 16% Crimes Against Persons 28% Other Investigations 18% Polygraph Examinations Meth Lab Investigations 4% >1% Property Crimes 10% Drug Investigations 20% 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 amount expended over the life of the grant: $1,223,015.80 Total Expended in July 2014: $48,699.30 Total remaining: $418,146.70 $25,000.00 $20,000.00 Meth Lab Waste Disposal Grant Expenditures By County July 2014 $22,657.50 $15,000.00 $10,000.00 $5,000.00 $4,155.00 $3,125.00 $3,754.30 $0.00 Lanier Montgomery Murray $3,737.50 Polk Richmond $4,662.50 Stephens $2,102.50 $3,997.50 Tattnall Ware 8 Crime Lab Medical Examiners (includes all laboratories) July 2014 FY2015 YTD Autopsies Consultations Total ME Cases Managed 254 254 140 140 394 394 Clayton County Death Certificates 47 47 Percentage of Cases Released in 90 days: 85% Medical Examiner Activity, FY2015 Consultations 36% Autopsies 64% Confirmed CODIS Hits for July 2014 State Offender Hits 63 State Forensic Hits 5 National Offender Hits 14 National Forensic Hits 2 Total 84 Samples entered into CODIS for July 2014 1,734 Profiles in CODIS Forensic Casework Profiles Convicted Offender Profiles Missing Person/Unidentified Human Remain Profiles Staff/QC File Total 9 15,952 281,448 4 349 297,753 Laboratory Production Report Turnaround for July 2014 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,505 4,707 74% 299 402 74% 192 350 55% 309 454 68% 1,513 1,738 87% 199 299 67% 198 231 86% System-wide Totals 6,215 8,181 76% Note: 94.6% 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 3,505 4,707 74% 299 402 74% 192 350 55% 309 454 68% 1,513 1,738 87% 199 299 67% 198 231 86% System-wide Totals 6,215 8,181 76% 10 Crime Laboratory Reports Processed for July 2014 Department Requested Total Released Chemistry (includes Drug ID) Firearms Forensic Biology Impressions Latent Prints Medical Examiners Toxicology Trace Evidence 2,917 266 2,600 10 191 394 2,478 137 2,461 457 2,283 8 73 399 2,808 91 Total 8,993 8,580 Crime Laboratory Reports Processed FY2015 Department Requested Total Released Chemistry (includes Drug ID) Firearms Forensic Biology Impressions Latent Prints Medical Examiners Toxicology Trace Evidence 2,917 266 2,600 10 191 394 2,478 137 2,461 457 2,283 8 73 399 2,808 91 Total 8,993 8,580 11 Georgia Crime Information Center CJIS Network Statistics System Uptime: Messages Processed: CJIS Operations 1. Sex Offender Registry Records Added 2. Protection Order Registry Records Added July 2014 99% 57,949,362 Month 183 Month 2,030 FY2015 183 FY2015 2,030 Database Totals 25,142 Database Totals 277,859 3. National Data Exchange (N-DEx) Number of Georgia agencies contributing to N-DEX: 3 Agencies/Users with N-DEx Inquiry Access Only (no data contributed) Added Removed Total with Inquiry Access Agencies Users 0 0 27 1 0 47 4. Off-Line Search Requests Type of Request Month FY2015 Administrative (Criminal Justice 21 21 Agency) Open Records 0 0 Subpoena 0 0 Media 0 0 Possible CJIS Security Violations 5 5 12 Criminal History Identification Services 1. Criminal Fingerprint Transactions Received Submissions Submissions w/Palms Submissions w/Photos Monthly 45,683 9,628 10,651 FY 2015 45,683 9,628 10,651 Transactions processed within 2 hours of receipt: 93% 2. Applicant Fingerprint Transactions Received Submissions Monthly 37,955 FY 2015 37,955 Transactions processed within 24 hours of receipt: 99% 3. Final Disposition Transactions Received GCIC TOTAL Monthly 3,548 66,811 FY 2015 3,548 66,811 4. RAPID Identification Transactions Submissions AFIS Hits NCIC Hits FBI RISC Hits 18,948 40% 41% 1% 18,948 40% 41% 1% 5. Disposition Recovery Project Provided to Vendors Completed by GCIC Research Counties Previous 0 6,998 3 July Accumulative To Date 0 16,926 839 7,837 3 3 13 14 Compliance and Customer Support 1. Customer Training GCIC personnel provided 252 hours of training to 404 criminal justice agency employees during the month. The total number hours of training conducted during FY2015: 252. 2. Compliance Audits GCIC conducted (0) full service audits; (0) on-site audits conducted for agencies with "inquiry only" access from the CJIS network; (22) non-criminal justice audits; and (0) fingerprint/disposition audits for the month. The total number of audits conducted during FY2015: 22. Plans and Program Development - Projects AFIS REPLACEMENT Project Description-- GCIC 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. Phase III focused on the FBI's Next Generation Identification (NGI) Increment 3 implementation which introduces two new features: palm submission capability and the use of the EFS (Extended Feature Set) profiles for latent searches of AFIS systems The project is in Phase IV which focuses on the FBI's Electronic Biometric Specification Transmission (EBTS) v10.0 compliance for greater compatibility to NGI 4. Listed below are changes required for T-Net and AFIS: 1. Accept and process any EBTS v10.0 live scan submission that conforms to GBI edits. 2. Ignore additional NIST record types allowed by EBTS v10.0 but are not required by GBI and successfully pass a full NIST record to the FBI if needed. 3. Accept and process NIST transactions which submit Type 14 1000 ppi fingerprint images. 4. Ensure all incoming to GBI and outgoing to FBI transactions are in EBTs v10.0 format. 5. FIS transactions sent to FBI should include a photo if the transaction is received with the photo. 6. Store NIST file contained in NIST record types not used by AFIS in Image Archive. 7. Send FBI bound submissions from Individual Fingerprint Workstation (IFW) as EBTS v10.0. 8. Support EBTS v10.0 compliant inbound and outbound transactions on the interoperability interface. 9. Import EBTS v10.0 LFFS and LFIS files for latent input. 10. Continue to accept and process EBTS v9.x transactions that conform to GBI edits. 15 Accomplishments This Reporting Period CCH/Ident and Applicant Services Requested Enhancements: Change Order GBI2014-01 complete T-Net change to add flag to T-Net Contributor table to indicate whether contributor may submit arrest transaction to CCH. Also, VECHS-GBI ORI for applicant GAV requests (GAPS). Change GAV# to GAGBIVECH when sending to the FBI. Change Order GBI2014-02A complete Add an optional NIST tag to transactions that will be used to create a note for the transaction on AFIS. Change Order GBI2014-03 complete New report listing applicant statutes with all ORI's who may submit transactions with that statute. 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-to-date 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 include the implementation of the SORT Public Website and the establishment of a web service between the SORT and Department of Corrections' SCRIBE system for data transfer. Additional phases include the integration of SORT with the NEC Image Archive (AFIS/IA) and customized photo and reporting enhancements. Monthly Update The SORT project team continues to monitor SORT transactions. SORT has begun the transition from the legacy environment to the SCON environment. Design development for the SORT Entry Service is in progress. Accomplishments This Reporting Period Unisys completed the design document mapping SORT data elements to receive, enter & update an offender to its data table in SORT and the corresponding National Information Exchange Model (NIEM) data element to develop the NIEM Information Exchange Package (IEPD) and to document validations of each data element Unisys completed the initial testing of the SORT Entry Service client in the SCON Test environment 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. Monthly Update The last Business Council meeting was held July 16, 2014. 16 Accomplishments This Reporting Period UAT #2 is Complete LLD submitted to GTA for approval Completed implementation of remaining urgent changes to close all issues Received approval for prod cut over change ticket 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.0 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 SSLX-VPN product. Accomplishments This Reporting Period IBM completed the PCR to close RFS1018 for Advanced Authentication; IBM has completed all requirements of the Technical Specification Document (TSD). The final draft was signed by GBI and submitted back to IBM. RAPIDID 2-FACTOR ADVANCED AUTHENTICATION Project Description: The software client for the RapidID Motorola MC75 devices was modified to include a fingerprint enrollment in the user logon procedure. Each user is required to enter a username, password and fingerprint of the left index finger as an enhancement of advanced authentication for the MC75 devices. The software upgrade is deployed to each MC75 device by an automatic software update process which prompts each user to enroll the fingerprint using the device scanner. The upgrade is deployed in three phases of two week intervals with the final phase ending May 30, 2014. The Cogent Bluecheck device will rely on the authentication used by the paired PC. The software client for the Cogent CSD-450 device was modified to support fingerprint enrollment for the advanced authentication upgrade. A web service was created to allow 3rd party systems to submit fingerprints to the RapidID server for user authentication. Accomplishments This Reporting Period The roll-out of the new software update was completed; o 119 agencies completed the software update; however, there are still users that need to complete the fingerprint enrollment. 17 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). Monthly Update Decision made on handling DNA Profile messages with no associated SID. Reobligation of funds request approved by the Federal Grantors for use in sending attendees to two other trainings, purchase of scanners, and some electrical work for the Sex Offender Image Archive system workstations. LIMS extraction for DNA Profile message is being revised to include the SSN. Unisys has documented the configuration and will revise as needed. Accomplishments This Reporting Period Decision made on how to handle a DNA Profile extracted from LIMS that has no associated SID: All DNA profile records are to be extracted from LIMS with or without an associated SID. o Profiles with an associated SID will be processed by the LEMS/JX switch and sent to the CCH for automatic matching and update to record. o Profiles with no associated SID will be directed to an error message queue to be researched by the CCH unit. The sample data extraction was discussed with CCH to ensure that adequate information is provided in the DNA Profile messages sent to the error queue to aid in resolving. DOFS currently stores the SSN in LIMS but plan to discontinue this practice in the near future. The SSN will be included with messages on the initial population effort. Going forth the SID should be required on all submissions to the lab so the SSN should not be needed. DOFS will revise the LIMS data extraction to include the SSN. CJCC and the Federal Grantors have approved the reobligation of funds for trainings and contract work related to the Sex Offender Image Archive. 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 -- the shipping dates for all R2D2 servers have been placed "on hold" until further notice because temperatures in most regional office server rooms are above the allowable temperature for server rooms. Accomplishments This Reporting Period New C3PO server for GBI-Data at HQ has been delivered and installed. R2D2 server has been delivered and installed at Kingsland. R2D2 servers have been delivered to Forsyth, Statesboro, Eastman and Douglas. Identified that temperatures are above standard operating temperatures in the majority of designated server rooms in regional offices where new R2D2 servers should be installed. 18 GEORGIA SECONDARY METAL RECYCLER PROJECT Project Description O.C.G.A. 10-1-360.1 and 10-1-353 require that GBI establish and maintain a database of required purchase transaction information from secondary metal recyclers that is accessible and searchable by Georgia law enforcement agencies. Monthly Update preparing to conduct the vendor evaluation process. Accomplishments This Reporting Period Scheduled vendor RFP evaluation for August 4, 2014. DOAS reviewed appeals to the bid process for this RFP. FINANCE AP UPLOAD PROJECT Project Description In an effort to improve efficiency in operations, the GBI Accounting Department is seeking to automate the uploading of invoice/payment transactions to Teamworks thus reducing, if not eliminating, the amount of data entry. The two areas for uploading transactions are the CJCC Victim's Compensation payments and various internal payments. The GBI Accounting Department has secured a contractor for the project and has obtained programming for a macro enabled spreadsheet that meets the SAO flat file requirements (2010) from the GA Soil & Water Conservation Commission. This will serve as the starting point for the contactor in automating the upload of internal payments. The contractor will work with the CJCC to define what is needed to automate the uploading of invoice/payment transactions in their Crime Management Information System. Monthly Update Project requirements submitted. Logistics and work equipment/applications secured for the contractor. Contractor began work on August 1, 2014. Discovery for automating the upload of internal payments is in process. Accomplishments This Reporting Period Project assigned to P & PD. Initial meeting with Project Manager and Stakeholders. Laptop and network access secured for contractor. Discovery meetings with stakeholders to define project scope, requirements, and deliverables. Participated in discussions and source data mapping session with CJCC on sources for data, readiness of data extraction, and potential process changes with automation. 19