OPTIMIZING ETL INTEGRATION WORKFLOWS IN PUBLIC HOUSING SYSTEMS: A CASE STUDY OF WAITLIST PROCESSING TIME REDUCTION
Keywords:
Public Housing Systems Integration, Waitlist Management Optimization, Enterprise Data Integration, Social Service Delivery, Process EfficiencyAbstract
The digital transformation of public housing assistance programs has introduced complex system integration challenges that significantly impact service delivery timelines. This article presents a case study of the San Diego Housing Commission's Rental Assistance Waitlist Portal, focusing on the optimization of data integration between Salesforce and Yardi systems through Dell Boomi ETL tool. The article addresses a critical bottleneck in waitlist processing where the traditional approach of integrating both generated and selected waitlist records led to extended processing times. The article proposes and implements a refined integration strategy that selectively transmits only actionable waitlist records, thereby streamlining the data flow between systems. The implementation results demonstrate substantial improvements in processing efficiency and significant reduction in applicant wait times. This optimization not only enhances system performance but also delivers tangible social impact by accelerating access to housing assistance. The article contributes to the growing body of knowledge on enterprise system integration in public sector services and offers valuable insights for similar organizations facing data processing challenges in social service delivery.
References
OMB Report "Waitlist Data Management and Burden Improvement at HUD," Office of Management and Budget, 2024. [Online]. Available: https://omb.report/icr/202408-2511-001/doc/145043601.pdf
"Methods," Salesforce for Housing Associations, 2024. [Online]. Available: https://assets.applytosupply.digitalmarketplace.service.gov.uk/g-cloud-14/documents/92308/338881151474281-service-definition-document-2024-05-02-1028.pdf
"Yardi Systems," Affordable Housing Suite Brochure, 2020. [Online]. Available: https://resources.yardi.com/documents/yardi-affordable-housing-suite-brochure/
Simplilearn: "Challenges of Big Data: Basic Concepts, Case Study, and More," 2024. [Online]. Available: https://www.simplilearn.com/challenges-of-big-data-article
CA Vinay Thyagaraj, "Extension of end/completion date of Real Estate Project - Section 7(3) RERA 2016," TaxGuru, 2023. [Online]. Available: https://taxguru.in/corporate-law/extension-date-completion-date-real-estate-project-section-7-3-rera-act-2016.html
M. Castellano-Román, A. García-Martínez, and M. L. Pérez López, "Social Housing Life Cycle Management: Workflow for the Enhancement of Digital Management Based on Building Information Modelling (BIM)," Sustainability, vol. 14, no. 12, p. 7488, 2022. [Online]. Available: https://typeset.io/papers/social-housing-life-cycle-management-workflow-for-the-34o5kpq4
Lumenalta, "13 data management best practices | Improve workflows and secure data," 2024. [Online]. Available: https://lumenalta.com/insights/13-data-management-best-practices
A. O. Adediran, S. S. Ajibade, A. Zaidi et al., "A Science Mapping Analysis of Energy Efficiency and Affordable Housing Research," International Journal of Energy Economics and Policy, vol. 14, no. 6, pp. 1-15, 2024. [Online]. Available: https://mail.econjournals.com/index.php/ijeep/article/view/16951
S. Betz and C. Wohlin, "Alignment of Business, Architecture, Process, and Organisation in a software development context," IEEE Xplore, 2012. [Online]. Available: https://ieeexplore.ieee.org/document/6475423
R. Woitsch and W. Utz, "Business Process as a Service: Model Based Business and IT Cloud Alignment as a Cloud Offering," IEEE Xplore, 2015. [Online]. Available: https://ieeexplore.ieee.org/document/7406854
Published
Issue
Section
License
Copyright (c) 2025 Ravi Chandra Chinta (Author)
This work is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License.
