The Care Database: Transparity take on the role of outsourced IT development
- 250+
- App Innovation
- Healthcare
About The Care Database
Chase Hospice Trading (CHT) are the owners of The Care Database, a web-based hospice management software package. There are currently thirteen hospice organisations across the UK that use The Care Database and this number continues to grow.Â
The challenge
The Care Database was initially implemented in CHT’s hospices – Shooting Star Hospices in April 2017. It was then made available for purchase by other organisations from January 2018 and twelve organisations have taken it up to date.Â
Having completed the initial development of the Care Database and with the application stable, CHT was looking to change partners for long-term support and enhancement development of the system. In particular:Â
- A fixed price support agreement with bug fixes to agreed service levelsÂ
- Ongoing maintenance to ensure the system remains secure and optimizedÂ
- Fixed-price development services to enhance The Care DatabaseÂ
The solution
The first stage of taking over management of the Care Database Application was:Â
- Transitioning the source code into GIT Repos in Azure DevOpsÂ
- Creating a backlog of issues and new features in Azure DevOpsÂ
- Carrying out a thorough review of the Web App and SQL source codeÂ
- Making some selected code changes and ensuring these could be successfully be deployed to TEST and then LIVEÂ
- Ensuring that CHT knew how to operate the Transparity online service desk for raising ticketsÂ
Having successfully taken over management of the system, routine support could beginÂ
The next stage was to look at how to improve the way the system is supported and developed by doing the following tasks. Each of these were specified and estimated as a new piece of work:Â
- Change the system so that the Web App and API work on Azure App Services (instead of IIS in a Virtual Machine (VM) per client) and then migrate all of the clients over to App ServicesÂ
- Introduce fully automated deployment pipelines to ensure releases from DEV to TEST to UAT and LIVE servers are fast and robustÂ
- For new features, introduce a new form of automated UI/Integration test that operates directly against the browser, in the same way a user does. These tests are based on Specflow and Selenium and are defined in Gherkin syntax. An example of which is shown below:Â
Feature: Roster a staff memberÂ
Background:Â
Given I have logged into and browsed to Roster pageÂ
Scenario: Find a roster slot that is unallocated that needs allocatingÂ
Given I have selected a roster slotÂ
When I associate a staff member that is free and has the required skillsÂ
Then the roster is updated with the matching staff memberÂ
The outcome
We are now successfully managing the Care Database Application, have a fixed a number of critical issues and have resolved several performance problems.Â
We are currently implementing an extension to the system that will allow it to obtain patient records directly from the NHS over a Health and Social Care Network (HSCN) gateway.Â
"We have a large and complex healthcare management system called The Care Database. We moved our development and support to Transparity at the beginning of the year and they rapidly picked up our existing code and familiarised themselves with our product. We have noticed a dramatic improvement in our development speed and the quality of work is high. This is due to the direct communication we have with their developers to discuss and solve problems. We look forward to continuing to work with Transparity and continuing to grow and improve our Care Database.."
Tom Bradley - Director of Operations