Georgia Bureau of Investigation May Monthly Report FY2013 Presented to the Board of Public Safety No Meeting Scheduled for July 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 - 17 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 Jun 36 25 27 27 29 31 26 25 21 20 24 25 15 15 16 18 18 14 15 11 10 11 1 2 3 4 6 6 6 10 11 12 15 4 4 4 4 4 4 4 4 5 5 6 19 20 20 20 21 22 25 27 28 28 29 30 31 30 30 30 31 36 38 40 40 43 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 548 645 492 Firearms 1,231 1,200 1,176 1,084 917 849 748 719 592 553 460 Forensic Biology 949 743 806 929 1,143 1,248 886 769 692 581 449 Latent Fingerprints 1,081 1,066 1,127 1,177 1,201 1,239 1,234 1,230 1,247 1,143 965 Medical Examiners 127 109 110 139 106 122 137 137 131 138 149 Miscellaneous Services 1 1 1 0 0 0 0 0 0 0 0 Questioned Docs/Photography 312 313 310 307 308 306 298 279 268 251 243 Toxicology 942 1,070 908 983 910 895 553 780 684 678 598 Trace Evidence 200 181 160 148 144 121 97 82 51 45 61 Total 6,330 5,909 6,828 6,931 6,631 6,406 5,142 4,699 4,213 4,034 3,417 4 GBI Administration Office of Privacy & Compliance/Open Records Open Records Request Archives May 2013 268 17 Total FY2013 2,947 408 Personnel Employee Totals Investigative Division Georgia Crime Information Center Division of Forensic Sciences Administration Bureau Total *Vacancies are State Funded Positions May 2013 Positions State Funded Grant Funded 325 34 91 14 282 36 45 0 743 84 Total 359 105 318 45 827 Current Vacancies* 43 15 24 6 88 5 INVESTIGATIVE DIVISION May 2013 Fiscal YTD Total Sworn Employees 240 (filled-includes grant) Total Investigative Hours Expended 29,008.25 294,427.90 Crimes Against Persons, includes Death Investigations Child Abuse Sex Crimes Missing Persons Assault, Kidnapping, Robbery, Terrorist Acts, Fugitive, Human Trafficking, etc. 9,067.50 3,953.50 2,707.00 532.00 180.00 1,695.00 98,891.45 48,711.50 24,859.45 4,508.00 862.00 19,950.50 Property Crimes, including Theft, Burglary, Forgery 2,868.00 27,738.50 Drug Investigations 7,612.00 70,700.00 Meth Lab Investigations 86.00 2,107.00 Polygraph Examinations 963.00 10,592.00 Background Investigations 88.00 1,233.00 Other Investigations, including Preliminary Investigations 4,095.25 41,668.95 Bomb Disposal Services 825.00 9,261.00 Crime Analysis 43.50 435.00 Crime Scene Specialists 3,360.00 31,801.00 All figures above represent Investigative Hours Total Seizures $595,202.15 $153,788,804.73 6 Investigative Hours Expended YTD FY2013 Bomb Disposal Services 3% Other Investigations 14% Crime Analysis >1% Crime Scene Specialists 11% Crimes Against Persons 34% Background Investigations >1% Polygraph Examinations 4% Meth Lab Investigations 1% Drug Investigations 24% 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 Additional funding adding in March 2013: $194,257.00 Total funding available: $795,257.00 Total expended through May 2013: $785,303.00 Total remaining: $9,954.00 Total Expended in May 2013: $46,495.00 $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 $6,517.50 Camden Meth Lab Waste Disposal Grant Expenditures By County May 2013 $9,130.00 $6,877.50 $7,442.50 $3,027.50 $4,057.50 $1,177.50 Gilmer Glynn Haralson Muscogee Terrell Toombs $5,087.50 Ware $3,177.50 Whitfield 8 Crime Lab Medical Examiners (includes all laboratories) May 2013 FY2013 YTD Autopsies Consultations Anthropology Total ME Cases Managed 286 2,981 138 1,425 0 0 424 4,406 Clayton County Death Certificates 45 423 Medical Examiner Activity, FY2013 Consultations 34% Anthropology >1% Autopsies 66% Confirmed CODIS Hits for May 2013 State Offender Hits 88 State Forensic Hits 22 National Offender Hits 22 National Forensic Hits 1 Total 133 Samples entered into CODIS for May 2013 1,138 Profiles in CODIS Forensic Casework Profiles Convicted Offender Profiles Missing Person/Unidentified Human Remain Profiles Total 13,975 259,223 21 273,219 9 Laboratory Production Case Turnaround for May 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 3,114 4,275 73% 188 289 65% 438 534 82% 293 318 92% 1,649 1,701 97% 220 315 70% 276 312 88% System-wide Totals 6,178 7,744 80% Note: 87.3% 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 27,044 44,318 61% 1,941 2,656 73% 3,718 5,402 69% 2,709 3,336 81% 20,102 22,160 91% 1,618 2,322 70% 2,562 3,199 80% System-wide Totals 59,694 83,393 72% 10 Crime Laboratory Cases Processed for May 2013 Department Requested Total Released Chemistry (includes Drug ID) Firearms Forensic Biology Latent Prints Medical Examiners Questioned Documents/Photography Toxicology Trace Evidence 2,378 194 2,858 191 424 3 2,173 101 2,659 385 2,253 198 402 14 2,169 66 Total 8,322 8,146 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 24,493 4,799 26,189 2,030 4,398 56 22,316 962 25,759 5,999 26,139 1,813 4,265 76 22,551 1,056 Total 85,243 87,658 11 Georgia Crime Information Center 1. SYSTEM AVAILABILITY: MAY 2013 Max Hours Possible for Month Downtime (Hours) Degraded (Hours) Percent Available for Month AFIS 744.00 Enterprise GoNET/ Network 2200 Infrastructure 744.00 744.00 IBM System 744.00 3.00 17.00 0.00 8.00 0.00 0.00 0.00 0.00 99.60% 97.72% 100% 98.92% NCIC Files 744.00 3.00 0.00 99.60% NICS NLETS 744.00 3.00 0.00 99.60% 744.00 2.00 0.00 99.73% 2. AUDITS: During the reporting month there were 31 full service audits conducted. There were 2 on-site audits conducted for agencies obtaining "inquiry only" from the CJIS network; 4 criminal justice E-Audits; 24 non-criminal justice audits. The total number of audits conducted during FY2013: 714. 3. TRAINING: GCIC personnel provided 588.75 hours of training to 2,684 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 Statement of Work (SOW) for the Image Archive was signed by NEC and GCIC. During this reporting period the following occurred: System testing and debugging bugs were found therefore system training was cancelled. On-site NEC engineer is working with the Rancho Cordova staff to obtain a fix for the issues. 5. SEX OFFENDER REGISTRY RE-DESIGN 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-todate 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 are the implementation of the Public Sex Offender Registry using the current (SORT) database and the integration of the SORT with the Department of Corrections' SCRIBE system. 12 Monthly Update: The Application Development Support unit and the Sex Offender unit continue to monitor SORT transactions. Bi-weekly meetings are conducted to discuss the progress of the Public Website implementation. The Application Support group has begun making changes needed to implement the customization of the SORT Public Website. SORT's Geocoding application and Address Verification applications must be updated to allow proper usage of the offender location feature in SORT. 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 May 15, 2013. The next scheduled Business Council meeting will be on June 19, 2013. Accomplishments This Reporting Period Data population of the target DB's is in progress. LEMS AIX Oracle 10g Production servers turned over to agency GBI continues progress on installing applications 16 applications installed Planned Accomplishments Tasks in Progress Finish Application Installs & remediation Finish Application Installs Complete UAT on the 16 applications that are installed Project Issues / Risks and Mitigation Reopened Risk 09 Oracle installation delay Status Pending Closed DB's installed pending data population with data. Issues with Mitigation Plan: T01 Protective Order Registry, CCH Servers have not been delivered. Impact will extend project schedule to end of September. 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. CCH Servers have not been delivered. This will cause project end date to be pushed out to 09/30/13. Main SCON Resource tries to configure IIS parameters or tries to launch the web page he is being prompted for a user ID. His SOG credentials will not work. This is preventing GCIC progress on UAT completion. Items Requiring Management Attention/Escalation: None 13 Critical Path Tasks/ Milestones/Deliverables Final approval of SCON-GBI (Affinity #1) DAD #4 UAT Ops Readiness) Agency begins application rebuilds on servers Baseline End 12/18/2012 Start 1/14/2013 End 2/18/2013 Execute Testing Scripts 1st UAT Agency Formal Approval of UAT Test as Complete (2nd UAT) Start 2/19/2013 End 3/26/2013 5/29/2013 End of Project 7/25/2013 Projected End Date 2/28/2013 Start 5/05/2013 End 6/05/2013 Start 6/05/2013 End 8/05/2013 9/05/2013 9/30/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 date due to late OP's readiness 16 UAT's are in the testing process. Expect late start date due to late OP's readiness. Confirm SCON Contract Deliverable Milestones Completed. 7. STAFF SERVICES INVENTORY APPLICATION Project Description GBI Staff Services utilizes an application that tracks items assigned to GBI employees by Staff Services. The existing system was updated with new features to enable a more user-friendly system such as the addition of a "Comments" field and the ability to allow special characters in the field edits. Additional enhancements include the addition of search capabilities for specific items as well as names of employees; a barcode capability for the Division of Forensic Science (DOFS) employees' badge; and the modification of the Reports feature to include comments entered for specific items issued. The new features and enhancement were completed and deployed into production on May 31, 2013. 8. 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' 14 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. Monthly Update: Final signatures were provided by GBI and GTA for the Project Change Request (PCR) created by IBM concerning the responsibility of procuring the application server software. GBI is looking into purchasing the software using the state-wide contract and is currently evaluating which software version to procure. Presently, IBM is working on the server racks and cable. Following the server set-up IBM will work on the port assignment (Itracs), SAN storage request, the firewall request and begin the server build out and back-up request. GBI has provided IBM the domain names and URL's which were required for the SSL certificates. IBM is working towards making sure the dependences and impact for the SCON activities are considered for the Advanced Authentication project. 9. SORNA REALLOCATION GRANT PROJECT Monthly Update GBI received a Sex Offender Registration and Notification Act (SORNA) grant award from the Criminal Justice Coordinating Council (CJCC) to assist the Georgia Department of Corrections (GDC) in moving the State towards compliance with the SORNA portion of the Adam Walsh Act. GBI has notified GDC of the opportunity of reimbursement for the purchase of live scan devices to capture fingerprints and palm prints to verify the identity of individuals entering the State Prison system. GDC has until June 30, 2013 to purchase the live scan devices and submit documentation to the GBI. 10. CRIMINAL HISTORY/IDENTIFICATION SERVICES a. Fingerprint Cards Received/Processed Document Criminal Cards Electronic Criminal Juvenile Criminal Electronic Juvenile Applicant Cards Electronic Applicant TOTAL Received May 702 43,489 41 228 208 30,381 75,049 Received FY2013 7,909 457,091 603 2,175 3,237 358,257 829,272 Processed May 692 42,033 34 202 199 29,371 72,531 Processed FY2013 7,400 438,331 567 1,919 3,057 345,835 797,109 b. Significant Productivity Data AFIS Searches (Criminal, Applicant & Juvenile) AFIS Hits (Criminal, Applicant & Juvenile) May 71,877 32,679 (45%) FY2013 796,269 352,236 (44%) c. Live Scan (Electronic Submissions) Activity May 1. ORIs transmitting electronically 363 2. ORIs added: 2 15 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 May: Inquiries FY2013: Hits May: Hits FY2013: 72,511 801,238 48 575 e. AFIS Remote Activity Inquiries May: Inquiries FY2013: LI Hits May: LI Hits FY2013: LIP Hits May: LIP Hits FY2013: TI Hits May: TI Hits FY2013: 684 7,899 101 1,252 5 14 14 213 f. CCH Record Corrections (Specials) Status Total Received Total Rejected Total Completed Total Still in Process May 1,751 145 1,713 38 g. Defense Attorney Requests for Criminal History Records for Criminal and Civil Cases May FY2013 Total Requests 175 2,196 Revenue Collected $670.00 $8,815.75 11. SEX OFFENDER REGISTRY a. Sex Offender Registry Records Added During the Month TOTAL May FY2013 155 1,794 b. Sex Offender Program Statistics 1. Total number offenders on file = 23,020 2. Predators = 398 3. Juvenile (treat as adult) = 25 4. Total records with images = 21,391 (99%) c. Registered Anniversary Letters Total Letters mailed: May FY2013 1,208 13,244 16 12. PROTECTION ORDER REGISTRY Records and Images Added During the Month Contributing Counties Records Added Records Added May May FY2013 118 2,093 20,553 Total orders on file: Active: Inactive: 260,399 8,848 251,551 Images Added May 15,331 Images Added FY2013 144,454 17