Operations Analytics with SQL
Analysed multi-table transaction and reconciliation data using SQL joins, CTEs, CASE statements, aggregations and window functions to investigate where payments were failing or going unreconciled, identifying a 21.3% card-transaction failure rate, 53 reconciliation exceptions and 13 customers with repeated failures.