endorsedOngoing

Backend Development, Database Migration & Staff Augmentation for Healthcare Company

Services Covered:

Custom Software Development • Staff Augmentation

Industry

Healthcare

Duration

94 months

Budget

200K - 999K

Start Date

1 October 2018

Team Size

11-15 Employees

Engagement Model

Nearshore

Project Capability Score (PCS)

80/100

Strong

Project Capability Score (PCS) estimates how capable fireup.pro is of successfully delivering a project like this, based on its past experience, track record, and ability to handle similar work. Learn more about PCS

Client

Confidential

Switzerland

Project Summary

Fireup.pro provided long-term staff augmentation for a large healthcare/biotechnology company, developing backend systems for a disease management application and building a global data repository with ETL processes on AWS. The engagement included a complex heterogeneous database migration, standardization to PostgreSQL/Aurora, and improvements that reduced maintenance costs and improved system supportability.

Key Challenges

Develop and deploy backend systems for a disease management application using Java/Hibernate/Spring/CXF on AWS
Create a worldwide data repository by amalgamating data from disparate databases via ETL on AWS
Address platform incompatibilities, mismatched data types, and complex mapping requirements across heterogeneous systems
Resolve encoding, timestamp conversion, numerical precision, and binary data differences while maintaining business continuity and regulatory compliance

Project Deliverables

Developed and deployed backend systems for a disease management application
Built a worldwide data repository and ETL processes on AWS
Performed heterogeneous database migration and complex data transformations
Migrated databases to Amazon Aurora/PostgreSQL and standardized the technology stack
Implemented data validation and system synchronization to maintain consistency

Project Solution

Provided sustained development staff augmentation to build and deploy backend systems using Java, Hibernate, Spring and Apache CXF. Designed and executed ETL processes on AWS to create a worldwide data repository, carried out a heterogeneous database migration with complex data-mapping and transformation logic, and migrated database infrastructure to Amazon Aurora/PostgreSQL to standardize the technology stack and ensure AWS support.

Project Outcome

Reduced maintenance costs by 50% due to the implementation of the new version of Aurora
Unified the technology stack by migrating from MySQL to PostgreSQL
Avoided unsupported components by migrating/adapting to Aurora 3
Delivered a compatible application that simplified switching between databases
Successfully synchronized systems to align with the organization's vision

Platforms

Cloud

Tech Stack

Java
Hibernate
Spring
Apache CXF
MySQL
PostgreSQL
Amazon Aurora
Amazon Web Services (AWS)

Client Endorsement

Overall Review Rating

4.75

Timeliness

Cost Rating

Willing to Refer

Quality of Deliverables

“fireup.pro has reduced the client's maintenance costs by 50%, unified their technological stack, avoided unsupported components, and created a compatible application. The team takes ownership of the projects, their decisions reflect long-term thinking, and their engagement is remarkable.”
Anonymous
Head of Engineering
Date: 11/04/2024