Technology Transformation Program

What is it

It's a multi-year, multi-project initiative to overhaul and modernize software systems. This willbuild a technology foundation that will help staff meet and exceed the demands for information and online services, while improving the organization's business processes and operational efficiency.

  • This is an essential program to modernize the District’s business and technology systems.
  • In addition to the new finance system already implemented, the full transformation will include:
    • Replacement of all accounts receivable, taxation and utility billing, municipal ticketing and licensing and the point of sale system;  
    • Recreation management software (including how citizens will book programs);
    • Land management systems;
    • Asset and work order management system.
  • With the digital backbone in place, the program will further expand the District’s web and mobile-friendly services to include activities such as online account services, reporting a problem (i.e. potholes or graffiti) and renewing dog licences.   
  • The program continues to move forward and gain traction. Each new milestone gains operational efficiencies which helps to propel the organization forward and improve service to the community. 


Latest News

July 2020

  • The District’s new Payroll System went live at the end of May and all staff and managers are utilizing the new online tools for time entry, submission, approval and pay processing.
  • The organization continues to expand its utilization of the Core Financials platform. Managers have real-time visibility to any variances between their department’s budget and actual amounts. This information are key inputs to the District’s quarterly Financial reports.
  • The TTP Team is focusing on the implementation of the Development Management system which will streamline and automate tasks for services such as Development Permits, Building Permits and Business Licenses. Launch is scheduled for the Fall 2020 and all can expect quicker and more effective turn-around and response times for application submissions, status checks and approvals.   
  • A 12 week pilot project was launched to configure, test and deploy a new Procurement system. The new system will increase efficiencies with the District’s procure to pay processes by automating several of steps that are involved with creating a requisition, issuing a purchase order, confirming goods receipt and paying the supplier. The pilot project will validate the new module and prepare to roll out to the rest of the organization near the end of 2020.  

January 2020

  • The new Core Financials system is being leveraged by the Finance team for year-end activities, resulting in efficiency gains through its intuitive and robust reporting capabilities. 
  • Work continues on the new Development Management system with the teams optimizing their business processes in anticipation of implementing the new tools in 2020.
  • The new Payroll System is undergoing user testing. A sample of managers, supervisors and staff are putting the new system through its paces and providing feedback to the project team. This “User Acceptance Testing” will be followed by the staff training phase which is the final milestone before Go Live.” 

July 2019

  • Core Financials have been live for a few months, and the project team is focused on post-implementation support for staff, and supporting enhanced report development.
  • The Payroll system testing continues. Development of employee training materials are underway.
  • Development Management user testing was completed. The interdepartmental knowledge transfer of business processes and report development, plus the development of training plans are on deck.

November 2018

  • Core Financials Go Live, including launch of new Chart of Accounts, automated workflow, and new and improved reporting.
  • Payroll started final testing phase.
  • Development Management moved into User Acceptance Testing Phase (UAT).

July 2018

  • Finance started the third and final round of testing.
  • Payroll started the second payroll test run.
  • Development Management moved into Test Phase 3.

June 2018

  • Finance system completed second round of testing.
  • Payroll completed first payroll test run.

May 2018

  • Test Phase 2 for Development Management Project initiated.

February 2018

  • Updated Program Charter and developed Land Data Administration Policy.

December 2017

  • Presentation to Council:
    • Revised Go-live Strategy for Financial Management and Development Management solutions
    • Moved Recreation system project to 2019
    • Extended TTP timeline by one year

September 2017

  • Test Phase 2 for Financial Management Project initiated (Core Financials and Payroll)

Historical Timeline

July 2017

  • Development Management implementation kicks-off with the start of the Tempest Land module

June 2017

  • TTP Benchmarking Plan initiated to measure benefits and ROI of the program.
  • Development Management project started.  Project charter completed and Project schedule established.

May 2017

  • Finance Solution (Payroll): Requirements Phase completed and Build Phase started.

April 2017

  • Fleet Management Solution live
  • Finance Solution: Requirements and Solution Design Phase completed.
  • Fleet Management Solution onsite training completed.

January 2017

December 2016

  • Finance Solution: Requirements workshops completed
  • FDM (Fire Management Software) software and database upgrade completed

October 2016

  • Finance Solution: Planning workshops completed

September 2016

  • SquamishAlert Emergency mass notification solution goes live
  • Finance Solution: Vendor contract negotiations completed and contracts signed

July 2016

  • Finance Solution: Vendor selected

January 2016

  • Technology Transformation Program launched

November 2015

  • Application Technology Roadmap adopted

Why the District needs the TTP

A recent, in-depth technology review identified that many major District systems were nearing end of life and needed replacement or significant upgrades.  With this in mind, the Information Technology (IT) department has significantly invested in, and built-out, its network and virtual server infrastructure to support new software acquisitions which will replace these existing high-risk, outdated, and obsolete software solutions.  These existing systems fall short due to a lack of integration, outdated underlying technology, functional limitations and significant gap areas that require manual workarounds.  Operationally, these current software constraints result in:

  • District challenges in obtaining timely and reliable data to inform management and strategic decisions;
  • Increases to District staff time spent on low value activities such as data entry, manual workarounds and extraction and reconciliation of data;
  • Internal barriers to improving the range and quality of services to the public;
  • Increasing costs and risks to maintain these aging and unsupported systems;
  • Growing levels of citizen frustration due to a lack of modern functionality;

The significant scope of work identified during the internal review brought about the creation of the Systems (Application) Technology Roadmap (SATR), which identified the highest priority areas and derived a planned approach and sequencing to the IT software overhaul. The SATR launched in Spring 2015 and was adopted by Council in November 2015.

The implementation of the Application Technology Roadmap is the Technology Transformation Program (TTP).  This program was launched in January 2016. 

Read the full report.

TTP Status

The first, and most complex project, and largest software acquisition in the TTP is the Core Business Solution - Financial Management implementation.  This monumental project commenced in September 2016 with completion planned for 2018.  A few significant benefits that will come from this project include:

  • A complete rebuild of the District’s chart of accounts which will facilitate improved operational and management reporting;
  • Improved process efficiencies with powerful workflows and  approval routing;
  • Increased public self-service offerings via the web.

This Financial Management solution is the major foundational layer to the building of the District’s integrated Enterprise Resource Planning (ERP) solution over the next four to five years.

A graphical representation of the integrated ERP solution is below. 


Core District Systems

Of the current systems in place, some modern, organization-wide, core systems are offering significant organizational benefit. These include the ESRI geographical information system (GIS), and Sharepoint electronic document and records management system (EDRMS). The District plans to retain these core systems long-term and plans to integrate them with all relevant future solutions.

Links and resources

What is a Systems Technology Roadmap? Why do we have one? What are the benefits? 

Read our Frequently Asked Questions.

Read the Application Technology Roadmap Strategy.

Read the TTP Core Business Solution– Financial Management vendor selection: Report to Council 

Visit the Squamish Open Data portal

Post your comment


No one has commented on this page yet.

RSS feed for comments on this page | RSS feed for all comments