HomeMy WebLinkAboutSeptember 12, 2016
Executive Committee Agenda
September 12, 2016
Council Chambers
2:00 pm
Chair: Councillor Pickles
For information related to accessibility requirements please contact: Linda Roberts
905.420.4660 extension 2928
lroberts@pickering.ca
Anything highlighted denotes an attachment or link. By clicking
the links on the agenda page, you can jump directly to that
section of the agenda. To manoeuver back to the agenda page use the Ctrl + Home keys simultaneously, or use the “bookmark”
icon to the left of your screen to navigate from one report to the
next.
--C.~o~-
PJ( ER1NG
Executive Committee
Meeting Agenda
September 12, 2016
Council Chambers
2:00pm
Chair: Councillor Pickles
(I) Disclosure of Interest
. (II) Delegations
1. Jennifer O'Connell
MP Pickering-Uxbridge
Re: Update from House of Commons
2. Mustafa Munawar
. Re: Parking Concerns in the Duffin Height Community
(Ill) Matters for Consideration
1. Director, Corporate Services & City Solicitor, Report IT 01-16
Information Technology Strategic Plan, Broadband and Intelligent
Community Initiatives
Recommendation
1-52
1. That this Report and the Technology Review and Roadmap (Attachment
1 ) prepared by Prior & Prior Associates Ltd. and dated January 11 , 2016
be ~eceived;
2. That the Technology Review and Roadmap be endorsed, provided that
funding requirements, if any, be subject to the budget approval process;
3. That Council recognize the importance offast, reliable and affordable
high-speed internet access for all residents and businesses within the City
of Pickering;
4. That Council endorse the "Dig Once" Standard, providing for the inclusion
of conduit to accommodate fiber optic (internet) cable in the standard
design specification for all future City road construction projects;
For information related to accessibility requirements please ·contact:
Linda Roberts
905.420.4660 extension 2928
lroberts@pickering .ca
-C~o~-
PJCKER1NG
Executive Committee
Meeting Agenda
September 12, 2016
Council Chambers
2:00pm
Chair: Councillor Pickles
5. That Council direct appropriate City staff to communicate and collaborate
with their counterparts at the Region of Durham and at the other lower tier
Durham municipalities, to encourage the other municipalities within
Durham Region to adopt policies similar to the City's Dig Once Standard,
so that the infrastructure necessary to accommodate a Region-wide
broadband system can be built over time;
6. That staff within the City's Information Technology Section be directed to
continue their efforts to have the City recognized as an Intelligent
Community by the Intelligent Community Forum;
7. That copies of this Report be forwarded to The Regional Municipality of
Durham and area municipalities;
8. That the appropriate officials of the City of Pickering be authorized to take
the necessary actions as indicated in this Report.
2: Director, Corporate Services & City Solicitor, Report CLK 04-16 53-65
City Policy ADM 160, Customer Service Policy
3.
-Bill 8, Public Section and MPP Accountability and Transparency Act, 2014
Recommendation
That Council approve revised City Policy ADM 160, Customer Services Policy
(Attachment 1 ).
Director, Corporate Services & City Solicitor, Report CLK 05-16
2017 Committee and Council Meeting Schedule
Recommendation
1. That the 2017 Standing Committee and Council Meeting Schedule
included as Attachment 1 to this report, be approved; and
66-69
2. That the draft by-law to amend Procedural By-law 7212/12, providing for
revised meeting dates, as noted in Attachment 2, be approved.
--C4Jof--
PJCKER1NG
Executive Committee
Meeting Agenda
September 12, 2016
Council Chambers
2:00pm
Chair: Councillor Pickles
2. That the appropriate officials of the City of Pickering be authorized to take
the necessary actions as indicated in this report.
(IV} Other Business
(V} Adjournment
~~Cd~o~~~
PlC ERlNG
From: Paul Bigioni
Director, Corporate Services & City Solicitor
Report to
Executive Committee
Report Number: IT 01-16
Date: September 12,2016
Subject: Information Technology Strategic Plan, Broadband and Intelligent
Community Initiatives
File: A-3700-002-13
Recommendation:
1. That this Report and the Technology Review and Roadmap (Attachment 1) prepared by
Prior & Prior Associates Ltd. and dated January 11, 2016 be received.
2. That the Technology Review and Road map be endorsed, provided that funding
requirements, if any, be subjeCt to the budget approval process.
3. That Council recognize the importance of fast, reliable and affordable high-speed internet
access for all residents and businesses within the City of Pickering.
4. That Council endorse the "Dig Once" Standard, providing for the inclusion of conduit to
accommodate fiber optic (internet) cable in the standard design specification for all future
City road construction projects.
5. That Council direct appropriate City staff to communicate and collaborate with their
counterparts at the Region of Durham and at the other lower tier Durham municipalities, to
encourage the other municipalities within Durham Region to adopt policies similar to the
City's Dig Once Standard, so that the infrastructure necessary to accommodate a Region-
wide broadband system can be built over time.
6. That staff-within the City's Information Technology Section be directed to continue their
efforts to have the City recognized as an Intelligent Community by the Intelligent Community
Forum.
7. That copies of this Report be forwarded to The Regional Municipality of Durham and area
municipalities.
8. That the appropriate officials of the City of Pickering be authorized to take the necessary
actions as indicated in this Report.
Executive Summary: Attachment 1 to this Report is the Technology Review and Roadmap
prepared by Prior & Prior Associates Ltd. and dated Jamrary 11, 2016 (the "IT Roadmap"). The IT
Roadmap is a multi-year strategic plan which represents the City's first comprehensive review of
the role of information technology in the City's administration. The IT Roadmap identifies the need
for (i) adequate staffing to meet service demands, (ii) governance of IT decision-making to ensure
1
2
IT01-16
Subject: IT Strategic Plan Information Report
September 12, 2016
Page 2
that the needs of the City as a whole are met by every IT project and (iii) upgrades and
improvements to existing IT infrastructure and business systems.
The importance of high speed internet (broadband) service is now widely recognized, and is
crucially important for the City's ongoing economic development. By adopting the "Dig Once"
Standard, the City will take a modest first step toward building the broadband infrastructure
necess~ry to serve the growing demand for broadband from residents and businesses.
Recognition of Pickering as an Intelligent Community will demonstrate the City's commitment to
maximizing the use of technology to enhance the lives and opportunities of its residents. Intelligent
Community status will assist the City in its ongoing economic development activities.
Financial Implications: There are no financial implications arising directly from this Report, as
any budget allocation required further to any of the Recommendations will be subject to future
Council approval.
That being said, it is essential for the economic development of the City of Pickering that high-
speed Internet access be more widely available to residents and businesses. Furthermore,
recognition of the City of Pickering as an Intelligent Community will serve to elevate Pickering's
profile and further increase economic development opportunities.
Discussion:
The IT Roadmap
The City of Pickering is on the cusp of major expansion. The development of Seaton will bring
significant growth and change to the City. Combined with planned intensification of development
within the City center, as well as proposals for a major tourist and entertainment complex and the
possible Federal airport, this new growth will demand that we use technology to continue the
City's ongoing transformation from a bedroom community to a thriving urban center. A corporate
culture that embraces the strategic role of technology will give the City a competitive advantage.
Strong and innovative IT solutions will improve City services, support growth and development in
a sustainable way, spur investment from global players, and enable more open, transparent and
responsive government.
The IT Road map (Attachment 1) is a multi-year strategic plan which represents the City's first
comprehensive review of the role of information technology in the administration of the City and
the delivery of its services. The IT Roadmap represents an opportunity to rethink the use of
technology at the City and to assess what changes are required to ensure that the City and its
residents obtain the maximum possible benefit from technology-enabled services. City staff must
work within the financial constraints imposed upon the City, but short-term cost sensitivity should
not deter the City from considering strategic investments that will enhance efficiencies and save
money over the long term.
CORP0227-07/01 revised
IT 01-16
Subject: IT Strategic Plan Information Report
September 12, 2016
Page 3
The IT Road map identifies a number of key issues which are summarized below:
1. The IT Section is understaffed and challenged to meet current demands.
The City of Pickering IT division is underfunded and understaffed as compared with similar
municipalities, according to a municipal benchmarking study completed by Prior & Prior and
research conducted by Deloitte (Appendix "B" of the IT Road map). In order to meet the demands
of a growing municipality, it is important to realize efficiencies and position staff for success
through investment in technology today. The City of Pickering's IT Section has managed to stay
the course over the last 15 years with a net zero increase in resources, however the ability to meet
current, let alone future needs may be unsuccessful without immediate improvements. Many
important business systems, including our financial application and telecommunications
infrastructure, require attention ranging from upgrades to complete replacement. This upgrading
will place additional demands on the City's existing IT staff complement. The current inability to
meet staff technology needs, from both a support and a strategic perspective, is a barrier to the
City being able to realize its full potential.
2. IT Infrastructure requires attention.
Many technology infrastructure components currently supporting the business operations of the
City of Pickering are 8 to 10 years old. During an investigation of the City's Network and Security
Infrastructure performed in 2015, staff found that the City was about 3 years behind on security
related updates. Critical security flaws in the City's network infrastructure were found and fixed,
but IT staff require training and additional IT processes and procedures must be put in place.
3. Major business systems require attention ranging from upgrades to complete replacement.
The City is in dire need of a new financial system. With additional investment, many existing
systems such as the planning and permitting system (Amanda) could provide significant increases
in efficiency and automation, resulting in improved service levels and increased ability to manage
a higher volume of planning and permit transactions. Without investment in new applications and
the associated IT staff necessary to design and administer them, the City will increasingly run the
risk of system failure and may miss out on opportunities to leverage technology to keep current
with residents' expectations for service delivery and community engagement. ·
4. Corporate oversight on technology projects.
"IT governance" is the process for direction, management and monitoring of how the City makes
use of technology. More than a single committee, IT governance consists of all the various staff
teams that are involved in IT decision making. Council is of course involved in IT governance, to
the extent of authorizing major projects and approving any necessary budget allocations. The goal
of IT governance is to ensure that the right people are making the right technology decisions at
the right time and for the right reasons.
Until now, decisions regarding the prioritization of technology projects have been left to the IT
Manager. These decisions may have far reaching consequences for the operation of the City as a
CORP0227-07/01 revised
3
4
IT 01-16
Subject: IT Strategic Plan Information Report
September 12, 2016
Page 4
whole. For this reason, staff (with the support of the GAO) have formed an IT Steering Committee
to provide advice regarding the prioritization and initiation of new technology projects. Drawing
staff from all Departments, the IT Steering Committee will ensure that technology decisions are
made with the best interests of the entire corporation in mind.
5. Following the IT Roadmap.
Implementing the IT Roadmap is subject to Council's budget approval process. To date, the IT
Section has taken on one new staff member to increase its capacity to deliver basic technical
support on a daily basis. An additional staff position has been added in the approved 2016 budget.
These changes will increase the ability of the IT Section to meet the growing demand for its
services. The creation of the IT Steering Committee will provide a coherent framework for IT
governance. These changes recommended by the IT Road map are already improving the
effectiveness of the City's IT Section.
Broadband Service in Pickering
Technology enhancements are necessary to enable the success of the City's businesses and
residents-now and in the future. Access to high speed internet service (broadband) is becoming
essential for health care, education, employment, social and political inclusion and overall
economic success. With the opening of a Microsoft data center inside Canada, the use of cloud
computing will only increase, and the need for broadband will increase along with it.
Some of the benefits of accessible and reasonably affordable fibre optic connection to the internet
are:
1. It provides businesses, public organizations, residents, and farmers equitable access to
marketplaces, healthcare, education and government services, putting Pickering on a
competitive footing with some of the best connected communities in Canada and around
the world;
2. Federal and Provincial funding is available to subsidize the cost of building fibre optic
infrastructure, with most of the remaining funds coming from telecom service providers;
3. It will provide residents and businesses in Pickering with more competitive choices, leading
to better services and lower prices -a platform for future economic prosperity and social
equality; and
4. It will reduce operational costs that the City currently pays to ISP's for network
connectivity. These costs will continue to grow as the need for connectivity increases and
broadband access becomes critical for both administration and service delivery.
Increasingly, high-speed Internet service is looked upon as a necessity. In the USA, the Federal
Communications Commission and many cities now regard broadband as a new public utility -a
service to be delivered like water pipes and highways. Robust and widely accessible broadband
infrastructure is needed for Pickering to become recognized as a prime location for new
CORP0227-07/01 revised
IT 01-16
Subject: IT Strategic Plan Information Report
September 12, 2016
Page 5
businesses to operate. Broadband will help attract new investment to the City. Following the
example of many American jurisdictions, City staff have introduced the "Dig Once" Standard for
future City road construction. "Dig Once" simply means that the standard design specification for
future city road construction projects includes an additional conduit to accommodate future
broadband requirements. The conduitwill then be in place to accommodate fibre optic cable as
and when the City wants to have it installed.
Corporate Services staff have worked together with staff in Engineering & Public Works in order to
implement "Dig Once". Over time, as road construction proceeds, "Dig Once" will ensure that
broadband service can be accommodated with only a tiny incremental increase to the cost of
future road construction projects. "Dig Once" is a modest but necessary step towards the
construction of broadband infrastructure throughout the City.
In an effort to expand broadband service throughout the Region of Durham, the City's Information
Technology and Economic Development staff currently participate in a Regional Broadband
Working Group consisting of staff from the Region, Veridian, Whitby and the Whitby Chamber of
Commerce. City staff strongly recommend the adoption by all municipalities within Durham Region
of policies similar to "Dig Once". The construction of broadband infrastructure on a region-wide
basis will increase opportunities within Pickering and throughout the Region to provide broadband
access in areas which are currently underserviced.
Intelligent Community
The Intelligent Community Forum ("ICF") is a global network of cities and regions with a think tank
at its center. Its mission is to help communities use information and communications technology
to create inclusive prosperity, to tackle social and governance challenges and to enrich quality of
life. The ICF formally recognizes eligible municipalities as "Intelligent Communities" on the basis of
criteria including broadband availability, knowledge level of workforce, digital equality and
innovation.
The main purpose for seeking recognition as an Intelligent Community is to attract innovative and
tech-oriented businesses to Pickering. Intelligent Community status signals that Pickering is a City
that strives to enhance the quality and efficiency of municipal services, and to reduce costs and
resource consumption. Achieving these objectives will enhance opportunities for the City's
residents and businesses.
IT staff have already begun the task of having Pickering recognized as an Intelligent Community.
No specific budget allocation has been required for this purpose.
CORP0227-07/01 revised
5
City of Pickering Technology Review and Roadmap
Table of Contents
Table of Contents ....................................................................................................... 2
Executive Summary .................................................................................................... 4
1. Introduction & Background ..................................................................................... 8
1.1 The Importance of Technology for Municipalities .............................................................................. 8
1.2 The Importance of the IT Roadmap .......................................................................................................... 8
1.3 Developing this Roadmap .............................................................................................................................. 8
2. The Current State .... ~ ............................................................................................... 9
2.1 Technology Environment Assessment ..................................................................................................... 9
2.1.1 Infrastructure Layer Recommendations .......................................................................................... 11
2.1.2 Major Business Systems Layer Recommendations ...................................................................... 12
2.1.3 Integration Layer Recommendations ................................................................................................ 12
2.1.3.1 GIS Environment ..................................................................................................................................... 13
2.1.4 Customer Facing Layer ............................................................................................................................ 13
2.2 Technology Management Practices Assessment .............................................................................. 14
2.2.1 Technology Management Practices Recommendations ............................................................. 14
2.3 Survey Results ................................................................................................................................................. 14
2.3.1 Respondents ............................................................................................................. : ................................... 14
2.3.2 Technology Overview ............................................................................................................................... 15
2.3.2.1 Technology Overview Recommendations .................................................................................... 15
2.3.3 Business Applications ............................................................................................................................... 15
2.3.3.1 Business Applications Recommendations ................................................................................... 16
2.3.4 IT Department ............................................................................................................................................. 17
2.3.4.1 IT Department Recommendations .................................................................................................. 17
2.3.5 After Hours Support .................................................................................................................................. 18
2.3.5.1 After Hours Support Recommendations ....................................................................................... 18
2.3.6 Access to Systems ....................................................................................................................................... 18
2.3. 7 Training .......................................................................................................................................................... 18
2.3.7.1 Training Recommendations ............................................................................................................... 19
3. Municipal Comparisons .................................. ~; ..................................................... 19
4. Emerging Trends ....................................................... · ........................................... 19
4.1 New Pressures ................................................................................................................................................. 19
5. IT Decision Making: IT Governance ........................................................................ 20
5.1 What is IT governance? ............................................................................................................................... 20
5.2 IT Department ................................................................................................................................................. 21
5.3 IT Policies and Standards ........................................................... · ................................................................ 21
6. !T Organization ..................................................................................................... 25
6.1 Current IT Organization Structure .......................................................................................................... 25
6.2 Future Goals for the IT Team .................................................................................................................... 25
6.3 Proposed IT Organization Structure ......... ~ ............................................................................................ 26
6.4 Opportunities for Partnership .................................................................................................................. 29
6.5 IT Service Delivery-the Help Desk ......................................................................................................... 29
Prior & Prior Associates page2
8
City of Pickering Technology Review and Roadmap
6.6 Adopt a Hybrid Delivery Model.. .............................................................................................................. 29
6. 7 Resource Technology Projects Appropriately ................................................................................... 30
6.8 Building Trust .................................................................................................................................................. 31
1. Conclusions and Major Recommendations ............................................................ 31
Appendix A-G.I.S. Review ....................................................................................... 33
Appendix B-Benchmarking Study ............................................................................ 36
Appendix C-Current Project Ust, and Work Plan ..................................................... 38
Appendix D -Architecture ............................................................... : ........................ 45
Prior & Prior Associates page 3
9
10
City of Pickering Technology Review and Roadmap
Executive Summary
Introduction
This Corporate Technology Multi-Year Plan is the first technology review that the City has
undertaken and the first technology plan that the City has developed. It is an opportunity tore-
think the way technology is perceived at the City and assess what changes are required tore-
position both the IT department and technology enabling services at the City. Enhanced
Technology services align with all five corporate priorities and in the near term will enhance our
ability to realize better opportunities for community engagement and corporate best practices.
The City of Pickering is poised on the precipice of significant growth and expansion. Development
in Seaton alone is noteworthy and combined with concurrent initiatives including Downtown.
Intensification, the Durham Live Entertainment Complex and an International Airport, our ability
to transform from a sleepy bedroom community into a hub for sustainability, innovation,
technology, culture and commerce will be tested.
A corporate culture that embraces the strategic role technology can play has a competitive
advantage. Strong and innovative IT solutions will improve City services, support growth and
development in a sustainable way, spur investment from global players, and lead to more open
and transparent government systems. A technologically advanced city will attract a higher caliber
talent pool to Pickering needed for ICT and a Broadband Infrastructure plan should be developed
in order to attract Information and Communication Technology (ICT) companies and advanced
manufacturing employers.
In order the meet the demands of a rapidly growing municipality, it is important to realize
efficiencies and position staff for success through investment in technology platform today. The
last 25 years has seen an insurgence in technology innovation and many organizations have
attained competitive advantage and realized success while others who failed to innovate, no
longer exist. The City of Pickering's IT department has managed to stay the course over the last
15 years with zero increase in resources, however the ability to meet current, let alone future
business and technological needs may be unsuccessful without immediate improvements.
Municipalities operate on tax dollars. As a result, often times we are too focused on short term,
cost sensitive items, rather than strategic investments that will enhance efficiencies and save
money in the long run.
Prior & Prior Associates page4
City of Pickering Technology Review and Roadmap
The Opportunity
While many organizations are reaping the benefits of technology as a competitive advantage,
Information technology as a platform and an enabling mechanism at the City has yet to appreciate
its full potential and operational efficiencies have not been realized. Municipalities large and small
face daunting challenges as they continue to deliver the same or enhanced services with fewer
resources and tax dollars.
In response to this challenge, the Corporate Technology Review and Road map sets out tactical
directions and frameworks to position the City of Pickering to be an organization that is SMART
(Sustainable, Modern, Agile, Resilient and Technology enabled).
Smart City ecosystems enhance quality and performance, reducing costs and consumption while
better engaging residents, businesses and key stakeholders. Enhanced technology can aid in real-
time decision making, helping senior staff make informed and timely decisions.
The goal is to increase the efficiency of municipal services to residents and businesses. Technology is
centra! to the City's success and building a City that does business differently, more efficiently, a City
that looks at all opportunities to work smarter is a central concept of the IT Road map.
An independent assessment of the City's IT landscape and its technology management approach
confirms that the City needs to address challenges in IT Service delivery and governance as staff and
resident's expectations for online services and solutions continue to increase. The more traditional
methods of service delivery are no longer acceptable and certainly not in a community that will grow
and transform quickly in the very near future.
There are several risks and gaps that have been identified that should be addressed, specifically:
• The IT Organization is understaffed and challenged to meet current demands.
• The infrastructure has some solid components but there are significant gaps such as with
remote facility connectivity, a lack of a test environment and limitations to the security and
disaster recovery capacity.
• The major business systems all require attention ranging from upgrades to complete
replacement. An overhaul of the project methodology is required in order to move forward
efficiently and effectively.
· • The customer facing layer of technology has identified several opportunities to improve the
customer experience from enabling online payments and other online service offerings.
• A lack of corporate oversight on technology projects including decision making and priority
setting.
In order to meet the demands and expectations that technology can deliver, the City will have to
invest in IT, both resources and products. New technologies are emerging every day that can have
great impact on municipal operations. The City should be prepared to take advantage of
Prior & Prior Associates page 5
11
12
City of Pickering Techno!ogy Review and Roadmap
opportunities as they are presented in order to implement the solutions that deliver the best value
for this community.
Reflecting the growing importance of technology, the road map recommends changes to the
governance of IT to help ensure that the City can execute effectively. Specific recommendations
include:
• Establishing a corporate Information Technology Steering Committee to oversee information
management and technology decision making and priorities
• Establishing a project intake and prioritization process for all technology projects
• Maintaining an approved IT project list
• Revising corporate IT policies.
The strategy also recommends changes to the IT Team to support the sustainability of the technology
environment and the delivery of the projects, including:
• Reorganizing the IT team into 3 discrete sections to better service current and future needs of
the organization.
• Grow the IT team-according to a municipal benchmarking study completed by Prior & Prior
and research conducted by Deloitte, the City's IT department is significantly understaffed to
meet the current requirements never mind the future requirements expressed by the business
departments or through the surveys. The following positions are recommended:
• Short term:
o Hire the Network Analyst position (currently approved)
o Hire a new Database Administrator/Analyst
o Hire a new Supervisor of Client Services
• Hiring new resources as soon as possible will transition the IT Manager from day-to-day
operational responsibilities in order to focus on more strategic activities.
• Progressively adding several new IT positions over the next 5 years to support the growing
business demands for new technology solutions:
• Medium term:
o Business Analyst/Project Manager
o Web and Digital services coordinator
o Application Administrator
• Longer term:
o Business Analyst/Project Manager (2nd position)
o Application Administrator (2nd position)
o Web Analyst/Developer
• Since IT is key to 24/7 business operations for several departments, there needs to be formal
support for IT outside of 'normal' office hours established.
Prior & Prior Associates page6
City of Pickering Technology Review and Roadmap
In response to the issues, the road map outlines a plan that addresses, as a priority, the current gaps
in infrastructure and business systems areas; these include initiatives pertaining to:
o Improving remote network access and Wi-Fi at all municipal facilities,
o Establish a test environment
o Enhance desktop/laptop device management
o Implement mobile device management strategy and tools
o Develop robust policies and operating procedures
o Modern collaboration tools (instant messaging, video conferencing)
o Preparing the City to address security, redundancy and other business continuity threats
Implementing and/or expanding major business systems that can be used to automate business
processes, such as:
o Develop an application inventory and lifecycle standard for all business systems.
o Develop in-house application support expertise to ensure products are implemented
that meets the business requirements and overall data strategy.
o Conduct a review or analysis of the Planning, building and permitting solution,
(AMANDA).
o Recreation management solution upgrade, review and upgrade or replacement.
o Review the Financial system (Vailtech) for upgrade or replacement.
o Corporate Enterprise Document Management solution review (LaserFiche).
o Continued growth of the GIS system.
o Develop a training/learning strategy for all technology users.
The customer facing services requires an expansion of the City's website to focus on offering online
services, service request submission and tracking online, moving bill and invoice payments online and
handling permits and licenses online.
It is clear that continued investments in, and development of, technology capabilities are required for
the City to meet Council, customer and management expectations. This road map identifies
appropriate initiatives and activities that must be undertaken to leverage technology effectively to
meet these demands. Initiatives and recommendations identified in the road map will be brought
forward as appropriate through the annual budget and capital planning process.
Prior & Prior Associates page 7
13
14
City of Pickering Technology Review and Roadmap
1. Introduction & Background
1.1 The Importance of Technology for Municipalities
Today, all businesses rely on technology. Whether a firm is in the business of selling products, delivering
packages, or providing health care-people, process, and technology need to work together for those services to
be delivered effectively.
Municipalities are no different. Technology is increasingly central to the City's ability to deliver services. Services
as diverse as collecting taxes, dispatching fire trucks, planning a sub-division, communicating and engaging the
community, checking out library books, and managing recreation program registration all rely on technology to
operate effectively and safely.
While email and smartphones keep every part of the organization connected and communicating, it is the back
office systems that allow managers and staff to track permit and planning applications, to manage customer
requests, or monitor budgets. These are the tools that will enable the City to maximize its operational efficiency.
Looking to the future, technology will continue to grow in importance. More customers will expect to use their
computers and smartphones to make an inquiry, report a problem or submit an application. Increasingly sensors
will be used to monitor critical infrastructure throughout the City and notify staff where problems are
anticipated, or have occurred. City's need to invest in infrastructure to attract/retain business investment, and
meet the diverse needs of a growing population.
1.2 The Importance of the IT Road map
Given the importance of technology and its role in delivering City services, and particularly given the many
competing demands ofthe municipal setting, an IT roadmap is very important. It addresses questions that are
fundamental to the City's future success: ·
• Are we doing the right things with technology?
• Are we making the right technology decisions?
• Is our Information Technology environment properly managed, maintained, secured, and able to
support our clients?
• Is it cost effective?
• What are our future community and organizational needs?
• Is our technology environment equipped to m~et current and future business requirements?
• Are we using technology innovatively to optimize operations, and proactively respond to the future?
Crucially it allows the City to determine the strategic priorities, and set out the key initiatives and activities that
will be critical to supporting the City's business goals a·nd objectives.
1.3 Developing this Roadmap
The City engaged Prior & Prior Associates to collaboratively develop this road map in the summer of 2015. Prior
& Prior worked with the IT Manager and the IT team to understand the current environment and issues they
were facing. We also surveyed all departments and staff to conduct a current state assessment of the City's use
and management of technology, and to identify future corporate and departmental technology needs. The
consultants worked with the IT Manager to identify priorities and directions, develop the organizational plan,
and to develop this document-the Technology Review and Roadmap.
Prior & Prior Associates page 8
City of Pickering Technology Review and Roadmap
2. The Current State
In developing this road map, Prior & Prior Associates conducted a current state assessment of the City's
Information Technology landscape. The consulting team looked at the current Technology environment, the
City's existing IT Management practices and considered the range of future pressures that the City faces. This
assessment is summarized over the next few pages, and is the basis for the Roadmap.
The City's current approach to technology is delivering far less than optimal results. The IT Department (and
technology) has been viewed as a cost center, a support organization, not an engine of innovation, growth and
service delivery improvement. The IT Department operates at a basic level-focusing on the basic sustainment
of software systems -keeping the computers running. IT staff are fully utilized supporting what is currently in
operation, not working on strategic initiatives that can simplify customer interactions with the City or streamline
and automate administrative tasks.
Although many major systems have been implemented by the City (most over a decade ago), many of the basic
capabilities needed to run the City are not working well. Because of this, managers and staff spend an
inordinate amount of time on administrative processes and tasks that remain largely manual despite
opportunities for automation. Excel spreadsheets and word documents are used to manage critical business
processes because the systems cannot do the job. Staff cannot quickly access or assemble critical information to
carry out their day-to-day tasks. Consequently, Coordinators, Supervisors, Managers, and Directors may
operate without the necessary intelligence to effectively manage their operations, increasing the risk of
producing inaccurate or incomplete information. These major gaps must be addressed.
Currently, the IT Department manages and supports over 500 staff in 17 locations throughout Pickering
consisting of over 465 desktops, laptops and mobile devices supported by 60 Physical and Virtual Servers and 13
business applications and 6 databases. IT staff do a good job of maintaining the existing systems considering
the number of resources available however many of the applications are outdated. IT does not have the time
to maintain the current technology portfolio let alone investigate new opportunities for technological
applications within the City.
Technology Trends and Areas of focus for City IT in the next few years should be:
• Security, Disaster Recovery and Business Continuity Planning
• Internet of Things-Smart Grid I Smart City/ Interconnected Systems
'" System Integration and IT Automation Process Improvements
" Big Data I Business Intelligence, Data Analytics and Open Government
· • Customer Relationship Management System
'" Online Services, e-commerce, online payments
11 City Mobile Strategy, Mobile Device Management
• Asset Management
11 City Financial System Replacement
2.1 Technology Environment Assessment
Prior & Prior's standardized municipal technology architecture shown in Figure 1 below was the basis for
evaluating the City's technology environment.1
1 The architecture presented here will be used as a future state architecture for the City, which will guide future technology
decision-making.
Prior & Prior .A.ssociates page 9
15
18
City of Pickering Technology Review and Roadmap
• The City should develop a backup strategy that consolidates their backup solution; addresses de-
duplication of data, and ensure processes are documented including the testing of backup/recovery
procedures. This would result in a decrease in storage and support costs and ensure continuity in case of
system failure.
• Significant work is also needed in the areas 6f security and disaster recovery I business continuity to
ensure that the City is appropriately secured and business continuity ready. Currently the firewalls are
managed externally, although there is value to have external support where necessary to augment the
expertise and resourcing of internal staff, there was some indication that the responsiveness of services
has been problematic. Additionally, the current location of the DR data center is in the Recreation
Building which is not suitable due to the close proximity to the main site.
• The City is currently utilizing Citrixtechnology which provides remote access to applications and internal
application delivery. Although Citrix provides the required functionality to users, it is not currently
deployed tb all staff, and does not address issues around application management for systems that
cannot operate in the Citrix environment. IT will actively monitor the enviro11ment, and further
implement changes the Citrix and Physical Desktop environment as the technology evolves.
• The City is currently on Exchange 2010 and has internal expertise to manage the email environment.
However, for the size of the IT department there is value in evaluating Microsoft 365 as a solution that
will potentially decrease IT costs, provide additional redundancy in functionality, and lends itself well
within the disaster recovery strategy.
2.1.2 Major Business Systems Layer Recommendations
Continuing upwards through the architecture, the Major Business Systems layer highlights areas of work with
respect to the major business systems-the key corporate systems that the municipality requires.
Specifically, the City needs to determine direction and implement solutions across a range of areas including but
not limited to:
• Planning, building and permitting solution review, and upgrade (AMANDA}
• Recreation management solution upgrade, review and replacement (Class)
• Financial system review and upgrade (Vailtech)
• Document Records Management-Corporate Enterprise Content Management (ECM} solution
implementation (LaserFiche}
A detailed assessment of business applications with business users is required to accurately determine the
level of work needed on major business systems. This work was outside of the scope of this engagement.
In order to effectively manage Major Business systems, the IT department will need to adapt new skills
(Project Management, Business Analysis, Software Application expertise} as well as continue to establish
and maintain the infrastructure foundation.
The City will also need to adopt a corporate approach to technology architecture decision making (IT
Governance). These recommendations require a reorientation of the IT team (new skills and staff) and
corporate attention to these expanded corporate needs.
2.1.3 Integration Layer Recommendations
The Integration layer also features a number of opportunities, including corporate reporting capabilities and
expanded systems integration to eliminate errors and staff time wasted on duplicate data entry. There is also a
Prior & Prior Associates page 12
City of Pickering Technology Review and Roadmap
gap in the ability to discover I search unstructured content and image management (files, documents, images,
etc.L requiring further development of the Intranet as a corporate collaboration environment. The Integration
Layer can only be addressed once the City has come to an agreement on the major business systems to focus on,
as much of the functionality in the Integration Layer is dependent on those decisions.
2.1.3.1 GIS Environment
A detailed assessment of the GIS environment and requirements is recommended. Currently the City has
invested in an industry leader GIS system (ESRIL however, the system is managed primarily out of the Planning
department, with limited access to other users, or integration with other systems. The GIS environment should
be managed in the same way as any other system, in particular systems used by the enterprise. Technical
implementation such as project management, business needs analysis, database management and software
development should be provided by the corporate IT department with some services such as data management,
requirements definition and implementation testing and assistance provided by the user departments. A
preliminary review included a current state assessment, an identification of immediate issues and initial
recommendations are included in Appendix A. A detailed review, such as a GIS Strategic Plan will further
identify user requirements, establish data standards and system governance principles, and design the
technology architecture required for the city to fully utilize the product and enhance services delivered to
employees and citizens.
2.1.4 Customer Facing Layer
Assessment of the Customer Facing layer identifies that the City has established a foundation with the website
and the introduction of some e-Services. Currently, the website is managed within the Communications
department which causes some coordination and resourcing issues for IT. Some user feedback also suggested
that the tool providing the service was not easy to use. Opportunities exist to offer many new services online-
although in some cases these projects will be dependent on first implementing the right business systems.
Additionally, a majority of citizen based traffic is mobile in nature, and the City should invest in building a
responsive website to address this requirement. Key opportunities include:
• Service request submission and tracking
• Billing and online payments (e-commerce)
• Permitting and licensing online
• Online registration and bookings
• Online forms
Overall, the assessment points to a need for the City to direct immediate attention to finishing the remaining
work on the corporate infrastructure layer, next the focus should shift toward the business system layers of the
architecture. This means:
•
..
Ensuring the infrastructure is sustainable by building out the corporate network, implementing effective
security and DR provisions and appropriately staffing the infrastructure function
Turning attention to the corporate business systems area, re-organizing the IT team, and establishing
the business systems that will drive the City's business processes and improve the City's operational
effectiveness.
Thereafter, in the medium-term (two to three yearsL attention can move to the top 2 layers-integration and
customer facing, where significant value and improvements in customer service can be gained.
Appendix D provides a more detailed explanation of the Enterprise Architecture.
Prior & Prior Associates page 13
1 9
20
City of Pickering Technology Review and Roadmap
2.2 Technology Management Practices Assessment
In reviewing the City's technology management approach, a number of positive aspects were noted, including:
• Strong leadership from the new IT Manager
• The IT team is well liked, respected and appreciated
• The .IT team is customer oriented and works hard to resolve issues and deliver solutions.
• Many best of breed infrastructure technology solutions capable of scaling to meet the City's growth
have been implemented
A number of areas for improvement were also identified:
• There is a lack of formal Corporate IT governance. This means that IT decisions and priority setting occur
without Senior Management Team involvement, which can result in un-coordinated activities, missed
opportunities and missed expectations
• There are limited IT policies, procedures, practices and documentation
• Some internal partnerships between IT and departments are not effective due to IT not always being
consulted on initiatives involving significant IT requirements
• Improvements to the efficiency of the helpdesk service will be necessary to maintain high service levels
without disruption to operational and project activities of all IT team members
• The IT department can leverage their existing help desk tool to assist them in formalizing IT processes,
as well as enhance use(' self service capabilities
• There are opportunities to improve IT processes including change management, to ensure more
reliability of IT services, and to support traceability of problems
· • There are opportunities to allocate IT staff more effectively based on the city's priorities and
requirements, their skills and capabilities
• The City requires a formalized <:Jpproach to. providing after hours IT support
2.2.1 Technology Management Practices Recommendations
• Establish an IT Steering Committee to support corporate wide decision making on technology projects.
• Establishing IT helpdesk standards and expectations, including prioritization of incidents.
• Implement a formalized help desk, and optimize use of existing help desk system.
• Implement self servic~ capabilities (e.g. self service password resets and group membership management).
• Develop a formalized after hours IT service (staff on standby I call-out rotation).
• Establishing change management procedures, including a standardized IT maintenance window.
• Developing formalized agreements with arm's length organizations regarding IT serviCe levels.
Further details regarding Technology Management Practices can be found in Chapter 5.
2.3 Survey Results
An online survey was distributed to all employees, and an email survey provided to department managers and
supervisors. Overall, the survey results and comments are very much aligned with the consultant's team
infrastructure review, and IT department meetings. The following is a compilation of those results and
recommendations.
2.3.1 Respondents
• 25 departments responded to the online survey, 196 staff, 9 departments to the email survey
Prior & Prior Associates page 14
City of Pickering Technology Review and Roadmap
• 74% Employees, 21% Managers/Supervis~rs, 5% Directors
• Staff with a good distribution of service years, slight majority over 20 years of service
• Responses were primarily from Pickering Civic Complex
.. All Staff that responded have access to business technology
2.3.2 Technology Overview
In general staff is Neutral/Satisfied with their business technology. Overall, 75% of staff are satisfied with IT
Services at the City.
About 25% of respondents commented on:
" slow network performance, mobility
.. issues with their PC/Laptop,
" challenges with printing.
" access to accurate updated GIS information, and
" consistent access to projectors/equipment in meeting rooms.
.. technology (inconsistency as well as performance} was noted by employees outside of the Civic
Complex.
2.3.2.1 Technology Overview Recommendations
1. Create a consistent, stable and reliable network in all facilities for all employees.
2. Implement a network strategy to support the needs of a mobile workforce.
3. Implement an IT asset management program for all desktops/PCs, loaner laptops, mobile devices,
prqjectors, and meeting room equipment in all buildings. This program should query all departments to
confirm their user requirements annually. This program will provide all staff with equipment that is
reliable, and reduce workload on IT staff to support equipment that is outdated.
4. Equip meeting rooms with fixed projectors and computer equipment.
5. Evaluate telecommunication requirements and resource availability to provide effective functionality for
all users.
2.3.3 Business Applications
Generally, staff seemed to have neutral perceptions of the existing applications used by the City. This suggests
that staff may not be aware of the possibilities of technology, are unable to form a knowledgeable opinion and
have become accepting of the current software status. Additionally, since a number of employees have a high
number of years of service, it can also mean a hesitation to raise concerns due to the changes that may result in
the work environment.
A significant number of respondents were dissatisfied with Vailtech, OnPoint GIS, and AMANDA. Both On Point
and AMANDA are considered best of breed application in the municipal space which suggests dissatisfaction
may be related to a number of issues such as lack of in house expertise for timely user support, lack of
integration with other applications, awareness of users on functionality and business process improvement
opportunities, and/or maintenance/upgrade cycles that cause service disruptions.
Based on our discussions with IT staff, management of business applications (software evaluation, purchases
and ongoing maintenance, upgrade cycles) have been decentralized to departments. IT is invited into a
discussion very late during the procurement cycle, and is not able to proactively manage licensing, and update
Prior & Prior Associates page 15
21
22
City of Pickering Ted'morogy Review and Roadmap
cycles. IT should also have the opportunity to evaluate how the application can integrate into the environment
to ensure the City optimizes access to data, and reduces. duplicate information entry, or purchases.' IT can assist
the department by supporting an evaluation of business processes, and software functionality to ensure the
product is fully utilized, and other departments that may benefit included in the conversation and
implementation. Centralizing the business application budget will also give the organization insight into the
overall application spend, and begin the dialogue on return on investment, and impetus to fully utilize available
functionality.
A number of "other'' systems were identified by employees as problematic (see list below} that were not listed
by IT, this is likely as a result of decentralization, and individuals refer to systems with different names.
1. MES
2. CCTS (Customer Care Tracking System}
3. Supply Bidding
4. ADP ezlabour Manager
5. ADP Payroll
6. Guardall System
7. Past Perfect
8. Adobe
9. GTechna Parking Ticket Software
10. Vital Stats
11. Integrated Library System/Horizon
12. GPS/Webtech lnterfleet GPS Software
13. Crisys
14. ldenticam
15. Corporate Customer Care
16. Lizard GeoViewer
17. PAD AED
18. Late/ Absence /Early qeparture
19. Vacation/Lieu
20. RFID
21. Woordworks Structural Program
22. H&S Functional Abilities
2.3.3.1 Business Applications Recommendations
1. In conjunction with departments, develop a business application inventory and lifecycle standard that
outlines the core business applications used by the City, the primary business owner, business and IT
support protocols (e.g. data bas~;, version maintenance, upgrade cycles}, and funding requirements.
Annually, the IT department should review business requirements to determine new areas/problematic
areas/services that need to be considered to enhance citizen services or internal employee productivity.
2. Create a centralized business application budget that is funded by departments that primarily use the
application (primary business owner). IT should be the steward of this application budget to ensure
departments are funding the appropriate number of licenses, maintenance dollars, hardware, database
licensing/maintenance, and ongoing support. Final decisions on procurement still reside with the
Prior & Prior Associates page 16
City of Pickering Technology Review and Roaclmap
primary business owner, however, decisions to purchase will include appropriate dollars to handle the
ongoing software maintenance and support charges.
3. Develop in-house application support expertise with business analyst skills on major business systems to
support end users leverage technology, and formalize partnerships with external agencies with subject
matter expertise to ensure products are fully utilized and managed effectively.
2.3.4 IT Department
A majority of those surveyed are satisfied with timeliness of IT response, resolution, quality of response,
knowledge and the Help Desk. Individuals commented freely on the quality of the Help Desk, and helpfulness of
Staff. In general, comments around 24x7 coverage, vacation coverage, issues that not everyone can support
everything and general lack of resourcing were raised. Currently the IT department does not have a dedicated
help desk environment, rather, the help desk phone line is responded to by members of the Network Support
team. Centralizing the help desk with consistent staffing will provide a higher level of service to staff, provides a
consistent approach to dealing with issues, and creates an avenue to identify reoccurring problems that can be
prevented moving forward. A knowledge base can also be maintained to assist staff in solving problems quickly
and eventually lead to a self-service environment where end-users .can find answers to their problems
conveniently. IT staff also commented on the silo environment in which they generally function, and their
inability to support one another effectively.
2.3.4.1/T Department Recommendations
1. Focus is required to create a team environment within IT. Time should be spent developing a shared
vision, and updating IT's mission as related to the new services and processes IT will be embarking on as
required by the City.
2. Create a help desk environment with appropriate staffing to provide effective coverage during business
hours, provide staff training and proactively manage work orders. A focused help desk environment
would also enable staff to proactively work with the business to develop service level agreements based
on user requirements, provide an avenue to escalate issues, and ensure ongoing capture of IT metrics to
proactively improve IT services and prevent issues. IT currently uses Alloy Software to manage help desk
tickets. Alloy is based on ITIL principles which are considered industry best practice in managing IT
services. It includes service management, asset management and other enterprise IT tools that would
be valuable improving the overall effectiveness and functionality of IT.
3: Processes should be implemented to ensure all IT staff have the capacity to develop good
documentation. The City is at risk because individual IT staff members are solely responsible for
particular services which results in support issues when they are away. Although backup resources are
identified, staff commented on their discomfort on backfilling a service because they weren't aware of
any resources that could help them (e.g. documentation), or they didn't feel they were trained
sufficiently to support the issues. Time must be allocated to cross train resources, and create effective
documentation to ensure ongoing coverage and continuity of IT services to the City.
A more detailed overview regarding the IT Organization is included in Chapter 6.
Prior & Prior Associates page 17
23
24
C!ty of Pickering Technology Review and Roadmap
2.3.5 After Hours Support
17% of respondents indicated they have a need for after-hours support. Although the majority suggest it is not
a requirement, recognizing the City operates on a 24x7 basis, and the increasing dependence on technology, it is
necessary for IT to evaluate after hours support requirements.
2.3.5.1 After Hours Support Recommendations
1. Based on user requirements, IT should develop an afterhours support strategy that identifies additional
staffing to provide support, provide support outside of regular business hours balanced with redundant
systems, and spare equipment for areas whose service hours extend outside of the core business hours.
2.3.6 Access to Systems
In reviewing comments related to "Are there IT systems, technologies or tools that you don't have access to
that the City should have in place? Are there systems you think the City should implement?", and are there new
IT services that the IT team should provide, respondents recognize the need to leverage technology to provide
convenient online services to citizens, and enhance internal productivity. Comments related to:
• Customer data mining software
• integrating systems {e.g. AMANDA and GIS),
• providing mobile real-time solutions
• · leveraging the GIS
• training
• high performing wired and Wi-Fi network
• access to technology equipment in meeting rooms
• new infrastructure and asset management system
• Utilize/upgrade Amanda
• Upgrade Class
• Upgrade Vailtech
• Security systems
• LaserFiche licensing
• Phone system issues
• Image Management
• Audio Visual Management
• Online customer/citizen portals
• Employee self-service {online processing of leave requests, password resets)
• Access to City Development applications
• Project management tools
Recommendations provided earlier will address the issues described above.
2.3.7 Training
Although a majority of respondents felt they were adequately trained to use the technologies available to them,
23% of staff never received any type of training and 27% staff received training more than 2 years prior. As the
pace of technological change continues to increase, and citizen expectations continue to rise, it is important to
Prior & Prior Associates page 18
City of Pickering Technology Review and Roadmap
provide staff with training not only to do their jobs, but also create an environment to explore using existing
technology to improve business processes and service provided.
2.3.7.1 Training Recommendations
IT in partnership with HR and other departments, develop a technology training/learning strategy that address
the core competencies in business technology, as well as addresses business specific applications to ensure all
staff have the capabilities to carry out their roles.
3. Municipal Comparisons
Nine municipalities were included in the environmental scan-Ajax, Aurora, Caledon, Cambridge, Georgina,
Newmarket, Stratford, Waterloo and Whitchurch-Stouffville. (It should be noted Stratford was included as it has
achieved the Intelligent Community designation that the City of Pickering has expressed interest in pursuing.)
The City of Pickering's population size of 95,000 positions it in the middle of these comparative municipalities.
The information provided by these organizations focused on number of staff, budgets, support volumes,
governance, staff compensation and organization structure.
Benefits to be derived from this type of scan have become increasingly difficult to achieve, in part due to the
range of services provided by the different municipality, as well as the types of services provided by the IT
organization and to whom.
Findings on IT resources and spending on IT initiatives suggests that the City of Pickering funding of IT projects is
a very low proportion of the overall capital budget.
The City currently employs 7 Full time resources to support and provide services to its xxx staff who are
becoming more dependent on technology than ever before. At the City, the ratio of users to IT staff is 89:1. In
comparison, the median of the benchmarked groups studied is 45:1. This means that City IT staff are supporting
twice as many end users as their comparators.
Another way to compare is IT cost per capita of the population. The City of Pickering spends $20 per person
whereas the median for the comparators is $44 per person. Indicating a significant underspend to service the
residents.
The detailed benchmark study can be found in Appendix B.
4. Emerging Trends
4.1 New Pressures
In addition to the current gaps and opportunities, the City must also take into account new or emerging factors
that will affect future business and IT strategic directions.
" Population Growth and Focus on Investment
" Changing Resident and Council expectations. Residents expect to be able to interact with the City
electronically, when they want, where they want, using devices to interact with the City, instead of
coming in to the Civic Complex. Processes in the back office must be digitized so that they can be
offered electronically to residents.
" Changing staff requirements. City staff require access to the information and systems necessary for
them to effectively deliver services. Millennial's are replacing boomers in the workforce, bringing with
Prior & Prior Associates page 19
25
26
City of Pickering Technology Review and Roaclmap
them different expectations. Attracting and retaining this new talent will be important-and technology
will be part of that. They expect a range of technologies to be readily available to them, and not just
during standard business hours. They will place new demands on technology and the IT team, and
expect their employer to provide the necessary tools.and solutions.
• Everything is becoming digital-The Internet of Things. New technologies are constantly emerging,
transforming everyday 'dumb' devices into smart devices that must connect to the network. Today
traffic lights and building security controls, garbage trucks and irrigation systems, even the garbage cans
themselves are becoming smart devices that connect to the City's technology infrastructure. These
devices connect to databases and systems that allow staff to monitor and manage their operation more
effectively and efficiently than in the past. This places additional demand for the IT division to be
involved with projects in which they previously may not have been-further creating the need for
additional IT resoureing.
• New technologies are emerging daily that promise to help staff do their jobs more effectively. Examples
include solutions that borrow from consumer technology such as virtual reality headsets that help field
workers identify buried assets, or real time glasses-based video streaming that allow building inspectors
to seek a second opinion from a colleague. This may sound like sci-fi, but progressive municipalities are
using this real technology today. As a small municipality, with limited resources, the City will need to be
cautious, identifying and selecting only those initiatives that deliver real value.
• Continuous improvement relies on operating insights. Digitization of processes means that data is
available to provide insights that can enable benchmarking and spark continuous improvement of
operations.
All of this results in an overwhelming amount of demand. In light of this the City must determine;
• Which, of the hundreds of possible IT initiatives, are the right priorities
• How can IT activities be coordinated so that the City gets the best value for its IT investments
IT Governance is theprocess by which senior management can take a leadership role to align IT decisions to the
overall strategy of the City.
S.IT Decision Making: IT Governance
5.1 What is IT governance?
IT Governance is the processes and structures which inform, direct, manage, and monitor how the organization
makes the best and most effective use of technology. This is more than a single steering committee, this is the
various teams and groups that are involved in IT decision making.
The goal of establishing an IT governance framework is to ensure that the right people are making the right
decisions, at the right time and for the right reasons. In some cases this will mean collective decision on
corporate priorities, in other. areas it will involve technical decision making on the best data storage technology
or networking protocol.
Prior & Prior Associates page 20
City of Pickering Technology Review and Roadmap
Organizations often view such decisions about technology as complicated, technical and "best leftJo the experts
in IT". However, in many cases, decisions about technology have ramifications, well beyond the technology
itself:
• How do we want to use technology in our business?
• What technology do we want our people to use, and how do we want them to use it?
• How much should we spend on technology?
• Which of our business processes should we direct our IT dollars towards?
• What do we need to tackle first?
• Should we do this now, or later?
• How secure do we want to be?
These are not decisions that technologists alone should be making, they are important business, decisions that
the leaders of the organization must address through a corporate IT Steering Committee. There are of course
purely technical decisions to be made, and the right IT staff (with the appropriate skillsets) need to be involved-
but in most cases IT experts should be advising the business leaders.
The IT Steering Committee can evolve and grow as needed but this is a recommended starting point.
5.2 IT Department
The IT Team remains responsible for delivery of IT services, and the IT team continues to be responsible for
operational IT matters. The IT governance arrangements are designed to assist the IT Manager in strategic
decision-making-not take over operational responsibilities. The IT Manager is responsible for sharing the
insights about IT operations (e.g. IT resource availability, emerging risks) that are necessary to assist the IT
Steering Committee in strategic decision-making.
In terms of project work, while IT staff will lead technology infrastructure projects, for business systems,
integration and customer facing projects, the IT team will be a strategic business partner with the .business lead
for the initiative. In these cases, it is not IT who will project manage the initiative, a business leader will lead this
work. The IT Manager will be the communication conduit for project status updates.
5.3 IT Policies and Standards
5.3.1/T POLICIES
Policies and standards establish the parameters within which the City uses technology, creating clear
expectations for those that use and manage technology. In keeping with the commentary throughout this
section, many of the decisions related to technology are business or management decisions. These are not
decisions to be made by IT on behalf of the corporation. For example;
" Which employees get smartphones
" Who is authorized to register a web domain for the City
" Which websites staff can access, and whether that activity should be tracked
" What content is saved when an employee retires
" How much space does an employee have in email
For each of these decisions a number of factors need to be weighed, including business impacts, employee
impacts and importantly, cost impacts. A standard IT policy framework typically addresses the following areas.
• Acceptable use
" IT Security *
Prior & Prior Associates page.21
27
30
City of Pickering Technoiogy Review and Roadmap
It is recommended that the IT Manager work with the IT Steering Committee to introduce an appropriate
methodology for the City's IT projects.
5.3.4 MEASUREMENT & REPORTING
5.3.4.1 PROJECT PORTFOLIO REPORTING
Reporting on the status of the project portfolio is important, in order that the IT Steering Committee can
monitor both overall portfolio performance and the progress of individual initiatives. The Steering Committee
should regularly receive a status report on the Approved Project List. The IT Manager will be responsible for
developing the portfolio status report.
As part of the review of the IT portfolio on a monthly basis the IT Steering Committee will review
• Prioritization changes
• Review red and yellow status projects
• Projects due for completion
• Projects due for startup
• New proposals
5.3.4.2 OTHER REPORTING
In addition, the IT team will develop a new set of business-focused metrics to help better monitor the City's
performance in executing this roadmap, as well as the day-to-day operations. Topic areas for new metrics
include:
• Ideas portfolio (new, transitioning to project)
• Service Requests (volumes, performance against targets)
• Change Requests (volumes, performance against targets)
• Assets (status, investment by category, resource use by asset).
• IT Resource (availability, utilization, allocation)
• ~inancials (cash flow, budget vs. actual, spend by portfolio category, spend by asset)
Prior & Prior Associates page 24
City of Pickering Technology Review and Roadmap
The following table outlines the recommended resources, the timeframe for their new positions to support
strategic plan activities and the rationale for the new position .
Year Resources . Rationale
2016 Supervisor, Client Services Transforming the user experience of IT is a top
priority. This requires a leader wh.o has experience
running a service desk, that can dedicate the time
required to redesign services and processes, and
help staff through the transition.
2016 Help Desk Technicians (2) Front-line Help Desk Technicians provided much-
needed immediate response support. They are
able to resolve the majority of routine support
requests at point of contact. They will perform
initial triage on other calls before escalating to a
more senior IT resource. This frees up the senior
resources to focus more on projects and major
issues. (to be funded through existing FTE change)
2016 DBA (Database Administrator I The IT team requires more DBA capacity, initially
Analyst) this in order to transition database activities that
departments have taken on, and to support future
work on reporting, data standards and integration.
2016 Network Security Analyst This is a senior IT position with a focus on security
and network expansion. Security is a growing.
concern for any organization and requires more
daily monitoring and planning.
2017 Business Analyst/Project Manager Dedicated business analyst I project management
staff, with training and experience will be critical
resources to help translate business needs into
systems requirements, and then help implement
the projects. Creating this position will help ensure
that the IT Manager can be less involved in leading
projects-and more focused on strategy and
developing team capabilities. See section below for
more details re: Business Analyst function.
2017 Application Administrator For major business applications, the City should
hire Application Administrators to fully support the
applications-to accelerate the implementation of
new capabilities, but also to ensure that as the
systems are more broadly adopted, support can be
provided in a sustainable way. This
recommendation is for an Amanda or GIS
Application Administrator to start:
2017 Application Administrator See rationale for Amanda Application
Administrator. This is recommended for an ERP
(FIS) Application Administrator-which will bring
Prior & Prior Associates page 27
33
34
City of Pickering Technology Review and Roadmap
Year Resources Rationale
the complement to two. Serious consideration
should be given to adding this position to support
the new FIS requirements and potential solution.
2018 Business Analyst/Project Manager See rationale for BA/PM.
2018 Help Desk Technician A third Help Desk Technician to handle to expected
growth of the City as well as the increased reliance
on technology.
2019 Web and digital coordinator No staff member currently has responsibility for
the web. Given the importance of the web as a
communications and customer service vehicle a
coordinator is required to spearhead web, social
media and other digital activities.
2019 Web Analyst/ Developer To support the ongoing growth of web and e-
Se!liices, the City should expect to retain in-house
analyst I web developer capabilities within the IT
department.
6.3.1 BUSINESS ANALYST
Larger organizations separate out IT roles, because specialist skills are required for different functions-it is
unusual and difficult to find staff that are good at all of the roles required in IT. For example, in larger
municipalities, the Project Manager, Business Analyst, System Analyst, Network Specialist, Helpdesk Analyst (and
many others) are separate job roles. At Pickering, the small team tries to cover off all the different roles.
Technology projects represent an opportunity to streamline business processes, reduce duplication, make
processes more customer friendly/accessible as well as faster and more efficient. However, this is dependent
upon conscious effort being applied to rethinking business processes before any implementation of technology
begins. To be successful before an IT project can begin or a technology solution can be chosen, the business
problem must be fully explored and understood, the project must be scoped, and the scope agreed with all
stakeholders. Without getting this part right, the City may implement the wrong solutions, to the wrong
problems, with unsatisfactory and costly results.
Leading this definition of the needs of the organization requires different skills from the technical skills required
to ultimately implement the chosen solution. The Business Analyst role brings the skills of process analysis and
process improvement, which can be put to use on more broad corporate and departmental projects that do not
necessarily involve technology.
6.3.2 CONTRACTING POSITIONS
It is also important that the City recogni;ze the significant resource demands of some of the major projects
identified such as Work Management and Document Management. These are significant undertakings that will
require fully allocated resources with previous experience. When undertaking such significant projects; the City
should consider funding contract staff (e.g. project manager, analysts) as part of the overall capital project, to
resource the project and to backfill existing resources both in IT and the departments.
Prior & Prior Associates page 28
City of Pickering Technology Review and Roadmap
6.4 Opportunities for Partnership
The City is fortunate to be located in an area that is fertile for partnership working. Moving forward there will
continue to be a wealth of opportunities to work with partners. Given the size of the City and some of the
challenges this presents-specifically the limited availability of technology and software solutions for small to
medium sized municipalities-the City should always be seeking to identify partnerships with other
municipalities and Durham Region that could help the City implement a shared solution (with lower operating
costs) or provide a higher caliber solution than the City could realistically afford independently.
6.5 IT Service Delivery-the Help Desk
To accommodate the new demands and to achieve the goals laid out in this roadmap, further IT service
improvements are also recommended. IT service delivery must become more agile and responsive to new and
emerging needs as well as become more proactive and strategic.
Partnerships are built on trust, and unless departments can rely on IT for basic services, they are unlikely to
trust them with such complex activities as business transformation. It will be very important tactically for
the IT team to earn its credibility by making significant improvements to this service. Improving the help
desk service is therefore a priority for IT and the City. A number of organizational recommendations are
made to help give the help desk authority within IT, to gain more focus, attention and improve its services.
• Establishing IT helpdesk standards and expectation, including the prioritization of incidents
• Implement a new help desk system and processes
• Develop a formalized after hours IT service -by/call out)
• Establish change management procedures
• Strong IT governance to prioritize projects and deliver on corporate requirements
6.6 Adopt a Hybrid Delivery Model
Traditionally the IT team has undertaken most of its work in-house, occasionally contracting out specific tasks
where technical expertise has been required. The reality of current IT departments, particularly with smaller
teams, is that maintaining all of the necessary skills and resources in-house to manage the complex technical
environments is impractical. To do so would mean hiring a large number of additional and specialized staff.
Smart IT organizations rely on a small team of in-house staff who in turn work with a network of trusted
partners, vendors and solution providers to deliver the required services. The focus is on "getting it done"
rather than IT staff figuring out how to do it themselves. This is a hybrid model of IT service delivery that relies
on a combination of internal IT and business skills and market based expertise and services. Ultimately this
means the IT team and the IT manager take on the new role of coordinator of IT services.
Some of the IT systems that the City operates are specialized for the municipal business such as tax
management and building permit systems. Some technologies however, such as networks, servers, file storage
and email are more generic. It is recommended the IT team secure the ongoing services of a third party
technology provider on a retainer basis to support and mange the complex technical environment, under the
direction of the IT Manager.
Prior & Prior Associates page 29
35
36
City of Pickering Technology: Review and Roadmap
6.7 Resource Technology Projects Appropriately
One of the key reasons that projects fail is simply due to the lack of resources allocated during implementation.
Major corporate projects such as those the City is now considering (e.g. Document Management, Asset
Management) are complex, business transformation solution, and typically need far more resources to
successfully implement them than initially expected. The current list of demands to implement new solutions
and improve existing solutions far outstrip the IT (and departmental) resources of the City.
It is clear from experience that projects face particular challenges in securing the level of staffing needed for
effective project management, configuration, implementation and training. The resource constraints impact
both IT and the departments. It is particularly important to secure departmef!tal buy-in as part of the planning
process to ensure that the need for appropriate subject matter experts is acknowledged and supported.
Some key suggestions in terms of resourcing projects and initiatives include:
• For major projects, resources must be dedicated (projects cannot be in addition to existing day-to-day
responsibilities); in future backfilling resources should be considered as part of original project funding
requests (and should be funded through capital budget).
• Where appropriate, specific skills needed for a defined period of time should be secured externally.
• Projects should not commence until the right level of resources can be committed, which should be
enforced by IT Steering Committee and the project management methodology.
• The City must be realistic about the capacity that they have to deliver major IT projects (1-2 large
projects in any one year).
• All projects that implement a solution will have ongoing operational impacts (maintenance, licensing
and operational support costs) therefore future operating funds must be considered and included in the
budget at the time of purchase.
• One approach that many other municipalities have embraced is utilizing more external resources and
funding these resources through capital project funding. When new staff cannot be hired, external
resources can be used to support both operational and project initiatives-to relieve internal staff to
focus on value added services.
• External resources can be in the form of:
o a consultant on a term and task basis,
o an in-house contractor (short term 1-2 year contracts on a project basis),
o or a service provider.
• Backfill departmental resources to ensure dedicated project availability (e.g. Business Specialists); for
example, if the City plans to implement a new HR system it should look to backfill (with a short term
resource) a senior member of the HR team to work/lead the project. This person will return to their
permanent job at the end of the project thus ensuring that key knowledge is retained within the City
• Application development and application support may be provided by vendors (e.g. Amanda)
Prior & Prior Associates page30
City of Pickering Technology Review and Road map
2. Adopt the municipal architecture as a framework for IT decision making, and follow the 1bottom up'
concept it reinforces
3. Adopt the recommended IT governance framework, including:
a. Establishing a corporate IT Steering Committee to oversee technology decision making and
priorities
b. Establishing a project intake and prioritization process,
c. Maintaining an approved IT project list, with only projects that are fully evaluated and resourced
d. Revising corporate IT policies
e. Reporting to communicate IT effectiveness
4. Grow the IT Team, by:
a. Establishing a dedicated 1helpdesk' function
b. Planning to add additional IT positions over the next 5 years to address the resourcing
requirements
5. Improve core IT services through a focus upon:
a. Establishing helpdesk service standards and formalizing the IT helpdesk service
b. Improving change management practices
c. Adopting industry standard approach to project management
d. Providing after hours IT support
6. Continue investment in core infrastructure initiatives, to establish a modern, flexible, scalable, reliable
and secure shared technology environment, including:
a. Technology asset management and lifecycle
b. Long term network strategy and build out
c. Security
d. Disaster recovery planning and readiness
7. Determine the direction for core business systems, and implement new business systems to address key
gaps.
8. Continued investment in technology, as a driver of efficiency and improved customerexperiences.
Investments will be overseen by the IT Steering Committee, and will be managed through the corporate
budget process, using this strategy to guide the priority setting .
. This roadmap recommends a range of municipal IT best practices. By adopting the recommendations presented
here, particularly with regard to staffing and governance, the City will be position itself well to deal with the
ever-growing demands of delivering efficient and effective services in a municipal environment.
Prior & Prior Associates page 32
38
City of Pickering Technology Review and Roadmap
Appendix A-G.i.S. Review
The City of Pickering has a Geographic Information System (GIS) with the following components:
GIS technology platform
• The City's GIS platform is built around ESRI GIS products, a widely used GIS software, consisting of
ArcGIS desktop software, ArcGIS Server software, ArcSDE database· (that uses Microsoft SQLServer
Database Management System)
• In addition, AutoCAD drawing systems are used by Engineering & Public Works Department for
engineering and technical designs and drawings (which in many cases use the GIS property layer as base)
• Rolta's Onpoint Web GIS to provide Web based viewing access to the GIS data for the more occasional
users
GIS data
The scope of GIS related data that have been created in the GIS ArcSDE database includes:
• Property/parcel data with the base property data provided by MPAC (Municipal Property Assessment
Corporation) monthly and continuously maintained by the City Development department staff to ensure
that the property boundaries, ownership and address data in the City are more up to date (relative to
the frequency of data provision from MPAC)
'" Street network as provided by Durham Region and maintained by the City Development department
staff
'" Planning data (Local Official Plan, Zoning, Development Applications) created and maintained by the City
Development department staff
• Digital Airphoto (via sharing agreement with the Region) updated yearly
" Storm Water data as provided by Durham Region on a yearly basis
" Water Hydrant data as provided by Durham Region on a yearly basis
• Street light data
• Park details, initially created as part of the PSAB Tangible Capital Asset project
" Natural resources data as provided by Ministry of Natural Resource's LIO (Land Information Ontario)
facility
GIS Applications
The main applications for the GIS system include:
• Property/parcel, street network, address information
• Regular mapping products and outputs (e.g. local official plan, zoning maps, park trail maps)
" Mapping and data support for planning projects (e.g. location maps, geographic analysis, data
extraction)
" Data provision (e.g. data extraction of base mapping information to support Engineering design) and
data analysis (e.g. geographic analysis, reporting, queries)
" Provide the capabilities for mapping view via integration with CSDC Amanda system (Permitting,
Development Applications, Enforcement, Service Request)
" Information inventory and data provision (e.g. Storm, Hydrant, Streetlight)
"' Vacant land inventory
'" Information product such as quarterly publication of Active Development Applications list
Prior & Prior Associates page 33
39
40
City of Pickering Technology Review and Roadmap
• Viewing of GIS information via the Rolta's On point Web Mapping platform
User Community
There are two power users of the GIS system, who access the system directly use the ESRI desktop software to
import data, create data, maintain data, and use the data for analysis, production of mapping products and
reports. They are located in the City Development department. Otherwise there are no regular direct users of
the GIS software (i.e. using the_ESRI GIS software functionality directly).
Indirect access to GIS data is available via the On point Web Mapping product (for viewing access only).
However, the implementation of the product was quite limited and there· are very few users thereof.
There is also viewing access to the GIS data via the Amanda to GIS interface, within the context of the
functionality of Amanda (e.g. in the context of permits and development application processing).
Information Technology Services provide GIS software platform support (software and database installation and
maintenance) through its DBA (Database Administrator).
Issues
Software:
• The GIS software is a couple of versions behind. A software upgrade is planned.
• The performance of the software is not an issue.
• Workstation performance is reasonable for GIS functionality. However, dual monitors workstation
configuration would enhance the usage efficiency for the power users.
Data and applications:
• Other than noted above (power users and Amanda interface), the City's GIS data and functions have not
been widely used and leveraged.
• On point (Web GIS viewer) implementation was very limited and the functionality of the software itself
has fallen behind somewhat in the past few years. The product is planned to be replaced by a more
robust GIS Web mapping product GeoCortex (for distributing GIS functionality to the occasional users,
including public users, and for integrating with myriad public open source data).
• Given the limited implementation of Onpoint, the user base is limited and the GIS data and functionality
are therefore not leveraged.
• City's policy is not in place to support the offering of GIS data and Web functionality for the public. GIS
offers a convenient and effective method of providing "what is there" type of information (events, road
closures, road projects, planning projects and applications, etc.) to the public via the City's Web site.
• Among City staff, there is not a good level of awareness of the GIS data and functionality and
applications
Recommendations
The implementation of GeoCortex provides an opportunity to establish a prominent GIS presence for both
internal and external users. The software capabilities to support occasional users are well regarded. Much of
the data foundation is in place. The initial functionality {internal and external) can be readily established.
Prior & Prior Associates page 34
City of Pickering Technology Review and Roadmap
However, a planned and resourced implementation, with the wider user participations, is required to ensure a
more robust roll out.
As part of the GeoCortex project, it should be considered as providing the platform to serve the "what is there"
type of applications (that have geographic context) to the public users, with the mapping functionality allowing
for a more convenient and efficient method to offer the information.
Information Technology should provide overall project management for the GeoCortex project. It should also
provide technical implementation resources for database setup, limited complementary development,
integration, technical configuration, etc. The power users and other end users will participate for requirements
articulation, output definition and layout, testing, review and so on.
GIS software and application implementation should be managed in the same way as other systems, with
technical implementation resources (project managers, analysts, developers) from Information Technology
Services, supplemented by user resources (requirements definition, and roll out participation). GIS software
technical training for these IT resources is needed (as in the case of other systems) so that they are aware of the
nuisances and particularity of the GIS software. GIS is moving more mainstream and is just another system with
capacities for geographic data processing and presentation ..
Given the limited resources in Information Technology Services for system implementation, additional resources
are needed for GeoCortex implementation. A minimal resource level of 6 person month of IT implementation
resource is needed, plus end user participation. On a continual basis, an allocation of 3 to 6 person months of
resources annually is required for new or enhanced functions in the public Web usage area.
Power users, mapping and cartographic expertise should continue to reside in user departments. It would not
be efficient for Information Technology Services to provide such specialized services that also require detailed
knowledge of data context.
Resources for creation and maintenance of GIS data should continue to ~eside in the corresponding "owner"
departments. Being the owner of the data, they understand the data and its context, and are in the best
position to work with the data that flow through their departments.
Basic data documentation should be developed to document the existence and context of the GIS data (data
contents, currency, ownership, etc.).
Prior & Prior Associates page 35
41
City of Pickering Technology Review and Roadmap
Ajax Aurora Ca;.,bridge Clarington Waterloo Newmarket Pickering Median (All)
Director of
IT Leadership IT Manager IT Manager Technology Services IT Manager Director IT Director, IT Manager, IT
Legislative and Corporate &
Reporting Information Financial Services Corporate Services Corporate Services Corporate Services Corporate Services Corporate Services·
Centralized? Yes Yes Yes Yes Yes Yes Yes
GIS Yes No Yes Yes lves Yes No
IT and IT and
Web/ CMS No No No No Communications Communications No
FTE 11 11 25 9 20 14 7
Contract Staff 0 0 0 0 0 4 0
Total IT Staff 11 11 25 9 20 18 7
Tech support-Asset Management
IT people in depts. Library 0 Team (6) 0 1 1 0
IT provides primary front line support.
Through IT Help IT. One application support and vendor 2nd level
Desk. Then (Maximo) is contact "Peer IT Supports all but escalation to other
escalated to supported in ITs up ports. IT will support" for Maximo is IT staff. 3rd level
·Application Support appropriate staff. Engineering Dept escalate to vendor application issues. supported by dept. to vendors. IT
Yes -new client
service division being
created. Heat for Yes, inhouse Yes-Alloy
Formalized Helpdesk Yes, KACE Yes. BMC Track-It! tracking calls. solution Yes-Track-IT Yes Navigator
Yes, password Yes-SLA's
resets, total established for No. Manager and
application, WAN, Yes. Policy currently No. IT Manager on different dept Supervisor are
Formal Out of Hours Phone failures No under review call. Yes 24x7 requirements called
Population 130000 56700 132000 85,000 98780 86,000 95000
Users 500 400 602 630 550 521 624
Employees 630 498 700 616 600 832 678
Workstations 344 291 750 340 600 404 300
Telephony 300 270 447 150 586 584 414
Smart Phones 45 114 143 90 222 214 75
Cell Phones 100 50 150 60 135 63 74
Radios 0 0 140 0 so 0 31
Town /City
Operating 49,000,000 74.412,700 111,500,000.00 172,655,144 $ 171,300,000 $ 112,926,115 $ 55,336,613
Town I City Capital 28,000,000 17,932,600 63,000,000.00 79,561,987 $ 71,800,000 $ 29,333,475 $ 24,984,853
IT Operating 1,800,000 1,807,458 4,846,954.00 1,500,000 $ 3,320,366 $ 2,834,374 $ 1.449,578
IT Capital 550,000 72,800 1.408,000.00 400,000 $ 1,049,672 $ 955,525 $ 432,375
Total IT Spend 2,350,000 1,880,258 6,254,954 $ 1,900,000 $ 4,370,038 $ 3,789,899 $ 1,881,953
Yes -Executive
IT Governance No Yes. BMC Track-It! yes -steeri ngcte No Not any more Team & IT Director No
IT Manager IT Director
recommends to C FO & Corporate recommends to
Decisions Senior Steering Committee Steering Cte IT staff Management Team Executive Team IT Manager
IT Strategy Yes expired 2014 Yes No Yes No No
Calculations
IT staff per 100,000
residents 8.5 19.4 18.9 10.6 20.2 20.9 7.4 18.
IT Staff % of total 1.7 2.2 3.6 1.5 3.3 2..2 1.0 staff 2.
IT users per IT staff 45.5 36.4 24.1 70.0 27.5 2.8.9 89.1 36.
% of IT operating of
Total Operating 3.7 2.4 4.3 0.9 1.9 2..5 2..6 2.
% of IT capital of
Total Capital 2.0 0.4 2.2 0.5 1.5 3.3 1.7 1
IT Spend as% of
Operating 4.8 2.5 5.6 1.1 2.6 3.4 3.4 3
Total IT Spend as%
of Total City Spend 3.1 2..0 3.6 0.8 1.8 2..7 2.3 2
IT Cost per capita 18.1 .33.2 47.4 2.2..4 44.2 44.1 19.8 33.
IT 0 perating 76.6 96.1 77.5 78.9 3919.9 2979.7 2940.4 96.
IT Capital 23.4 3.9 22..5 2.1.1 1643.0 774.0 1327.6 2.3.
PC: IT Staff 31.3 2.6.5 30.0 37.8 30.0 2.2..4 42..9 30.
$$ per staff $ 3,730.16 $ 3,775.62. $ 8,935.65 3084.42 $ 7,2.83.40 $ 4,555.17 $ 2,775.74 3775
$$per PC 6831.4 6461.4 8339.9 5588.2 7283.4 9380.9 6273.2 6831
Prior & Prlor Associates page 37
43
44
City of Pickering Technolog>J Review and Road map
Appendix C-Current Project list, and Work Plan
The following table provides a detailed list of all of the current projects as categorized by the technology
architecture. These are intended as a guide only, and the Steering Committee will be responsible for
setting the annual priorities and the investment levels.
Projects Layer Sublayer Why Status
Ping Street Customer Facing Customer Service Keep Current I In Progress
Systems Platforms Functionality
C&R-Membership Customer Facing Customer Service New Service I In Progress
Email Facilitation Systems Platforms Tech Trend
IT Strategic Plan Governance IT Service In Progress
Management
On call I After-hours Governance Service In Progress
support Improvement
IT Organizational Governance Service
Review Improvement
Change Control Process Governance Maintenance
Implementation
Operational and Capital Governance Financial In Progress
Budget Management
Smart and Intelligent Governance Residential In Progress
Durham Services I E. D.
IT Service Request Governance Efficiency
Management Review
Pay Phone Infrastructure Corporate Bell I Cost Savings In Progress
Replacement Infrastructure
Applications
Alloy Navigator-Infrastructure Corporate Service
Configuration for Infrastructure Improvement
Service Mgmt Applications
Citrix Upgrade Infrastructure Corporate Keep Current I In Progress
I nfrastru ctu re Functionality
Applications
Prior & Prior Associates page 38
City of Pickering Technology Review and Roadmap
Mobile Device Infrastructure Corporate Risk Management
Management Process Infrastructure
Applications
Oracle RMAN Infrastructure Storage Keep Current I In Progress
Implementation Functionality
Dell Compellent Infrastructure Storage Service In Progress
Upgrade/ REC COMP Improvement
DRP Infrastructure Disaster Recovery Risk Management In Progress
Planning I Replacement Infrastructure Essential! nfrastructure Maintenance In Progress
Scanner/Copier Services
Bell I Rogers Rate Plan Infrastructure Essentia I Infrastructure Cost Savings In Progress
for Cell Phones Services
Help Desk Software Infrastructure Essential Infrastructure Keep Current I In Progress
(Alloy Nav) Upgrade Services Functionality
Facility Review for Infrastructure Essential Infrastructure Maintenance In Progress
Claremont-Phones, Services
Network, etc.
Blackberry Server Infrastructure Essential Infrastructure Cost I Compliance
Decommissioning Services
Tape Backup Review I Infrastructure Essential Infrastructure Cost/Compliance
Backup Design Services
What's Up Gold -Infrastructure Essential Infrastructure Systems· and
Upgrade and Services Network Mgmt
Configuration
PCI Compliance Review Infrastructure Essentia I Infrastructure Risk Management
Services
Office 365 Review Infrastructure Essential Infrastructure Keep Current I
Services Functionality
GFI Upgrade I nfrastru ctu re Essential Infrastructure Keep Current I
Services Compliance
Prior & Prior Associates page 39
45
City of Pickering Technology Review and Roadmap
Civic Complex-Wi Fi Infrastructure Network Consistency In Progress
(Next steps)
Rogers/Radiant MPLS Infrastructure Network Increase In Progress
Network Review Reliability
Cisco Network I Infrastructure Network Keep Current I In Progress
Cleanup I Upgrade I Performance
Replacement
Library Wi-Fi System Infrastructure Network Service
Upgrade Improvement
Firewall Replacement Infrastructure Network DRP /Functionality In Progress
City Wi-Fi Expansion Infrastructure Network Service
Improvement
Monitoring and Infrastructure Security Availability In Progress
Reporting System
Evaluation
Security Assessment-Infrastructure Security Security In Progress
Pen Test
Security Monitoring Infrastructure Security Risk Management In Progress
Review
Desktop Application Infrastructure Security Security
Patching I Updates
Network Security-Infrastructure Security Risk Management
Managed Services
Review
McAfee AV-VM / Infrastructure Security Security
Network
Desktop Management Infrastructure Servers&Desktops Maintenance In Progress
Strategy
HP Chassis Upgrade I Infrastructure Servers&Desktops Keep Current I in Progress
Replacement Performance
HP Blade Server Infrastructure Servers&Desktops Keep Current I In Progress
Replacement Performance
Desktop Hardware Infrastructure Servers&Desktops Functionality
Purchase I Build
Desktop OS Imaging Infrastructure Servers&Desktops Efficiency
Solution
Prior & Prior Associates page 40
46
City of Pickering Technology Review and Road map
Desktop Patching Infrastructure Servers&Desktops Compliance
Solution Review
Monitor Replacement Infrastructure Servers&Desktops In Budget In Progress
Review for Eng and PW
VMWare Upgrade 5.1 Infrastructure Servers&Desktops Keep Current I In Progress
to 5.5 Functionality
Backup Solution Review Infrastructure Storage Everything In Progress
Dell Compellent Infrastructure Storage Keep Current I
Controller Upgrade-Performance
CIV
Backup using VEAM I Infrastructure Storage DRPIFunctionality In Progress
ROM -VMDK
Open Data I Big Data Integration DashboardsiPerforman New Service I
ce Reporting Tech Trend
ESRI Upgrade Integration GIS Keep Current I In Progress
Functionality
Fire Services Mobile Major Business Dispatch and RRMS Keep Current I In Progress
Inspections Solution Systems Functionality
Emergency Major Business Dispatch and RRMS Risk Management In Progress
Management Systems
Configuration -Civic
Complex
Fire Services-Crysis Major Business Dispatch and RRMS Service In Progress
Device Review Systems Improvement
EOC-Claremont-Major Business Dispatch and RRMS Risk Management In Progress
Configuration and Systems
Testing
Laser Fiche Licensing Major Business Document& Records Cost I Compliance In Progress
Review Systems Management
Laser Fiche Forms Major Business Document&Records Keep Current I In Progress
Module Systems Management Functionality
Library Printing Major Business Document&Records Service
Solution Review Systems Management Improvement
Corporate Print Major Business Document&Records Service
Solution Review Systems Management Improvement
Prior & Prior Associates page 41
47
City of Pickering Technology Review and Roadmap
Facilities Management Major Business Facilities Functionality In Progress
System Systems
Geocortex Major Business GIS Service
Implementation Systems Improvement
Amanda RFS Major Business Infrastructure, Asset Process In Progress
Implementation Systems Mgmt
Asset Management Major Business Infrastructure, Asset Maintenance In Progress
System Systems Mgmt
GPS Tracking System Major Business Infrastructure, Asset Service
for City Vehicles Systems Mgmt Improvement
C&R Court Booking Major Business Recreation Service In Progress
Application Systems Improvement
Fire Services -Fire Site Major Business Other Service
Facility System Systems Improvement
Road Patrol Major Business Planning, Permitting, Compliance In Progress
Systems License, Inspection
City Reporter-Parks Major Business Planning, Permitting, Compliance In Progress
Inspections Systems License, Inspection
Bylaw Enforcement Major Business Planning, Permitting, Keep Current I
App Systems License, Inspection Functionality
Amanda System Major Business Planning, Permitting, Keep Current I
Upgrade-Permits Systems License, Inspection Functionality
Class System Review Major Business Recreation Software Upgrade
Systems
Weblink Upgrade I Major Business Service In Progress
·Review Systems Improvement
Adobe SW Upgrade I Major Business Software Upgrade
Cloud Connect Design Systems
Prior & Prior Associates page 42
48
City of Pickering Technology Review and Roadmap
Proposed Work Plan and Schedule
This work plan represents the recommendations included in this Technology Review and Roadmap
combined with the highest ranked projects on the current IT Department's Project List.
Est. Total Est. OpEx
Projects Budget Impacts '15 '16 '17 '18
Infrastructure --
Cisco Network I Cleanup I Upgrade I
Replacement II II II
Citrix Upgrade II II
Firewall Replacement II II
Dell Hyperconverged Infrastructure II
Implementation
Dell Compel lent Upgrade I REC COMP II
EOC-Claremont-Configuration and Testing IIIII IIIII
Dell Compellent Controller Upgrade-CIV IIIII
Review and upgrade where needed, remote
facility connectivity IIIII II
Build a test environment II IIIII
Mobile Device Management Plan II II II
Backup using VEAM I RDM-VMDK IIIII II
Identify Meeting Room technology
requirements and upgrade where appropriate. II II
Business Systems --
Develop a business application inventory,and
lifecycle plan. II
Laser Fiche Licensing Review IIIII II
ESRI Upgrade II IIIII II
Geocortex Implementation II II
Class System Review IIIII II IIIII
C&R Court Booking Application II II
Fire Services-Fire Site Facility System II II
Amanda System Upgrade-Public Portal, etc 1!1 II IIIII
Facilities Management System II IIIII
Citywide Asset Management Reconciliation II II
'19
Prior & Prior Associates page 43
49
City of Pickering Technology Review and Roadmap
Est. Total Est. OpEx
Projects Budget Impacts '15 '16 '17 '18 '19
Customer Facing --
C&R-Membership Email Facilitation II II
Supporting Activities ... --
Governance .. --
Establish ITSteering Committee . --II •
Establish project intake and evaluation process --• II
Setup project reporting --II • II
Establish project management process --II II
Develop IT Standards, procedures & policies • II Ill •
Identify budget planning-plan for the future
and sustainability II
·. ·. rr Organization --
Develop an IT Vision & mission-team-
building II Ill II
Revamp all IT roles and responsibilities I
service delivery standards --Ill II II
Operational and Capital Budget Management • II • • •
Review all IT job descriptions (take through
the JIQ process) --1111 Ill II
IT Organizational Review-add new positions
to properly resource IT to support the City's
goals. • • Ill Ill II
ITService Improvements --
Set IT Helpdesk service expectations arid
implement supporting processes . --• II
Implement self service tools (e.g. password
resets) -II II
Formalize after hours IT support -• •
Establish change management processes,
including change window --• • •
Review IT recharge mechanisms --II •
Review device provisioning annually --• • • II II
Develop a user training program • • •
Ongoing System Upgrades &Maintenance I --I··· ...
CapEX and Opex Budget Forecast
• • • • •
System Maintenance upgrades • • • II II
Annual software licence renewals • II • II II
Totals
Prior & Prior Associates page44
50
52
City of Pickering Technology Review and Roadmap
processes (land and property, assets,. financial, human resources and spatial), digitally connecting cross-
departmental business processes. In addition, many point solutions that enable specific areas of the
business, Fire dispatch for example, are operating with a clear support model in place. All of the
business systems rely upon the underlying infrastructure to allow them to operate (e.g. databases,
servers, network and a PC}. Without reliable infrastructure, business systems will not be effective.
Integration: These are the tools, technologies and data standards that allow information from separate
business systems to be connected and combined. This integration minimizes work for staff by reducing
the amount of duplicate data entry. It also allows staff to easily source information and enables
management to gather insights and identify trends and patterns that will help them manage their
services more cost effectively. Setting and enforcing common data standards across systems is central to
enabling the City to build a common view across all departments of the interactions it has with
customers or with properties. GIS ties together all ofthe work the City does as well as its interactions
with a given location, enabling power analysis and spatial trend identification.
Customer Facing Systems/Customer Access Channels: These are the services such as the website,
telephone and face-to-face service-s, with which the City's customers interact directly. Beyond
providing information for customers to self-serve, the web should be viewed as a customer service
platform.
Using the web (and apps) and web technologies, customers should be able to interact directly with the
City-submitting and tracking service requests and enquiries, applying and paying for services, booking
City facilities and other routine and complex services. Web apps, and smart phone apps should interact
with business systems to feed requests and applications directly into the systems that back office and
field staff use to process them. In some cases, back office solutions may have public facing components
which can be integrated into the City's website. In other cases, solutions that use the integration layer to
pass customer requests through the CRM and into the back office systems will need to be built. This
allows the CRM to keep a consistent record of interactions between individuals and the City, irrespective
of the department with which they are interacting.
All of the layers are interconnected. Without a stable, secure, infrastructure layer, reliable business
applications cannot support efficient and effective service delivery. Without these back-end
applications, delivery of integrated end-to-end online services cannot be achieved. And without the
integration layer, information remains locked within individual application silos.
The architecture must be implemented from the bottom up-there is simply no other proven way of
doing it.
Prior & Prior Associates page46
--Cf:Jof-~
PlCKE 1 G
Report to
Executive Committee
'
Report Number: CLK 04-16
Date: September 12, 2016
From:
Subject
Paul Bigioni
Director, Corporate Services & City Solicitor
City Policy ADM 160, Customer Service Policy
Bill 8, Public Section and MPP Accountability and Transparency Act, 2014
File: A-11 00
Recommendation:
1. That Council approve revised City Policy ADM 160, Customer Service Policy (Attachment 1 ).
Executive Summary: With the inclusion of the municipal sector under the jurisdiction of the
Ontario Ombudsman and the introduction of Bill 8, municipalities have a renewed responsibility to
strengthen and clearly define their own local complaint mechanisms and policies. This gives the
public a clear path to follow when seeking resolution to an issue. In compliance with Bill 8, City
Policy ADM 160, Customer Service Policy has been revised to include more detail regarding our
complaint resolution process.
Financial Implications: None.
Discussion: The Ontario Ombudsman's Office can conduct investigations into
municipal matters based on complaints received directly from the public. Members of the public
will be able to utilize the Ontario Ombudsman if they do not feel their complaints are being heard
by their municipality. It is important that the City have clear guidelines for receiving feedback and
resolving issues relating to public complaints. The Ontario Ombudsman will only investigate a
complaint once local complaint processes have been completed.
Revisions to ADM 160 include additional details regarding the City's complaint tracking and
response procedures, and actions for staff to take in the event they are contacted by the Ontario
Ombudsman.
Attachments:
1. City Policy ADM 160, Customer Service Policy (draft)
53
01 Definitions
01.01
01.02
01.03
01.04
01.05
01.06
01.07
01.08
Accessibility Standards-Ontario regulation 429/07 created under the
Accessibility for Ontarians with Disabilities Act, 2005, (AODA) which provides for
standards to enhance the accessibility of an organization.
Bill 8 -is the Public Sector and MPP Accountability and Transparency Act,
2014. This legislation makes changes to the Ontario Ombudsman's mandate,
expanding their jurisdiction to municipalities which allows the Ombudsman to
investigate municipal complaints.
Complaint -any expression of dissatisfaction about the action or lack of action
taken regarding operations, facilities or services provided by the City of
Pickering or by a person or body acting on behalf of the City. The term
"dissatisfaction" is key to the definition of a complaint. Feedback of a positive or
general nature, comments on a service or facility that do not require a response,
or requests for service, are not complaints. Complaints imply that the
complainant is unhappy with the service received, and that they require a follow-
up in response to the issue.
Customers:
a) all staff;
b) Mayor & Members of Council;
c) other political representatives;
d) citizens and visitors to the City of Pickering;
e) businesses;
f) volu-nteers and agents recognized by the City; and
g) all community stakeholders.
Feedback-means an opinion, comment, or expression of interest with respect
to a City program or service.
Ontario Ombudsman -an official whose function is to investigate in an
independent manner any decision or recommendation made or done or omitted
in the course of the administration of the municipality.
Service Level Standard -A standard defining customer service best-practices.
Service request-a service request can be received through various service
channels and shall be responded to in compliance with corporate policies and
procedures. Service requests may be a complaint, issue, or simply a request for
service.
Policy Title: Customer Service Page 2 of 5
56 Policy Number: ADM 160
02 Scope and Responsibility
02.01 Anonymous allegations or allegations made on behalf of an unidentified third
party will not be considered or investigated, with the exception of complaints
that are an immediate threat to safety.
02.02 , This Policy applies to all municipal employees.
02.03 This Policy is not meant to address:
a) issues already addressed by legislation, or an existing Municipal by-law,
policy or procedure;
b) services of the municipality where there already exists a right of appeal or
process to complain;
c) a decision of Council or a decision of a Standing Committee; or
d) internal employee complaints.
03 Guiding Principles
03.01
03.02
03.03
03.04
All complaints Will be treated in a confidential manner in order to protect the
complainant's privacy in accordance with the Municipal Freedom of Information
and Protection of Privacy Act 1990, subject to the need to disclose such
information as may reasonably be necessary in order to properly investigate the
matter.
Review of complaints shall be impartial and respectful to all parties involved.
As per the City of Pickering's service level standards, complaints should be
documented and acknowledged within one business day. This includes an initial
response to the complainant advising of anticipated action and timeline for
response. Given the nature of the issue or concern, these timelines are flexible.
The City will regularly monitor and review complaints to identify issues, trends,
areas of concern, and opportunities for improvement.
04 Procedure for Submitting and Processing a Complaint
04.01 A complaint may be given verbally (in person or by telephone) or in writing.
Policy Title:
Written complaints can be submitted using the City's Feedback Form available
on the City's website and in City facilities, or in another format (i.e. email,
handwritten, social media, etc.). Complaints should include:
a) the specific details of what occurred;
b) date of occurrence including time, day, month and year;
Customer Service
Policy Number: ADM 160
Page 3 of 5
57
04.02
04.03
04.04
04.05
04.06
04.07
04.08
05 Training
c) who was involved;
d) what outcome is being sought; and
e) contact details for the complainant.
All complaints will be forwarded to the Customer Care Centre. Complaints will
be tracked by the City's tracking system. Customer Care staff will forward the
complaint to the appropriate department for action and follow up.
Complaints received by other Departments will be handled according to the
Customer Service Policy and corresponding Standard Operating Procedures.
Customer Care staff will follow up with staff responsible on the agreed upon
follow-up date to ensure the complaint is being responded to. Once the issue
has been. resolved, the complaint will be ,closed in the system.
Complainants shall be provided with the contact information for the Ontario
Ombudsman's Office and other options available to them in the event that they
are dissatisfied with the City's complaint process or outcome.
If any City staff are contacted by the Ontario Ombudsman's office, they must
advise the City Clerk to keep track of calls.
In order to ensure effective response timelines to citizen requests, concerns or
enquiries the service expectations have been determined for the following
categories and outlined in Appendix 1 :
a)
b)
c)
d)
mailed or faxed correspondence;
email standards;
telephone and voicemail; and
complaint resolution.
Complete records will be maintained for each complaint. The records will be
maintained in accordance with the City of Pickering's Records Management By-
law. -
Customer service training is the cornerstone of our customer service program. All
employees (including full-time, part-time, term, temporary, and volunteers) receive training
on the City's customer service program. Customer service training is included in our
employee orientation sessions.
Training is based on our service level standards including:
• customer car~ values;
Policy Title: Customer Service
58 Policy Number: ADM 160
Page 4 of 5
• telephone/voicemail standards;
• email standards;
• correspondence standards;
• complaint resolution; and
• accessibility standards.
06 Feedback
Customer feedback is an integral component of our service delivery program, providing
opportunities to l~arn and improve. We value feedback about our programs and services
and recognize the right of our citizens to make a complaint, compliment or suggestion
about our services. We are committed to using customer feedback to improve/enhance
our service delivery. All customer feedback is monitored by our Customer Care Centre,
tracked, and responded to.
07 Accessibility Standards
The City will use reasonable efforts to ensure that its policies, practices and procedures
are consistent with the following principles:
07.01
07.02
07.03
07.04
The goods or services must be provided in a manner that respects the dignity
and independence of persons with disabilities.
The provision of goods or services to persons with disabilities and to others
must be integrated unless an alternate measure is necessary, whether
temporarily or on a permanent basis, to enable the person with a disability to
obtain, use or benefit from the goods or services.
Persons with disabilities must be given an opportunity equal to that given to
others to obtain, use or benefit from the goods or services.
We will use reasonable efforts to ensure that the policies, procedures and
practices are consistent with the following principles:
• dignity;
• independence;
• integration, except when alternate measures are necessary to meet the
needs of people with disabilities; and
• equal opportunity.
Please refer to all associated Procedures and Standard Operating Procedures, if applicable, for
detailed processes regarding this Policy.
Appendices
Appendix 1 Service Level Standard Guidelines Summary
Policy Title: Customer Service
Policy Number: ADM 160
Page 5 of 5
59
--Cit/ oJ--
PJCKER1NG
Report to.
Executive Committee
Report Number: CLK 05-16
Date: September 12, 2016
. From: Paul Bigioni
66
Director, Corporate Services & City Solicitor
Subject: 2017 Committee and Council Meeting Schedule
Recommendation:
1. That the 2017 Standing Committee and Council Meeting Schedule included as Attachment 1
to this report, be approved; and
2. That the draft by-law to amend Procedural By-law 7212/12, providing for revised meeting
dates, as noted in Attachment 2, be approved.
Executive Summary: In accordance with the Municipal Act, 2001, every municipality and
local board shall pass a procedure by-law for governing the calling, place and proceedings of
meetings. The attached By-law provides notification of the meetings of Council.
Financial Implications: There are no financial implications.
Discussion: The City of Pickering Procedural By-law provides for governing the
calling, place and proceedings of meetings. In accordance with the intent of the Municipal Act, of
open, transparent and accountable government, the 2017 meeting schedule, as required by the
Procedural By-law 7212/12, is presented in order for public notification to commence.
As a result of the Region of Durham making changes in their meeting structure, and in order for
the City's meeting schedule to align with the Region's schedule, the following change has been
made to the City of Pickering meeting dates within the Procedural By-law:
Standing Committee Meetings will be the 1st Monday of each month
Council Meetings will be the 2nd Monday of each month
One additional Council meeting has been scheduled for February 27th in order to facilitate an
earlier approval of the 2017 Budget. Also, staff have scheduled the last Committee and Council
meetings before the summer recess for the last two Mondays in the month of June, with Council
recessing for the months of July and August.
70
-------~~1~----
PlCKERlNG
From: Paul Bigioni
Director, Corporate Services & City Solicitor
Report to
Executive Commi.ttee
Report Number: FIN 16-16
Date: September 12, 2016
Subject: Establishment of the Accelerated Infrastructure Program (AlP) Reserve
Recommendation:
1. That Council approve the establishment of the Accelerated Infrastructure Program (AlP)
Reserve;
2. That Council authorize the Division Head, Finance & Treasurer to transfer any unused funds
from the AlP Levy to the AlP Reserve and this transfer be permitted until the end of the AlP
program;
3. That Council authorize the Division Head, Finance & Treasurer to fund any budget shortfalls
related to the AlP capital projects from the AlP Reserve; and
4. That the appropriate City of Pickering officials be authorized to take the necessary actions as
indicated in this report.
Executive Summary: As per Report FIN 05-16 Recommendation 1d), Council approved
$557,000 for the Accelerated Infrastructure Program (AlP) Special Levy in the 2016 Budget. The
AlP levy will generate $557,000 per year to fund the debt.charges related to the AlP capital roads
projects. After Council approval of the budget, staff commence work on the various capital
projects. There are situations in which the project start date may be delayed for various reasons,
resulting in excess budget funds. The above recommendations direct the surplus funds to the AlP
Reserve to fund any unanticipated cost increases. ·The AlP Reserve will serve as contingency
provision for any project shortfall either at the tendering stage or construction phase. If all of the
phase one AlP projects are under budget and if there are funds remaining in the AlP Reserve,
staff will bring forward a Report to Council seeking Council's authority to apply the surplus dollars
to the phase two AlP projects, including Kinsale Road, Sandy Beach Road, Sideline 14 and
Westney Road reconstruction.
FIN 16-16
Subject: Establishment of the Accelerated Infrastructure
Program (AlP) Reserve
September 12, 2016
Page 2
Financial Implications: The establishment of the AlP Reserve allows for the special levy
being raised to be set aside to fund the projects when they are ready to proceed. All projects
approved in the AlP have a 1 0-year debt-financed component. Debenture financing will be
undertaken when projects are ready to proceed. Based on the current preliminary status of all four
AlP projects, proceeding either in late 2016 or early 2017, the City will not undertake any
debenture financing in 2016. As a result, the unused AlP funds will be transferred to the AlP
Reserve as per Recommendation 2.
Discussion: . In the 2016 Capital Budget, the following four projects were approved under the
AlP program, and the approved sources of funds are as follows:
Account Project Description Gross Cost Sources of Funds
5320.1631 Sixth Concession Road $1,550,000 Debt 10-Year $1,550,000
Reconstruction and Storm
Sewer Replacement.
5320.1632 Westney Road $1,550,000 Debt 10-Year $1,550,000
Reconstruction
5321.1608 Salem Road Reconstruction $2,200,000 DC Reserve Funds $1,100,000
Debt 10-Year $1,100,000
5321.1609 Sandy Beach Road-EA, $600,000 DC Reserve Funds $300,000
Design & Approval Internal Loan 1 0-Year
$300,000
At the time of writing this report, the preliminary status of the AlP projects are presented below:
Account Project Description Status
5320.1631 Sixth Concession-Road To have package ready to tender late
Reconstruction and Storm Sewer 2016. Depending on weather
Replacement. condition, may hold off tender and
construction until spring 2017.
5320.1632 Westney Road Reconstruction Scheduled.for spring 2017.
5321.1608 Salem Road Reconstruction To have-package ready to tender late
2016. Depending on weather
condition, may hold off tender and
construction until spring 2017.
5321.1609 Sandy Beach Road-EA, Design & Working on RFP. Scheduled to be
Approval awarded in late 2016.
71
FIN 16-16
Subject: Establishment of the Accelerated Infrastructure
Program (AlP) Reserve
Recommended for the consideration
of Pickering City Council
~ ~.LS,zotb
Tony Prevedel, P.Eng.
Chief Administrative Officer
September 12, 2016
Page 4
73
74
--/}~? /1'--L-Uf; '"'()
PlCKERlNG
From: Paul Bigioni
Director, Corporate Services & City Solicitor
Subject: Cash Position Report as at June 30, 2016
Report to
Executive Committee
Report Number: FIN 17-16
Date: September 12, 2016
Recommendation: That Report FIN 17-16 from the Director, Corporate Services & City
Solicitor be received for information.
Executive Summary: This report presents the City of Pickering's cash position, continuity of
taxes receivable, outstanding investments, development charges collected, other development
contribution information and building permits issued for the six months ended June 30, 2016.
Significant factors that affect the overall cash position of the City in the first half of 2016 are as
follows:
• $1.7M-City portion of development charges collected from January to June 2016. This is the
fourth highest amount collected over the same period in the last 10 years ($2.6M collection in
2012, $2.2M in 2013 and $1.9M in 2008).
• 421 -total building permits issued in the first six months of 2016. This is the third highest
number of permits issued over the same period in the last 10 years (503 permits issued in
2012 and 466 in 2013).
Financial Implications: The financial position of the Corporation for the six months ended
June 30, 2016 was a net increase in cash of $4,653,003 (from $6,823,254to $11 ,476,257).
Sources of funds during the period totaled $151,716,311 against total uses of funds of
$147,063,308.
Discussion: This report presents key operational indicators over a six-month. period of activity
ending June 30, 2016. Similar indicators from prior years are also presented, if applicable, for
comparison purposes.
Statement of Cash Position: Attachment 1 presents the City's relevant sources and uses of funds
for the period January to June, 2016. Subcategories are listed are for those transactions with
material values. At the end of the reporting period, the City accumulated a net increase in cash of
$4.6M. Note that this net increase in cash may not be comparable over the same period from
prior years due to timing differences in receipts and disbursements of cash due to variations in tax
due dates.
Report FIN 17-16
Subject: Cash Position Report as at June 30, 2016
September 12, 2016
Page 2
Continuity of Taxes Receivable: Attachment 2 summarizes all tax-related transactions from
January to June, 2016 and provides the total outstanding taxes receivable as at June 30, 2016.
The total amount comprises all taxes billed for the City, Region and School Boards including
amounts owing for the September 28th residential and commercial final due date.
The following is the summary of taxes receivable:
• Current year as at June 30, 2016:
o Taxes billed to date: $201.1 M (includes final residential and commercial taxes due later in
the year)
o Tax payments and adjustments: $119.8M
o Taxes receivable at June 30, 2016: $88.5M (includes final residential and commercial
taxes due later in the year)
Outstanding Investments: Attachment 3 lists the short and long term investments for both Current
and Reserve Funds outstanding as at June 30, 2016. Total investment portfolio at the end of the
period is $113.5M with $109.1M from general investments and $4.4M from internal loans. The
portfolio varies year to year depending primarily on the timing of collection and remittance of
development charges and supplementary taxes.
Development Charges Collected: The City is responsible for the collection of development
charges on behalf of the City, Region and School Boards. Attachment 4 shows a total collection of
$4.6M for the period, with $1.7M for the City, $2.6M for the Region and $0.3M for the School
Boards.
Note that development charges collected as reported under the Sources of Funds on Attachment
1 does not match with the remittance amounts to the Region and School Boards under the Uses
of Funds, also in Attachment 1. This discrepancy is a result of 1) timing differences in payments
to the Region and School Boards, as monies become payable 25 days following the month of
collection, and 2) the City portion is not reported as a line item under the Use of Funds.
Other Development Contributions: Attachment 5 is provided to show other significant
development contributions specifically from the cash-in-lieu of parkland received in the first half of
2016.
Multi Year Receipts: The rest of the Attachments show multiyear receipts of the City's portion of
development charges, as presented on a column chart. The total collection of $1.7M in the first
half of 2016 is the 4th highest first half of the year collection in the last 10 years. Only collections
during the first six months of 2008, 2012 and 2013 were higher than $1.7M.
Similarly, the 421 building permits issued in the first half of 2016 represents the third highest
number of permits issued in the last 10 years, behind the 503 permits issued during the same
period in 2012 and the 466 issued in 2013.
75
Sources of Funds:
Accounts Receivable collected
Development charges collected *
Operating
Grants-in-lieu:
Federal
Provincial
Ontario enterprises
Municipal enterprises
Linear Properties
Federal specific grants
Ontario specific grants
Interest Income
Sale of land
Tax payments received
POA Revenue
Total
Use of Funds:
Operating and Capital Expenditures
Payroll
Region Levy
Regional portion of Dev. Charges
School Board Levies
School Board portion of Dev. Charges
Debenture payment to Region
Total
Net Cash Increase (Decrease)
Current Fund
TOTAL
*Includes City, Region and School Boards
ATTACHMENT#J~TO REPORT# Pri\J ... !7-f ~
City of Pickering
Statement of Cash Position
for six months ending June 30, 2016
$ 678,055
4,616,342
45,359,729
915,698
1,030,463
4,049,602
1,412,306
-
48,036
137,532
267,420
-
93,148,635
52,493
$ 151,716,311
$ 23,307,127
21,576,709
76,340,730
2,420,355
21,896,839
240,680
1,280,868
$ 147,063,308
$ 4,653,003
FINANCIAL POSITION
Bank Balance Net Cash Bank Balance
January 1, 2016 Provided (Used) June 30, 2016
$ 6,823,254 $ 4,653,003 $ 11,476,257
$ 6,823,254 $ 4,653,003 $ 11,476,257
77
Building Permits Issued
2006-2016
900~----------------------------------------------~-------------------------------
800+-------------------------------------------------------~----------------------
~ 700+-------------------------------------------------~----------------------------------
j 600+-------------------------------------------~~-----------------------------------
l{l ·~ 500+-------------------------------------~~tr~n---~~----------------------
8. g' 400 +--------------':..:_:_ ___________ --____ --l
:2 al 300
'(;
!)_ 200
100
0
2006 2006 2007 2007 2008 2008 2009 2009 2010 2010 2011 2011 2012 2012 2013 2013 2014 2014 2015 2015 2016
1st 2nd 1st 2nd 1st 2nd 1st 2nd 1st 2nd 1st 2nd 1st 2nd 1st 2nd 1st 2nd 1st 2nd 1st
Half Half Half Half Half Half half Half Half Half half half half Half half Half Half Half Half Hlaf Half
ENG 21-16
Subject Proposed Amendments to the Traffic & Parking
By-law 6604/05 -Various Locations
September 12, 2016
Page2
Before the parking restrictions were implemented in 2008, .notice was given to 67 homes in the
area. A total of 16 replies with 13 in support and 3 in opposition to restrictions on the curve were
received.
A letter dated January 8, 2016 was delivered to 67 homes on Brookshire Square regarding the
potential removal of on-street parking re~trictions on Brookshire Square. The letter asked area
residents to indicate their support or opposition to the potential removal of on-street parking
restrictions along the north eastern curve on Brookshire Square. Of the 67 homes on Brookshire
Square surveyed, 24 replies were generated with 19 in support of the removal of parking
restrictions and 4 in opposition to the removal of parking restrictions along the curve.
Many residents who were in favour of the removal mentioned that the restrictions were requested
to be put in place due to a neighbour dispute, not because of traffic operational issues, which the
2008 report stated. However, those opposed to the removal stated that the restrictions do help
with vehicular sightlines.
Therefore, based on the comments received from area residents and staff review, City staff have
concluded that a full removal of parking restrictions along the curve is not necessary. Rather, a
partial removal of parking restrictions at the south end (approximately 10 metres) is
· recommended. Only parking restrictions along the actual curve would remain.
The proposed parking restriction removal on Brookshire Square is shown graphically in
Attachment 1.
Parking Restrictions are proposed on Merritton Road
Concerns have been received by City staff regarding vehicle parking from the area resident on
Merritton Road. Merritton Road is a no exit road with one residence and multiple commercial
businesses. Currently, visitors and customers to those businesses park on the shoulder of both
sides of the street.
To assist with vehicle access and sightlines, parking restrictions on Merritton Road were
implemented in July, 2015. However as a result of these parking restrictions, the area resident
has experienced additional difficulty with entering and exiting the residence due to visitors and
customers to the businesses parking closer to the resident's driveway. The owner of the residence
has asked for permanent restrictions at their driveway so that they can enter and exit the
residence safely.
In response to this concern, Engineering & Public Works staff have completed a review and
temporary parking restrictions were placed on Merritton Road at the area resident's driveway until
permanent restrictions could be implemented. The temporary parking restrictions have been in
place since the winter with no complaints from the area resjdent or the businesses. Therefore,
Engineering & Public Works staff recommend that permanent restrictions be placed on the south
side Merritton Road in front of the area resident's house.
CORP0227-07/01 revised
85
86
ENG 21-16
Subject: Proposed Amendments to the Traffic & Parking
By-law 6604/05 -Various Locations
September 12, 2016
Page 3
The proposed parking restriction on Merritton Road is shown graphically in Attachment 2.
Parking Restrictions are proposed on Chickadee Court
The Region of Durham has raised concerns that waste collection vehicles are having difficulty
turning onto Chickadee Court from the new development at the south east section on the road,
south of Sparrow Circle. This issue occurs during the daytime only when vehicles are parked on
the west side of the Chickadee Court.
To avoid this conflict from occurring, Engineering & Public Works staff recommends that a portion
of Chickadee Court, south of Sparrow Circle have parking restricted on the west side of the road.
The parking restrictions are being proposed as Mondayto Friday, 7:30 am to 4:30 pm only,
excluding holidays, to minimize any inconvenience to area residents,
The proposed parking restriction on Chickadee Court is shown graphically in Attachment 3 ..
A yeild sign is proposed on Spartan Court
The extension of Spartan Court to the north where the road previously only curved south has
created an uncontrolled intersection where Spartan Court intersects with itself. The east/west
portion of Spartan Court now intersects directly with the north/south portion of the road creating an
uncontrolled intersection where possible vehicular conflicts could occur. Although Spartan Court is
a low volume road and is not a through street, it is recommended that a yield sign be placed on
the east/west approach of the intersection to minimize vehicular conflicts and to designate right of
way.
The proposed yield condition on Spartan Court is shown graphically in Attachment 4.
The proposed Traffic and Parking By-law 6604/05 Amendment, Schedule 2, No Parking and
Schedule 8, Yield Right of Way Signs is provided in Attachment 5.
Attachments:
1. Partial Removal of Parking Restrictions, Brookshire Square
2. Proposed Parking Restrictions, Merritton Road
3. Proposed Parking Restrictions, Chickadee Court
4. Proposed Yield Control, Spartan Court
5. Being a by-law to amend By-law 6604/05 providing for the regulating of traffic and parking,
standing and stopping on highways or parts of highways under the jurisdiction of the City of
Pickering and on private and municipal property
CORP0227-07/01 r~vised
92
The Corporation of the City of Pickering
By-law No.
Being a by-law to amend By-law 6604/05
providing for the regulating of traffic and
parking, standing and stopping on highways or
parts of highways under the jurisdiction of the
City of Pickering and on private and municipal
property.
Whereas By-law 6604/05, as amended, provides for the regulating of traffic and parking
on highways, private property and municipal property within the City of Pickering; and
Whereas, it is deemed expedient to amend Schedule 2 and Schedule 8 to By-law
6604/05 to provide for the regulation of parking restrictions and stop signs on highways
or parts of highways under the jurisdiction of the Corporation of the City of Pickering,
specifically to address the proposed on-street parking on Brookshire Square, Merritton
Road and Chickadee Court, and a proposed yield condition on Spartan Court.
Now therefore the Council of The Corporation of the City of Pickering hereby enacts as
follows:
1. Schedule 2 to By-law 6604/05, as amended, is hereby further amended thereto
by the following:
Schedule 2
No Parking
Column 1 Column 2 Column 3 Column 4
Highway Side Limits (From/To) Prohibited Times
or Days
Delete
Brookshire Square Inside Loop Anytime
(as per Appendix 2c)
94
·By-law No. ATTACHMENT# 5""_ TO REPORT# __ f_N 0 02 f -1 (c:;
-~ . j __ of 3_
By-law passed this 19th day of September, 2016.
David Ryan, Mayor
Debbie Shields, City Clerk
Page 3