Case study · Citi Custody Operations · Apr – May 2022

Project Daisy

Settlement monitoring for Citi's custody operations team. One place to go from a firm-wide view of pending trades down to the single instruction holding everything up, in a few clicks.

Enterprise dashboardsData visualizationFinancial operations
Variance vs. DTC
−$0.90M
Out of tolerance
Instruction pipeline
1,000Received
68In progress
834Settled
98Exceptions
58:37to cutoff
DTC · DVP
20,000 pending
RoleUX Designer, IBM
ClientCiti Custody Operations & Custody IT
TeamDevelopers, data analysts, ops and IT stakeholders
What I didWorkshops, research, wireframes, hi-fi prototypes, component system
Overview

Every trade has a deadline

Citi Custody settles tens of thousands of securities trades a day through depositories like DTC and the Federal Reserve. Each trade passes through a chain of systems: intake, sanctions screening, validation, then settlement. It has to clear all of them before a hard cutoff.

When something breaks, the operations team needs to know three things fast: what broke, where it's stuck, and how much money is on the line. Project Daisy gave them one set of dashboards to answer all three, from the top-level picture down to a single trade.

Two groups use it. Custody Operations analysts track trades and exposure. Custody IT production support keeps the message flow between systems healthy during critical hours.

The chain every trade travels
CitiSwitchGatewayAICitiSanctionscreeningASTRACitiSpanDTC · FED

These are Citi's internal system names. "AI" is one of the systems in the chain, not artificial intelligence.

The problem

Lots of data, not many answers

01

No clear signal

The dashboards the team had lacked clarity and actionable insight, which made it slow to spot and deal with transaction risk.

02

Too dense to read

Users needed visuals that made complex metrics make sense, both at the high level and down at the individual trade.

03

Nothing matched

Design and usability were inconsistent from one dashboard to the next, so every view had to be learned on its own.

Discovery

Listening to the people on the clock

40%of users said they were unhappy with the usability of the dashboards they relied on

I ran stakeholder interviews and user research with the operations and IT teams, then mapped how they actually worked through a settlement day.

  • Two modes, no bridge. Analysts switch between scanning the big picture and hunting down one trade. Moving between the two was the pain point we heard most.
  • Exceptions blended in. The numbers that needed action didn't stand out from the ones that didn't, so finding risk meant reading everything.
  • Not every metric matters equally. Working with the data teams, we ranked the metrics that drive decisions and built the visuals around those.

I also ran design workshops to get stakeholders aligned early and turn their input into concrete dashboard features.

Approach

Overview first, detail one click away

The whole product follows one drill-down path. Every number is a doorway to the level below it, and filters carry through so context never gets lost.

Level 1DepositoryDTC · FED
Level 2Client groupPlatinum · Other
Level 3ClientTop 10 by amount
Level 4AccountPipeline · exposure
Level 5TradeFull lifecycle

Let exceptions find you

Color is reserved for status. Red only ever means "this needs action," so it means something when it shows up.

Say it in plain language

Variance, status and fail reasons are written out instead of left for people to work out from the numbers.

One system, every screen

Shared filters, tables, chips and charts mean that once you learn one view, you know them all.

WorkshopsAlign stakeholders on goals and features
WireframesMap layouts and drill-down paths
PrototypesHi-fi, clickable flows
Feedback roundsIterate with users at each stage
BuildWork with devs and data analysts on feasibility
The design

Eight screens, one path

Screens 01 to 06 follow one analyst's drill-down, from the full DTC picture to a single failed trade. Screens 07 and 08 are the IT production support views. All data is illustrative.

01
Where the day starts

Settlement overview

The landing view answers the first question every analyst asks: are our books and the depository telling the same story? Citi custody and DTC sit side by side with the variance spelled out, so nobody has to subtract columns in their head.

DaisyCustody OperationsSearch CUSIP, TN, client or accountLive · May 25, 2022 · 2:31 PM ET
DTC/All client groups
Settlement overview
ExportDrill into clients
Depository DTCClient group AllDate Today+ Add filter
Pending trades
50,000
40,000 deliver · 10,000 receive
Pending settle amount
$37.00M
700,000 shares on Citi books
Variance vs. DTC
−$0.90M
Out of tolerance 1,800 trades unmatched
Next cutoff · DTC DVP
58:37
20,000 trades still pending
Today's pending settlement
Citi custody books vs. DTC · in tolerance up to $0.20M, watch up to $0.40M
AmountShares
Citi custodyDTC (depository)Variance
SegmentTradesSharesAmountTradesSharesAmountTradesAmountStatus
All clients
Total50,000700,000$37.00M48,200688,400$36.10M−1,800−$0.90MOut of tolerance
Deliver40,000400,000$24.00M38,600391,000$23.40M−1,400−$0.60MOut of tolerance
Receive10,000300,000$13.00M9,600297,400$12.70M−400−$0.30MWatch
Platinum
Total35,000550,000$25.00M34,600546,000$24.80M−400−$0.20MIn tolerance
Deliver27,000310,000$16.00M26,700306,500$15.85M−300−$0.15MIn tolerance
Receive8,000240,000$9.00M7,900239,500$8.95M−100−$0.05MIn tolerance
Other
Total15,000150,000$12.00M13,600142,400$11.30M−1,400−$0.70MOut of tolerance
Deliver13,00090,000$8.00M11,90084,500$7.55M−1,100−$0.45MOut of tolerance
Receive2,00060,000$4.00M1,70057,900$3.75M−300−$0.25MWatch
Settled vs. unsettled
DTC trades due to settle today
70.8%settled
Settled121,000
Unsettled50,000
Unsettled delivers
40,000 trades · by reason
Failed15,000
ASTRA exception10,000
New same-day10,000
AI exception5,000
Unsettled receives
10,000 trades · by reason
Failed3,000
ASTRA exception2,500
AI exception2,500
New same-day2,000
02
Who needs attention

Client performance

One level down, the top clients are ranked by settlement amount with a settlement rate bar on every row. Client E jumps out right away: big unsettled exposure on a small book.

DaisyCustody OperationsSearch CUSIP, TN, client or accountMay 25, 2022 · 5:02 PM ET · end of day
DTC/Platinum/Top 10 · MTD
Client settlement performance
Export
Depository DTCClient group PlatinumClients Top 10Period Month to date+ Add filter
Settled MTD
$759.90M
968,749 trades
Unsettled now
$32.20M
24,306 trades
Settlement rate
95.9%
Target 95%
Clients below target
4
Client E at 42.6%
Month to date · settled vs. unsettled
Top 10 Platinum clients by settlement amount
AmountTradesUnits
SettledUnsettled
#ClientTradesAmount ↓TradesAmountSettlement rate
1Client G151,233$384.20M100$1.10M
99.7%
2Client N149,871$105.30M3,497$3.90M
96.4%
3Client M280,972$90.70M3,497$4.20M
95.6%
4Client D25,976$41.80M3,497$5.60M
88.2%
5Client J148,610$39.30M100$0.40M
99.0%
6Client L139,402$38.60M2,603$2.90M
93.0%
7Client B24,118$36.00M100$0.20M
99.4%
8Client E16,910$9.20M4,812$12.40M
42.6%
9Client A16,450$8.70M3,497$1.20M
87.9%
10Client K15,207$6.10M2,603$0.30M
95.3%
DTC fails by reason code
320 failed instructions
Net balance order REC DK90
No deposit CR · claim filed vs. broker80
Trans cust A/C REC DK60
DVP reclaim DK50
Awaiting shares from counterparty20
Awaiting money10
Security frozen by depository10
Fails by clearing broker
Failed units by broker ID
Broker 0066659,366
Broker 0077750,000
Broker 0003325,000
Broker 0009917,000
Broker 0004411,000
Broker 0000510,000
03
Following the work through the chain

Instruction pipeline

Coming from the client view, Client E's low settlement rate needs an explanation. Every instruction moves through intake, sanctions screening, validation and settlement, and this view shows where each one sits right now, so you can see exactly where an account's trades are piling up.

DaisyCustody OperationsSearch CUSIP, TN, client or accountLive · May 25, 2022 · 2:31 PM ET
DTC/Platinum/Client E/All accounts
Instruction pipeline · Client E
CountsAmounts
Depository DTCClient Client EAccount AllTransaction type All+ Add filter
Received today1,000across 6 accounts
In progress68routing, screening, validating
Settled83483.4% of today's instructions
Exceptions9848 AI · 2 ASTRA · 48 failed
Where each instruction is right now
Every instruction received today sits in exactly one stage, so each row adds up to its total
IntakeScreeningValidationSettlement
AccountReceived todayFGRRoutingGWIn screeningCS requestSanction hitAI replyClearedAI replyCancelledGWAI exception—ValidatedASQReadyCIF · CFSIASTRA exc.—SettledASQFailedASQ
8209314223—2—104——11110
8209428554—3—158—223315
8210112621—2—232—1122
8212416232—1—74——1387
8212612722—1—521—1095
8217215822—2—93——1319
Total1,0001614—11—48243283448
Needs actionException stages only light up when they hold work. Click any count to open those trades.
04
Splitting an account open

Pipeline by transaction type

Expanding an account breaks it into DVP, RVP, DF and RF, so an analyst can tell whether a pile of exceptions is one bad flow or a wider problem. Filters live in a side panel that keeps the table in view.

DaisyCustody OperationsSearch CUSIP, TN, client or accountLive · May 25, 2022 · 2:31 PM ET
DTC/Platinum/Client E/All accounts
Instruction pipeline · by transaction type
Collapse all
Depository DTCClient Client EAccount AllTransaction type All+ Add filter
2 empty stages hiddenSanction hit and Cancelled have no work for this client today.
IntakeScreeningValidationSettlement
AccountReceived todayFGRRoutingGWIn screeningCS requestClearedAI replyAI exception—ValidatedASQReadyCIF · CFSIASTRA exc.—SettledASQFailedASQ
82093142232104——11110
DVP12012173——1024
DF2———————11
RVP1511131——62
RF5———————23
82094285543158—223315
DVP20021155——1824
DF10———5———14
RVP6522133—2484
RF101112———23
82101126212232—1122
8212416232174——1387
82126127221521—1095
8217215822293——1319
Total1,00016141148243283448
FiltersReset
DTC
Client E
All accounts
AllDVPRVPDFRF
Exceptions only
Hide empty stages
CancelApply
05
How much money is on the line

Account exposure

At the account level, the question becomes exposure. Totals for deliver and receive sit above the trade list, and open items are counted and valued so the team knows exactly what is still at risk at end of day.

DaisyCustody OperationsSearch CUSIP, TN, client or accountMay 25, 2022 · 5:02 PM ET · end of day
DTC/Platinum/Client A/028373
Account exposure · 028373
Export
Depository DTCClient Client AAccount 028373+ Add filter
Total exposure
$118.25M
8 instructions · 230 units
Deliver
$94.95M
5 instructions
Receive
$23.30M
3 instructions
Open items
3
2 need action $301.4K at risk
End-of-day exposure
Client A · Account 028373 · DTC
All 8Open 3Settled 5
TypeCUSIPTNCustomer ref.Trade dateSettle dateQtySettlement amountBrokerStatus
DP25856T1082133700258NFT43519677098705/23/2205/25/2220$54,600,000.0000005Settled
DP88160R1012133700268NFT43519677099705/23/2205/25/2234$39,175,971.0066666Settled
RF02856T10821337002252NFT43519677098105/23/2205/25/2236$20,500,000.0088888Settled
RP02856T108Missing TNNFT43519677116605/23/2205/25/2241$116.0066666Not ready
DP88160R101Missing TNNFT43519677117805/23/2205/25/2221$258.0000005AI exception
RP21850910T21337002242NFT43519677097105/23/2205/25/2228$2,800,000.0066666Settled
DP02856T10821337002262NFT43519677099105/23/2205/25/2224$877,000.0000005Settled
DP88160R10121337002264NFT43519677099405/23/2205/25/2226$301,000.0066666Failed
DP Deliver vs. paymentRP Receive vs. paymentRF Receive free
06
The single trade that's holding things up

Trade lifecycle

The last step of the drill-down. Each trade shows a seven-step tracker, and selecting one opens a timeline with every system hop, timestamp and the fail reason. No more reading a 20-column grid of timestamps.

DaisyCustody OperationsSearch CUSIP, TN, client or accountMay 25, 2022 · 5:02 PM ET · end of day
DTC/Platinum/Client A/028373
Trade lifecycle · 028373
Depository DTCClient Client AAccount 028373+ Add filter
Trade lifecycle
Client A · Account 028373 · 8 instructions
TypeCUSIPAmountReceived → SettledStatus
DP25856T108$54,600,000.00
Settled
DP88160R101$39,175,971.00
Settled
RF02856T108$20,500,000.00
Settled
RP02856T108$116.00
Not ready
DP88160R101$258.00
AI exception
RP21850910T$2,800,000.00
Settled
DP02856T108$877,000.00
Settled
DP88160R101$301,000.00
Failed
Complete Waiting Exception / failed Not reached
Trade · TN 21337002264
$301,000.00 Failed
CUSIP88160R101TypeDeliver vs. paymentCustomer ref.NFT435196770994Clearing broker66666Trade / settle05/23/22 → 05/25/22
Lifecycle
ReceivedFGR · CitiSwitch → Gateway
10:53:02
RoutedGateway → AI
10:53:04
Screening requestedCS.REQUEST.REMOTE · AI → CitiSanction
10:53:05
Sanction clearedAI.REPLY.LISTEN · CitiSanction → AI
10:53:09
ValidatedASQ · AI → ASTRA
10:53:12
Ready to settleASQ · CitiSpan → ASTRA
10:53:15
Settlement failedCIP · ASTRA → CitiSpan DTC
16:13:40
Fail reasonDVP reclaim DK · counterparty did not affirm
Copy detailsOpen in ASTRA
07
What IT production support watches

Message queue volume

Behind every trade is a chain of message queues. This heatmap shows traffic for each queue by transaction type, so the support team can spot hot spots without reading every number.

DaisyCustody OperationsSearch CUSIP, TN, client or accountLive · May 25, 2022 · 2:31 PM ET
All depositories/Today
Message queue volume
Count% of total
Depository AllDate Today+ Add filter
Messages today
90,250
across 9 queues
Busiest queue
CIP
22,750 · ASTRA → CitiSpan DTCC
Busiest flow
RVP → ASQ
10,000 · CitiSpan → ASTRA
Transaction count per message queue
By transaction type · darker cells carry more traffic
FewerMore messages
TypeFGRCitiSwitch → GWGatewayGW → AICS.REQUESTAI → CitiSanctionAI.REPLYCitiSanction → AIASQAI → ASTRAUTIASTRA → AIASQCitiSpan → ASTRACIPASTRA → CitiSpan DTCCCFSIASTRA → CitiSpan FRBTotal
DVPDeliver vs. payment5,0002,1005,0007,0001,9005001,0007,50030030,300
RVPReceive vs. payment1,0001,1001,2002,0003,00050010,00075010019,650
DFDeliver free2,0001,1502004,0005,0002505,0007,00020024,800
RFReceive free1,0001,1001,2001,0001,9005001,0007,50030015,500
Total9,0005,4507,60014,00011,8001,75017,00022,75090090,250
08
Throughput and the race to cutoff

Production support

The IT view pulls together three things the support team juggles during critical hours: how each hop is performing against its benchmark, how volume is moving, and how much time is left in each settlement window.

DaisyCustody IT · Production SupportSearch CUSIP, TN, client or accountLive · May 25, 2022 · 2:31 PM ET
Custody IT/Today
Production support · exceptions
Alert settings
Depository AllWindow Critical hours+ Add filter
Message throughput vs. benchmark
Messages per hour on each hop of the settlement chain
On targetWithin 10%Below
Gateway → AI
1,000msg/hr
Benchmark 1,000On target
AI → CitiScreening
900msg/hr
Benchmark 1,000−10%
CitiScreening → AI
900msg/hr
Benchmark 1,000−10%
AI → ASTRA
1,250msg/hr
Benchmark 1,000+25%
ASTRA → CitiSpan
1,000msg/hr
Benchmark 900+11%
CitiSpan → ASTRA
1,500msg/hr
Benchmark 2,000−25%
ASTRA → AI
1,000msg/hr
Benchmark 1,500−33%
AI → Gateway
900msg/hr
Benchmark 900On target
DTC volume
Messages per 10 min across all queues, during critical windows
0
250
500
750
1K
4–7 AM
9–11 AM
2–3:30 PM
5–6:30 PM
6:30–8 PM
FED volume
Messages per 10 min across all queues, during critical windows
0
250
500
750
1K
8:30–8:40 AM
9 AM–3:30 PM
Countdown to cutoff
Time left in each settlement window, and what is still waiting
DTCDVP
58:37to cutoff
20,000 pending
12,000 on track5,000 at risk3,000 blocked
DTCDO settlement
48:37to cutoff
15,000 pending
9,000 on track4,000 at risk2,000 blocked
DTCFree transactions
3:58:37to cutoff
15,000 pending
12,500 on track1,500 at risk1,000 blocked
FEDTrades in / out
28:37to cutoff
10,000 pending
5,000 on track3,000 at risk2,000 blocked
FEDSettlements
58:37to cutoff
17,000 pending
11,000 on track4,000 at risk2,000 blocked
Design system

Built from shared parts

I standardized the components so navigation and usability stayed consistent everywhere. The palette stays in Citi's blues, and status colors are only used for status.

Color
Navy#002D72 · brand, headers
Cerulean#056DAE · links, actions
Settled#1F7A45 · healthy
At risk#C77700 · watch
Failed#D9261C · needs action
Status chips
SettledNot readyFailedNew same-day
Filters
Depository DTCClient Client A
Lifecycle stepper
KPI tile
Variance vs. DTC
−$0.90M
Out of tolerance
Rate bar
95.9%
Type
Overpass for UI · Overpass Mono for IDs
Impact

What it changed

30%less time spent analyzing transaction risk
35%increase in user satisfaction, measured in post-implementation surveys

Users got clear, accessible visuals that helped them make faster, better calls on transaction risk.

The dashboards lined up with Citi's business goals and balanced what users needed with what was technically feasible.

Reflection

What I'd take with me

Design for the worst minute of the day. The 30 minutes before a cutoff are when these screens matter most. Designing for that moment shaped everything from the color rules to where the countdown lives.

The data team is part of the design team. Deciding which metrics matter wasn't a UI decision. Working through it with the analysts made the dashboards simpler and more useful.

Consistency compounds. A shared set of components did more for usability than any single screen did.