AWS Athena
Data storage and analytics layer for working with large client datasets.
Internal audit · ratio monitoring showcase
Data Visualization Ratio Monitoring
A graph-led showcase of a specific ratio monitoring use case, designed to make control performance easier to review across time, clients, and supporting financial context.
The page supports the outcome of an internal audit by making threshold exceptions, persistence, and related amounts visible in one place. The example data covers 4 clients and 18 monthly snapshots from January 2025 through June 2026.
All data is fictitious and intended solely to showcase data visualization for ratio monitoring; it does not represent a real audit conclusion.
Tools and platforms used
SQL
Query, filter, aggregate, and extract breach patterns and supporting figures.
Codex + GPT-5.5
Support for SQL development, fast iteration, and the interactive graphing layer.
Page technique
Next.js, Recharts, and fixed mock data combine ratio monitoring with supporting amounts.
Client timelines · 18 months
Where the 80% control line gets crossed
Blue / left axis shows total equity in USD. Red / right axis shows the monitored ratio; the 80% limit is marked in the same red family.
Example Client
AURORA-17
Peak equity$3,317,749
Peak monitored ratio86.4%
Months above 80%9
Latest snapshotJun 2026 · 82.1% · $3,171,307
Breach windowJan 2025 to Jun 2026
Example Client
KITE-42
Peak equity$3,171,414
Peak monitored ratio86.3%
Months above 80%12
Latest snapshotJun 2026 · 82.3% · $3,012,933
Breach windowJan 2025 to Jun 2026
Example Client
NOVA-88
Peak equity$4,529,843
Peak monitored ratio86.6%
Months above 80%6
Latest snapshotJun 2026 · 83.2% · $4,529,843
Breach windowJan 2025 to Jun 2026
Example Client
CINDER-31
Peak equity$6,119,616
Peak monitored ratio91.0%
Months above 80%12
Latest snapshotJun 2026 · 82.6% · $5,336,839
Breach windowJan 2025 to Jun 2026