Citigroup, Columbus, OH, USA.
World Journal of Advanced Research and Reviews, 2024, 21(02), 2212-2220
Article DOI: 10.30574/wjarr.2024.21.2.0563
Received on 08 January 2023; revised on 24 February 2024; accepted on 27 February 2024
Securities pricing reconciliation across global markets demands sub-second validation of millions of vendor-sourced price quotes against configurable tolerance thresholds, with deterministic exception routing and regulatory-grade audit trails. Existing reconciliation systems apply static comparison logic, monolithic ETL pipelines, and manual exception queues that fail to scale across multi-vendor, multi-asset-class environments spanning NYSE and international exchanges. This paper presents the Distributed Pricing Reconciliation and Exception Governance Framework (DPREG), a production-deployed cloud-native platform at Citi Bank engineered to validate securities pricing across global markets through configurable business rule orchestration, multi-vendor consensus modeling, and autonomous exception lifecycle management. DPREG integrates a Tolerance-Adaptive Price Validation Engine (TAPVE), Multi-Vendor Consensus Scoring Model (MVCSM), Configurable Exception Routing Protocol (CERP), and Downstream Data Lake Publishing Gateway (DDLPG) within a microservices architecture containerized on OpenShift/Kubernetes. The platform orchestrates end-to-end price collection via Kafka-as-a-Service, IBM MQ, REST APIs, and SFTP, feeding multi-threaded validation services backed by SQL Server, Oracle, MongoDB, and Redis caching. Experimental and operational evaluation across live NYSE and global market feeds demonstrates throughput exceeding 2.8 million price validations per hour, tolerance breach detection precision of 99.3%, exception resolution latency below 4.2 seconds for automated workflows, and data lake publishing consistency of 99.997%. DPREG establishes a new architectural reference for enterprise-grade securities pricing governance in distributed financial cloud infrastructure.
Securities Pricing Reconciliation; Tolerance Validation; Exception Management; Multi-Vendor Consensus; Microservices Architecture; Openshift; Financial Cloud Infrastructure; Data Lake Publishing
Preview Article PDF
Arun Meesala. Distributed securities pricing reconciliation at global scale: Price validation engine for financial institutions. World Journal of Advanced Research and Reviews, 2024, 21(02), 2212-2220. Article DOI: https://doi.org/10.30574/wjarr.2024.21.2.0563