City Council Quarterly Update Atlanta Information Management Presented

City Council Quarterly Update Atlanta Information Management Presented By Samir Saini Chief Information Officer, AIM Presented By: Samir Saini Chief Information Officer 1

AIM Objectives, Goals, Strategies Customers Mayor’s Executive Office Watershed Management Hartsfield-Jackson Int’l Airport Atlanta Police Department Atlanta Fire and Rescue Department of Corrections Judiciary Branch Dept. of Public Works Dept. of City Planning Dept. of Parks & Recreation Dept. of Sustainability Workforce Dev. Agency Atlanta 311 Dept. of Finance Department of Procurement Department of HR Dept. of Law 2

AIM IT Scope, By the #s 9410 customers 8 5 data centers 165 200 supported city sites 120 179 active projects 31, 000 emails received 145 432 per day city apps 4344 4982 servicetickets permonth 6216 PCs & laptops 1352 953 servers 156 active IT vendors 1493 network devices 946 187 network attacks active IT blocked per day Contracts 6000 4948 mobile devices 282 pcs & laptops per tech supported 3

AIM IT Service Portfolio General Services Operational & Consulting o Accounts & Access Services o Project Management o Files & Documents o Application Support o Employee Services o Solution Development o Communication Services o Data Analytics & Reporting o Collaboration Services o Geospatial Analysis & Reporting o Help & Support o Business Analysis o Equipment & Software o RFI/RFP Evaluation o Education/Training Services o Cyber Security Consulting o Connectivity o Contract Management 4

System Availability & Performance Health System Outages by Month: Past 2 Years Total Hours 21 Actuals 30 Critical 99. 79% 25 High 99. 83% Essential 100% Important 99. 68% Total Hours 10 5 3 45 авг-17 3 июл-17 5 июн-17 4 май-17 6 апр-17 2 фев-17 дек-16 3 янв-17 5 8 мар-17 10 ноя-16 4 8 окт-16 8 сен-16 7 авг-16 7 июл-16 9 июн-16 9 15 13 май-16 12 апр-16 дек-15 ноя-15 окт-15 сен-15 13 авг-15 Type 35 20 мар-16 23 июл-15 # of Outages 29 фев-16 32 янв-16 1000 900 800 700 600 500 400 300 200 100 0 August Count System Availability 7/15 – 8/17 100% 98% 0 Performance Overview (Aug 16 to Aug 17) Target 99% MIN Systems Availability above target(99%) # Outages ↓ 4(50% since 8/16. Duration ↓ 51% Note: Downtime ↓due to continued focus on responsive incident management and infrastructure stabilization. FY 17 Q 4 / FY 18 Q 1 Accomplishments ü ATL 2 Watershed Refresh - Upgraded HQ circuits from 10 mb to 100 mb ü ATL 2 Remote sites upgraded – 72 of 78 (92%) ü AT&T Ready Metro-E Conversion to ASE – 46 of 116 (40%) completed ü 311 Call Center Contact Solution Telephony Upgrade(30%) ü Upgrade Kronos Timekeeping System – 6 X performance boost ü Decommissioned legacy Nortel phone system affecting all City Hall FY 18 Q 2 Plans 96% 94% 92% 90% 5 6 6 7 5 6 6 6 7 7 6 6 7 5 6 7 6 5 7 l 1 ug 1 p 1 ct 1 ov 1 ec 1 an 1 b 1 ar 1 pr 1 ay 1 n 1 ul 1 ug 1 J A J J Ju Ju A M Fe M Se O N D D A Ju Critical (24/7) Essential (8 AM- 5 PM) Critical (8 AM-5 PM) Important (8 AM-5 PM) High(24/7) Target o ATL 2 Remote sites upgraded (Physical Network) – 78 of 78 (100%) o AT&T Ready Metro-E to ASE Conversion – 58 of 60 (97%) o Vo. IP Deployment Critical Public Safety (APD/AFD) – 10 of 12 (83%) o Server Virtualization– 95% complete o Critical App Back-ups to MS Azure Cloud – 50% complete 5 o Migrate At Risk EOL 2003 Servers to 2008+ - 99% complete

Service Desk Health Fiscal 7/15 – 8/17 Performance Overview (Aug 16 – Aug 17) August Service Desk Performance 100, 00% 95, 00% 90, 00% Type Actuals Incidents Resolved 82% Target 85% MIN SLA 85, 00% 80, 00% Requests Resolved 75, 00% 92% Total Ticket Resolution 90%, above 85% target Incidents resolved (82%) below SLA; Trend: Since Aug ’ 16 - ↑ 11%, Volume ↑ 35. 8%. Requests resolved (93%) exceeded SLA Trend: Since Aug’ 16 SLA is ↑ 3%, Volume ↑ 16% 70, 00% FY 17 Q 4 / FY 18 Q 1 Accomplishments Total Tickets Resolved (Incidents & Requests) Requests Resolved 17 ü Office 2016 Deployment – 2222 of 3809 (58%) complete ü IE 11 Upgrade (Aviation Services) – 938 of 1236 (76%) complete ü Capriza Mobile App Pilot: Improve AIM Service Desk ticket updates Ju l M ay 17 17 ar M 6 17 Jan v 1 No p 1 6 Se 16 Ju l M M ay 16 16 ar 16 5 Jan v 1 No p 1 5 Se Ju l 15 65, 00% Incidents Resolved Target Service Desk Performance w/ Volume Fiscal 7/15 - 8/17 7000 105, 00% 100, 00% 95, 00% 90, 00% 85, 00% 80, 00% 75, 00% 70, 00% 65, 00% 6000 5000 4000 3000 2000 17 Ju l M ay 17 17 M ar 17 Jan 6 v 1 No 6 p 1 Se 16 Ju l M ay 16 16 M ar 16 Jan 5 v 1 No 5 p 1 Se Ju l 15 0 Total Ticket Resolved - Volume Incidents Resolved - Volume FY 18 Q 2 Plans Requests Resolved - Volume Requests Resolved o o o o Office 2016 Deployment – 100% complete Pilot Windows 10 Skype for Business rollout Capriza Chatbot – password reset pilot Deploy Intune – Strengthen Mobile Device Mgmt Complete ITSM/ITIL procedures and Service Catalog Improve self-service password reset capability 6

Cyber Security Health Performance Overview (Aug 16 – Aug 17) Cyber Security Performance 1 500 000 1 500 1 000 500 0 л 1 ав 5 г се 15 н ок 15 т но 15 я 1 де 5 к ян 15 в 1 фе 6 в ма 16 р1 ап 6 р ма 16 й ию 16 н 1 ию 6 л 1 ав 6 г се 16 н 1 ок 6 т но 16 я 1 де 6 к ян 16 в 1 фе 7 в ма 17 р ап 17 р1 ма 7 й ию 17 н 1 ию 7 л 1 ав 7 г 1 7 0 Malware attacks 2 000 ию Network & Email Fiscal 7/15 – 8/17 Malware Attacks(Fireeye) Network Attacks(Firewall) Email Spam(Websense) Security Awareness Training ↓ 63. 0% - Blocked Network attacks (73 K to 27 K) ↓ 29. 4% - Malware blocked from ‘calling home’ (17 to 12) ↓ 24. 1% - “Phishing” Email Risk (249 K to 189 K) New Security Metrics starting Q 2/3 FY 17 Q 4 / FY 18 Q 1 Accomplishments ü ISO Certification Audit Complete w/ Recommendations & Responses ü External Vulnerability Assessment w/ Recommendations/Responses ü Strengthened internal security monitoring and detection to mitigate malicious malware attacks Completion Progress (92%) ü Security Awareness Training – Completion 92%, Adoption in the New Employee Orientation Email Security GF/DWM 6177 Incident Reporting Aviation 778 Intro to Security Awareness Field Employees 1193 Passwords New employees 57 Phishing Invest Atlanta 20 o Public Wi. Fi Total Trained 8, 225 o FY 18 Q 2 Plans o Identity Access Management – strengthen secure access to city o electronic resources Patch Management – Improve the timely application of software updates across servers, applications, databases, and endpoints. Strengthen VPN Access Controls & Request Fulfillments with Online Request Forms Roll out new Security Metrics 7

Project Management Delivery & Performance Project Delivery Fiscal 8/16 -8/17 90% Performance Overview (Aug 16 – Aug 17) August Projects in “Control” ↓ 12% - (77. 4%). Projects in “Critical” ↑ 10. 5% - (4. 20%). Projects in “Caution” ↑ 38. 5% - (11. 8%). All status within targets Type Actuals Target Control 77. 39% >70% Caution 11. 76% <20% FY 18 - 122 Active, 49 On-Hold - Across 16 Depts. Critical 4. 20% <10% FY-17 close out- 118 Completed (32 -Q 1, 26 -Q 2, 25 - Q 3, 35 - Q 4); 80% FY 17 Q 4 /FY 18 Q 1 Accomplishments 70% ü Stage-gate review process rolled out for COO Top Projects ü PMO organizational re-structure – Phase I complete ü Cristo Rey HS/GSU CIS Internship programs complete ü MS Project Online Implementation – Phase I Complete 60% 50% 40% 30% FY 18 Q 2 Plans 20% o Re-vamping of PMO processes for project in-take, classification and approvals 10% 0% Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr. May Jun Jul Aug 15 15 15 16 16 16 17 17 Project - Controlled Target - Controlled Project - Caution Target - Caution Project - Critical Target - Critical o Complete PMO re-organization o Complete Customer Service Training Course o Complete onboarding of all active projects to MS Project Online 8

PMO: FY 17 Year End 5; 4% 118 Projects Implemented FY 17 AIM Centralized Services (ACS) 26; 22% City Administrative Services (CAS) 30; 25% City Operations Support (COS) Enterprise Project Management Office (EPMO) F. A. S. T. /SMARTCITY 19; 16% 4; 3% Public Safety & Justice (PSJ) Watershed Management Services (WMS) 30; 25% 12 30 112 Active Projects 25 8 20 6 15 10 4 5 2 0 58 Projects On Hold 10 AFR AIM APD AWDA DOC DOF DOP DPCD DPW DWM ENT EXEC JA LAW OEAM 0 AFR AIM APD AWDA DOC DOP DPCD DPW DWM ENT EXEC 9 OEAM

PMO: FY 18– Year to Date 11 Projects Implemented Q 1 111 Projects To Be Implemented End of Fy 18 10

FY 18 Q 1 Implemented Projects (11) # Dept 1 AFR 2 AIM Mircosoft Online Project Server 3 AIM Open Enrollment for year 2018 4 AIM Numara Mobile Application 5 AIM Oracle User Interface Enhancements 6 APD 7 DHR Open Enrollment 2018 8 DOC Efforts to Outcome Software 9 DWM SMART BENCH 10 JA 11 OEAM Name Accela Improve Crime Analysis Management (Implement Microsoft Power BI) Pre-Trial Intervention Ethics Move from the 12 th Floor CHT to 3 rd Floor Atrium 11

FY 18 Q 2 Projected to Be Implemented (44) FY 18 Q 2 Projects to be Implemented # Dept Project Name 1 AFRD APD Public Safety Academy move to 786 Cleveland Avenue 2 AFRD AFR Scheduling and Deployment Management System (Phase 2) 3 AIM VPN Consolidation 4 AIM GMS, DPS MIGRATION 5 AIM Penetration Testing - phase 2 6 AIM EGIS Data Migration (AVS) 7 AIM Firing Range 8 APD Mercedes Benz Stadium Data Center Connection Project 9 APD Replace Zone 3 Police Precinct 10 APD Search 360 Upgrade to Slingshot 11 APD Cop. Logic 12 APD Move Zone 4 Investigations to 711 Fulton Industrial Blvd 13 APD City Adminiistrative Services (CAS)e Management Improvement 14 APD VIC Network UPgrade 15 DHR Wellness. Center - Timeline_08102017 16 DOA Email Archiving Function Enhancement and Upgrade Tech Source One 17 DOC Camera Proof of Concept 18 DOC Corrections PC Refresh 19 DOP Procurement Document Management System 20 DPCD Accela Software Assessment - Procurement 21 DPCD EDR Software - Procurement 22 DPCD QMS Customer Queue Mgt - Procurement 12

FY 18 Q 2 Projected to Be Implemented (44) (cont’d) FY 18 Q 2 Projects to be Implemented # Dept Project Name 23 DPCD Upgrade Accela Master Scripts Library to Version 3 24 DPW Street. Car Primavera Contract Management Server Buildout 25 DPW Max. View Server Installation 26 DPW Assessment Strategy for Fleet Assetworks Application 27 DPW Atlanta Streetcar (ASC) Mobile Application Program - Phase 1 A 090817 28 DPW Atlanta Streetcar (ASC) Traffic Signal Expansion Project (Project) 29 DPW Fleet Mgmt System Implementation 30 DPW Fuel RFP 1 31 DWM Kronos Enhancements DWM 32 DWM OSS i. Auditor Heath & Safety 33 DWM Document Managemetn Solutions 34 DWM Open Records Management System 35 DWM Online Utility Exhcnage 36 DWM Maximo Optimization Upgrade Project 37 DWM OPA Business Performance Analytics Tool 38 DWM Hansen Application Decommission Strategy 39 ENT Office 2016 Upgrade 40 JDA APD CITATION TICKET TO PAYMENT- Stabilization (Phase 2) 41 OEAM Convergint Security Systems Services Project 42 OEAM Flatiron Building WEI Phase 2 The Point 43 OEAM Improve City Services with ATL 311 Mobile App 44 WATL Metal Plates Waze Integration 13

SEPTEMBER 2017 THURSDAY, SEPTEMBER 14 TH: North Avenue Ribbon Cutting FRIDAY, SEPTEMBER 15 TH: “Experience Smart ATL” 14