City Of Park Ridge December 14, 2015 Council Update Overview - PowerPoint PPT Presentation

Prescient Solutions City Of Park Ridge December 14, 2015 Council Update

Overview • Commenced Services August 3, 2015 • 3 year agreement • First 90 Day Focus: • Stabilize and document the environment • Reduce the backlog of helpdesk tickets • Identify high priority projects and remediation items

Key Accomplishments Issue Impact / Risk Solution / Results Cost Savings Failed controller on SAN / Hard Degraded performance on SAN Replaced failed controller and • • drives on system backup storage impacting virtual server reset SAN. Brought SAN back unit performance for users. No to 100% functionality and ability to failover which would performance. result in data loss and/or Replaced failed drives and • corruption. restored storage space for Physical server backups failing system backups. • for months with no storage available. Email archiver out of space E ‐ Mail from July for all employees Expanded space allotted to the could not be accessed in the archiver and reconfigured the archives for legal and FOIA software to begin archiving of e ‐ requests. mails. Added ancillary resources to help Ability to address high priority 306 hours above contracted $38,250 – Cost Avoidance (extra support the transition issues faster than utilizing or resources resources @ $125 per hour x 306 hiring additional staff without (ARM, Professional Services, having to increase costs Floaters) Negotiated 3 rd party vendor Support Contracts The SAN and primary UPS were $5,000 no longer under valid support support contracts to improve contracts which results in very service and reduce cost. high time & material support costs on a per incident basis.

Accomplishments Continued Issue Impact / Risk Solution / Results Cost Savings Security Patches / Firmware No regular security patch or Update all servers, computers and Updates system firmware updates. network devices/appliances. Set Security and integrity of your regular planned updates, and infrastructure and data monitor. This allows for a more susceptible to a breach secure server and network environment Squad video not uploading to Police staff could not access video Implemented a manual upload server due to poor outdoor Wifi in order to provide for legal / FOIA process until better Wifi coverage coverage and limited time of requests and officer upload processes can squads being in range of Wifi be implemented System Backups A number of system backups had Corrected errors and updated not successfully completed in configurations to ensure all months greatly increasing risk of systems are being backed up data loss. regularly Guest wireless inaccessible Guest users needed to be Reconfigured guest wireless to manually authorized by IT staff allow users to connect without causing frustration to users and any IT intervention. Configured increased administrative terms of service acceptance page overhead. for all users to accept prior to connecting. Fire vehicle mobile data Computers would freeze up or Reinstalled operating system and computers (MDC) unreliable lose connectivity to dispatch configured software to stabilize regularly the computers

Accomplishments Continued Tickets Closed by Month *Through 11/30/2015 505 tickets closed since August 1 st •

In Process Issue Impact / Risk Solution / Results Cost Savings Equipment Replacement Plan When technology is left in service Create a lifecycle for each too long: category of equipment based Decreased staff efficiency upon vendor product roadmaps • Performance degradation and needs of staff. Implement a • Increased risk of system failure replacement rotation that evenly • Increased risk of network balances yearly deployments to • outage reduce budget impact Increased risk of security • vulnerabilities Operating System Support End ‐ of ‐ Life operating systems Replace equipment still running exist in the network creating an unsupported operating systems increased security risk as well as reduced compatibility with newer software and applications Consolidated Backup Solution One backup platform to perform Replace the two current backup all system backups with one single platforms with one consolidated point of management platform Network Reconfiguration and Improperly configured network Reconfigure and document Documentation equipment can result in network settings to alleviate risks performance degradation and security vulnerabilities

In Process Issue Impact / Risk Solution / Results Cost Savings Wireless Network Current internal staff wireless Replace and consolidate current network is slow and does not wireless equipment to increase provide proper coverage. Current manageability, performance & guest wireless is provided by coverage completely separate equipment and management portal. MUNIS upgrade (Server & MUNIS currently runs on a very Move to a new virtual server Software) old server which is a performance running the current version of the and security risk. The current software. MUNIS software version is outdated, there are a number of improvements and new features in current versions. CAD/RMS Deployment Implementing Sungard dispatch Continue working with Sungard software in the squad cars and and West Suburban to deploy full configuring access to the Records functionality of the system. system for staff. Replaces paper processes and submissions, provides electronic reporting, automates certain tasks

Looking Forward Strategy: • Continue to stabilize and update the environment • Work with departments to identify needs • Work with City Manager & Finance Director to establish priorities • Bi ‐ Weekly Status Meeting • Create project list, technology roadmap and budget plan

Thank You Q & A

2016 2017 2018 2019+ MUNIS (Finance): Requisitions & Purchase Orders MUNIS (Finance): Contract/Bid Management MUNIS (Finance): Citizen Self Service Software Implementation (Public Works): Work Orders & Time Tracking Software Implementation (HR): ADP Phase II: Process Automation, Open Enrollment, Employee Self Service Software Implementation (Capital Projects & Development): Plan Review, Permits, Inspections, Business Licenses Infrastructure: Wireless Network Replacement/Expansion Software Implementation (All Departments): Centralized Electronic Document Management Infrastructure/Software Implementation (All Departments): Office 365 & Sharepoint Online: Intranet, E ‐ Mail, Instant Messaging, Virtual Meetings MUNIS (Finance): Utility Billing CIS Migration/Upgrade Infrastructure: In ‐ Building Camera System Software Implementation (All Departments): Website Enhancements & Expansion Infrastructure (Public Works): Vehicle Metrics & Tracking Software Implementation (CP&D): Adjudication Platform