Georgia Bureau of Investigation May Monthly Report FY2017 Presented to the Board of Public Safety No Meeting Scheduled for July 2017 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 FY2017 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 24 23 23 24 26 26 23 27 29 32 33 8 8 7 10 11 11 16 18 17 14 20 1 1 1 2 2 2 3 3 1 1 1 4 4 5 5 5 5 5 5 4 7 7 24 24 28 21 9 6 8 8 8 9 8 31 30 33 28 16 14 17 15 15 15 15 3 DOFS Backlog Chart Unworked Reports over 30 Days Old FY2017 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 6,546 7,175 7,822 8,482 9,237 9,453 9,648 10,156 10,462 11,193 11,333 0 0 0 0 0 0 0 0 0 0 1 2,520 2,878 3,031 3,051 3,094 2,997 3,015 2,942 2,926 2,832 2,861 3,110 3,191 3,466 3,724 3,863 3,863 3,859 3,991 4,488 4,629 4,714 38 40 43 42 39 37 37 41 41 41 42 3,137 3,234 3,309 3,446 3,550 3,551 3,503 3,572 3,675 3,766 3,758 120 97 170 165 198 194 182 192 207 207 228 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 2 827 506 829 858 1,523 1,386 971 1,038 854 819 763 466 503 511 520 531 513 504 484 519 538 482 16,764 17,624 19,181 20,288 22,035 21,994 21,719 22,416 23,172 24,027 24,184 4 GBI Administration Office of Privacy & Compliance/Open Records Open Records Request Archives May 2017 330 40 Total FY2017 3,276 301 Personnel Employee Totals May 2017 Investigative Division Georgia Crime Information Center Division of Forensic Sciences Administration Total State Funded Positions 350 42 299 43 734 Grant Funded Positions 19 75 29 1 124 Total 369 117 328 44 858 Total State Funded Positions Vacant Investigative Division 15 Georgia Crime Information Center 1 Division of Forensic Sciences 33 Administration 7 Total 56 State Funded Vacancies Under Active Recruitment 5 1 24 5 35 5 INVESTIGATIVE DIVISION May 2017 Fiscal YTD Total Sworn Employees 274 (filled-includes grant) Total Investigative Hours Expended 28,141.75 315,185.06 Crimes Against Persons, includes Death Investigations Child Abuse Sex Crimes Missing Persons Assault, Kidnapping, Robbery, Terrorist Acts, Fugitive, Human Trafficking, etc. 8,993.25 4,939.00 2,095.25 613.00 146.00 1,200.00 106,745.50 55,493.50 29,857.50 4,748.50 3,429.00 13,217.00 Property Crimes, including Theft, Burglary, Forgery 2,731.50 30,372.80 Drug Investigations 4,017.00 42,929.50 Meth Lab Investigations 3.00 123.00 Polygraph Examinations 982.00 9,522.00 Background Investigations 219.00 4,569.00 Other Investigations, including Preliminary Investigations 6,422.00 69,715.51 Bomb Disposal Services 859.00 10,594.00 Crime Analysis 7.00 31.00 Crime Scene Specialists 3,908.00 40,582.00 All figures above represent Investigative Hours Total Seizures $573,567.86 $119,242,366.34 6 Investigative Hours Expended YTD FY2017 Background Investigations 1% Crime Analysis >1% Crime Scene Specialists 13% Bomb Disposal Services 3% Crimes Against Persons 34% Other Investigations 22% Polygraph Meth Lab Investigations Investigations 3% >1% Drug Property Investigations Crimes 14% 10% 7 8 Crime Lab Medical Examiners (includes all laboratories) May 2017 FY2017 YTD Autopsies Consultations Total ME Cases Managed 302 2,586 113 1,587 415 4,173 Clayton County Death Certificates 32 452 Percentage of Cases Released in 90 days: 71.6% Medical Examiner Activity, FY2017 Consultations 38% Autopsies 62% Confirmed CODIS Hits for May 2017 State Offender Hits 31 State Forensic Hits 6 National Offender Hits 10 National Forensic Hits 1 Total 48 Samples entered into CODIS for May 2017 778 Profiles in CODIS Forensic Casework Profiles Convicted Offender Profiles Missing Person/Unidentified Human Remain Profiles Staff/QC File Total 9 21,003 341,663 6 499 341,171 Laboratory Production Report Turnaround for May 2017 Laboratory Headquarters - Atlanta Central Regional - Macon Coastal Regional - Savannah Eastern Regional - Augusta Northeastern Regional Southwestern Regional - Moultrie Western Regional - Columbus # Released in 45 Days 2,393 36 79 323 1,046 83 61 Total % Released in Released 45 Days 4,361 55% 248 15% 465 17% 472 68% 1,277 82% 313 27% 261 23% System-wide Totals 4,021 7,397 54% Note: 77.2% Casework Reports were released within 90 days. Report Turnaround for Year-to-Date, FY2017 Laboratory Headquarters - Atlanta Central Regional - Macon Coastal Regional - Savannah Eastern Regional - Augusta Northeastern Regional Southwestern Regional - Moultrie Western Regional - Columbus # Released in 45 Days 24,276 874 478 3,525 11,441 793 763 Total % Released in Released 45 Days 42,302 57% 2,707 32% 4,394 11% 5,044 70% 12,924 89% 2,150 37% 2,010 38% System-wide Totals 42,150 71,531 59% 10 Crime Lab Reports Processed for May 2017 Department Requested Total Released Chemistry (includes Drug ID) Firearms Forensic Biology Impressions Latent Prints Medical Examiners Operations Support Toxicology Trace Evidence 2,973 215 1,852 1 225 475 5 2,472 124 2,437 291 1,809 1 199 506 2 2,548 110 Total 8,342 7,903 Crime Lab Reports Processed FY2017 Department Requested Total Released Chemistry (includes Drug ID) Firearms Forensic Biology Impressions Latent Prints Medical Examiners Operations Support Toxicology Trace Evidence 28,702 2,671 20,602 35 2,374 5,151 147 25,969 1,416 21,314 2,260 18,917 18 1,540 5,066 125 26,025 1,332 Total 87,067 76,597 11 Georgia Crime Information Center May 2017 NCIC SERVICES CJIS Network Statistics System Uptime: Messages Processed: 100% 73,634,810 CJIS Operations 1. Sex Offender Registry Records Added Month 169 2. Protection Order Registry FY2017 1,667 Database Totals 29,688 Records Added Month 2,527 FY2017 24,180 Database Totals 350,497 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 36 Users 0 1 38 4. Off-Line Search Requests Type of Request Month FY2017 Administrative (Criminal Justice Agency) 25 277 Open Records 0 13 Subpoena 0 0 Media 0 0 Possible CJIS Security Violations 2 27 12 CJIS Audits GCIC conducted 37 CJIS Audits INFORMATION SERVICES Criminal History/Identification Services 1. Criminal Fingerprint Transactions Received Submissions Submissions w/Palms Submissions w/Photos Month 43,198 19,486 13,147 Transactions processed within 2 hours of receipt: 2. Applicant Fingerprint Transactions Received Submissions Month 38,508 Transactions processed within 24 hours of receipt: 3. Final Dispositions Received Local Agency GCIC TOTAL Month 68,180 8,874 77,054 4. RAPID Identification Transactions Submissions AFIS Hits NCIC Hits FBI RISC Hits Month 12,508 61% 40% 5% 5. Non-criminal Justice Audits, Visits and Trainings In Compliance Out of Compliance Total Audits Advisement Memos Agency Visits Month 14 20 34 3 13 FY2017 442,211 196,528 135,738 93% FY2017 441,740 99% FY2017 710,472 62,062 772,534 FY2017 150,319 51% 40% 3% FY2017 71 76 147 1 127 Attendees Trainings 6. Disposition Recovery Project Submitted by Vendor Dispositions Processed Month 33 272 5 16 3089 2872 Project to Date 78131 71554 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. 14 PLANS AND PROGRAM DEVELOPMENT 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 - Application development has begun for the Sex Offender Registry Tool (SORT) Integra ID Image Archive integration and for the CCH/Ident additional permissions. Last month the SOW for the Document Management additional root folders (Weapons Carry Licenses and IT Security) along with updates to the document function/screen in the Mental Health folder were approved but not implemented. The tasks outlined for the SOW will be sole sourced after the fiscal year close. APPLICATION DEVELOPMENT PROTECTIVE ORDER REGISTRY Project Description - In an effort 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 - The project application development team worked on completing additional tasks (Runbook task list), which are required prior to moving the application to production. 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 programmer began receiving basic DOFS file data communications on child death information. The team is working on finalizing the data that will be used to build the initial database of child death cases. COMPUTERIZED CRIMINAL HISTORY (CCH) ENHANCEMENTS Project Description - The Computerized Criminal History (CCH) system will undergo system enhancements to meet the new State of Georgia legislative changes concerning the First Offender Act (FOA). Additional updates such as system modifications and reports will be implemented for internal users. Monthly Update - The vendor continues coding the remaining system enhancements. Of the eight remaining, four are scheduled to be available for testing mid-July, two at the end of August and the final two will be available the end of September 2017. 15 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 - The project team reported that the project is technically behind schedule. The project goal is to focus on getting the requirements for the data exchanges accurately completed. The business workgroup and the Subject Matter Experts (SMEs) began meeting every week to finalize the data exchanges. Once the exchanges are complete, the business workgroup will approve and provide a recommendation to the Governance Committee. The evaluations were completed for the Request for Qualified Contractor (RFQC) proposals and GTA procurement will begin reviewing the contract red-line items with each vendor and their legal team. Once the vendor contracts are finalized the vendor will need to submit a Statement of Need (SON). 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 - Microsoft conducted two training sessions and GCIC completed UAT. The results of the UAT were unsuccessful and additional test scripts and training dates will be provided to encourage more UAT participation. Microsoft reported completion and delivery of the CRM solution build, however; GCIC has determined that the current solution does not meet expectations. Several meetings have been planned with Microsoft to further discuss. CUSTOMER SUPPORT TRAINING Project Description - The Customer Support Training group provides training in the area of 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 for the month are included in the charts. The LMS Staff handled 177 phone calls, 936 emails and managed LMS user account additions and changes. 16 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 work on the various project tasks in preparation of the 2017 Symposium. A checking account was opened for the GCIC Training Association Inc. 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 project programmer continues coding and will begin work on the report function of the CCH/AFIS Update log. 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 in order to take advantage of new features and advances in technology, GCIC is looking to upgrade or replace this system. Monthly Update - The project manager continues to gather requirements to be included in a proposal. The Request for Proposal (RFP) will be issued after July 1. 18 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 - GBI continues to work on the mapping of the state codes to the NIBRS codes and a list of the data mappings completed thus far was sent to the vendor. The vendor is developing the web service and will provide a technical specifications document to GBI once complete. The vendor has completed report configurations with a header/footer, and set-up the hosted UAT environment in the Azure platform. Programming continues for the Incident data entry page User Interface (UI) customizations and for the Family Violence manual data entry page. 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 vendor began development based on the SOW for the Archive enhancements to add SORT. The website updates were completed and deployed. 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 project manager met with other GCIC divisions to discuss SharePoint implementation. The GCIC SharePoint site was finalized and is ready for deployment after all users are trained. The LMS staff is developing the training for the platform. WEB SITES REDESIGN PROJECT Project Description - Redesign of the internal and external Georgia Crime Information Center (GCIC) web sites. Monthly Update - The enhancements to the GCIC Extranet content are finalized and is pending final approval from GCIC Command Staff. The changes are scheduled to be implemented in production the latter part of June. 19