Past Database Projects
Below are examples of previous work.
From unmanageable to invaluable.
An HIV treatment facility in South Africa, already short on resources as they fight a growing epidemic, faced the added burden of an unmanageable and unusable system for tracking patients, visits and treatment. Working closely with staff at the clinic, Laura created a new Access database customized to their unique needs. Now, less time spent on data entry means more time for patients. Custom queries and reports mean more responsive care.
Attack of the 50 foot spreadsheet.
A state-level program established to help patients pay for prescriptions drugs was using a complicated system of Excel spreadsheets to track clients, prescriptions, formularies, payments and rebates. With a new database in place, tracking and reporting are quicker and more accurate, freeing staff time to focus on making improvements to the program.
Complex funder reporting requirements conquered with the touch of a button (okay, maybe two).
A federal-level funder, in a push to gather more data, gave their grantees two options: start using our new client tracking system or send us data from your system in the exact (complicated) format we need. At the time, two of these grantees were successfully using databases that Laura built, which were tailored to their needs, and were hoping to avoid switching. Laura was able to create a feature that allows users to review and submit the required data with only a few quick button clicks.
A data entry nightmare? I think not.
A research organization was conducting lengthy interviews with participants of a state-funded program using pencil and paper forms. They needed a database to enter and house results. With user-friendly screens that matched the exact look and design of the paper survey plus automatic error-checking, the database Laura built made data entry fast and accurate.