Meet Trianz at AWS re:Invent 2025 Register Now
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.
This agentic model transformed the end-to-end workflow from a linear, human-dependent process into a self-optimizing system capable of executing tasks autonomously while maintaining full regulatory compliance and traceability.
Technology Components
Cloud Services
Application Stack
Infrastructure Tools
Transformational Effects
Reduction in Database cost
Compute Cost Savings
Cost Optimization
Downtime Migration
- 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.
Ready to Transform Your Data Platform?
Let's discuss how we can help you build a modern data architecture that drives business value