Maximuscle / Maxinutrition (now part of GlaxoSmithKline)
Project : Recruited to deliver an improved Stock Control & Sales Ordering capability to enable the company to successfully grow the business with a wider product set.
Achievements:
Designed & Implemented a Stock Control System that enabled real time feedback on Stock Levels
Migrated/Converted existing FileMaker Pro SOP/CRM to a more modern database architecture & platform
Successfully migrated all data and business logic into Servoy front-end with SQL back-end
Dramatically increased the performance of the financial reporting database as well as improving user data entry and searching capabilities
Used Agile methodologies to deliver the new platform in faster timescale
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
Professional Conferences
Project : Recruited to Migrate/Convert existing FileMaker Pro system to more modern database architecture & platform and add electronic sending of all invoices, documentation & certificates.
Achievements:
Replaced old method of printing & posting with automatic generation of paperwork as PDFs & direct emailing
Created a new batch process to allow offloading bulk emailing tasks to server, greatly improving worker efficiency
Successfully migrated all data and business logic into Servoy front-end with SQL back-end