Georgia Bureau of Investigation February Monthly Report FY2013 Presented to the Board of Public Safety April 18, 2013 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 - 16 2 Vacant State Positions FY2013 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 July 36 25 27 27 29 31 26 25 25 15 15 16 18 18 14 15 1 2 3 4 6 6 6 10 44 444444 19 20 20 20 21 22 25 27 30 31 30 30 30 31 36 38 3 DOFS Backlog Chart Unworked Cases over 30 Days Old FY2013 Discipline Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Chemistry 1,487 1,226 2,230 2,164 1,902 1,626 1,189 703 Firearms 1,231 1,200 1,176 1,084 917 849 748 719 Forensic Biology 949 743 806 929 1,143 1,248 886 769 Latent Fingerprints 1,081 1,066 1,127 1,177 1,201 1,239 1,234 1,230 Medical Examiners 127 109 110 139 106 122 137 137 Miscellaneous Services 1 1 1 0 0 0 0 0 Questioned Docs/Photography 312 313 310 307 308 306 298 279 Toxicology 942 1,070 908 983 910 895 553 780 Trace Evidence 200 181 160 148 144 121 97 82 Total 6,330 5,909 6,828 6,931 6,631 6,406 5,142 4,699 4 GBI Administration Office of Privacy & Compliance/Open Records Open Records Request Archives February 2013 283 48 Total FY2013 2,053 338 Personnel Employee Totals Investigative Division Georgia Crime Information Center Division of Forensic Sciences Administration Bureau Total *Vacancies are State Funded Positions February 2013 Positions State Funded Grant Funded 325 38 91 14 282 36 45 0 743 88 Total 363 105 318 45 831 Current Vacancies* 38 10 25 4 77 5 INVESTIGATIVE DIVISION February 2013 Fiscal YTD Total Sworn Employees 243 (filled-includes grant) Total Investigative Hours Expended 27,384.50 208,047.70 Crimes Against Persons, includes Death Investigations Child Abuse Sex Crimes Missing Persons Assault, Kidnapping, Robbery, Terrorist Acts, Fugitive, Human Trafficking, etc. 9,284.50 4,555.00 2,141.50 654.00 88.00 1,846.00 70,771.20 36,849.50 15,314.20 3,328.00 459.00 14,820.50 Property Crimes, including Theft, Burglary, Forgery 2,500.00 19,633.75 Drug Investigations 6,219.00 48,676.00 Meth Lab Investigations 263.00 1,649.00 Polygraph Examinations 1,041.00 7,687.00 Background Investigations 24.00 869.00 Other Investigations, including Preliminary Investigations 3,548.00 30,071.75 Bomb Disposal Services 747.00 6,506.00 Crime Analysis 73.00 261.00 Crime Scene Specialists 3,685.00 21,923.00 All figures above represent Investigative Hours Total Seizures $1,129,137.97 $149,918,894.58 6 Investigative Hours Expended YTD FY2013 Bomb Disposal Services 3% Other Investigations 15% Crime Analysis >1% Crime Scene Specialists 11% Crimes Against Persons 34% Background Investigations >1% Polygraph Examinations 4% Meth Lab Investigations 1% Drug Investigations 23% Property Crimes 9% 7 Meth Lab Waste Disposal Grant Total amount of grant beginning February 2012: $401,000.00 Additional funding adding in September 2012: $200,000.00 Total funding available: $601,000.00 Total expended through February 2013: $612,726.50 Total remaining: -$11,726.50 Deficit (Awaiting additional funding from CJCC that was approved beginning January 1st.) Total Expended in February 2013: $71,825.00 $9,000.00 Meth Lab Waste Disposal Grant Expenditures By County February 2013 $8,475.00 $8,000.00 $7,000.00 $7,442.50 $7,280.00 $6,000.00 $5,700.00 $6,162.50 $5,000.00 $4,000.00 $3,742.50 $4,102.50 $5,130.00 $4,102.50 $3,742.50 $3,000.00 $2,670.00 $2,252.50 $2,000.00 $2,565.00 $2,252.50 $3,177.50 $3,027.50 $1,000.00 $0.00 Bibb Brantley Bryan Coffee Cook Franklin McDuffie Monroe Murray Oconee Pierce Thomas Union Walton Ware Whitfield 8 Crime Lab Medical Examiners (includes all laboratories) February 2013 FY2013 YTD Autopsies Consultations Anthropology Total ME Cases Managed 252 2,144 118 1,040 0 0 370 3,184 Clayton County Death Certificates 35 286 Medical Examiner Activity, FY2013 Consultations 34% Anthropology >1% Autopsies 66% Confirmed CODIS Hits for February 2013 State Offender Hits 17 State Forensic Hits 6 National Offender Hits 11 National Forensic Hits 1 Total 35 Samples entered into CODIS for February 2013 Headquarters Cleveland Savannah 140 1,871 15 Total 2,026 Profiles in CODIS Forensic Casework Profiles Convicted Offender Profiles Missing Person/Unidentified Human Remain Profiles Total 13,480 253,902 21 267,403 9 Laboratory Production Case Turnaround for February 2013 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 2,450 3,981 62% 311 339 92% 236 355 66% 287 321 89% 1,988 2,099 95% 68 101 67% 119 188 63% System-wide Totals 5,459 7,384 74% Note: 84.8% Casework Reports were released within 90 days. Case Turnaround for Year-to-Date, FY2013 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 17,700 31,120 57% 1,283 1,789 72% 2,355 3,770 62% 1,946 2,509 78% 13,612 15,531 88% 1,265 1,709 74% 1,822 2,320 79% System-wide Totals 39,983 58,748 68% 10 Crime Laboratory Cases Processed for February 2013 Department Requested Total Released Chemistry (includes Drug ID) Firearms Forensic Biology Latent Prints Medical Examiners Questioned Documents/Photography Toxicology Trace Evidence 2,171 224 2,284 219 370 3 1,960 110 2,362 357 2,453 189 347 6 1,910 107 Total 7,341 7,731 Crime Laboratory Cases Processed FY2013 Department Requested Total Released Chemistry (includes Drug ID) Firearms Forensic Biology Latent Prints Medical Examiners Questioned Documents/Photography Toxicology Trace Evidence 17,317 3,560 18,712 1,479 3,187 37 16,096 692 17,918 4,516 18,124 1,248 3,031 35 16,151 756 Total 61,080 61,779 11 Georgia Crime Information Center FEBRUARY 2013 1. SYSTEM AVAILABILITY: Max Hours Possible for Month Downtime (Hours) Degraded (Hours) Percent Available for Month AFIS 672.00 Enterprise GoNET/ Network 2200 Infrastructure 672.00 672.00 IBM System 672.00 6.00 70.25 0.00 21.75 0.00 0.00 0.00 0.00 99.11% 89.55% 100% 96.76% NCIC Files 672.00 4.00 0.00 99.40% NICS NLETS 672.00 4.00 0.00 99.40% 672.00 2.00 0.00 99.70% 2. AUDITS: During the reporting month there were 20 full service audits conducted. There were 17 on-site audits conducted for agencies obtaining "inquiry only" from the CJIS network; 16 criminal justice E-Audits; 28 non-criminal justice audits. The total number of audits conducted during FY2013: 552. 3. TRAINING: GCIC personnel provided 681.75 hours of training to 1,984 criminal justice agency employees during the month. 4. AFIS REPLACEMENT Project Description: GCIC has 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. Monthly Update: A Draft Statement of Work (SOW) for the Image Archive was reviewed by GBI/GCIC staff involved in the design. Minor adjustments were made to the SOW and the document was returned to NEC for review. 5. SEX OFFENDER REGISTRY RE-DESIGN PROJECT Project Description: Georgia's Sex Offender Registry (SOR) was created in 1996 and the purpose of the SOR is to provide law enforcement with an efficient and effective method of monitoring sex offenders. In 2010, the Georgia Department of Audits and Accounts Performance Audit Operations conducted an audit on the Georgia SOR and their findings indicated that the SOR is an outdated and inflexible computer system; the registry does not fully meet the needs of law enforcement monitoring and investigating sex offenders and that the public website should provide more complete and accurate information. The information contained in the audit validated issues GBI had noted for some time regarding the need to improve and modernize the SOR. To remedy the current database limitations, the Georgia Bureau of Investigation (GBI) seeks to modernize and replace the SOR using web technologies, which will allow GBI to accommodate requests from sheriffs and other customers. Moving to web technologies will ensure greater flexibility for the State to incorporate future updates or enhancements as dictated by state or federal legislation, operational needs, or public demands. Increased 12 capabilities would also allow the sex offender database to link to other databases to help improve record accuracy or offender tracking, such as address verification or developing a link with the Department of Corrections for information on re-incarceration of offenders. Offender images would be stored in a format allowing sharing with the Federal Bureau of Investigation's (FBI) National Crime Information Center (NCIC) Convicted Sex Offender File for use by all criminal justice agencies throughout the United States. Access to the public registry would be real time instead of 24 hours old as with the current process of providing a daily update for public web presentation. Monthly Update: The Application Development Support unit and the Sex Offender unit continue to monitor transactions transmitted from SORT to the National Crime Information Center (NCIC). Discussions have begun for Phase II of the SORT project to implement the public website. The Sex Offender Registry website is currently being maintained by GANet through FTP submissions. With the new public website, data for the registry will be populated directly from the SORT database. 6. 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. The team will identify which servers can be consolidated and the timeframe to complete the move. Monthly Update: We are now on a once a month schedule for the SCON Business Council meetings. The last meeting was held on February 20, 2013. The next scheduled Business Council meeting will be March 20, 2013. Accomplishments This Reporting Period Ongoing progress of DB & Middleware installation 37 servers turned over to agency GBI continues progress on installing applications Ongoing resolution of technical issues Planned Accomplishments Tasks in Progress Finish Application Installs Begin UAT Project Issues / Risks and Mitigation Issues with Mitigation Plan: T01 Protective Order Registry, tracking item for impacts. Optimistic that this is a low impact issue. Risks: The legacy server cannot be patched due to firmware/hardware issues. Patching the OS and applying Service Packs to the new hardware at the NADC should not be an issue; however, it is unknown how these patches will impact the application Protective Order Registry. 13 AFIS network is an isolated network at GBI HQ and requires a different solution to facilitate communication. This issue is related to issue # T02 regarding One-toOne NAT issue. The solution for issue # T02 resolved the majority of the server communication requirements except for these AFIS servers. Several of the servers released yesterday failed the "Map-Back" test. The SunOne Middleware product currently installed on the legacy servers is out of support and cannot be installed. All attempts to reinstall by copying files from the legacy servers have failed. A replacement middleware solution is required. Items Requiring Management Attention/Escalation: None Critical Path Tasks/ Milestones/Deliverables Final approval of SCON-GBI (Affinity #1) DAD #4 UAT Ops Readiness) Agency begins application rebuilds on servers Execute Testing Scripts 1st UAT Agency Formal Approval of UAT Test as Complete (2nd UAT) Baseline End 12/18/2012 Start 1/14/2013 End 2/18/2013 Start 2/19/2013 End 3/26/2013 5/29/2013 End of Project 7/25/2013 Projected End Date 2/28/2013 Start 3/15/2013 End 4/15/2013 Start 4/16/2013 End 5/28/2013 6/11/2013 7/25/2013 Status Will resubmit when DB's are installed and reported as monitored and backed-up. GBI continues progress on installing applications. Expect late start due to late OP's readiness One application has been tested Expect late start due to late OP's readiness Confirm SCON Contract Deliverable Milestones Completed 7. ADVANCED AUTHENTICATION Project Description - The CJIS Security Policy is published by the FBI in partnership with the CJIS Advisory Policy Board (APB). The CJIS Security Policy integrates presidential directives, federal laws, FBI directives and the criminal justice community's APB decisions along with guidance from the National Institute of Standards and Technology (NIST) and the National Crime Prevention and Privacy Compact Council (Compact Council). The goal of the Security Policy is to provide a unified set of standards and best practices to ensure that criminal justice information (CJI) is kept secure and only accessed by authorized personnel in the performance of their duties and that appropriate controls are in place to protect CJI, from creation through dissemination; whether at rest or in transit. In order to meet the obligations outlined in the FBI CJIS Security Policy 5.0 (CJISD-ITS-DOC-08140-5.0), GBI will implement an advanced authentication solution that will integrate seamlessly with the States' existing SSL VPN solution. GBI is working with RSA the Security Division of EMC to implement the RSA Adaptive Authentication (On-Premise) application. This solution offers a comprehensive multi-factor layered protection for all users. This risked-based authentication (RBA) technology will conduct a risk assessment to positively assure the user's identity and to detect fraudulent activity. 14 Monthly Update: GBI/GCIC approved the IBM Customer Solution Proposal (CSP) for the Advanced Authentication project. GBI is awaiting feedback from IBM on the next steps to procure and install the necessary hardware required for the application. 8. OPEN RECORDS MANAGEMENT (ORM) SYSTEM Project Description Implementation of a records management system designed to track open records requests submitted to the Open Records Unit. The newly designed web-based system replaces the existing Microsoft Word Mail Merge process currently in use. The ORM system will increase productivity of multi-user access and reporting services. Monthly Update: The Open Records Management (ORM) system went into production on February 18, 2013. 9. CRIMINAL HISTORY/IDENTIFICATION SERVICES a. Fingerprint Cards Received/Processed Document Criminal Cards Electronic Criminal Juvenile Criminal Electronic Juvenile Applicant Cards Electronic Applicant TOTAL Received February 735 39,056 79 181 238 41,469 81,758 Received FY2013 5,594 328,356 446 1,461 2,410 262,727 600,994 Processed February 619 37,525 63 157 211 39,948 78,523 Processed FY2013 5,119 314,547 406 1,295 2,239 253,557 577,163 b. Significant Productivity Data AFIS Searches (Criminal, Applicant & Juvenile) AFIS Hits (Criminal, Applicant & Juvenile) February FY2013 78,537 577,974 31,482 (40%) 254,361 (44%) c. Live Scan (Electronic Submissions) Activity February 1. ORIs transmitting electronically 360 (496 devices) 2. ORIs added: 1 3. On average, during the month, live scan represented 98% of total electronic and hard card criminal receipts. 4. On average, during the month, live scan represented 99% of the total applicant electronic and hard card receipts. d. AFIS Latent Activity Inquiries February: Inquiries FY2013: Hits February: Hits FY2013: 82,039 579,756 52 407 15 e. AFIS Remote Activity Inquiries February: Inquiries FY2013: LIP Hits February: LIP Hits FY2013: TI Hits February: TI Hits FY2013: LI Hits February: LI Hits FY2013: 875 5,904 2 8 40 155 118 889 f. CCH Record Corrections (Specials) Status Total Received Total Rejected Total Completed Total Still in Process February 1,482 89 1,447 22 g. Defense Attorney Requests for Criminal History Records for Criminal and Civil Cases February FY2013 Total Requests 242 1,628 Revenue Collected $1,125.00 $6,970.75 10. SEX OFFENDER REGISTRY a. Sex Offender Registry Records Added During the Month TOTAL February FY2013 156 1,319 b. Sex Offender Program Statistics 1. Total number offenders on file = 22,635 2. Predators = 377 3. Juvenile (treat as adult) = 23 4. Total records with images = 20,983 (99%) c. Registered Anniversary Letters Total Letters mailed: February FY2013 1,097 9,713 11. PROTECTION ORDER REGISTRY Records and Images Added During the Month Contributing Counties Records Added Records Added February February FY2013 119 1,631 14,765 Images Added February 11,730 Images Added FY2013 103,835 Total orders on file: Active: Inactive: 246,021 8,508 237,513 16