Georgia Bureau of Investigation October Monthly Report FY2015 Presented to the Board of Public Safety December 11, 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 21 22 23 4 15 5 6 7 7 3 2 7 7 7 7 10 10 8 9 24 23 20 18 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 1,202 1,309 402 428 553 726 232 325 347 433 36 31 28 16 1,789 1,863 1,986 2,089 65 102 44 47 0 0 0 0 911 778 748 891 151 181 201 216 4,827 4,899 5,109 5,727 4 GBI Administration Office of Privacy & Compliance/Open Records Open Records Request Archives October 2014 307 56 Total FY2015 1,244 163 Personnel Employee Totals October 2014 Investigative Division Georgia Crime Information Center Division of Forensic Sciences Administration Total State Funded Positions 318 40 284 43 685 Grant Funded Positions 17 67 19 0 103 Total 335 107 303 43 788 Total State Funded Positions Vacant Investigative Division 18 Georgia Crime Information Center 2 Division of Forensic Sciences 23 Administration 7 Total 50 State Funded Vacancies Under Active Recruitment 4 2 8 5 19 5 INVESTIGATIVE DIVISION October 2014 Fiscal YTD Total Sworn Employees 242 (filled-includes grant) Total Investigative Hours Expended 26,394.25 107,749.55 Crimes Against Persons, includes Death Investigations Child Abuse Sex Crimes Missing Persons Assault, Kidnapping, Robbery, Terrorist Acts, Fugitive, Human Trafficking, etc. 9,216.50 4,319.00 2,833.00 323.00 181.00 1,560.50 35,553.00 17,325.00 10,041.50 1,319.00 374.00 6,493.50 Property Crimes, including Theft, Burglary, Forgery 2,537.00 10,657.80 Drug Investigations 4,721.50 19,975.25 Meth Lab Investigations 10.00 76.00 Polygraph Examinations 987.00 4,159.00 Background Investigations 133.00 734.00 Other Investigations, including Preliminary Investigations 4,385.25 17,783.50 Bomb Disposal Services 802.00 2,922.00 Crime Analysis 19.00 87.00 Crime Scene Specialists 3,583.00 15,802.00 All figures above represent Investigative Hours Total Seizures $749,529.65 $3,084,610.55 6 Investigative Hours Expended YTD FY2015 Crime Analysis >1% Background Investigations 1% Bomb Disposal Services 3% Crime Scene Specialists 15% Crimes Against Persons 33% Other Investigations 16% Polygraph Examinations Meth Lab Investigations 4% >1% Drug Investigations 18% 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,281,627.60 Total Expended in October 2014: $15,992.50 Total remaining: $359,534.90 $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 Meth Lab Waste Disposal Grant Expenditures By County October 2014 $7,385.00 $3,997.50 $4,610.00 Chatham Montgomery Polk 8 Crime Lab Medical Examiners (includes all laboratories) October 2014 FY2015 YTD Autopsies Consultations Total ME Cases Managed 251 1,035 143 549 394 1,584 Clayton County Death Certificates 42 167 Percentage of Cases Released in 90 days: 94% Medical Examiner Activity, FY2015 Consultations 35% Autopsies 65% Confirmed CODIS Hits for October 2014 State Offender Hits 45 State Forensic Hits 12 National Offender Hits 16 National Forensic Hits 1 Total 74 Samples entered into CODIS for October 2014 1,784 Profiles in CODIS Forensic Casework Profiles Convicted Offender Profiles Missing Person/Unidentified Human Remain Profiles Staff/QC File Total 16,416 285,850 4 349 302,619 9 Laboratory Production Report Turnaround for October 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,247 4,373 74% 351 397 88% 105 256 41% 234 338 69% 1,763 1,987 89% 170 249 68% 135 204 66% System-wide Totals 6,005 7,804 77% Note: 94.3% 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 13,072 17,320 75% 1,244 1,608 77% 651 1,306 50% 974 1,571 62% 6,149 6,998 88% 700 1,112 63% 786 971 81% System-wide Totals 23,576 30,886 76% 10 Crime Laboratory Reports Processed for October 2014 Department Requested Total Released Chemistry (includes Drug ID) Firearms Forensic Biology Impressions Latent Prints Medical Examiners Toxicology Trace Evidence 2,686 432 2,249 7 168 394 2,363 143 2,681 366 2,501 16 73 269 2,016 151 Total 8,442 8,073 Crime Laboratory Reports Processed FY2015 Department Requested Total Released Chemistry (includes Drug ID) Firearms Forensic Biology Impressions Latent Prints Medical Examiners Toxicology Trace Evidence 10,821 1,730 9,121 26 764 1,585 9,030 576 10,408 1,456 8,978 41 342 1,554 9,225 436 Total 33,653 32,440 11 Georgia Crime Information Center October 2014 CJIS Network Statistics System Uptime: Messages Processed: 99% 55,226,050 CJIS Operations 1. Sex Offender Registry Records Added Month 192 FY2015 704 Database Totals 25,572 2. Protection Order Registry Records Added Month 2,029 FY2015 8,341 Database Totals 284,325 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 1 0 28 Users 0 1 45 4. Off-Line Search Requests Type of Request Month FY2015 Administrative (Criminal Justice Agency) 25 77 Open Records 1 1 Subpoena 2 2 Media 0 0 Possible CJIS Security Violations 6 22 12 Criminal History Identification Services 1. Criminal Fingerprint Transactions Received Submissions Submissions w/Palms Submissions w/Photos Monthly 43,582 9,496 11,388 Transactions processed within 2 hours of receipt: FY 2015 176,494 37,234 44,470 93% 2. Applicant Fingerprint Transactions Received Submissions Monthly 34,222 Transactions processed within 24 hours of receipt: 3. Final Disposition Transactions Received Local Agency GCIC TOTAL Monthly 66,941 3,446 70,387 FY 2015 144,032 99% FY 2015 249,139 12,582 261,721 4. RAPID Identification Transactions Submissions AFIS Hits NCIC Hits FBI RISC Hits 5. Disposition Recovery Project Provided to Vendors Completed Research Counties Monthly 17,292 42% 40% 1% FY 2015 74,206 41% 41% 1% Monthly 0 980 3 Project to Date 18,501 11,327 3 13 0.0% 0.0% 0.00%.0% Dispositions Recovered Through October 31, 2014 0.3% 4.7% 0.3% 0.09% 0.04% 2.1% 00..60%% 8.3% 20.4% 44.5% 5.0% 1.6% 3.1% 8.8% Gu ilty Dead Docket Dismi ssed No Billed No Further Action Nolle Prossed Not Guilty Transferred Mistrial Alread y Entered Mentally Incompetent to Stand Trial Not P resented to Grand Jury Deleted OTN I ndic ted Bind Over Directed Verdict Warrant Issued Nolo Contendere Vac at ed Conviction Offenses Through October 31, 2014 2453 382 61 45 1211 94 24 305 486 345 202 4 Aggravated/ Child Molestation Aggravated Sexual Battery Aggravated/S odomy Armed Robbery Cruelty to Children Enticing a Child for Indecent... Other Sex Crimes Kidnapping Murder Rape Statuatory Rape Trafficking of Persons for Labor or... Compliance and Customer Support 1. Customer Training GCIC personnel provided 225 hours of training to 667 criminal justice agency employees during the month. The total number hours of training conducted during FY2015: 1221 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: 90. Plans & 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 14 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. Accomplishments This Reporting Period NGI Increment 3/EBTS 10.0 Compliance: CCH/Ident., Applicant Services and NEC agreed on "single response." Live Scan specification was updated and posted to the GCIC website. Live Scan specification availability notification was sent to Live Scan vendors. Statement of Work payment schedule was changed and sign off completed 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. 15 Monthly Update The SORT project team continues to monitor SORT transactions. SORT has completed the transition from the legacy environment to the SCON environment. The design development for the SORT Entry Service Client is complete. Accomplishments This Reporting Period Unisys completed the SORT Entry Web Services design to allow outside case management systems to integrate with SORT. CUSTOMER RESOURCE MANAGEMENT TOOL Project Description--GCIC found the need to develop a Customer Resource Management (CRM) tool and database that will capture and store pertinent information on GCIC customers. The stored information will include customer details, method of connectivity, training information, auditing schedules and other applicable data that to assist GCIC personnel in providing efficient customer service by reducing duplicative tasks while allowing for better tracking of customer information. The CRM system will store relevant data and perform search capabilities for reports. Monthly Update The current CRM requirements have been documented. Two third-party vendor software applications have been evaluated. A decision is pending on whether to continue with an in-house application rebuild or purchase a third party software product. Accomplishments This Reporting Period Technical information has been collected from four (4) third-party vendors and used as requirements documentation. 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 AT&T, IBM & GBI conducted and completed the Fail-Over plan System Acceptance Testing. Pilot Agencies (Loganville PD & Columbia County SO) began using Advanced Authentication. 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 16 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 Ticket requests to open network path (Test & Prod) between the lab system and the law enforcement switch escalated for resolution. LIMS Connector installed on virtual machine--Installation on LIMS Test Environment delayed until network path opened. Configuration of CCH modifications and enhancements began. Accomplishments This Reporting Period Ticket requests to open network path (Test & Prod) between the lab system and the law enforcement switch escalated for resolution. Installation of LIMS Connector on a virtual machine similar to the LIMS Test Environment. CCH DNA profile status error queue terminal message sample provided to the CCH/Identification Program Manager for review. Integrated Test Plan document created. CCH response message format finalized. Mock-up of the CCH Person screen with added DNA fields provided. FILE SERVICES TRANSFORMATION/CONSOLIDATION PROJECT Project Description - GBI file server data will be moved from the existing Legacy hardware to a more operationally stable, secure, and supportable hardware. This project involves the purchase and installation of nineteen servers across the state. Monthly Update One large server has been installed at GBI headquarters; eighteen smaller servers have been installed in regional investigative offices across the state. Networking and firewall connectivity is the current task. The migration of data from the old servers to the new servers is scheduled to start January 1, 2015 or earlier. Accomplishments This Reporting Period Determined that GBI does not have current login scripts for the servers. 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 Identified issues with terms and conditions agreements for Secondary Metal Recyclers and Law Enforcement Agencies. Testing was scheduled for the pilot business locations to ensure the system functions as required, can handle the volume, and the customers receive quality service and responsiveness from the vendor. System implementation is schedule for December 1, 2014. Accomplishments This Reporting Period The Statement of Work was accepted. 17 Corrected an issue found during testing that would not allow .pdf file formats to be uploaded as an image. A meeting was held for the Secondary Metal Recycling Association to hear their concerns. 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 building the solution continues. Revised requirements have been documented. Accomplishments This Reporting Period Revision and acceptance of solution requirements. Workflow diagram of proposed solution based on discussions with Applications Development created to provide visual discussion tool until end user form entry screens are available. Verified with SAO that there is no limit to the number of rows for inclusion in the AP Upload flat file. List of chart fields for the GBI AP upload template for utility bills provided by Accounting. CONTACT CENTER Project Description -- The Georgia Technology Authority GTA awarded new Hosted Contact Center contracts for Services to multiple providers. The AT&T HICS Contact center services were previously available to state agencies through a single provider, and the single-provider contract for these systems will expire on June 30, 2015. As a result, state agencies with an existing HICS contact center service will need to contract with one of the new providers prior to the expiration of the existing system contract. The new contracts will provide GBI with access to a choice of new technology solutions at competitive prices. Monthly Update weekly scheduled meetings for the Contact Center with GTA. The first draft of the RFQ has been developed. Accomplishments This Reporting Period Developed first draft of RFQ 18 Technology Services AGENCY COUNT Total Agencies: 1461 PORTAL XL PROJECT COUNTIES DEVICE CONVERSIONS With Conversion Activity: 71 Number of Devices: 3475 Agencies Completed: 120 No Conversions Started: 88 Devices Converted: 900 Agencies In Progress: 13 Devices Outstanding: 2575 19