A healthcare firm needed to move its genetic test ordering process online. Physicians across Japan were submitting orders through a patchwork of faxes, phone calls, and email attachments — a workflow that introduced transcription errors and made tracking difficult. eSolia designed, built, and launched a cloud-based order entry system on the PROdb platform that's now used by roughly 5,000 healthcare professionals nationwide.
Project Parameters
| Parameter | Value |
|---|---|
| Team | PM x 1, Developer x 3, Consultant x 1 |
| Users | ~5,000 healthcare professionals |
| Duration | 12 months (development through registration site launch) |
| Sites | Tokyo (client office), nationwide (end users via web) |
What Needed Solving
The client's existing order workflow was manual. Physicians would fill out paper or PDF forms, send them by fax or email, and staff at the healthcare firm would re-key the information into internal systems. Errors crept in at every handoff — misspelled patient names, wrong test codes, incomplete forms that required follow-up calls. Turnaround times suffered.
The firm also lacked visibility into order volume and status. There was no dashboard, no searchable history. When a physician called to check on a test, someone had to dig through files.
The client wanted a web-based system that physicians could use directly — no intermediary data entry, no paper forms.
What We Did
We built the system on eSolia's PROdb cloud database platform, which gave us a head start on the back-end infrastructure (authentication, data modeling, API layer, hosting) without starting from zero.
The order entry application lets physicians log in, select test types, enter patient and specimen information, and generate standardized order documents. Form validation catches errors before submission — required fields, format checks, logical consistency between test type and specimen type. The system produces printable order sheets that accompany physical specimens to the lab.
The registration portal came next. We built a separate website where healthcare professionals register for access to the order system. This included anti-spam measures, an invitation-based onboarding flow with email verification, and a custom furigana-to-romaji conversion API so that Japanese name entry worked smoothly for both the registration database and downstream systems that required romanized names.
We also built a localized marketing website for the client, integrated with PROdb, to support the product's market presence in Japan.
What the Client Gained
- Physicians order tests directly — no fax, no re-keying, no transcription errors
- Built-in form validation catches mistakes before submission, reducing incomplete orders
- Full order history is searchable, so status inquiries take seconds instead of a phone call and a filing cabinet
- ~5,000 healthcare professionals registered and actively using the system nationwide
- The registration portal handles onboarding without manual account provisioning
- Marketing site and order system share a single data platform, reducing integration overhead
Technology Involved
- eSolia PROdb cloud database platform
- Custom web front-end (responsive, mobile-friendly)
- REST API layer for order processing and data exchange
- Furigana-to-romaji conversion API (custom-built)
- Automated email workflows (invitations, confirmations, notifications)
For custom database and web application development, see our PROdb platform and Project Management services.