21-11-2019

8 weeks



The work

UX/UI de­sign

Project scop­ing

Web ap­pli­ca­tions



The tech

Spring Bot

TRANSPORT & MAIN ROADS LEGACY MIGRATION

Excel mi­gra­tion to a mod­ern web ap­pli­ca­tion for a Government sys­tem

In 2019, the Department of Transport and Main Roads (TMR) com­menced a proof of con­cept with WorkingMouse to de­ter­mine the value as­so­ci­ated with their unique mi­gra­tion meth­ods in con­junc­tion with the Codebots tech­nol­ogy.

4

Weeks in scop­ing

8

Weeks in de­vel­op­ment

380

Tickets com­pleted

Understanding the prob­lem

01

How might we mi­grate an ac­cred­i­ta­tion scheme from Excel to Web?

In 2019, the Department of Transport and Main Roads (TMR) com­menced a proof of con­cept with WorkingMouse to de­ter­mine the value as­so­ci­ated with their unique mi­gra­tion meth­ods in con­junc­tion with the Codebots tech­nol­ogy.

TMR’s goal is to progress their dig­i­tal trans­for­ma­tion by mod­ernising an ac­cred­i­ta­tion scheme from an of­fline Excel sys­tem to a cloud-based, full-stack ap­pli­ca­tion with OpenAPI spec­i­fi­ca­tion doc­u­men­ta­tion.

Ideation

01

Determine which Codebots plug-ins can be im­ple­mented im­me­di­ately

In or­der to align with the Department’s ex­per­tise, WorkingMouse de­liv­ered the ap­pli­ca­tion us­ing a Spring server side and Angular client side.

WorkingMouse cre­ated a mod­ern, mi­croser­vice-ready ap­pli­ca­tion de­ployed into AWS cloud. The ini­tial proof of con­cept was de­liv­ered in 4 weeks with a fur­ther 8 weeks planned to have it ready for pro­duc­tion. The ap­pli­ca­tion has a CRUD User Interface, data mi­gra­tion ca­pa­bil­i­ties, ad­vanced gov­er­nance con­trols, and full API doc­u­men­ta­tion.

The Solution

01

A mi­gra­tion to a mod­ern web ap­pli­ca­tion

The pro­ject was part of the Department’s broader dig­i­tal trans­for­ma­tion strat­egy with a view to con­nect­ing to both up­stream and down­stream sys­tems, al­low­ing for re­port­ing and ease of dis­sem­i­na­tion of in­for­ma­tion.

As the ap­pli­ca­tion was mod­elled, the Department now has an ex­ten­si­ble so­lu­tion that can grow with their re­quire­ments, for ex­am­ple to sup­port other man­aged ac­cred­i­ta­tion schemes. Business op­er­a­tions change so it’s cru­cial that the tech­nol­ogy that sup­ports them can change too.

The team

\