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

David Burkett

Head of Growth

Jake Wood

Head of Operations

Rhiannon Stevens

Product Designer

Csharpbot

Software Developer

Check out some other pro­jects …

Aptus Design System

Aptus uses patented cou­pler tech­nol­ogy to stream­line the con­struc­tion process. Their unique tech­nol­ogy, paired with a de­sign sys­tem that en­sures qual­ity has led to cost and time sav­ings in the con­struc­tion in­dus­try.

Central Highlands Website Development

In part­ner­ship with WorkingMouse, CHDC has re­de­vel­oped their web­site to bet­ter sup­port the re­gion and cre­ated a new plat­form that changes the way stake­hold­ers can in­ter­act with lo­cal in­dus­tries.

Kindred Engagement Portal

Kindred Property Group is one of the fastest-grow­ing real es­tate agen­cies in Queensland. The com­pany is on a mis­sion to im­prove the way cus­tomer ser­vice is han­dled within the real es­tate in­dus­try by lever­ag­ing tech­nol­ogy.

Still look­ing for more?

Sign up for the lat­est up­dates to our Way of Working, case stud­ies and more.