Council FY 19 Budget Overview Daphne Rackley Chief

Council FY 19 Budget Overview Daphne Rackley Chief Information Officer, Interim 6. 6. 18

Atlanta Information Management (AIM) Presentation Flow § Budget Presentation Team (Council’s left to right) – Errin Baugh, DCIO Enterprise Project Management Office (EPMO) – Daphne Rackley, Chief Information Officer, Int. – Lateef Ashekun, Service Desk Director – Kelvin Brooks, Chief Information Security Officer, Int. § Department Overview (See presentation) – Organizational Chart – FY 18 Accomplishments – FY 19 Plans § AIM Operating Budget Highlights (See Budget Book p. 169. General Fund on p. 175) – Personnel – O&M – Cyber Security 2

AIM Organizational Chart CIO, Interim Daphne Rackley Communications Deanna Williams, Comm Mgr. Chief of Staff TBD, DCIO Human Resources Danielle Jones, Mgr. Business Relationship Mgmt. (BRM) Jaci Vickers, Dir. La. Monte Carr, Dir. Tech Innovation & Performance (TIP) Kirk Talbott, Exec. Dir EPMO Errin Baugh, DCIO Ideation (Business Analysis) Rockie Pitts Service Desk Lateef Ashekun Applications Praveen Hombaiah Continual Service Improvement Implementation Angelia Brown, Arlanda Ross, Jaci Vickers Server Tony Barnes QA/QC Eduardo Torrejon Project Governance Dwayne Cole Network Shanda Astin Data Analytics & Reporting Frank Ruben Training Kimberly Nelson Telecom Tameka Dudley Performance & Audit Compliance Roger Campbell Project Administration Kia Hampton Centralized Services De-centralized Services Applications & Data Services (ADS) Vacant, DCIO Project Mgt. Lynn Fleming JA Michal Legend: Infrastructure & Operations (OIO) Jason Watkins, CTO Data Center Kathy Bullard PMO / FAST Ed Peters EGIS Rajesh Polumahanti PMO Ray Robinson Information Security (OIS) Watershed Kelvin Brooks, Exec. Dir Amanda Fitzpatrick , DCIO Operations Amobi Christopher/ Kevin Page Project Mgmt. Trina Nkhazi Aviation Sharon Heard-Brown, DCIO Applications Support Blondette Christian Business Services A. Perkinson & Michelle Yike Applications Development Jianrong “JZ” Zhang Network Operations Noel Smalls Business Operations Mgmt. Deirdre Bibbs Network Services Erin Greene PMO Kim Kerr Strategic Services Nyreen Lamb QA/QC Yvette Mackey Centralized Ops Director Ben Graham, Int. Security Moe Ismail PMO David Washington Centralized Ops Service Desk Jon Pruitt 3

Atlanta Information Management FY 18 Performance # of Outages 29 23 Service Desk Performance 21 9 12 13 9 7 7 8 8 4 10 5 8 3 2 6 4 5 3 4 5 4 7 5 2 3 Key Accomplishments (from FY 15) 97 100 87 77 19 50 68 24 20 FY 11 FY 12 FY 13 FY 14 65. 00% Target Total Tickets Resolved (Incidents & Requests) 120 44 70. 00% 5 127 67 75. 00% 10 Count 140 68 80. 00% 15 0 80 85. 00% 20 Project Completions 0 90. 00% 25 Total Hours 40 95. 00% 30 13 60 100. 00% 35 Ju Au l-15 g Se -15 p. Oc 15 t No -15 v-1 De 5 c Jan-15 Fe -16 b M -16 ar Ap -16 M r-16 ay Ju -16 n. Ju 16 Au l-16 g Se -16 p. Oc 16 t No -16 v-1 De 6 c Jan-16 Fe -17 b M -17 ar Ap -17 M r-17 ay Ju -17 n. Ju 17 Au l-17 g Se -17 p. Oc 17 t No -17 v-1 De 7 c Jan-17 Fe -18 b 18 1000 900 800 700 600 500 400 300 200 100 0 System Outages Ju Au l 15 g Se 15 p 1 Oc 5 t No 15 v 1 De 5 c Jan 15 Fe 16 b M 16 ar Ap 16 M r 16 ay Ju 16 n 1 Ju 6 Au l 16 g Se 16 p 1 Oc 6 t No 16 v 1 De 6 c Jan 16 Fe 17 b M 17 ar Ap 17 M r 17 ay Ju 17 n 1 Ju 7 Au l 17 g Se 17 p 1 Oc 7 t No 17 v 1 De 7 c Jan 17 Fe 18 b 1 8 Total Hours 32 FY 15 FY 16 FY 17 FY 18 o o o Established centralized Cyber Security office and Security Governance Board o Lead Connect. Home digital inclusion program; delivered tablets with internet connectivity to 465 families & 883 children across 65 APS schools Migrated some core applications (Email & Oracle ERP) to the cloud. Centralized AIM Service Desk, achieved minimum 85% ticket resolution with SLA Established central PMO office, completed 388 projects across 15 City departments Enacted Smart City governance, and technology innovation project portfolio Established central data analytics reporting team (DART), data lake platform and visualization toolset 4

Atlanta Information Management FY 19 Proposed Operating Budget: $ 35, 064, 527* General Fund Enterprise Funds $28, 126, 302 $6, 938, 225 FY 15 Budget $35, 382, 673 Strategic Initiatives Key Operations (GF) Operational Area CIO Budget ($) $ 808, 985 Infrastructure and $ 12, 363, 916 Operation Authorized Positions KPIs / Scope of Service Strategic Alignment 5. 75 Enterprise Ethical, Transparent and Fiscally Responsible 54. 84 % System Availability # System Outages PCs/Laptops - 6216 Smartphones – 4948 Servers - Data Centers – 5 Networks – 5 World Class Workforce, Infrastructure and Services Applications $ 10, 428, 390 27. 8 % Application Availability Applications – 400+ World Class Workforce, Infrastructure and Services PMO $ 1, 632, 422 26. 34 % Projects Completed % At-Risk Projects – 111 World Class Workforce, Infrastructure and Services Time to Remediation Firewalls – 20 VPN – 600 World Class Workforce, Infrastructure and Services Security $ 1, 558, 160 4. 6 Administration $ 1, 335, 427 10 Contracts - 187 *FY 19 budget will be amended to reflect additional Cyber Security related expenses FY 19 Budget $35, 064, 527 Ethical, Transparent and Fiscally Responsible § § Improve IT Financial Management § Improve Infrastructure Reliability and Effectiveness § Engrain Great Customer Service in the AIM Culture § Utilize Data Analytics to Improve City Services § § Rationalize & Enhance Applications § Strengthen IT Talent Management Enhance Cybersecurity Governance and Services Strengthen IT Project Governance & Delivery 5

Atlanta Information Management AIM General Fund Budget | Historical Trend $ 35, 000 200 $ 31, 511, 780 180 $ 30, 000 $ 27, 087, 187 $ 28, 089, 785 $ 26, 881, 884 $ 27, 271, 056 $ 28, 544, 179 $ 28, 153, 255 $ 27, 565, 222 $ 28, 126, 302 160 $ 25, 372, 782 $ 25, 000 127. 24 129. 41 120 $ 20, 000 $ 15, 000 140 81 84 90 89. 5 94. 4 96. 08 100 # FTEs Budget 122. 27 130. 46 80 60 $ 10, 000 40 $ 5, 000 20 $ - FY 10 FY 11 FY 12 FY 13 Personnel FY 14 Non-Personnel FY 15 Total FY 16 FY 17 FY 18 FY 19 0 # Staff 6

Atlanta Information Management FY 19 Proposed Amended Budget: $ 5. 7 M (GF) Type of Expense FY 19 Total GF DWM DOA Managed Security Services Provider (Secure. Works) $2. 98 M $0. 987 M Microsoft Security Protection & Detection $2. 82 M $1. 7 M $0. 764 M $0. 364 M Network Redesign/Configuration $1. 50 M $1. 5 M n/a Application Packaging (Remote deployments of user applications, based on department and employee personas) $0. 350 M $. 245 M $0. 105 M n/a Application Re-building & Rationalization $1. 7 M $1. 18 M $0. 510 M n/a Change Management/Training| Citywide (One. Drive, Windows 10, Skype etc. ) $0. 050 M Total $9. 5 M $5. 7 M $2. 4 M $1. 3 M 7

Cyber Security | Where are we now? Applications 20; 5% 147; 35% 257; 60% Impacted (N) Impacted (Y) TBD 90 80 70 60 50 40 30 20 10 0 [VALUE] (37%) (57%) Online Notes: # Mission Critical Apps: 95 Impacted Applications: 143 # Impacted Apps (All): 147 # Applications: 424 [VALUE] (5%) (1%) Partial (Online) Offline Sunset 90 80 70 60 50 40 30 20 10 0 [VALUE] (80%) [VALUE] (5%) Online Partial (Online) [VALUE] (13%) Offline (2%) Sunset • Rebuild critical apps in current “reinforced” environment • Stand-up “new” environments (on-premise & cloud) • Develop plans to move apps to “new” environment; Email & Oracle already cloud based • Rationalize (reduce) # of Apps Notes: 29% (49) of the impacted applications are mission critical Computers Phase II Reimaged Impacted: 2, 283 (36%) 433; 16% Computer Refresh | Pilot (500) 146; 29% Phase III Reimaged Non-Impacted d TBD – Based on Assessment Phase IV Computer Refresh 2295; 84% Target Outside of Target 354; 71% Deployed Pending Approximately ≈ 4, 319 Notes: • Total Inventory ≈ 6300 • Approx. 200 Computer models/variations • Deployed 200 Loaner Surfaces • Deploying 500 Emergency PCs • Leasing 4, 319 Computers

Q&A 9