Problem Statement:
The organization relied on legacy COBOL programs for insurance data processing, making maintenance, scalability, and modernization difficult. The project aimed to transform legacy business logic into modern SQL-based processes, streamline data migration workflows, and ensure accurate delivery of multiple insurance data trails while supporting comprehensive testing and production readiness.
Tools and Technologies:
Alteryx, SAP HANA, SQL, COBOL, STTM
Summary:
• Migrated legacy COBOL business logic into SQL-based transformations using STTM.
• Developed and enhanced Alteryx workflows for insurance data processing and migration.
• Delivered and validated 9 insurance data trail migrations into SAP HANA.
• Performed data validation, reconciliation, and quality assurance to ensure migration accuracy.
• Supported end-to-end testing activities, including SIT, UAT, and production deployment.
• Collaborated with business and technical stakeholders to resolve migration and data issues during project execution.
Alteryx Workflows:
