Meet Trianz at AWS re:Invent 2025 Register Now
Customer Success Story
Mainframe to Cloud Modernization for Financial Services Platform
Client
A prominent government contractor in the financial services sector seeking to modernize their legacy platform infrastructure to enable cloud-native, secure operations and support business expansion initiatives.
Business Challenge
- Legacy Platform Dependencies: Critical business applications running on outdated IBM DB2 iSeries with Java-based frontend and SSRS reporting on SQL Server.
- Compliance Requirements: Needed secure, government-compliant platform to meet contracting standards.
- Accelerated Timeline: Required complete modernization in under 4 months to showcase capabilities to clients for future business opportunities.
- Business Continuity Risk: Legacy systems posed operational risks and limited scalability for new business expansion.
- Complex Data Migration: Over 900 database objects including 150 stored procedures and functions required migration.
- Reporting Infrastructure: 100+ SQL Server reports needed realignment to modern data warehouse solution.
Approach
Trianz executed a comprehensive legacy modernization strategy with accelerated delivery:
- Legacy Assessment & Planning: Conducted thorough analysis of existing IBM DB2 iSeries environment and identified migration dependencies.
- Cloud-Native Architecture Design: Architected secure, government-compliant AWS infrastructure with PostgreSQL backend and Redshift data warehouse.
- Automated Migration Strategy: Utilized specialized migration tools (Ispirer) and AWS Database Migration Service for efficient data transfer.
- Database Modernization: Migrated 900+ database objects including tables, stored procedures, functions, triggers, views, and sequences.
- Application Refactoring: Modernized Java-based frontend applications to integrate with new PostgreSQL backend.
- Reporting Platform Migration: Realigned 100+ reports from SQL Server to Amazon Redshift for enhanced analytics capabilities.
- Business Logic Transformation: Converted 150 DB2 stored procedures and functions to PostgreSQL equivalents.
- Hypercare Support: Provided post-migration support during stabilization period before customer handover.
- Containerization Strategy: Implemented Docker containers for improved scalability and deployment efficiency.
- Compliance Validation: Ensured FedRAMP compliance requirements were met throughout the modernization process.
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
AWS IAM
Amazon RDS PostgreSQL
Amazon Redshift
AWS Database Migration Service (DMS)
Amazon EC2
AWS CloudFormation
Amazon VPC
AWS IAM
Amazon CloudWatch
Application Stack
Java
PostgreSQL
Docker Containers
Infrastructure Tools
Ispirer Migration Tool
Migration Evaluator
Transformational Effects
4-Month
Accelerated Delivery
900+
Database Objects Migrated
100+
Reports Realigned
150
Components Modernized
- 4-Month Accelerated Delivery: Completed comprehensive legacy modernization within aggressive timeline to meet business requirements.
- 900+ Database Objects Migrated: Successfully transferred all tables, stored procedures, functions, triggers, views, and sequences to modern platform.
- 100+ Reports Realigned: Migrated entire reporting infrastructure from SQL Server to Amazon Redshift for enhanced analytics.
- Government Compliance Achievement: Established secure, government-compliant cloud infrastructure enabling new business opportunities.
- 150 Business Logic Components Modernized: Converted all DB2 stored procedures and functions to PostgreSQL for improved performance.
- Enhanced Scalability & Performance: Cloud-native architecture provided foundation for business expansion and improved operational efficiency.
Ready to Transform Your Data Platform?
Let's discuss how we can help you build a modern data architecture that drives business value