Data Engineering Patterns for Cross-System Reconciliation in Regulated Enterprises: Architecture, Anomaly Detection, and Governance

• URL: http://arxiv.org/abs/2604.15108v1
• Date: Thu, 16 Apr 2026 15:02:39 GMT
• Title: Data Engineering Patterns for Cross-System Reconciliation in Regulated Enterprises: Architecture, Anomaly Detection, and Governance
• Abstract summary: This paper introduces the GERA Framework, a vendor-neutral, four-layer data architecture that integrates deterministic cross-system reconciliation.<n>The architecture spans four layers (ingestion, staging, core models, and semantic serving) following the multi-layer pattern now common in modern data platforms.
• Score: 0.0
• License: http://creativecommons.org/licenses/by/4.0/
• Abstract: Regulated enterprises in the United States--banks, telecommunications providers, large technology companies--operate across heterogeneous systems that were rarely designed to interoperate. ERP platforms, billing engines, supply chain tools, and financial reporting infrastructure coexist within the same organization, but they do not talk to each other well. The resulting fragmentation produces familiar problems: transactions recorded in one system but unreconciled in another, asset inventories drifting from their systems of record, and audit-readiness that depends on manual effort. The PCAOB's 2024 inspection cycle put a number on the consequences: a 39% aggregate Part I.A deficiency rate across all inspected firms. This paper introduces the GERA Framework (Governed Enterprise Reconciliation Architecture)--a vendor-neutral, four-layer data architecture that integrates deterministic cross-system reconciliation, statistical anomaly detection (baseline Z-Score with robust alternatives), governed semantic standardization, and NIST CSF 2.0-aligned security controls into a single methodology. The architecture spans four layers (ingestion, staging, core models, and semantic serving), following the multi-layer pattern now common in modern data platforms. The patterns are demonstrated through U.S. broadband operations--where billing reconciliation, inventory aging, and governance are tightly coupled--and draw on the author's implementation experience across three regulated enterprise environments: a regional bank, a national broadband provider, and a Fortune 500 technology company's central finance organization. This is a practitioner reference--an architectural framework paper documenting field-tested patterns--not a controlled experiment or benchmark study. No proprietary systems, datasets, or internal implementations are disclosed.

Related papers

• Poisoning Agentic Alpha: Adversarial Vulnerabilities Across Roles and Architectures in Multi-Agent Trading Systems [103.90831279037094]
  LLM-based multi-agent trading systems are moving rapidly from research prototypes to live deployments that control real assets.<n>A corrupted signal can propagate to the final decision and translate into realized financial loss.<n>We present the first systematic empirical study in the financial domain to characterize how an adversarial signal enters a multi-agent trading system.
  arXiv  Detail & Related papers  (2026-08-25T05:07:37Z)
• A Security-Oriented Lifecycle Model for Large Language Model Systems [2.313414330066]
  Security-relevant activities such as data verification, artifact signing, agentic permission control, and decommissioning are often left implicit or assumed to receive due care.<n>We propose a lifecycle model for LLM systems that supports security analysis by structuring it around security-relevant boundaries.
  arXiv  Detail & Related papers  (2026-08-04T13:13:48Z)
• TRACE: A Threat Modelling Methodology for Distributed, Cloud-First, and Decentralized Organisations [0.0]
  We present TRACE, a methodology that treats threat actors, roles, assets, critical invariants, and trust/authority edges as first-class, evidence-linked objects.<n>We compare nine widely used frameworks across ten dimensions, show where each falls short in distributed, cloud-first, zero-trust settings, and specify TRACE.
  arXiv  Detail & Related papers  (2026-06-20T20:24:15Z)
• Rethinking Weak Supervision in Anomaly Detection: A Comprehensive Benchmark [41.98173822607898]
  This paper introduces WSADBench, the first benchmark that unifies evaluation across distinct weakly supervised scenarios.<n>Based on over 700K experiments, WSADBench reveals four critical insights.
  arXiv  Detail & Related papers  (2026-05-25T17:32:58Z)
• ComplexMCP: Evaluation of LLM Agents in Dynamic, Interdependent, and Large-Scale Tool Sandbox [61.862814740220806]
  $textbfComplexMCP$ is a benchmark designed to evaluate agents in rigorous conditions.<n>Built on the Model Context Protocol (MCP), $textbfComplexMCP$ provides over 300 meticulously tested tools.
  arXiv  Detail & Related papers  (2026-05-11T16:20:51Z)
• EMRGF: A Practitioner Framework for Governance-Driven Enterprise Technology Modernization [0.0]
  This article presents the Enterprise Modernization Reliability and Governance Framework (EMRGF)<n>EMRGF comprises four interlocking modules -- Cloud and Legacy Modernization Governance, Data Platform Reliability Integrity, AI-Enabled Automation Governance, and Mission-Critical Reliability and Root-Cause Routines.<n>The framework is explicitly aligned with U.S. national policy mandates including CSF 2.0, AI RMF, and Executive Orders 14028 and 14110.
  arXiv  Detail & Related papers  (2026-05-06T03:37:20Z)
• Governance by Design: A Parsonian Institutional Architecture for Internet-Wide Agent Societies [0.2900810893770133]
  We argue that governing internet-wide agent societies requires institutional design, not merely risk enumeration or process compliance.<n>Applying Talcott Parsons' AGIL framework, we derive a prescriptive sixteen-cell institutional architecture for internet-wide agent governance.<n>We conclude with a prioritized roadmap for the missing governance infrastructure.
  arXiv  Detail & Related papers  (2026-04-13T11:37:46Z)
• Decision Trace Schema for Governance Evidence in Real-Time Risk Systems [0.0]
  No single logging format captures the complete governance-relevant record of how a decision was reached.<n>DES defines ten required root-level fields and introduces a tiered evidence strategy.<n> DES is the only specification covering all four layers simultaneously.
  arXiv  Detail & Related papers  (2026-04-10T13:06:38Z)
• Telecom World Models: Unifying Digital Twins, Foundation Models, and Predictive Planning for 6G [60.29349053952935]
  We introduce the Telecom World Model(TWM) concept, an architecture for learned, action-conditioned, uncertainty-aware modeling of telecom system dynamics.<n>We propose a three-layer architecture, comprising a field world model for spatial environment prediction, a control/dynamics world model for action-conditioned Key Performance Indicator (KPI) trajectory prediction, and a telecom foundation model layer for intent translation and orchestration.
  arXiv  Detail & Related papers  (2026-04-08T09:41:58Z)
• Gym-Anything: Turn any Software into an Agent Environment [67.2443447990221]
  Gym-Anything is a framework for converting any software into an interactive computer-use environment.<n> CUA-World is a collection of over 10K long-horizon tasks spanning domains from medical science and astronomy to engineering and enterprise systems.
  arXiv  Detail & Related papers  (2026-04-07T17:38:15Z)
• UGAF-ITS: A Standards Harmonization Framework and Validation Tool for Multi-Framework AI Governance in Distributed Intelligent Transportation Systems [1.1002771741647328]
  UGAF-ITS is a standards harmonization framework that consolidates 154 source obligations into 12 unified controls across eight governance domains.<n>A three-tier operating model allocates each control to the vehicle, edge, or cloud tier where enforcement and defensible evidence production are feasible.<n>An evidence backbone of 20 versioned artifacts supports a single audit package across all three frameworks.
  arXiv  Detail & Related papers  (2026-04-07T09:37:05Z)
• MASEval: Extending Multi-Agent Evaluation from Models to Systems [77.09381093359598]
  MASEval is a framework-agnostic library that treats the entire system as the unit of analysis.<n>It allows researchers to explore all components of agentic systems, opening new avenues for principled system design.
  arXiv  Detail & Related papers  (2026-03-09T18:46:17Z)
• From Agent-Only Social Networks to Autonomous Scientific Research: Lessons from OpenClaw and Moltbook, and the Architecture of ClawdLab and Beach.Science [0.0]
  OpenClaw and Moltbook produced a large-scale dataset of autonomous AI-to-AI interaction in January 2026.<n>This study conducts a multivocal literature review of that ecosystem and presents two complementary platforms for autonomous scientific research.
  arXiv  Detail & Related papers  (2026-02-23T13:10:01Z)
• The Agentic Regulator: Risks for AI in Finance and a Proposed Agent-based Framework for Governance [6.107950696680386]
  Current model-risk frameworks assume static, well-specified algorithms and one-time validations.<n>We model these technologies as decentralized ensembles whose risks propagate along multiple time-scales.<n>We propose a modular governance architecture that decomposes oversight into four layers of "regulatory blocks"
  arXiv  Detail & Related papers  (2025-12-12T05:57:32Z)
• Learning to Route: A Rule-Driven Agent Framework for Hybrid-Source Retrieval-Augmented Generation [55.47971671635531]
  Large Language Models (LLMs) have shown remarkable performance on general Question Answering (QA)<n>Retrieval-Augmented Generation (RAG) addresses this limitation by enriching LLMs with external knowledge.<n>Existing systems primarily rely on unstructured documents, while largely overlooking relational databases.
  arXiv  Detail & Related papers  (2025-09-30T22:19:44Z)
• MCP-Orchestrated Multi-Agent System for Automated Disinformation Detection [84.75972919995398]
  This paper presents a multi-agent system that uses relation extraction to detect disinformation in news articles.<n>The proposed Agentic AI system combines four agents: (i) a machine learning agent (logistic regression), (ii) a Wikipedia knowledge check agent, and (iv) a web-scraped data analyzer.<n>Results demonstrate that the multi-agent ensemble achieves 95.3% accuracy with an F1 score of 0.964, significantly outperforming individual agents and traditional approaches.
  arXiv  Detail & Related papers  (2025-08-13T19:14:48Z)
• Entity-Switched Datasets: An Approach to Auditing the In-Domain Robustness of Named Entity Recognition Models [49.878051587667244]
  We propose a method for auditing the in-domain robustness of systems, focusing specifically on differences in performance due to the national origin of entities. We create entity-switched datasets, in which named entities in the original texts are replaced by plausible named entities of the same type but of different national origin. We find that state-of-the-art systems' performance vary widely even in-domain: In the same context, entities from certain origins are more reliably recognized than entities from elsewhere.
  arXiv  Detail & Related papers  (2020-04-08T17:11:31Z)

This list is automatically generated from the titles and abstracts of the papers in this site.

This site does not guarantee the quality of this site (including all information) and is not responsible for any consequences.