×

Police NSW

The NSW Police Force is one of the largest police organisations in the English speaking world. It's comprised of over 20,000 employees. To help the Police NSW on their digital transformation journey, WorkingMouse modernised some of their current legacy systems.

Introduction

In late 2018 WorkingMouse and Codebots qualified as finalists in the NSW Pitch to Pilot program. As part of the program we were able to pitch the Codebots firecracker migration method via the Codebots platform and Continuous Modernisation Playbook to several senior NSW IT leaders.

Following the event, WorkingMouse was contacted by NSW Police Force and given the opportunity to pilot Codebots within the organisation. The project comprised of beginning to modernise their 200 plus legacy Access databases that sit within their operational division.

Achieve the extraordinary

Free consultation

Process

To begin, WorkingMouse started with modernising 7 Fatal Crash Microsoft Access Databases. The offline system is used by the traffic research and intelligence unit as part of their traffic & highway patrol command.

The project was run in an agile fashion, fixing the time but varying the scope based on organisational priorities.

Problem/Opportunity

Prior to the project there were three key issues the team aimed to tackle.

1. The information was stored on outdated Microsoft Access Databases which is not in line with the Department's modern web-based skill set.
2. The support required from the internal IT department was significant due to the databases breaking and the constant reloading of backups.
3. The time it would take for the safety team to copy the data over from the COPS system on a daily basis.

Solution

To solve these issues WorkingMouse (using the Continuous Modernisation Playbook) approached the problem by migrating the 7 databases into a central entity diagram using the firecracker migration pathway. In doing so we were able to simplify the 7 different systems down to 1 new modern web based application.

The application created is now a modern .Net Core (C#) server side with a React client side. The application is in line with Police NSW's modern IT skill set making it easier to run and support. They are now able to host in their on premise environment securely.
In addition to the migration the project team were able to add on several useful behaviours and functionality. The team added the following:
1. Active Directory integration for auto login
2. API to internal Oracle DB to automatically input the new daily data saving a significant amount
of time.
3. Customer Reports.
4. CRUD behaviour for all entities
5. Restful JSON API

Overall, the team were very happy that the new system met all technical requirements from the IT side but also covered all of the original functionality from the old system.

Our Way of Working delivers the best results

Download now

Powered by Codebots

Over the course of the project, the team achieved the following;
  • 122 requirements completed
  • Customer satisfaction score of 5.5/6
  • 239 UI and API unit tests successfully running
  • Lines of code written by both bots: 48,980 (80% of total written)
  • Lines of code written by C#bot: 32,887 (53.5% of total written)
  • Lines of code written by Reactbot: 16,093 (26.5% of total written) 
  • Lines of code written by humans: 12,458 (20% of total written)

CRUD

Manage your data effectively with the ability to create, read, update and delete records. A flexible and powerful way to unlock data.

Reports

The ability to export data captured by the application in an easy to understand report. Drive business decisions with real data.

Timeline

See what actions have been taken on your application through a timeline. Once a specified activity is performed, it is logged in the timeline section and time stamped.

API

Connect your upstream or downstream system with your present application through APIs. The bots write their own API documentation ready to be integrated into your existing environment.

Admin

Manage your application with administrator privileges. Lock down important parts of the application to administrator access only.

Active Directory

Connect the application through active directory integration so that users can be authenticated without new application specific credentials.