Modernization of a Health Surveillance Data Platform: A Retrospective on Legacy-to-Cloud Migration

Mallikarjuna Rao Vasa

International Journal of Scientific Research in Computer Science, Engineering and Information Technology, 2023, vol. 9, issue 6, 1061-1068

Abstract: Modernizing mission-critical public health data platforms requires more than infrastructure migration; it demands preservation of complex business semantics, regulatory compliance, and analytical integrity across heterogeneous cloud ecosystems. This paper presents a governance-driven, two-release cloud modernization framework for migrating a legacy disease surveillance platform from SQL Server to a cloud-native architecture integrating Salesforce, Snowflake, Informatica IDMC, and Tableau. The proposed approach combines metadata-driven data integration, reverse-engineered business-rule preservation, phased migration execution, reusable transformation pipelines, automated reconciliation, and cloud-native orchestration to minimize migration risk while improving scalability and data quality. The first release establishes foundational data profiling, schema transformation, and baseline validation, whereas the second release extends enterprise-scale migration through incremental loading, optimized orchestration, cross-platform reconciliation, and performance tuning for operational and analytical consistency. Results demonstrate significant improvements in reconciliation coverage, defect resolution efficiency, migration scalability, and enterprise data governance despite a threefold increase in migrated assets. The framework provides a repeatable reference architecture for cloud modernization of regulated healthcare and government information systems and offers practical guidance for future enterprise data platform transformations requiring operational resilience, analytical trustworthiness, and long-term maintainability.

Keywords: Cloud Data Modernization; Public Health Data Platforms; Disease Surveillance Systems; Legacy System Modernization; Data Platform Migration; Enterprise Data Architecture; Cloud Migration; Snowflake Data Warehouse; Salesforce Platform; Informatica Intelligent Data Management Cloud (IDMC); Enterprise Data Engineering; Cloud-Native Architecture (search for similar items in EconPapers)
Date: 2023
Note: Article URL: https://ijsrcseit.com/CSEIT23906784
References: Add references at CitEc
Citations:

Downloads: (external link)
https://ijsrcseit.com/CSEIT23906784 Article URL (text/html)
https://ijsrcseit.com/paper/CSEIT23906784.pdf Full text (application/pdf)

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:jbh:ijsrcs:v9:y2023:i6:id:hcseit23906784

DOI: 10.32628/CSEIT23906784

Access Statistics for this article

More articles in International Journal of Scientific Research in Computer Science, Engineering and Information Technology from International Journal of Scientific Research in Computer Science, Engineering and Information Technology
Bibliographic data for series maintained by Pankaj Sharma (USA) ().