
Project Highlights
- Provide a data platform that supports ETL (Extract, Transform, Load) processes and real-time streaming for Electronic Health Records (EHR) and health care related data.
- Handle porting 15 million medical records (over 30 years) to the new platform.
- Optimize search engine to handle 5TB sample data in 3 seconds.
- Protect sensitive medical information through advanced encryption and secure management.


About Client
Our client is a leading healthcare organization in the USA, dedicated to delivering innovative healthcare solutions. With a mission to improve the health and well-being of its members, the company offers a diverse range of health insurance plans and related services.

Client Challenges
As a leading healthcare company, our client faces the daily challenge of managing a vast amount of health data. Every day, they handle millions of medical records, each containing critical information essential for patient care and health management.
Facing this challenge, they desired to create a robust data platform to support extensive healthcare services, migrate and validate existing data, and handle the massive volume with a powerful analytics system for health clinics and insurance services.
Recognizing the need for expertise in healthcare software development, they have considered TMA, a leading Vietnam technology service provider with a 12-year track record specializing in big data and analytics as their strategic software partner.

Solutions
- Data ingestion: Data of medical records from external partners, internal sources, and membership are gathered and securely transferred into the system.
- Data analytics: Data is initially stored in the loading zone without changes, with real-time streaming managing continuous inflow. The data is then sorted and secured in the Protection stage, where it is categorized and encrypted to ensure safety while stored and during transmission. Finally, the data is refined and transformed to meet business needs, making it ready for use.
- Data output: Transformed data is decrypted and made available for use by the company’s partner or internal employees. The platform also includes a search engine capable of handling 5TB of sample data and delivering results in under 3 seconds, enhancing data retrieval speed.

Benefits
- Enhanced data management: The platform efficiently manages 15 million medical records, making important information easily accessible and organized.
- Better decision-making: The analytics platform supports comprehensive data analysis for better informed decisions about health clinics and insurance services.
- Enhanced data security: Categorization and encryption of data ensure that sensitive medical information is protected, reducing the risk of data breaches.