The Positronic Group

Building Powerful Databases for Business

The Royal National Orthopaedic Hospital Stanmore


Project : Recruited to improve the efficiency of the Orthotics Department by creating a virtually paperless system enabling faster and more responsive Patient treatment.

Achievements:

Delivered a newly automated batch process interface to Hospital HL7 system that brings in all Patient Demographic data into SQL database back-end

Designed, tested and implemented a Stores Stock Control system allowing the Orthotics Department to improve it’s Purchase Ordering and see real time stock levels

Dramatically reduced the need for paper-based processes to allow a much improved workflow and lower error rate

Allowed Orthotists (Consultants ) to create electronic Job Cards & Specification Sheets for Patients that pass from place to place electronically instead of using pieces of paper

Dramatically reduced a large source of errors from the workflow by eliminating badly hand-written data and allowing Orthotists to draw directly onto diagrams with mouse or stylus and entering data or dimensions electronically

Successfully migrated all data and business logic of FileMaker database into Servoy front-end with SQL back-end

Project : Recruited to create another, more complex, Stock Control system to track all non-consumable items used in Operating Theatres.

Achievements:

Moved RNOH from a manual, yearly Stock Take system to an electronic solution that tracks items from Goods-In to Operating Theatre in real time

Delivered a unique QR bar-coding system for each item to allow scanning by iOS devices

Used normal, 1D, bar-codes, to scan items at Goods-In (decoding GS1 & HIBC Symbologies) and then generated a QR code for item to allow easier subsequent scanning

Created a simple web-based iOS interface to move items to GLN locations using QR codes, allowing easy tracking and locating of items

Implemented a way of recording final usage of items in Operating Theatre, allowing reporting of costs of Procedures, usage (& wastage) by Consultant, tracking of Prosthesis in Patients in case of recall