Abto Software assisted a US-based healthcare service provider with the software development of a custom internal ERP (Enterprise Resource Planning) system. The solution streamlines simplified patient appointment registration, management and logistics. The delivered ERP system helps the client company to provide trusted and certified patient care.
Abto Software suggested an effective solution allowing healthcare specialists to find the best time & cost option to commute to the client. The mechanism of scheduling patients’ visits is based on their location and the current location of the patient care specialist. According to the situation, the system can plan and suggest the best choices for specialists: what to do, how much time this will take, etc.
Also, the product gives the specialist the opportunity to evaluate and rate the patient, so the colleagues could see this information.
Main goals of advanced ERP development
Abto Software was approached by a US-based healthcare service provider to enhance a custom ERP platform. The project’s main goal was to completely refactor the architecture of the existing database to increase the overall business’ efficiency.
Delivering a reliable tool for healthcare client management
Our developers used the earlier existed system as the solution’s prototype. However, some significant changes were introduced to improve upon the original version and develop a fully functional ERP platform.
Our team covered the following tasks:
- Architecture refactoring
Our full-stack engineers refactored the architecture of the existing database. We made it faster, and more efficient. Also, we recommended and utilized the use of server-side rendering. This reduced server load and improved the overall solution.
- Setting up CI/CD processes
Abto Software provided an experienced DevOps engineer who set up and optimized CI/CD processes. Our expert also helped the client with server configuration and played an integral part in designing infrastructure architecture.
- Quality assurance and automation
To ensure that the delivered ERP platform meets client’s requirements and specifications, Abto Software provided the necessary QA services. Our team was responsible for automation of web application flows, testing API and end-to-end functionality tests. We were working on:
a. QA process audit & establishing our own efficient QA process
b. UI Automation Framework creation
c. Automating regression suite and covering main application flows by the E2E tests
d. API framework creation / API automation testing
e. Integration automated tests with different test tracking systems
f. Integration automated tests with CI/CD
- Custom data warehouse development
To provide the ERP platform with an advanced reporting functionality, and to not risk the overall performance of the production environment. Abto engineers developed a custom DWH (Data Warehouse). This is a complex data storage system for structuring data. It regularly downloads data from the product database and generates comprehensive reports for more efficient analytics and making proper business decisions as a result.
Main features of the designed healthcare ERP platform
- Business operations’ planning & optimization
To manage and plan everyday business activities such as routing, operational management, accounting, risk management and compliance, the delivered healthcare ERP system suggests optimal choices and best prognoses. It assists the client with remote access to key resources and reports.
- Appointment management
One of the main purposes of the ERP solution is quicker and more effective patient appointment management.
- Patient communication
The system is equipped with different tools (email, SMS, chat, etc.). They enhance communication with patients, for example, by sending reminders about appointments.
- Patient segmentation based on location
The ERP system provides a useful CRM feature of segmenting patients by location. Each care provider can operate within a particular region, which makes it easier to handle more patient requests and increase business value as a result.
- Health risk detection
The system allows our client to detect potential health risks. This, in turn, prevents the patient from getting more severe health issues.
- Patient records
The system collects and gives access to information about each patient, including medical records, appointment history, payment information, risk category, etc. Each patient has their own profile in the system where all information is stored.
- Data protection
The system provides role-based access to patient information. For example, a care provider may use the system to check the location and the need of their next patient. At the same time, they may not access the patient’s payment data, as this information is only used by accountants. The solution is equipped with the log-in timeout feature. It ensures an additional level of security that keeps patient information safe.
- Payment handling
The system makes it easier to handle and process patient payments. This feature is especially important to our client since they have to deal with many different types of payments.
While working on the custom healthcare ERP platform, our team took into account the following nuances:
- Integration challenges in online payment processing
To protect customer & transaction’ details while establishing seamless and secure online transactions, Abto Software had to adhere to the latest privacy regulations.
- Challenges of database refactoring
To keep the current coupling, our team had to be careful with all previous dependencies and customers’ data presented in the database.
- Working with users’ data – security precautions
To prevent unauthorized access to sensitive users’ data, Abto’s team implemented security measures such as ACLs (access control lists). It includes encryption, monitoring, configuration management, and alerting.
- HIPAA compliance
Any project in healthcare that is connected with user’s data and sensitive information should follow the process and procedure of updating compliance documentation and regular review.
- Integration with Claim.MD
Claim.MD is an EDI (Electronic Data Interchange) Clearinghouse system for automating the transfer of the data in a specific format following specific data content rules between a health care provider and medical care facility. Abto Software team had to provide the integration and unified work interface for several different systems with their own characteristics. Despite the difficulties, Claim.MD appeared to be the perfect solution to cope with this task.
In addition to developing various features for the ERP system, our team also helped complete many integrations with third-party services.
- Google maps
The service is used in tandem with the location-based patient segmentation feature. It allows to build thought-out routes using GPS.
- EDI Clearinghouse
Our engineers added integration with Clam.MD. This allows our client to handle online claims on virtual payment handling, document processing, and other.
- Payment methods
Various third-party payment methods were implemented in the ERP system. For example, the popular service Stripe. Therefore, patients can choose the most suitable option. Payment information and history are stored and can be accessed directly from the system.
- Communication channels
The team also added handy third-party communication services. This way, the client can communicate with patients and send relevant updates and notifications via email, SMS, chat, and more.
Tools and technologies
- Google maps
Servers & Infrastructure
- AWS (EC, SQS, S3)
- AWS ECS/ECR
- AWS Codebuild/Codepipeline
QA & Automation
- Selenium GRID
- September 2020 – March 2022
- 2 backend developers
- 1 frontend developer
- 1 DevOps
- 1 AQA
- 2 data warehouse developers
Value delivered to business
Our client obtained a custom internal Enterprise Resource Planning system. The solution streamlines various internal processes, from appointment planning to logistics, including top-tier data protection.
In brief, the designed healthcare ERP system provided:
- Quicker and more efficient appointment management, payment handling, and more
- Improved communication between clinicians and patients
- Better usability, responsive design
- Increased scalability
- Tangibly quicker ERP development with an easier onboarding process for engineers
- Better security and top-tier data protection
Here are the main business benefits of the delivered ERP solution:
- It significantly increases the quality of provided patient care;
- Notably reduces the amount of work performed manually;
- Provides top-tier data protection;
- Improves overall business performance by optimizing internal processes and enhancing routes;
- Saves enterprise’s time and resources and greatly increases the revenue of the business.