Georgia Bureau of Investigation April Monthly Report FY2013 Presented to the Board of Public Safety No Meeting Scheduled for June 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 21 20 25 15 15 16 18 18 14 15 11 10 1 2 3 4 6 6 6 10 11 12 44 44444455 19 20 20 20 21 22 25 27 28 28 30 31 30 30 30 31 36 38 40 40 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 Firearms 1,231 1,200 1,176 1,084 917 849 748 719 592 553 Forensic Biology 949 743 806 929 1,143 1,248 886 769 692 581 Latent Fingerprints 1,081 1,066 1,127 1,177 1,201 1,239 1,234 1,230 1,247 1,143 Medical Examiners 127 109 110 139 106 122 137 137 131 138 Miscellaneous Services 1 1 1 0 0 0 0 0 0 0 Questioned Docs/Photography 312 313 310 307 308 306 298 279 268 251 Toxicology 942 1,070 908 983 910 895 553 780 684 678 Trace Evidence 200 181 160 148 144 121 97 82 51 45 Total 6,330 5,909 6,828 6,931 6,631 6,406 5,142 4,699 4,213 4,034 4 GBI Administration Office of Privacy & Compliance/Open Records Open Records Request Archives April 2013 339 28 Total FY2013 2,679 391 Personnel Employee Totals Investigative Division Georgia Crime Information Center Division of Forensic Sciences Administration Bureau Total *Vacancies are State Funded Positions April 2013 Positions State Funded Grant Funded 325 34 91 14 282 36 45 0 743 84 Total 359 105 318 45 827 Current Vacancies* 40 12 20 5 77 5 INVESTIGATIVE DIVISION April 2013 Fiscal YTD Total Sworn Employees 241 (filled-includes grant) Total Investigative Hours Expended 28,567.45 265,419.65 Crimes Against Persons, includes Death Investigations Child Abuse Sex Crimes Missing Persons Assault, Kidnapping, Robbery, Terrorist Acts, Fugitive, Human Trafficking, etc. 9,304.75 3,762.00 3,363.75 410.00 85.00 1,684.00 89,823.95 44,758.00 22,152.45 3,976.00 682.00 18,255.50 Property Crimes, including Theft, Burglary, Forgery 2,618.75 24,870.50 Drug Investigations 7,138.00 63,088.00 Meth Lab Investigations 126.00 2,021.00 Polygraph Examinations 952.00 9,629.00 Background Investigations 134.00 1,145.00 Other Investigations, including Preliminary Investigations 3,865.95 37,573.70 Bomb Disposal Services 990.00 8,436.00 Crime Analysis 50.00 391.50 Crime Scene Specialists 3,388.00 28,441.00 All figures above represent Investigative Hours Total Seizures $1,836,562.50 $153,193,602.58 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 April 2013: $738,809.00 Total remaining: $56,448.00 Total Expended in April 2013: $46,842.50 $7,000.00 $6,000.00 Meth Lab Waste Disposal Grant Expenditures By County April 2013 $6,355.00 $5,000.00 $4,000.00 $3,000.00 $5,130.00 $3,615.00 $3,177.50 $4,415.00 $4,565.00 $4,102.50 $4,057.50 $3,177.50 $2,817.50 $3,640.00 $2,000.00 $1,790.00 $1,000.00 $0.00 Burke Cook Glynn Habersham Jeff Davis Laurens McDuffie Montgomery Richmond Thomas Upson Whitfield 8 Crime Lab Medical Examiners (includes all laboratories) April 2013 FY2013 YTD Autopsies Consultations Anthropology Total ME Cases Managed 260 2,695 121 1,287 0 0 381 3,982 Clayton County Death Certificates 47 378 Medical Examiner Activity, FY2013 Consultations 34% Anthropology >1% Autopsies 66% Confirmed CODIS Hits for April 2013 State Offender Hits 65 State Forensic Hits 12 National Offender Hits 11 National Forensic Hits 0 Total 88 Samples entered into CODIS for April 2013 2,761 Profiles in CODIS Forensic Casework Profiles Convicted Offender Profiles Missing Person/Unidentified Human Remain Profiles Total 13,835 258,225 21 272,081 9 Laboratory Production Case Turnaround for April 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,957 4,191 71% 249 302 82% 403 505 80% 237 269 88% 2,465 2,486 99% 62 165 38% 241 287 84% System-wide Totals 6,614 8,205 81% Note: 86.4% 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 23,930 40,043 60% 1,753 2,367 74% 3,280 4,868 67% 2,416 3,018 80% 18,453 20,459 90% 1,398 2,007 70% 2,286 2,887 79% System-wide Totals 53,516 75,649 71% 10 Crime Laboratory Cases Processed for April 2013 Department Requested Total Released Chemistry (includes Drug ID) Firearms Forensic Biology Latent Prints Medical Examiners Questioned Documents/Photography Toxicology Trace Evidence 2,169 211 2,083 180 381 10 2,012 94 2,640 422 2,894 170 400 13 1,968 98 Total 7,140 8,605 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 22,104 4,466 23,365 1,843 3,975 53 20,142 865 23,100 5,614 23,886 1,615 3,865 62 20,382 990 Total 76,813 79,514 11 Georgia Crime Information Center 1. SYSTEM AVAILABILITY: APRIL 2013 Max Hours Possible for Month Downtime (Hours) Degraded (Hours) Percent Available for Month AFIS 720.00 Enterprise GoNET/ Network 2200 Infrastructure 720.00 720.00 IBM System 720.00 2.50 12.25 0.00 5.50 0.00 0.00 0.00 0.00 99.65% 98.30% 100% 99.24% NCIC Files 720.00 5.25 0.00 99.27% NICS NLETS 720.00 5.25 0.00 99.27% 720.00 2.00 0.00 99.72% 2. AUDITS: During the reporting month there were 28 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; 4 non-criminal justice audits. The total number of audits conducted during FY2013: 653. 3. TRAINING: GCIC personnel provided 665 hours of training to 1,655 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 hardware and software delivered to GBI 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. Monthly Update: The Application Development Support unit and the Sex Offender unit continue to monitor SORT transactions. Updates to XML web services which facilitate the exchange of information and the integration of the National Crime Information Center (NCIC) database, the Computerized 12 Criminal History (CCH) database, the National Law Enforcement Telecommunication System (Nlets) and the Law Enforcement Message Switch (LEMS) were implemented in the SORT test environment and tested for acceptance prior to uploading to production. Deployment of these updates to the SORT production environment is scheduled for April 2013. The SOR Team reviewed the current SOR public website to aid in the customization and development of the SORT Public website screens and data fields. The Application Support staff met to determine what needs to be done to implement the customization. 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 April 26, 2013. The next scheduled Business Council meeting will be May 22, 2013. Accomplishments This Reporting Period Oracle 11g installation is in progress GBI continues progress on installing applications 13 applications installed Warm backup of CCH Prod Oracle DB has been completed to the Satabeast. This DB snapshot will be used to populate the GETS-HE Oracle DB's Planned Accomplishments Tasks in Progress Finish Application Installs Complete UAT on the 13 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, 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. 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 1-to-1 NAT issue. The solution for issue #T02 resolved the majority of the server communication requirements except for these AFIS servers. A shared "jump server" resource that is used by multiple agencies to communicate with servers is resource constrained (disk space and memory). GBI has opened two incident tickets IN399184 and IN430609. GBI wants SCON to escalate these incidents tickets to resolve these resource constraints on this server. 13 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 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 7/05/2013 7/08/2013 8/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 date due to late OP's readiness 13 UAT's are in the testing process. Expect late start date 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. Monthly Update: The original IBM Customer Proposal Solution (CSP) required changes in the responsibility of procuring the application server software. It was decided that GBI would order this software using the state-wide contract. Signatures for the Project Request for Change (PCR) are pending since GBI is responsible for ordering the server software. Currently, IBM has procured four physical servers for the Advanced Authentication project. 14 The servers were placed at the NADC location. GBI will work with IBM on the domain names and URL's which are required for the SSL certificates. The next step is for IBM to deliver the servers to GETS-HE, initiate key documents (OnePath, Build Sheet and Firewall request and other pertinent forms) and define the project milestone target dates. Once the hardware is set-up, GBI will order the RSA Advanced Authentication software. 8. CRIMINAL HISTORY/IDENTIFICATION SERVICES a. Fingerprint Cards Received/Processed Document Criminal Cards Electronic Criminal Juvenile Criminal Electronic Juvenile Applicant Cards Electronic Applicant TOTAL Received April 767 41,703 62 264 330 30,557 73,683 Received FY2013 7,207 413,602 562 1,947 3,029 327,876 754,223 Processed April 698 40,457 58 236 316 29,602 71,367 Processed FY2013 6,708 396,298 533 1,717 2,858 316,464 724,578 b. Significant Productivity Data AFIS Searches (Criminal, Applicant & Juvenile) AFIS Hits (Criminal, Applicant & Juvenile) April 70,584 31,396 (44%) FY2013 724,392 319,557 (44%) c. Live Scan (Electronic Submissions) Activity April 1. ORIs transmitting electronically 361 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 April: Inquiries FY2013: Hits April: Hits FY2013: 72,009 728,727 62 527 e. AFIS Remote Activity Inquiries April: Inquiries FY2013: LI Hits April: LI Hits FY2013: LIP Hits April: LIP Hits FY2013: TI Hits April: TI Hits FY2013: 951 7,215 145 1151 1 9 18 199 15 f. CCH Record Corrections (Specials) Status Total Received Total Rejected Total Completed Total Still in Process April 1,305 70 1,191 12 g. Defense Attorney Requests for Criminal History Records for Criminal and Civil Cases April FY2013 Total Requests 196 1,995 Revenue Collected $855.00 $8,815.75 9. SEX OFFENDER REGISTRY a. Sex Offender Registry Records Added During the Month TOTAL April FY2013 145 1,639 b. Sex Offender Program Statistics 1. Total number offenders on file = 22,878 2. Predators = 396 3. Juvenile (treat as adult) = 23 4. Total records with images = 21,259 (99%) c. Registered Anniversary Letters Total Letters mailed: April FY2013 1,125 12,036 10. PROTECTION ORDER REGISTRY Records and Images Added During the Month Contributing Counties Records Added Records Added April April FY2013 109 1,759 18,460 Images Added April 13,419 Images Added FY2013 129,123 Total orders on file: Active: Inactive: 249,394 8,578 240,816 16