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 Java 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. One of the in­escapable truths men­tioned above is that knowl­edge is al­ways miss­ing. We mit­i­gated the risk by doc­u­ment­ing and mod­el­ling at every stage.

“”

—

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.

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.