[Case 02]
Replacing a 12-year-old Access database nobody could read
Commercial Property · Internal Tools
Midshift set out to transform career growth by integrating mentorship, AI-driven roadmaps, and an LMS
In October 2023, Midshift was set out to accelerate career growth through mentorship and complementary services. However, user research uncovered a significant market gap, leading to the AI-generated roadmap becoming the platform’s core service.
[Project Overview]
A commercial property firm ran its billing on a twelve-year-old Access database that only worked if someone edited it by hand, and nobody at the company could read how it worked. I audited the system to map what it actually did, then planned and prototyped a migration to a custom web app and database that connects to Xero, so the team can own their numbers and trust them without paying a developer to explain them. Full case study coming soon.
[Industry]
Commercial Property · Internal Tools
[My Role]
Product Designer & Builder
[Platforms]
Custom web app
[Timeline]
Ongoing