ALM processes relied on a fragmented DWH structure introducing data quality issues and taking 8 hours end-to-end. CALIGO designed a dedicated ALM DataMart integrated with SAS ALM, automating cash flow calculations and scenario analyses — cutting execution time to 4 hours.
ALM processes required a more isolated and purpose-built data flow than the existing DWH structure could provide. Data quality issues and the absence of a dedicated ALM layer limited the reliability of outputs. End-to-end execution took approximately 8 hours, delaying timely insights and decision-making for balance sheet risk management.
CALIGO designed and implemented a dedicated, isolated ALM DataMart fed from the DWH, enabling a controlled and consistent data layer tailored for ALM processes. This was integrated with SAS ALM, standardising and automating cash flow calculations, scenario analyses, and reporting. Targeted optimisations improved performance while maintaining flexibility for ad-hoc analytical needs.
Full automation of ALM processes was achieved, improving data consistency and reducing operational complexity. Execution time was reduced from 8 hours to 4 hours — a ~50% improvement — enabling faster and more reliable insights. The solution delivered a scalable, high-performing, analytics-ready ALM environment, strengthening the bank's ability to manage balance sheet risks.