Built for desktop screens. Scroll sideways to see each chart in full.
Work project
Operational Risk Overview
Monthly operational risk report for the board: net loss and risk capital (RWA) against the annual limits, the largest loss events of the month and the year, product trends and reliability incidents.
- Period
- Spring 2026
- Role
- Sole developer. Replaced the old notebook with SQL models in Greenplum, automated the process-to-P&L mapping, built the ClickHouse mart and all the charts
- Result
- One report that refreshes after month-end close, with no manual assembly
- Audience
- Executive board
- Stack
- SQL, Greenplum 6 (MPP), ClickHouse, Apache Superset 2.1, ECharts, JavaScript
- Data
- Synthetic. The production SQL belongs to the bank