Case Studies
Financial Services

Collections Exception Intelligence

A mid-market NBFC eliminated 90 minutes of daily manual reconciliation and reduced exception discovery lag from 14 hours to under 2 minutes.

12,000 accounts, one exception brief, zero engineering after week one.

At a Glance

ClientMid-market NBFC, consumer lending
IndustryFinancial Services — Lending & Collections
Scale12,000 active loan accounts
Systems ConnectedData warehouse (loan/account) · Operational database (collections cases) · Banking-partner S3 file (mandate status)
Workflow DeployedCollections Exception Intelligence
Deployment18 days, read-only, zero engineering after connection

Key Metrics

Exception Detection

14h → 2min

Time from a mandate bounce or DPD breach to an ops alert.

Time to Live

18 days

Read-only connection to first live exception brief.

Engineering Dependency

Zero

Engineering hours spent maintaining the workflow after go-live.

The Situation

An NBFC managing 12,000 active loan accounts had its operational data split across three systems: loan disbursement and account metadata in a data warehouse, active collections cases in an operational database, and weekly mandate status files uploaded from their banking partner to S3. Nobody was watching all three simultaneously. Every morning, two analysts spent 90 minutes pulling exports, running VLOOKUPs, and building a reconciliation sheet to identify which accounts had missed mandates, which were approaching DPD thresholds, and which were already in breach. Exceptions were discovered an average of 14 hours after they occurred.

Ninety minutes, every morning, just to find out what already went wrong yesterday.
Current State — Before Autonmis
Broken

Data sources

Data Warehouse

Loan disbursement & account metadata

Operational DB

Active collections cases

Banking Partner File

Mandate status (S3 upload)

No unified view — sources never sync

Failure events

14 hour discovery lag
90 min daily manual export
Exceptions found when clients call

What Was Breaking

Why manual operations couldn't scale

01

Three systems, no shared view.

Loan and account data lived in the warehouse, live collections cases in the operational database, and mandate status arrived as a weekly file from the banking partner — nobody was checking all three against each other on any given day.

02

A fixed cost before any real work started.

Two analysts spent 90 minutes every morning exporting, running VLOOKUPs, and rebuilding the same reconciliation sheet — regardless of how many real exceptions existed that day.

03

Discovery took 14 hours on average.

A bounced mandate or a DPD breach typically surfaced at the next morning's reconciliation, not the moment it happened.

04

The failure compounded.

A bounce not caught same-day routinely became a second missed EMI before anyone followed up — turning a one-step recovery into a multi-step one.

The approach

The Approach

1

Connect your sources

Read-only connection to DWH, operational DB, and S3 — 30 minutes, no engineering required.

2

Configure rules in plain language

SLA definitions, DPD thresholds, mandate bounce logic — written by ops, not SQL engineers.

3

Autonmis watches continuously

Cross-source evaluation runs on schedule. Exceptions surface in Slack before anyone escalates.

After

Data Warehouse

Loan disbursement & account metadata

Operational DB

Active collections cases

Banking Partner File

Mandate status (S3 upload)

Autonmis

Governed Intelligence Layer

Knowledge Base

rules · thresholds · logic

6am Exception Brief
Live Exception Dashboard
Real-time Breach Alerts

Connected read-only to all three sources in a single session. The Knowledge Base was configured with SLA definitions, DPD threshold rules, and mandate bounce classification logic — in plain language, no SQL required. Autonmis then ran automated cross-source reasoning on a schedule, evaluating every account against its SLA tier, detecting mandate failures as they arrived, and delivering a structured exception brief to the ops lead's Slack at 6am every morning. Real-time threshold alerts fired during the day when a breach occurred — before anyone escalated.

The workflow went from draft to production in 18 days. No engineering involvement after initial data source connection.

The Workflow

TriggerA mandate bounce is recorded in the banking-partner file, or an account crosses a configured DPD threshold in the operational database.
Data SourcesData warehouse (loan/account metadata) · Operational database (collections cases) · Banking-partner S3 file (mandate status)
Runs AsContinuous cross-source evaluation against Knowledge-Base-defined SLA and DPD rules; 6am structured exception brief to Slack, plus real-time threshold alerts through the day.
Human in the LoopOps lead reviews the 6am brief and initiates outreach on flagged accounts; escalation to legal/recovery requires ops sign-off once an account crosses the highest DPD tier.

Results

14 hours → under 2 minutes

Exception discovery lag

Previously discovered when a client escalated

Audited against the 14-hour average discovery lag measured before go-live.

90 minutes → zero

Daily analyst time on reconciliation

Two analysts freed from daily export + VLOOKUP

Audited against the two analysts' daily manual-reconciliation time prior to connection.

Eliminated entirely

Manual reconciliation process

Cross-source check now runs automatically

18 days

Time to first live workflow

From zero to production exception alerts

None

Engineering dependency for ongoing operation

Ops team runs it independently

Governance Note

Every threshold in this workflow runs against the DPD and mandate-bounce logic the ops team defined in the Knowledge Base — not a generic guess at what 'overdue' means.

Implementation

Time to live

3 weeks to first live exception alert

Sources connected

3 (DWH, operational DB, S3 file)

Engineering dependency

Zero

Ready to see it in your stack?

We can scope your use case to a live workflow in the first session.

Three sources. No engineering dependency. First automation in under three weeks.

Book a 30-minute call

Composite deployment example. The business workflow reflects real implementation patterns. Company names, operational data, and reported outcomes have been synthesized for illustration.