HomeMy WebLinkAbout07.c. Central San 2016 IT Accomplishments 7.c.
Central San 2016 IT
Accomplishments
Infrastructure
• Installed Smart Boards in seven conference rooms and 30 staff were
trained how to use them.
• Installed an Information TV in the Headquarters Office Building lobby and
configured it with a video player to play Central San educational videos
automatically during working hours.
• Assisted with network and telephone planning and configuration changes to
support the move of Asset Management staff and IT staff to the Garden
Level. We love having the new space!
• Acquired and implemented the connections and installation of equipment at
anew Co-Location facility in Rocklin, California to provide redundant off-site
storage and computer resources in case of a local emergency. Most of
Central San's core business systems are now replicated at this remote
location.
• Signed a contract and acquired the equipment necessary to replicate the
SunGard system fully between the Collection System Operations (CSO)
Division in Walnut Creek and the Martinez campus. Cleaned up the
physical data center at CSO, reorganized the room, and eliminated the old
rack and equipment.
• Installed new industrial network switches throughout the Treatment Plant.
Will cut over to the new switches once power work has been completed.
• Eliminated Google email routing.
• Converted from CaINet2 to CaINet3 billing for telecom and data lines.
• Replaced the projector in Multi-Purpose Room to eliminate flashing.
• Installed new recording equipment in the Board Room podium and
reconfigured the equipment to eliminate outages caused by overheating.
• Selected a contractor to design and relocate the Data Center so it is
protected from future water events. Worked with contractor to inventory
systems, map out connections in order to finalize the location and
architecture decisions.
• Conducted WiFi "heat map" study to determine where WiFi improvements
are needed in most of buildings. Added new WiFi equipment in those areas
where improved coverage was needed.
• Acquired and installed new Wonderware Supervisory Control and Data
Acquisition (SCADA) servers for the Pumping Stations.
Software Improvements
• Upgraded Laserfiche Document Management System to the latest version.
• Upgraded CUTIS intranet platform and fixed the search tool.
• Transitioned Computer-Aided Design (CHAD) license servers to IT.
• Consolidated old Engineering Services Group printers and plotters with
other Central San printers on the same server.
• Fixed the resource scheduling (meeting rooms and Central San vehicles)
process in Microsoft Outlook.
• Installed InfoWorks for use by Engineering to help model Central San
systems.
• Purchased new photo storage system for the Communication Division.
Negotiated new Microsoft contract to upgrade Microsoft Office to the latest
version, provide new cloud services through Office 365, Skype for
Business, Microsoft OneDrive, SharePoint, and other tools. Upgraded this
software for a large number of pilot users. Negotiated a contract to train 30
staff in how to use this software, to be conducted at the end of January.
• Upgraded VMWare virtual server environment to latest version.
2
Mobile Deployments
• Purchased 30 tablets for CSO staff for use with the new CityWorks
Computerized Maintenance Management System (CMMS). Configured all
devices, installed protective covers and software and trained staff how to
use them. The tablets were added to the items that IT supports on a daily
basis going forward.
• Purchased and pilot tested several different types of mobile devices for
Environmental Compliance Inspectors, which are in use today.
• Installed and configured mobile security software on each tablet that allows
IT staff to track the device location and remotely lock or erase the device if
lost or stolen.
• Implemented complex Active Directory Federation Services (ADFS)
services which enable CityWorks tablets to securely access the Geospatial
Information System (GIS) servers. This was also necessary to facilitate the
moving to Microsoft Office 365.
Successfully pilot tested a cell phone amplifier in a work truck to boost
signal in remote areas.
Business Improvements
• Installed new Cognos report-writing software and conducted training for 15
staff on how to build new reports and charts.
• Developed 20 new and improved business and financial reports using
Cognos BI to make Enterprise Resource Planning (ERP) information more
useful and accessible.
• Conducted a Request for Proposal (RFP) and selected a vendor to
implement an automated Agenda Management System. Implementation
has begun with a goal of being live in March 2017.
• Implemented IT Pipes video tools in three TV trucks to replace the outdated
Granite XP /WinCAN solution.
3
• Conducted pre-RFP intranet/internet vendor demonstrations and issued an
RFP for a vendor to replace these systems beginning in the first quarter of
2017.
• Implemented Benselect tools so that staff can manage their own benefits
online.
• Implemented Hartford Life Insurance project to allow staff to sign up for this
benefit online.
• Worked with SunGard and Human Resources to implement the new
Affordable Care Act (ACA) requirements.
• Conducted a one-week Business Process Improvement effort with the
Purchasing Division. Identified many areas where improvement could be
obtained. Implemented many of those changes on the spot and are moving
forward with making more changes District wide.
• Worked with East Bay Municipal Utility District (EBMUD) to acquire
customer billing information earlier to improve the process for Central San's
billing process for commercial customers.
• Created a master Standard Operating Procedure (SOP) template within
Laserfiche for use by all departments, and assisted with training on how to
use these templates.
• Updated Central San website to comply with SB272 rules that require to the
posting of current system information online.
Business Support
• Installed and configured various instruments in the Environmental
Laboratory.
• Took over first-line support for CAD systems and implemented a contract
for supplemental support through Cad Masters contract.
• Implemented emergency paging system over the Avaya telephone system.
• Completed IT portion of the Maze financial audit.
4
Security
• Configured all computers to auto-lock their screens to reduce chance of
computers being used for malicious purposes.
• Secured sensitive employee information.
• Explored two-factor authentication software to improve security beyond
simple passwords. Evaluation is continuing.
• Re-implemented backups at CSO.
• Became a member of and participated in Multi-State Information Sharing
and Analysis Center (MS-ISAc) Security Association. Receive regular
security alerts and notifications.
• Installed Cisco firewall patches to secure network equipment.
• Blocked a serious ransomware attack in March before it caused damage.
• Implemented Barracuda SPAM filter that blocked over 2,700 viruses that
attempted to enter the organization via email during the year.
• Updated the IT Recovery Plan.
• Conducted two external IT security audits and used the results to build a
remediation plan which is underway now.
• Implemented new IT security procedure and provided (and continue to
provide) training on the procedure District-wide.
• Cleaned up network access permissions in Active Directory, removed old
users who are no longer with the District, and improved the methods for
keeping permissions current.
• Installed and activated new network monitoring tools to alert IT staff of any
suspicious activity and enable it to respond proactively before damage is
done.
• Installed new cyber security and anti-malware software console.
5
Regular Business
• Closed 2,119 help desk tickets.
• Set up new desktop computers for 25 employees.
• Performed adds, moves and changes for telephone lines as staff were
added, moved or left the organization.
• Set up training facilities on a regular basis for various functions.
• Maintained the network with zero widespread unplanned outages and better
than 99.9% uptime overall.
• Maintained email system with zero unplanned outages District-wide.
• Improved help desk internal processes to help IT staff respond more quickly
to requests.
• Assessed needs for CAD machines and reduced costs by purchasing
faster, lower-cost workstations.
Staffing
• Hired a new System Administrator.
• Hired two new IT Technicians.
6