Abstract
The Bank’s Treasury and Risk Management team struggled with the Netting Schedule Report, critical for counterparty risk management and regulatory compliance. Manual extraction of data from Workday ERP, emails (LCH files), and SQL databases (HACS files) created complex, multi-step workflows. Staff spent excessive time reconciling derivatives, securities financing transactions, and performing risk-adjusted calculations using spreadsheets. This labor-intensive process delayed report distribution, increased human error risk, misallocated skilled resources, and impeded timely decision-making. Inefficiencies affected collateral optimization and accurate assessment of counterparty exposure. The Bank needed an automated, streamlined solution to reduce manual effort, improve accuracy, and accelerate reporting.