Care Health Insurance cuts reporting time by 75% with automated data processing

With a growing network of over 21,700 healthcare providers, Care Health Insurance provides comprehensive health coverage for millions of individuals and families in India. Previously, Care’s actuarial team relied on a license-based reporting tool to process raw customer policy and claims data and generate reports for the Insurance Regulatory and Development Authority of India (IRDAI), as well as for internal analyses. Kolla Suresh, head of IT and operations, Care Health Insurance, explains, “Every month, we analyze our business to see trends and growth data, and that standardized report is the root of all our analyses.”

However, this process often took more than a week, depending on various external factors like drive capacity, database size, and server load. With the database increasing by 1.5−2 GB every month, processing times lengthened further. At the same time, Care’s business was expanding annually, making faster, more reliable reporting critical. “Our data kept growing as the business grew, so we wanted to automate and speed up the reporting process to keep pace,” Suresh adds.

Having already run some of its applications on AWS, Care turned to AWS Partner Lumiq to modernize its reporting solution. Together, they built a data lake on AWS that provides a single source of truth for policy and claims data across the organization.

Data is stored in Amazon Simple Storage Service (Amazon S3) buckets and processed with Amazon EMR. AWS Glue automates data preparation, while Amazon Athena supports direct data analysis in Amazon S3. Data ingestion uses AWS Database Migration Service (AWS DMS) and Syniti to replicate data from source systems.

As part of the migration, Lumiq re-architected Care’s reporting approach so that historical data could be retrieved directly from the data lake. “Lumiq was very helpful in helping us reduce dependency on our previous core reporting system and guiding us through the re-architecting,” says Suresh. Teams across the organization, including the Care actuarial team, use the data lake to analyze data stored in Amazon S3 each day to identify and assess portfolio trends and inform business decisions.

By automating reporting and reducing manual intervention, Care cut report generation time by at least 75 percent. “Migrating to AWS has transformed our data processing capabilities. We can now generate reports in just two days, compared to timelines that previously took more than a week,” Suresh notes. “This has significantly improved our efficiency and accuracy, and we’ve also eliminated our licensing costs,” says Suresh.

The new solution also provides 24x7 self-service access to reporting, freeing teams from dependency on IT for historical data requests. With AWS managed services, Care benefits from built-in AWS security, monitoring, and Multi–Availability Zone scalability. Looking ahead, Care is also exploring generative AI on AWS to improve contact center operations with agentic AI. “We plan to increase our contact center efficiency overall, and we look forward to working with AWS to deliver that capability,” Suresh concludes.