Georgia Bureau of Investigation August Monthly Report FY2015 Presented to the Board of Public Safety October 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 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 21 4 15 7 7 7 7 10 10 24 23 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 1,191 402 428 232 325 36 31 1,789 1,863 65 102 0 0 911 778 151 181 4,827 4,899 4 GBI Administration Office of Privacy & Compliance/Open Records Open Records Request Archives August 2014 344 54 Total FY2015 640 80 Personnel Employee Totals August 2014 Investigative Division Georgia Crime Information Center Division of Forensic Sciences Administration Total State Funded Positions 318 40 284 44 686 Grant Funded Positions 17 66 24 0 107 Total 335 106 308 44 793 Total State Funded Positions Vacant Investigative Division 23 Georgia Crime Information Center 7 Division of Forensic Sciences 21 Administration 7 Total 58 State Funded Vacancies Under Active Recruitment 11 5 7 4 27 5 INVESTIGATIVE DIVISION August 2014 Fiscal YTD Total Sworn Employees 241 (filled-includes grant) Total Investigative Hours Expended 27,485.30 54,777.05 Crimes Against Persons, includes Death Investigations Child Abuse Sex Crimes Missing Persons Assault, Kidnapping, Robbery, Terrorist Acts, Fugitive, Human Trafficking, etc. 9,161.00 4,060.00 2,699.50 384.00 76.00 1,941.50 16,852.50 7,714.00 4,829.50 646.00 129.00 3,534.00 Property Crimes, including Theft, Burglary, Forgery 2,771.30 5,542.80 Drug Investigations 5,193.75 10,527.75 Meth Lab Investigations 28.00 62.00 Polygraph Examinations 1,011.00 2,139.00 Background Investigations 194.00 452.00 Other Investigations, including Preliminary Investigations 4,195.25 9,214.00 Bomb Disposal Services 817.00 1,547.00 Crime Analysis 9.00 41.00 Crime Scene Specialists 4,105.00 8,399.00 All figures above represent Investigative Hours Total Seizures $1,126,456.30 $1,595,485.30 6 Investigative Hours Expended YTD FY2015 Crime Analysis >1% Background Investigations 1% Bomb Disposal Services 3% Crime Scene Specialists 15% Crimes Against Persons 31% Other Investigations 17% Polygraph Examinations Meth Lab Investigations 4% >1% Drug Investigations 19% 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 amount expended over the life of the grant: $1,251,360.10 Total Expended in August 2014: $29,716.80 Total remaining: $389,802.40 $10,000.00 $9,000.00 $8,000.00 $7,000.00 $6,000.00 $5,000.00 $4,000.00 $3,000.00 $2,000.00 $1,000.00 $0.00 $7,916.80 Bibb Meth Lab Waste Disposal Grant Expenditures By County August 2014 $9,270.00 $6,197.50 $2,662.50 Brooks Colquitt Montgomery $1,372.50 Polk $2,297.50 Toombs 8 Crime Lab Medical Examiners (includes all laboratories) August 2014 FY2015 YTD Autopsies Consultations Total ME Cases Managed 270 524 141 281 411 805 Clayton County Death Certificates 37 84 Percentage of Cases Released in 90 days: 85% Medical Examiner Activity, FY2015 Consultations 36% Autopsies 64% Confirmed CODIS Hits for August 2014 State Offender Hits 71 State Forensic Hits 14 National Offender Hits 16 National Forensic Hits 1 Total 102 Samples entered into CODIS for August 2014 1,677 Profiles in CODIS Forensic Casework Profiles Convicted Offender Profiles Missing Person/Unidentified Human Remain Profiles Staff/QC File Total 9 16,103 282,967 4 349 299,423 Laboratory Production Report Turnaround for August 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,355 4,350 77% 294 400 74% 163 366 45% 242 403 60% 1,677 1,790 94% 183 281 65% 225 265 85% System-wide Totals 6,139 7,855 78% Note: 94.4% Casework Reports were released within 90 days. Report Turnaround for Year-to-Date, FY2015 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 6,860 9,058 76% 593 802 74% 355 716 50% 551 857 64% 3,190 3,528 90% 382 580 66% 423 496 85% System-wide Totals 12,354 16,037 77% 10 Crime Laboratory Reports Processed for August 2014 Department Requested Total Released Chemistry (includes Drug ID) Firearms Forensic Biology Impressions Latent Prints Medical Examiners Toxicology Trace Evidence 2,600 423 2,005 5 216 412 2,014 140 2,607 370 2,287 7 84 316 2,406 94 Total 7,815 8,171 Crime Laboratory Reports Processed FY2015 Department Requested Total Released Chemistry (includes Drug ID) Firearms Forensic Biology Impressions Latent Prints Medical Examiners Toxicology Trace Evidence 5,495 714 4,594 15 403 806 4,492 276 5,068 827 4,570 15 157 715 5,215 185 Total 16,795 16,752 11 Georgia Crime Information Center August 2014 CJIS Network Statistics System Uptime: Messages Processed: 92%* 57,949,362 *Major impact on system availability was SCON project. CJIS Operations 1. Sex Offender Registry Records Added Month 158 FY2015 341 Database Totals 25,274 2. Protection Order Registry Records Added Month 2,286 FY2015 4,316 Database Totals 280,232 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 0 0 27 Users 0 0 47 4. Off-Line Search Requests Type of Request Administrative (Criminal Justice Agency) Open Records Subpoena Media Possible CJIS Security Violations Month 14 0 0 0 5 FY2015 35 0 0 0 10 12 Information Services 1. Criminal Fingerprint Transactions Received Submissions Submissions w/Palms Submissions w/Photos Monthly 44,339 9,270 11,375 Transactions processed within 2 hours of receipt: 93% 2. Applicant Fingerprint Transactions Received Submissions Monthly 38,983 Transactions processed within 24 hours of receipt: 99% 3. Final Disposition Transactions Received Local Agency GCIC TOTAL Monthly 52,245 3,480 57,725 4. RAPID Identification Transactions Submissions AFIS Hits NCIC Hits FBI RISC Hits Monthly 19,917 40% 41% 0% FY 2015 90,022 18,898 22,026 FY 2015 76,938 FY 2015 117,508 7,028 124,536 FY 2015 38,865 40% 41% 0% 5. Disposition Recovery Project Provided to Vendors Completed Research Counties Monthly 0 1,214 3 Project to Date 16,926 9,051 3 13 14 Compliance and Customer Support 1. Customer Training GCIC personnel provided 272 hours of training to 2030 criminal justice agency employees during the month. The total number hours of training conducted during FY2015: 524. 2. Compliance Audits GCIC conducted (0) full service audits; (0) on-site audits conducted for agencies with "inquiry only" access from the CJIS network; (16) non-criminal justice audits; and (0) fingerprint/disposition audits for the month. The total number of audits conducted during FY2015: 38. Plans and Program Development 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. AFIS 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 Change Order GBI2014-04 One of four items implemented Filter FBI Reject Notifications to GBI Mailbox. NGI Increment 3: Acceptance Test Plan review complete. 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 establishment of a web service between the SORT and Department of Corrections' SCRIBE system for data transfer, the integration of SORT with the AFIS Image Archive (IA) and customized photo and reporting enhancements. Monthly Update The SORT project team continues to monitor SORT transactions. Design development for the SORT Entry Service is in progress. Accomplishments This Reporting Period Due to SCON project limited activity occurred in this area. 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. Accomplishments This Reporting Period Production Cut Over Event completed successfully on 8/10/14 All production cut over User Acceptance Testing was done successfully during the month of August contributing to the success of production cut over NLETS routers were put in place in the NADC in time for production cut over NCIC UAT testing and Metro Header Vendor testing completed successfully during August. 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. 16 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 The Request for Solution (RFS) for the fail-over plan was submitted. 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 Implementation is set for the week of November 2, 2014. The Division of Forensic Science (DOFS) provided the stored procedure and database access for the Laboratory Information Management System (LIMS) to Unisys. Unisys completed the configuration for the LIMS Connector and DNA Profile Status Message. Accomplishments This Reporting Period DOFS provided stored procedure and database log-in information for the LIMS to Unisys. Unisys completed configuration and documentation for the LIMS Connector and DNA Profile Status message. 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 A C3PO server was installed at GBI HQ and 18 R2D2 servers were installed in regional investigative offices throughout the state. The migration of data from the old servers to the new servers is scheduled to start Jan 1, 2015. 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. 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. 17 Monthly Update Contract was awarded to LeadsOnline and working with vendor on kick-off meeting date. Accomplishments This Reporting Period Vendor evaluation completed. Notice of Intent to Award (NOIA) posted and ended on August 17th. Reviewed and updated changes involving vendor contract. The contract awarded to LeadsOnline. 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 State Accounting Office (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 Discovery for automating the upload of internal payments continues. The contractor hired to assist in automating the upload of internal payments was terminated for failing to produce requested changes. The Applications Development unit is in the process of identifying an internal resource to add to the project team. CJCC provided a sample flat file extract from their Case Management system for review. Accomplishments This Reporting Period Discovery meetings and discussions with project contractor for internal AP Upload process. Review of SAO flat files layout, Soil & Water spreadsheet (example), and questions to SAO on formatting and testing procedure. Contractor terminated for failure to produce. Flat file extract sample provided by CJCC for review. 18