Building an ERP platform for US Healthcare Provider. Web cover. Abto Software portfolio

ERP platform for Healthcare Provider

Designing reliable ERP system for
US healthcare provider
Industry:

Services:

ERP development
Appointment management
Payment handling
1

Project overview

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. 

2

Main goals

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.

3

Our contribution

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
4

Main features

Main features of the designed healthcare ERP platform

abto software
  • 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.
5

Main challenges

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.
6

Third-party integrations

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

Tech stack

  • Vue.js
  • Vite
  • Vuex
  • Vuetify
  • TypeScript
  • Laravel
  • Lumen
  • ElasticSearch
  • ReactNative

Third-party integrations

  • Google maps
  • Mailgun
  • Postmark
  • Stripe
  • twilio
  • ClimMd
  • Availity
  • Srfax
  • Kustomer
  • Quickbooks

Servers & Infrastructure

  • AWS (EC, SQS, S3)
  • Docker

CI/CD tools

  • AWS ECS/ECR
  • AWS Codebuild/Codepipeline
  • Terraform
  • Github

QA & Automation

  • Java
  • Maven
  • TestNG
  • Allure
  • Selenium
  • Selenium GRID
  • SoapUI

Timeline:

  • September 2020 – March 2022

Team:

  • 2 backend developers
  • 1 frontend developer
  • 1 DevOps
  • 1 AQA
  • 2 data warehouse developers
7

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.

Categories:

Contact Us

To find out more about Abto Software expertise, request a quote or get a demo of your custom solution.

  • Clicking this button, I agree to the processing of my personal data.