Domain-Driven Data Architecture for Enterprise HR-Finance Systems : Bridging Workday Analytics with Modern Data Platforms

Authors

  • Sudheer Devaraju  Walmart Global Tech, India
  • Tracy Boyd  Walmart Global Tech, India

DOI:

https://doi.org/10.32628/CSEIT228128

Keywords:

Domain Driven Design, Enterprise Architecture, HR Analytics, Financial Systems, Data Integration, Cloud Native Analytics, Workday, Semantic Integration.

Abstract

This research presents an architectural framework based on DDD principles to integrate Workday with cloud-native data platforms. We propose a comprehensive architectural pattern that divides HR-Finance domains into bounded contexts, preserving data lineage and semantic consistency across the enterprise ecosystem. A Proof of Concept was implemented across three Fortune 500 organizations, reducing data integration complexity by 67% and improving analytical query performance by 3.2x over the typical ETL approach. To preserve context across HR and financial domains while ensuring consistency and enabling domain-specific optimization, the study introduces a "semantic bridge" pattern. Empirical evidence demonstrates that, in modern data architectures, it is possible to achieve a 78% reduction in reconciliation efforts and a 91% improvement in real-time reporting accuracy. We validate this framework for enterprises migrating to cloud-native analytics platforms.

References

  1. E. Evans, Domain-Driven Design: Tackling Complexity in the Heart of Software. Boston, MA, USA: Addison-Wesley Professional, 2003.
  2. Gupta et al., "Domain Driven Design for Enterprise Applications," Proc. 2nd Int. Conf. Innovations Comput. Inf. Technol., 2020.
  3. Workday, "Workday Studio," 2019. [Online]. Available: https://www.workday.com/en-us/products/platform-technology/studio.html.
  4. S. Sachdeva and S. Bhalla, "Semantic interoperability in standardized electronic health record databases," ACM J. Data Inf. Qual., vol. 3, no. 1, pp. 1–37, 2012.
  5. V. Vernon, Implementing Domain-Driven Design. Boston, MA, USA: Addison-Wesley Professional, 2013.
  6. Apache Software Foundation, "Apache Airflow," 2020. [Online]. Available: https://airflow.apache.org/.
  7. Apache Software Foundation, "Apache NiFi," 2020. [Online]. Available: https://nifi.apache.org/.
  8. D. Calvanese et al., "Ontop: Answering SPARQL queries over relational databases," Semantic Web, vol. 8, no. 3, pp. 471–487, 2017.
  9. S. Tursunbayeva, M. Pagliari, C. Lauro, and C. Antonelli, "People analytics—a critical evaluation," Int. J. Hum. Resour. Manag., vol. 31, no. 12, pp. 1475–1493, 2020.
  10. G. C. Deka and X. Liu, "A Framework for Integrating Structured and Unstructured Financial Data for Decision Support and Planning," Proc. IEEE Int. Conf. Big Data, 2018, pp. 5127–5132.
  11. Robinson, J. Webber, and E. Eifrem, Graph Databases, 2nd ed. Sebastopol, CA, USA: O'Reilly Media, 2015.
  12. S. Ambler and P. J. Sadalage, Refactoring Databases: Evolutionary Database Design. Boston, MA, USA: Addison-Wesley Professional, 2006.
  13. D. Wegener and S. Rüping, "On Reusing Data Mining in Business Processes – A Pattern-based Approach," in Business Process Management Workshops, M. zur Muehlen and J. Su, Eds., Berlin, Heidelberg: Springer, 2011, pp. 264–275.
  14. D. Moody, "The 'Physics' of Notations: Toward a Scientific Basis for Constructing Visual Notations in Software Engineering," IEEE Trans. Softw. Eng., vol. 35, no. 6, pp. 756–779, Nov. 2009.
  15. J. Sowa, "Ontology, Metadata, and Semiotics," in Conceptual Structures: Logical, Linguistic, and Computational Issues, B. Ganter and G. W. Mineau, Eds., Berlin, Heidelberg: Springer, 2000, pp. 55–81.
  16. D. Karagiannis and H. Kühn, "Metamodelling Platforms," in E-Commerce and Web Technologies, K. Bauknecht, A. Min Tjoa, and G. Quirchmayr, Eds., Berlin, Heidelberg: Springer, 2002, pp. 182–182.
  17. M. A. Beyer and D. Logan, "Assessing the Capabilities and Costs of Semantic Technologies," Gartner, Stamford, CT, USA, Technical Report G00236676, Feb. 2013.
  18. Poggi, D. Lembo, D. Calvanese, G. De Giacomo, M. Lenzerini, and R. Rosati, "Linking Data to Ontologies," in J. Data Semantics X, S. Spaccapietra, Ed., Berlin, Heidelberg: Springer, 2008, pp. 133–173.
  19. R. Angles and C. Gutierrez, "Survey of graph database models," ACM Comput. Surv., vol. 40, no. 1, pp. 1–39, Feb. 2008.
  20. P. Cudré-Mauroux, "Leveraging Knowledge Graphs for Big Data Integration: The XI Pipeline," Semantic Web, vol. 11, no. 1, pp. 3–11, Dec. 2019.
  21. H. Panetto, M. Dassisti, and A. Tursi, "ONTO-PDM: Product-driven ONTOlogy for Product Data Management interoperability within manufacturing process environment," Adv. Eng. Inf., vol. 26, no. 2, pp. 334–348, Apr. 2012.
  22. S. Das, S. Sundara, and R. Cyganiak, "R2RML: RDB to RDF Mapping Language," 2012. [Online]. Available: https://www.w3.org/TR/r2rml/.

IInternational Journal of Scientific Research in Computer Science, Engineering and Information Technology

Downloads

Published

2021-02-28

Issue

Volume 7, Issue 1, January-February-2021

Section

Research Articles

License

Copyright (c) IJSRCSEIT

Creative Commons License

This work is licensed under a Creative Commons Attribution 4.0 International License.

How to Cite

[1]
Sudheer Devaraju, Tracy Boyd, " Domain-Driven Data Architecture for Enterprise HR-Finance Systems : Bridging Workday Analytics with Modern Data Platforms" International Journal of Scientific Research in Computer Science, Engineering and Information Technology(IJSRCSEIT), ISSN : 2456-3307, Volume 7, Issue 1, pp.318-325, January-February-2021. Available at doi : https://doi.org/10.32628/CSEIT228128