The vendor is required to provide information technology consultants annually for new applicants.
- Professional services in one of the below categories for shorter lengths of time and that fall underneath the roster cap of $130,000.
- Roster categories:
1. Business intelligence services
• Administration of the sap business objects suite, including:
o Bi launchpad
o Crystal reports
o Webi
o DATA services
• Administration of the microsoft SQL server suite, including:
o Power bi
o Reporting services
o Analysis services
o Data base engine
o Integration services
• Administration of the microsoft power suite, including:
o Power bi
o Power automates
o Power apps
o Copilot
• Product and solution development and implementation of:
o Sap business objects suite
o Microsoft SQL server suite
o Microsoft power suite
• Administration and modification of custom-built applications and interfaces, written in the following languages:
o Python
o Drupal
• Experience working with API's (restful and soap) to expose and consume data.
• Experience in branching, merging code, continuous testing and software delivery pipelines and containers using visual studio, test manager, azure DevOps, azure pipelines or other tools.
• Experience preparing wireframes, mock-ups and prototypes that clearly illustrate functionality using responsive design to create applications that automatically conform to multiple screen sizes/devices.
• Experience designing mobile apps
• Experience with digital accessibility design aspects
• Experience with data governance best practices
• Review, define and document business intelligence strategies  2. GIS services
• administration of the ESRI suite of products, for example:
o ArcGIS server
o ArcGIS portal
o ArcGIS pro
o ArcGIS online
• Creating and editing spatial data sets, for example:
o Buildings
o Road networks
o Land parcels
o Civic addresses
o Fire and emergency response zones
• Spatial analysis support such as:
o Route optimization for service provision and response
o Demographics and population awareness
o Taxation rate calculations
o Traffic patterns and road management
o Hazard, risk and vulnerabilities that can impact agency
o Active transportation planning
• Creation of spatial visualization tools including traditional topographic maps and interactive on-line story-based applications
• Processing of aerial and terrestrial captured photography for both 2d and 3d applications
• Review, define and document GIS strategies
• Expertise in GIS architecture
3. Enterprise architecture and solutions architecture services
• Transforming business and technical requirements into architectural models and designs
• Evaluation and selection of software solutions
• Documenting the solution architecture for new solutions in the context of the overall agency landscape
• Defining and documenting integration architecture design for new solutions
• Performing detailed design and code reviews as required
• Review, define and document strategic roadmaps and solution roadmaps
• Documenting environment specifications for new solutions
• Reviewing, defining and documenting enterprise architecture domain guidance
• Reviewing, defining and documenting domain reference architectures
• Analyzing current trends in technology architecture and educating about new frameworks and best practices
• Implementation and integration experience with both SaaS and on-premise solutions
4. Cyber security
• Penetration testing
• Vulnerability scanning
• Threat risk assessments
• Organizational information security risk management
5. Infrastructure services
• Disaster recovery and backup services
o Capacity planning
o Optimization
o Veeam
• Storage, virtualization and hyperconverged infrastructure
o Capacity planning, performance analysis and architecture
o VMware (ESXI)
o VxRail
• Networking and communications
o Architecture, analysis and troubleshooting
o Cisco, switcher, routers and firewalls
o Fortinet switches, routers, firewall and other applications
• Citrix
o Administration and implementation
o Architecture and performance analysis
o Capacity planning
• Cloud services
o Administration, configuration and licensing
o o365
o MS azure
• Monitoring, discovery and testing
o Administration, configuration and operations
o Netwrix
o Orion SolarWinds
o Tenable
- Professional services roles
1. Project management services
• Define, estimate and plan project tasks, resources, timelines and milestones
• Prepare for technology solutions and participate in evaluations
• Develop, maintain, execute, and monitor project plans
• Develop and manage budgets, forecasts and expenditures
• Identify, document, report and mitigate project risks and issues
• Manage the project team, tasks and timeline
• Responsible for project communications and regular status reporting
• Responsible for completion and quality of project deliverables
• Responsible for operational readiness and post go live support documentation
• Other project management work as required.  2. Business analyst services
• Organize and facilitate requirements sessions
• Prepare requirements documents
• Translate the business requirements into functional and non-functional requirements
• Assist with the development and evaluation for technology solutions
• Create user acceptance (UAT) test plan and test cases and lead UAT
• Lead and support training including preparation of training material
• Completed business process mapping
• Research best practice and incorporate into analysis
• Preparation of business cases
• Perform analysis by applying various analysis techniques such as swot, roi, and gap analysis
• Review applicable technologies as part of business case preparation  3. Change management services
• Plan and lead all change management activities working with project teams and business units
• Responsible for producing all change management project deliverables including but not limited to change management strategy and plan, training plan, business readiness assessments, and communications plan 
• Develop and implement change management strategies, plans, and framework 
• Provide expertise, consultative advice, guidance and coaching in terms of change management strategies, approach and related tools
• Lead and or provide support to training including preparation of training material 
• Other change management work as required.
4. Privacy impact assessment services
• Review of relevant project deliverables 
• Review of applicable municipal, provincial and federal legislation and related municipal policies, procedures and associated documents, e.g., previous privacy impact assessments 
• Collaborate with the agency project team and business stakeholders on privacy related matters 
• Identify stakeholders and assess privacy impacts and potential risks 
• Conduct the privacy impact assessment, evaluate results and present findings following agency guidelines for conducting the pia 
• Complete a pia report identifying any privacy risks resulting from the implementation of solution and include specific mitigation recommendations to address the identified risks 
• Provide privacy advice identifying privacy related matters including but not limited to privacy risks and associated remediation options addressing the identified risks.
- Contract Period/Term: 2 years
- Questions/Inquires Deadline: July 04, 2025