Development

Medaur Hospital Information Management System

Transformed fragmented Excel databases into an intuitive hospital management system that unified 32,000+ patient records and eliminated years of duplicate data chaos

Client ORL Medaur

Year 2026

Services UI/UX Design, TypeScript Development, API Integration

Duration 2 months

The Challenge

ORL Medaur's patient data was scattered across dozens of Excel files, creating a nightmare for medical staff. The biggest pain point: when patients returned for follow-up visits, they were entered as entirely new records rather than linked to their existing history. A patient who visited in 2007, 2015, and 2024 existed as three separate entries with no connection between them. Doctors had no unified view of a patient's medical journey—they couldn't see previous diagnoses, treatments, or notes without manually searching through multiple spreadsheets. Appointments were tracked on paper calendars, data entry took excessive time, and the entire system was fragile, unsearchable, and prone to human error.

Our Role

We handled all design and frontend development for this project, collaborating with a backend team handling the Django REST Framework API. We were responsible for the complete UI/UX design system, all frontend development using TypeScript, and full API integration to connect the interface with the backend. From wireframes to production code, we owned the entire user-facing experience.

The Approach

Our core strategy was radical simplification for non-technical medical staff who have zero tolerance for learning curves. Healthcare workers need to focus on patients, not software—so the system had to be immediately intuitive. We designed every interaction to require minimal clicks, used familiar medical workflows as the structure, and prioritized visual clarity over feature density. The goal was to build something that feels like it's helping, not something that needs to be "figured out."

Discovery & Research

We started by shadowing medical staff for a full day to observe their actual workflows. We watched them flip through paper appointment books, search Excel files by patient name, and manually copy data between spreadsheets. Through interviews with doctors and administrative staff, we identified the critical pain points: duplicate patient entries, no visit history visibility, and time wasted on data entry. We mapped out their current process—from patient check-in to appointment scheduling—and identified where the system was creating friction. The key insight: they didn't need a complex hospital management platform; they needed a fast, visual interface that consolidated scattered data into a single source of truth.

Design & Development

We designed a patient-centric interface where every patient card immediately shows their complete visit history in chronological order—solving the duplicate data problem at its core. We used a familiar card-based layout that feels like flipping through organized files rather than navigating software. For appointments, we built a calendar interface that replaced their paper system, with drag-and-drop scheduling and color-coded appointment types. We prototyped the UI in Figma, tested with staff, then moved straight into TypeScript development. The frontend architecture uses a component-based structure for maintainability, with real-time API calls to the Django backend ensuring data stays synchronized. We focused heavily on performance optimization—with 32,000+ patient records, search had to be instant, not laggy. Through careful state management and API response caching, the system feels snappy even with massive datasets.

Final Design

The final system provides a unified patient management interface that consolidates years of fragmented data into a single, intuitive platform. Medical staff can now see a patient's complete visit history—from their first appointment in 2007 to their most recent checkup—in one consolidated view. The built-in appointment calendar replaced paper tracking with digital scheduling, full-text search across 32,000+ records returns results instantly, and the entire interface requires zero training because it mirrors the mental models healthcare workers already use.

Results & Outcomes

The system successfully unified ORL Medaur's entire patient database and eliminated years of data fragmentation. Medical staff now complete patient management tasks in a fraction of the time, with full visibility into patient histories that were previously impossible to access. The digital appointment calendar has completely replaced paper-based scheduling.

Key Achievements

Unified patient visit history view—staff can now see complete medical timeline from first visit to most recent

Eliminated duplicate patient entries that plagued the Excel-based system for years

Built-in appointment calendar replaced paper-based scheduling with drag-and-drop digital system

Instant full-text search across 32K+ records with optimized performance and caching

Zero-training interface designed for non-technical medical staff—intuitive from day one

Real-time data synchronization with Django REST Framework backend

What We Learned

This project taught me that the best software often feels invisible—users shouldn't think about the interface, they should just get their work done. Watching medical staff use the system reinforced how critical it is to design for real workflows, not idealized ones. We initially wanted to add more features, but restraint proved more valuable than complexity. If we were to approach this again, we'd spend even more time upfront observing staff in their natural environment before touching Figma. The biggest surprise was how much performance optimization mattered—users notice the difference between a 200ms search and a 50ms search, even if they can't articulate why. This project fundamentally changed how we think about designing for non-technical users in high-pressure environments like healthcare.