🏦
Banking

Enterprise Financial Data Warehouse

The Challenge

A large financial institution was running month-end reporting across 11 disconnected source systems — core banking, GL, CRM, and loan origination — resulting in a 6-day close cycle, frequent reconciliation failures, and no single trusted view of the balance sheet.

What We Built

Designed and delivered a centralised cloud data warehouse on Azure Synapse, with automated ELT pipelines ingesting and reconciling data from all 11 source systems nightly. Built a layered data model (raw → staging → conformed → reporting) aligned to BCBS 239 data lineage requirements.

6d → 1dMonth-end close cycle
11Source systems integrated
99.8%Reconciliation accuracy
Azure Synapse dbt Python Azure Data Factory SQL Power BI
📉
Credit & Lending

Credit Risk Scoring & PD Model

The Challenge

A consumer credit provider was using a legacy scorecard built on 3-year-old bureau data. Approval rates were declining and bad debt was rising — the model no longer reflected current borrower behaviour in a post-COVID credit environment.

What We Built

Rebuilt the probability of default (PD) model using gradient boosting on 24 months of behavioural, bureau, and transactional data. Included full model documentation, champion/challenger testing infrastructure, and a monitoring dashboard tracking Gini, KS, and PSI monthly.

+18ptsGini coefficient improvement
-22%Bad debt on new originations
<200msReal-time scoring latency
Python scikit-learn XGBoost MLflow SQL Server Power BI
📋
Banking

IFRS 9 Provisioning & Regulatory Reporting Automation

The Challenge

The finance team at a mid-size bank was manually calculating IFRS 9 expected credit loss (ECL) provisions in Excel each quarter — a 10-day process prone to error, version conflicts, and audit risk. Regulatory submissions were consistently late.

What We Built

Built an automated ECL calculation engine that stages loans, applies PD/LGD/EAD models per IFRS 9 stage, and produces a full provision report with audit trail. Integrated directly into the GL for journal entry generation and connected to the PA reporting template for regulatory submission.

10d → 4hQuarterly provisioning cycle
100%Audit trail coverage
0Late regulatory submissions
Python SQL Server dbt Excel (output) Azure DevOps
👤
Fintech

Single Customer View & 360 Data Platform

The Challenge

A bank with five product lines (home loans, personal loans, vehicle finance, credit cards, and transactional accounts) had no unified view of a customer's full relationship. Marketing, credit, and collections teams each operated from different, conflicting customer records.

What We Built

Designed and built a master customer data platform with entity resolution logic to deduplicate and link records across all five product systems. The resulting SCV feeds the CRM, the credit risk engine, and a real-time customer profitability model used by relationship managers.

5Product systems unified
+31%Cross-sell conversion rate
SingleSource of truth for all teams
Python Snowflake dbt Apache Spark Tableau
💳
Credit & Lending

Collections Intelligence & Arrears Prioritisation

The Challenge

A credit provider's collections team was working a flat call list — every account in arrears treated equally. High-value accounts that were likely to cure were receiving the same attention as low-value chronic defaulters, wasting agent time and missing recovery opportunities.

What We Built

Built a collections scoring model that predicts the probability of cure within 30 days for each arrear account, weighted by exposure at risk. The model feeds a daily prioritised work queue for collections agents, with a management dashboard tracking roll rates, cure rates, and agent performance.

+27%Collections recovery rate
-35%Agent time on low-value accounts
DailyAutomated queue refresh
Python XGBoost SQL Server Power BI Azure Functions
Banking

Real-time Fraud & AML Transaction Monitoring

The Challenge

A digital payments provider was running batch fraud detection on a 4-hour lag — by the time alerts fired, fraudulent funds had already moved. The existing rules-only engine was also generating a high volume of false positives that overwhelmed the compliance team.

What We Built

Deployed a streaming transaction monitoring pipeline processing events in real time, combining a rules engine with an ML anomaly detection layer. The ML layer learns customer spending patterns and flags deviations, dramatically reducing false positives while improving the true fraud catch rate. Alerts route to a case management dashboard for analyst review.

4h → 1.2sFraud detection latency
-61%False positive alert volume
+40%True fraud catch rate
Apache Kafka Python Spark Streaming Isolation Forest PostgreSQL Grafana

Project details have been anonymised to protect client confidentiality. Outcome figures reflect actual results achieved. Technologies listed are those used in each specific engagement.

See something relevant to your business?

We have likely solved a version of your problem before. Let's talk through it.

Start a Conversation