Join Join nt Executive Committee nt Executive Committee th Sept - PowerPoint PPT Presentation

Join Join nt Executive Committee nt Executive Committee th Sept 2017 26 th Strat Strat ta Update ta Update – 26 Sept 2017

Strata IT Director Upda ate GDIP Global Programme Comms Key Focus Cyber Managing Security Workload

But First

What did we do ? • Identified the issue at 6:45am • Mobilise Strata infrastructure specialists to attend Civ vic Centre • Assign staff and managers to each site to ensure comm munication channels with authorities were open • Restart the network switches • Isolate parts of the network as we performed a struct tured restart • Engage third parties Nexus, ComputerWorld, Dell to d diagnose issues • Investigate potential SAN issue • Replace faulty disk in SAN • Recompose the desktop environment • Bring users back on line • Work with partners to identify root cause • Publish RFO (Reason for Outage) • Investigate future risk mitigation

What is a SAN AN = Storage Area Network ontains three tiers of storage

The Root Cause Tier 1 = £xxx’s Issue 1 – Data Issue 1 Data Progression Progression Tier 2 = £xx’s Tier 3 = £x’s Issue 2 Issue 2 - - Restripe Restripe Issue 3 - Issue 3 - Rebuild Rebuild Disk Expansion Installed & Disk Expansion Installed & Faulty Disk in Tier 3 Faulty Disk in Tier 3 Optimised process commences Optimised process commences th Sept 10 th 10 Sept Aug 29th Aug 29th

The three events combine ed to create ……… Data Restripe Restripe Progression Rebuild

Key Focus • Worksmart training completed in • Bi Weekly updates issued EDDC • 3 rd parties involved – six step process • Strata service desk now running • Golden Image being recompiled Anywhere 365 • Outlook issues admitted by Global • EDDC port successful after lots of Microsoft GDIP planning • Service Go live 6th Sept Comms Cyber Work • High level of phishing attacks being • BCR’s decreasing defended against • Active management of the Threat Load • Staff being proactively alerted and workload funnels informed as to how best to protect • Proactive engagement with clients themselves against attack to prioritise work • Four levels of protection in place

Project Resource & Capac city Project utilisation now reducing to a more Project Resource e Utilization (%) realistic level enabling better workload balance 15% Leave & Absence 15% Non-Change eg Support, Trainin 20% BCRs 50% Projects Over Commitment Project Commitment Nov-2014 Jan-2015 Mar-2015 May-2015 Jul-2015 Sep-2015 Nov-2015 Jan-2016 Mar-2016 May-2016 Jul-2016 Sep-2016 Nov-2016 Jan-2017 Mar-2017 May-2017 Jul-2017 Sep-2017 Nov-2017 Jan-2018 Mar-2018 May-2018 Jul-2018 Sep-2018 Nov-2018 Jan-2019 Mar-2019 May-2019 Jul-2019 Sep-2019 Nov-2019 Jan-2020 Mar-2020 May-2020 Jul-2020 Sep-2020 Nov-2020

KPI’s are All Showing Impr rovements Incidents Service Req Security Maintenance Problems BCR’s ne 2017 8 239 21 333 94 324 ept 2017 2 180 17 283 85 296 ecrease 6 59 4 50 9 28

Other Focus Areas Town Meetings – monthly town meetings with all Strata staff, attendan ance level is high and feedback good Strata Social – two events have been organised (Sports Night / Golf C Challenge) to bring Strata staff together in an informal environment, hi level of attendance. Christmas do arranged. Newsletter – second edition of the Strata Insight publication has been n issued and well received by all staff. Work Experience – working closely with Exeter College to deliver effe ective work experience for students – Service desk / Web Design proje Effective recruitment – through the HR implemented Employee Refer rral Scheme we are attracting high quality staff to Strata. We are also getting pro-active approaches from people wishing to come to work f for Strata. Current saving in first three months of operation £10k Web site – we have launched a new Strata web site to provide a much h ‘cleaner’ view of the Strata organisation to the outside world. Printer replacement project – we are currently replacing all the Mult ti-Function Devices across the three authorities.. on 31 st Oct 2017 Staff Engagement Survey – now issued to all staff, date for completio

ST01 – Strata Organisatio ST02 – Support & Infrastr ST03 – Document Centre Spend Analysis ST04 – Security & Complian ST05 – Programme & Res ST06 – Business Systems Monthly Staff Costs by Cost Code Product and Service by Cost Code Per Month £90,000.00 £700,000.00 £80,000.00 £600,000.00 £70,000.00 £500,000.00 £60,000.00 £400,000.00 £50,000.00 £300,000.00 £40,000.00 £30,000.00 £200,000.00 £20,000.00 £100,000.00 £10,000.00 £0.00 £0.00 £0.00 ST01 ST02 ST03 ST04 ST05 ST06 ST14 ST01 ST02 ST03 ST04 ST05 ST06 -£100,000.00 01/04/2017 01/05/2017 01/06/2017 01/07/2017 01/08/2017 01/04/2017 01/05/2017 01/06/2017 01/07/2017 Staff Costs by Month Product and Service Spend by Month £218,000.00 £800,000.00 £216,000.00 £700,000.00 £214,000.00 £600,000.00 £212,000.00 £500,000.00 £210,000.00 £400,000.00 £208,000.00 £300,000.00 £206,000.00 £200,000.00 £204,000.00 £100,000.00 £202,000.00 £0.00 4/1/2017 5/1/2017 6/1/2017 7/1/2017 8/1/2017 4/1/2017 5/1/2017 6/1/2017 7/1/2017

Overtime and Mileage Spen end Analysis Total Overtime Spend by Month Mileage Spend by Month £7,000.00 £3,500.00 £6,000.00 £3,000.00 £5,000.00 £2,500.00 £4,000.00 £4,000.00 £2,000.00 £2,000.00 £3,000.00 £1,500.00 £2,000.00 £1,000.00 £1,000.00 £500.00 £0.00 £0.00 4/1/2017 5/1/2017 6/1/2017 7/1/2017 8/1/2017 4/1/2017 5/1/2017 6/1/2017 7/1/2017 8/1/2 Impact of the end of th the Global Desktop Project

Strata – Manage ement Team Update

Strata Board – Management Te eam Update • Compliance and Security • Support and Infrastructure • Document Centres • Business Systems • Programme and Resources

Compliance a and Security Robin B Barlow

Update • PSN Coco (Code of Connection) • An impasse has occurred as the PSN team now have e a zero tolerance approach to older Windows 2003 Servers. • 3 Windows 2003 servers remain (ECC x 1, EDDC x 2). ). Down from circa 50 back in May 2017. • ECC have been impacted by the unavailability of a key resource. • EDDC is the core telephony servers (circa £12k k) upgrades may now need to be undertaken. • Project to be setup to look at the many 2008 se servers that will need resolving by January 2020 • PSN Connection • Arduous process with Vodafone has continued, how wever dates to migrate the emails services are now confirmed in e September. This will then allow the EDDC & TDC co onnections to be terminated. • No further progress on government email system fr rom Crown Commercial Services, however all Councils are on the accredited ‘whitelist’ and therefore the connections s are secure with all other national and local government agencie • Security position • Continual banking and ransomware threats coming g in short bursts. Also many fake Paypal threats • Releasing block for Javascript downloads (another f favourite threat route)

Support & In nfrastructure Robin B Barlow

Key Infrastructure Activiti ties Staff Update Three new apprentices commenced work on 1 st Sept • Ben Gordon (form DCC) joined the ECC Strata service des sk • All service desks will be manned with four staff, inc. an ap pprentice at each site • • Server Migrations TDC migrations are progressing with well 31 migrated, 47 7 servers left to migrate, 18 decommissioned • TDC server rental now down to 3 Hosts and San, estimate ed total cost to Strata around 50K. • Target completion for Server migrations end of Decembe er 17 • • Global Communications Worksmart programme completed • Go live 6 th Sept • Contact Centre Software installed on Strata Servicedesk. . • • Devon WAN (Wide Area Network) 8 fold increase in costs – Strata working with KCOM to re eplace Devon WAN links • • SAN (Storage Area Network) We have installed a further 20TB’s of SAN disk capacity a as usage has been far more than original predictions •