Transport & Main Roads Legacy Migration

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

Springbot

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.

Daltrey Biometric Security

Daltrey’s mis­sion is to re­de­fine how iden­tity is used to cre­ate safer, more se­cure en­vi­ron­ments. Using bio­met­ric tech­nol­ogy, they pro­vide or­gan­i­sa­tions with an iden­tity so­lu­tion that dri­ves se­cu­rity pol­icy from a po­si­tion of trust.

Department of Defence Procurement Platform

The Department of Defence is one the largest Government agen­cies in Australia. WorkingMouse helped im­prove vis­i­bil­ity across their pro­cure­ment spend­ing by con­sol­i­dat­ing a num­ber of dis­parate sys­tems into a cen­tralised ap­pli­ca­tion.

Still look­ing for more?

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

\