Georgia Bureau of Investigation March Monthly Report FY2018 Presented to the Board of Public Safety May 10, 2018 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 FY2018 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 38 37 31 31 30 28 26 28 27 16 15 15 15 16 16 18 18 16 11 1111110 77 7677776 9 10 10 5 7 8 8 8 8 17 17 12 13 17 18 17 15 17 3 DOFS Backlog Chart Unworked Reports over 30 Days Old FY2018 Discipline Chemistry Data Conversion Firearms Forensic Biology Impressions Latent Prints Medical Examiners Miscellaneous Services Operations Support Toxicology Trace Evidence Total Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun 12,601 12,743 13,861 13,802 14,111 14,246 15,223 15,598 16,145 1 1 1 1 1 1 1 1 1 2,956 2,984 3,080 3,081 3,166 3,190 3,232 3,285 3,250 5,225 5,553 5,695 5,431 5,563 5,687 5,677 5,560 5,686 44 46 48 47 47 48 52 51 54 3,727 3,747 3,934 3,948 4,127 4,142 4,190 4,174 4,276 188 177 193 218 232 261 320 274 245 0 0 0 0 0 0 0 0 0 2 2 0 0 0 0 0 7 2 746 639 819 822 1,033 776 1,080 791 724 487 441 438 440 468 494 489 512 539 25,977 26,333 28,069 27,790 28,748 28,845 30,264 30,253 30,922 4 GBI Administration Office of Privacy & Compliance/Open Records Open Records Request Archives March 2018 322 23 Total FY2018 3,133 306 Personnel Employee Totals March 2018 Investigative Division Georgia Crime Information Center Division of Forensic Sciences Administration Total State Funded Positions 350 43 313 43 749 Grant Funded Positions 24 77 37 4 142 Total 374 120 350 47 891 Total State Funded Positions Vacant Investigative Division 17 Georgia Crime Information Center 0 Division of Forensic Sciences 27 Administration 6 Total 50 State Funded Vacancies Under Active Recruitment 8 0 14 3 25 5 INVESTIGATIVE DIVISION March 2018 Fiscal YTD Total Sworn Employees 272 (filled-includes grant) Total Investigative Hours Expended 34,328.00 272,354.00 Crimes Against Persons, includes Death Investigations Child Abuse Sex Crimes Missing Persons Assault, Kidnapping, Robbery, Terrorist Acts, Fugitive, Human Trafficking, etc. 13,458.25 7,869.00 3,840.25 349.00 274.00 1,126.00 99,736.00 54,391.00 27,718.50 4,199.00 1,707.00 11,720.50 Property Crimes, including Theft, Burglary, Forgery 2,910.50 24,573.75 Drug Investigations 4,366.00 35,780.00 Meth Lab Investigations 21.00 93.00 Polygraph Examinations 996.00 7,814.00 Background Investigations 198.00 2,208.00 Other Investigations, including Preliminary Investigations 7,126.25 60,822.25 Bomb Disposal Services 973.00 8,798.00 Crime Analysis - 26.00 Crime Scene Specialists 4,279.00 32,503.00 All figures above represent Investigative Hours Total Seizures $898,516.72 $25,328,965.85 6 Investigative Hours Expended YTD FY2018 Background Investigations 1% Crime Analysis >1% Bomb Disposal Services 3% Crime Scene Specialists 12% Crimes Against Persons 37% Other Investigations 22%Polygraph Investigations 3% Meth Lab Investigations >1% Drug Investigations 13% Property Crimes 9% 7 8 Crime Lab Medical Examiners (includes all laboratories) March 2018 FY2018 YTD Autopsies Consultations Total ME Cases Managed 295 2,109 160 1,224 455 3,333 Clayton County Death Certificates 59 408 Percentage of Cases Released in 90 days: 78.7% Medical Examiner Activity, FY2018 Consultations 37% Autopsies 63% Confirmed CODIS Hits for March 2018 State Offender Hits 43 State Forensic Hits 11 National Offender Hits 20 National Forensic Hits 2 Total 76 Samples entered into CODIS for March 2018 1,021 Profiles in CODIS below totals are from February 2018 due to renovations at the GBI, the CODIS computer was offline. Updated totals will be reported for April 2018. Forensic Casework Profiles Convicted Offender Profiles Missing Person/Unidentified Human Remain Profiles Staff/QC File Total 22,148 327,471 7 503 350,129 9 Laboratory Production Report Turnaround for March 2018 Laboratory Headquarters - Atlanta Central Regional - Macon Coastal Regional - Savannah Eastern Regional - Augusta Northeastern Regional Southwestern Regional - Moultrie Western Regional - Columbus # Released in 45 Days 1,876 72 61 237 912 22 63 Total % Released in Released 45 Days 3,256 58% 397 18% 589 10% 407 58% 1,037 88% 296 7% 265 24% System-wide Totals 3,243 6,247 52% Note: 67.3% Casework Reports were released within 90 days. Report Turnaround for Year-to-Date, FY2018 Laboratory Headquarters - Atlanta Central Regional - Macon Coastal Regional - Savannah Eastern Regional - Augusta Northeastern Regional Southwestern Regional - Moultrie Western Regional - Columbus # Released in 45 Days 17,410 324 555 2,486 8,241 507 416 Total % Released in Released 45 Days 29,523 59% 2,359 14% 4,473 12% 3,943 63% 9,536 86% 2,141 24% 2,208 19% System-wide Totals 29,939 54,183 55% 10 Crime Lab Reports Processed for March 2018 Department Requested Total Released Chemistry (includes Drug ID) Firearms Forensic Biology Impressions Latent Prints Medical Examiners Operations Support Toxicology Trace Evidence 2,777 300 1,878 1 165 510 16 2,309 87 2,326 80 1,337 0 110 591 16 2,332 46 Total 8,043 6,838 Crime Lab Reports Processed FY2018 Department Requested Total Released Chemistry (includes Drug ID) Firearms Forensic Biology Impressions Latent Prints Medical Examiners Operations Support Toxicology Trace Evidence 24,054 1,621 13,273 17 1,683 4,327 78 19,947 724 19,221 946 12,304 7 1,090 4,232 83 19,894 638 Total 65,724 58,415 11 Georgia Crime Information Center March 2018 NCIC SERVICES CJIS Network Statistics System Uptime: Messages Processed: 100% 77,145,942 CJIS Operations 1. Sex Offender Registry Records Added Month 150 FY2018 1,274 Database Totals 30,818 2. Protection Order Registry Records Added Month 2,333 FY2018 19,496 Database Totals 373,250 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 2 2 19 Users 3 8 25 4. Off-Line Search Requests Type of Request Month FY2018 Administrative (Criminal Justice Agency) 34 195 Open Records 3 11 Subpoena 0 0 Media 0 0 Possible CJIS Security Violations 0 26 12 CJIS Audits GCIC conducted 41 CJIS Audits INFORMATION SERVICES Criminal History/Identification Services 1. Criminal Fingerprint Transactions Received Submissions Submissions w/Palms Submissions w/Photos Month 43,465 18,807 15,165 Transactions processed within 2 hours of receipt: 2. Applicant Fingerprint Transactions Received Submissions Month 45,967 Transactions processed within 24 hours of receipt: 3. Final Dispositions Received Local Agency GCIC TOTAL Month 76,408 4,855 81,263 4. RAPID Identification Transactions Submissions AFIS Hits NCIC Hits FBI RISC Hits Month 9,459 63% 44% 8% 5. Non-criminal Justice Audits, Visits and Trainings In Compliance Out of Compliance Total Audits Month 12 24 36 13 FY2018 370,961 164,392 121,182 95% FY2018 344,050 100% FY2018 596,534 41,636 638,170 FY2018 91,883 64% 42% 6% FY2018 89 123 212 Advisement Memos Agency Visits Attendees Trainings 6. Disposition Recovery Project Submitted by Vendor Dispositions Processed Month - - 14 75 110 1,125 6 52 1568 1980 Project to Date 92,261 91,412 The chart below shows the number of serious/violent felony offenses that were previously restricted but are now returned for licensing and employment purposes because a disposition of guilt was obtained and entered in the criminal history database. guilt was obtained and entered in the criminal history database. PLANS AND PROGRAM DEVELOPMENT 14 AFIS ENHANCEMENTS Project Description - System enhancements for the Automated Fingerprint Identification System (AFIS) which include Accounts Receivable, T-Net fee changes, AFIS -SORT interface, system reports, creation of new IntegraID Document Management folders. Monthly Update - The vendor completed the integration of the Integra ID Document Management feature to SORT test and production servers and conducted in-house training for GBI SORT application staff. APPLICATION DEVELOPMENT - Protective Order Registry Project Description - To provide better information sharing, the Georgia Protective Order Registry (POR) is being updated to improve record data quality and expanding database capabilities by replacing the existing application and infrastructure. Monthly Update - Vendors are working to resolve QPOR processing issues with the image formats. All scheduled training sessions were completed and additional training is scheduled thru December 2018. The team will resume UAT once the image formatting is resolved. The deployment date has been extended to May 2018. CHILD FATALITY SYSTEM REVIEW PROJECT Project Description - The Child Fatality Review (CFR) unit requested an enhancement to their current process to capture Medical Examiners (ME) data for child related deaths in the State of Georgia and have asked for additional reporting capabilities. Monthly Update - The developer began working on the project and is focused on application development. CRIMINAL JUSTICE EXCHANGE PROJECT Project Description - The Georgia Bureau of Investigation will programmatically own an initiative of the Governor's Office entitled Criminal Justice Exchange Project (CJEP). CJEP will incorporate the electronic exchanges of information between state and local criminal justice agencies in Georgia. Each exchange automates a manual, paper-based criminal justice business process and will follow a criminal case lifecycle from booking through disposition and supervision. The goals of the project are to create seamless connections between systems, establish a single, consistent architecture adopted to guide all aspects of program implementation and to establish a governance structure that views criminal justice as a statewide community. The exchanges will involve the coordination of multiple agencies and vendor applications. Monthly Update - A collaboration continues between GBI, GTA, Consultants, Statewide Stakeholders and vendors for completion of the project data exchanges. GCIC IT coordinated with GTA, ATT, IBM and the CCH vendor on getting the server certificates installed on the CCH production and test servers. The connectivity to GTA ESB was successfully tested and IBM created certificate keys to be installed on servers at GTA. The progression of tasks and work towards addressing project risks with error handling, CJIS Data policy and GTA ESB storage has shifted the pilot deployment date to potentially third quarter 2018. The SME and PMO 15 Consultants revised the project schedule dates to include integration testing and the Go-Live checklist was presented to the Executive Steering Committee. CUSTOMER RELATIONSHIP MANAGEMENT (CRM) APPLICATION PROJECT Project Description - The CRM Application Project will provide a single source of historical interaction with GCIC external customers. The application will give GCIC end users the ability to search, track and report customer interactions throughout GCIC's business units. Monthly Update - No accomplishments this reporting period. The project is on hold and will resume once a new project manager is assigned during the second quarter. CUSTOMER SUPPORT - TRAINING Project Description - The Customer Support Training group provides training in GCIC programs, GCIC applications, GCIC/FBI compliance and other supported law enforcement training to both criminal and non-criminal justice agencies, municipal, magistrate and probate courts across the State of Georgia. The group extends the option to receive classroom training or training within an e-Learning environment. Monthly Update - The GBI online Learning Management System contains several videos and online classroom training available to agencies and vendors of law enforcement agencies. The trainings completed online and within the classrooms for the month are included in the charts. The LMS Staff handled 185 phone calls, 1,316 emails and managed LMS user account additions. The Customer Support Training team also developed and delivered employee training for the GCIC SharePoint application and agency training on GCIC programs/applications. 16 FINANCE ACCOUNTS RECEIVABLE (AR) SYSTEM PROJECT Project Description - GBI Finance/Accounting requested a new accounts receivable system to process fee invoices and payments. Monthly Update - The RFP posted to the Georgia Procurement Registry (GPR) on March 23, 2018 and will close April 24, 2018. 17 GCIC TRAINING SYMPOSIUM Project Description - The GCIC Training Symposium is designed to offer continuing education with the goal of providing vital knowledge regarding GCIC and federal law enforcement programs to both the criminal justice and non-criminal communities. Monthly Update - The project team continues to complete tasks for the symposium and tasks completed include finalizing theme graphics, drafting the class schedule, confirming instructors/speakers, receiving instructor/speaker bios, and selecting attendee/speaker gifts. GEORGIA APPLICANT PROCESSING SYSTEM REPLACEMENT (GAPS) PROJECT Project Description - The Georgia Crime Information Center Information Services is seeking to obtain the services of a qualified and experienced vendor to provide an applicant fingerprinting solution that will electronically capture and submit applicant fingerprints to the Automated Fingerprint Identification System (AFIS). In addition, the selected vendor shall handle receiving fingerprint search results and disseminate the results to the requestor. Monthly Update - The evaluation team signed member participation forms and the eRFP was posted for bid (until April 12, 2018). HUMAN RESOURCES (HR) TIMESHEET PROJECT Project Description - Enhancement of the application used by non-sworn units of the GBI for tracking time. Monthly Update - The project resumed with the continued application development of incorporating business requirements. INFORMATION SERVICES CRIMINAL HISTORY APPLICATION REDESIGN PROJECT Project Description - A redesign of the web application used by Information Services staff to log and track activities performed on criminal history information as well as services performed for the public. Monthly Update - The application developer continues with coding. LAW ENFORCEMENT MESSAGE SWITCH (LEMS) Project Description - The message switch provides a means of communication between federal, state and local law enforcement agencies throughout the state of Georgia, the United States and other countries and to take advantage of new features and advances in technology, GCIC is looking to upgrade or replace this system. Monthly Update - The GTA Chief Technology Office (CTO) review board provided feedback on the RFP. GCIC is working on changes to the RFP and will not post the RFP until fiscal year 2019. 18 LEARNING MANAGEMENT SYSTEM (LMS) PROJECT Project Description - GCIC plans to replace the existing learning management system (LMS) by obtaining a new web-based LMS software application. The online learning management system will allow interactive exercises to aid in knowledge retention and administration of training information. The LMS training system will manage all learning components, security, enrollment, and course structure for course certification. Monthly Update - The RFP was cancelled due to the stakeholder choosing to remain with the current vendor. NATIONAL INCIDENT-BASED REPORTING SYSTEM (NIBRS) PROJECT Project Description - The National Incident Based Reporting System (NIBRS) collects data on each single incident and arrest for each offense coming to the attention of law enforcement for which specific facts about each crime is collected. GBI is in the process of replacing the current UCR summary-based system with an application that will collect incident-based data. Monthly Update - The application developer resolved the duplicate records issue. The vendor is assisting GBI IT staff in resolving problems found in the flat file data transmission to migrate UCR data to NIBRS. The final data migration from UCR to NIBRS will take place once final validation of records is complete. SEX OFFENDER REGISTRY TOOL (SORT) ENHANCEMENT PROJECT Project Description - System enhancements for the SORT application. Phase 1 will consist of modifications to the application used by Sheriff's Offices, the public website, NCIC web services and SORT Reports. Phase 2 will focus on the web service between SORT and AFIS for the upload of SORT documentation. Monthly Update - The GBI continues to work with Watch Systems (Offender Watch) to assist with the vendors connection to SORT while also ensuring that they meet GBI application standards and requirements. GBI's SORT vendor is working on a cost estimate and scope of work documentation to include the impact that will be required to address an audit trail for record modifications in the SORT system. The GCIC application developer has resumed modification of the SORT test interface with the image archive system. SHAREPOINT CONFIGURATION PROJECT Project Description - The SharePoint tool will be used as an internal web portal for organizing and sharing information as an employee collaborative tool for internal communication. The portal will also include an Intranet application for each of the three GBI divisions that would allow content management, document repository and information sharing of announcements, news and department information. Monthly Update - The GCIC Customer Support Training group provided two additional training sessions to GCIC Managers and Contributors. SharePoint permission issues were discovered and were corrected. DOFS is the next work group to receive SharePoint training. 19