12-05-2019

8 weeks



The work

UX/UI de­sign

Project scop­ing

Web ap­pli­ca­tions



The tech

C# Bot

POLICE NSW LEGACY MIGRATION

Consolidating 7 legacy sys­tems into a mod­ern web app

The NSW Police Force is one of the largest po­lice or­gan­i­sa­tions in the English speak­ing world. To help the Police NSW on their dig­i­tal trans­for­ma­tion jour­ney, WorkingMouse mod­ernised some of their cur­rent legacy sys­tems.

2

Weeks in scop­ing

8

Weeks in de­vel­op­ment

147

Tickets com­pleted

Understanding the prob­lem

01

How might we quickly mod­ernise legacy sys­tems within Police NSW start­ing with the Fatals Database?

In late 2018 WorkingMouse and Codebots qual­i­fied as fi­nal­ists in the NSW Pitch to Pilot pro­gram. As part of the pro­gram we were able to pitch the Codebots fire­cracker mi­gra­tion method via the Codebots plat­form and Continuous Modernisation Playbook to sev­eral se­nior NSW IT lead­ers. Following the event, WorkingMouse was con­tacted by NSW Police Force and given the op­por­tu­nity to pi­lot Codebots within the or­gan­i­sa­tion. The pro­ject com­prised of be­gin­ning to mod­ernise their 200 plus legacy Access data­bases that sit within their op­er­a­tional di­vi­sion.

Ideation

01

Validate with a Proof of Concept

To be­gin, we ran a proof of con­cept that fo­cused on mod­ernising 7 Fatal Crash Microsoft Access Databases. The of­fline sys­tem is used by the traf­fic re­search and in­tel­li­gence unit as part of their traf­fic & high­way pa­trol com­mand. There were three key is­sues the team aimed to tackle. 1. The in­for­ma­tion was stored on out­dated Microsoft Access Databases which is not in line with the Department’s mod­ern web-based skill set. 2. The sup­port re­quired from the in­ter­nal IT de­part­ment was sig­nif­i­cant due to the data­bases break­ing and the con­stant re­load­ing of back­ups. 3. The time it would take for the safety team to copy the data over from the COPS sys­tem on a daily ba­sis.

The Solution

01

A mod­ern .NET web ap­pli­ca­tion mod­elled from the legacy sys­tem

We ap­proached the prob­lem by mi­grat­ing the 7 data­bases into a cen­tral en­tity di­a­gram us­ing the fire­cracker mi­gra­tion path­way. In do­ing so we were able to sim­plify the 7 dif­fer­ent sys­tems down to 1 new mod­ern web based ap­pli­ca­tion. The ap­pli­ca­tion cre­ated is now a mod­ern .Net Core (C#) server side with a React client side. The ap­pli­ca­tion is in line with Police NSW’s mod­ern IT skill set mak­ing it eas­ier to run and sup­port. They are now able to host in their on premise en­vi­ron­ment se­curely. In ad­di­tion to the mi­gra­tion the pro­ject team were able to add on sev­eral use­ful be­hav­iours and func­tion­al­ity. The team added the fol­low­ing: 1. Active Directory in­te­gra­tion for auto lo­gin 2. API to in­ter­nal Oracle DB to au­to­mat­i­cally in­put the new daily data sav­ing a sig­nif­i­cant amount of time. 3. Customer Reports. 4. CRUD be­hav­iour for all en­ti­ties 5. Restful JSON API Overall, the team were happy that the new sys­tem met all tech­ni­cal re­quire­ments from the IT side but also cov­ered all of the orig­i­nal func­tion­al­ity from the old sys­tem.

The team

\