Legacy Application Reimagined for Claims Matching with AWS

Client

A US-based financial services provider modernized a legacy membership and vendor file management system to a secure, scalable, and cloud-native platform, enabling seamless business operations and improved member servicing.

Business Challenge

• Aging Technology Stack: The core application was built on outdated platforms like FoxPro and Crystal Reports, hindering flexibility and innovation.
• Performance and Cost Inefficiencies: On-prem SQL Server setup was costly, under-optimized, and hard to scale.
• Rigid Reporting Capabilities: Static reports and lack of interactivity reduced decision-making effectiveness.
• Security and Compliance Gaps: Absence of modern access control mechanisms and limited auditability compliance posture.
• Deployment Inflexibility: Manual deployments and lack of DevOps culture slowed down the release lifecycle.

Approach

Trianz led comprehensive re-architecture with an end-to-end cloud-native redesign to unlock scalability, agility, and cost efficiency:

• Legacy Decommissioning: Retired FoxPro and Crystal Reports to eliminate tech debt and modernize data flow and reporting.
• Cloud-Native Redesign: Rebuilt the monolithic application as containerized microservices hosted on ECS Fargate, improving resilience and portability.
• Data Modernization: Migrated from SQL Server to Amazon Aurora PostgreSQL, simplifying schema design and reducing database license costs.
• Real-Time File Processing: Implemented event-driven architecture using Amazon S3 triggers, AWS Lambda, and AWS Batch for automated ingestion, processing, and validation.
• Interactive Reporting: Delivered a web-based dashboarding solution with responsive design, export capabilities, and advanced filtering.
• Secure CI/CD Pipeline: Established CI/CD using AWS CodePipeline, CodeBuild, and CodeDeploy to streamline releases and enforce quality gates.
• Advanced Security Posture: Integrated role-based IAM, AWS Secrets Manager, and PingFed SSO for centralized access control.
• Monitoring and Observability: Configured AWS CloudWatch and CloudTrail for full-stack visibility, alerts, and governance.
• Cost Optimization: Introduced auto-scaling, S3 lifecycle policies, and Reserved Instances for predictable workloads.
• Seamless Cutover: Orchestrated a zero-downtime migration to ensure uninterrupted business continuity.

Transformational Effects

• 42% Reduction in Database Licensing Costs: By replacing proprietary databases with Aurora PostgreSQL
• 35% Compute Cost Savings: Leveraged ECS Fargate auto-scaling and right-sized workloads
• 20% Additional Cost Optimization: Through Reserved Instances for predictable workloads
• Zero Downtime Migration: Carefully orchestrated go-live with continuous availability
• Improved User Experience: Web dashboards and real-time alerts enhanced decision-making and productivity
• Robust Security and Compliance: Centralized identity control and fine-grained access policies improved audit-readiness