Lena OrtizChief compliance officer
Approver- Before
- Signs a narrative stitched together from eight sources, and has to trust each number in it.
- Now
- Hovers any figure to see the query behind it, and signs a version that is locked once approved.
One case, step by step
One quarter, from data close to a signed narrative
Q3 2026 closed on Sep 30. Brazil’s residual risk has risen to High, and the Compliance Committee meets on Oct 15. Here is what happens next, screen by screen, in the working solution.
- 01Morning
The quarter, on one screen
Lena Ortiz · Chief compliance officerLena opens the solution: residual risk rose in 5 of 12 markets, Brazil most at +2.0. 121 reports in four channels resolve to 83 distinct issues, and the committee report is due in 9 days. Under “Needs you”: the Q3 draft waiting for her approval, Brazil now High, one issue raised in four channels, an overdue margin-cap plan.
“Colombia — September monitoring feed not received. The report says “not available” for this figure; nothing was estimated.”
- 02One click
“Run quarterly narrative” — and the agents start
Lena Ortiz · Chief compliance officerThe eight sources load. The Query agent runs 214 read-only queries; the De-duplication agent turns 121 reports into 83 issues, merging 38 duplicates across four channels. Five guided analyses run in parallel, the Narrative writer drafts five sections, and the figure check traces 32 of 32 numbers. The last step waits for Lena.
“Draft ready. 32 figures, each from a live query · 2 empty results reported, not filled · waiting for your approval.”
- 03Next
The risk map: twelve markets, six risk areas
Lena Ortiz · Chief compliance officerResidual risk by market and area on a 1–25 scale — HCP engagement, distributors, tenders, grants, hospitality and demo kit — each cell a live query over the risk assessment scores. Brazil sits at 13.0 · High, with distributors at 19 and tenders at 15. Colombia carries a “gap” flag for its missing feed.
- 043.5 seconds
What moved Brazil — two areas explain the whole rise
Risk movement analystBrazil went from 11.0 to 13.0, the largest rise of the 12 markets. Distributors & agents went 12 → 19: the due-diligence control was rated Weak after 7 of 19 distributor reviews were overdue at quarter end, against 1 of 19 in Q2. Public tenders went 10 → 15: only 5 of 8 sampled tender reviews passed testing. The other 4 of 6 areas did not move.
“Investigations closed in Brazil this quarter: None — the query returned no rows, so the report says none.”
- 05Hover any figure
Every number, with the query behind it
Query agentEach figure the analyst wrote sits in the Figures panel with its value, the query text, the row count, the source and the time it ran. Hover “12 → 19” and the query over the risk assessment scores appears: 2 rows, ran Oct 6, 09:14. The control rating comes from the control testing results, the overdue reviews from the third-party register.
- 06Next
Which issues drove it — each one counted once
De-duplication agent23 Brazil reports — 5 hotline, 5 audit, 10 monitoring, 3 investigation — resolve to 14 distinct issues, 8 of them in the two areas that moved. The largest, ISS-BR-031, is one allegation raised in all four channels: matched on Andara Distribuidora by tax ID, Hospital Santa Clara and payments through credit notes, at similarity 0.94, and confirmed by Rafael Souza, compliance lead for Brazil, on Oct 2.
Merges below 0.85 similarity go to the market compliance lead. A merge is reversible and logged.
- 07Ranked
Where to focus, ranked by risk lowered
Mitigation and focus analystThree actions for Brazil. Finish the 7 distributor due-diligence renewals — plan MP-BR-11, 3 of 7 done — which would take the area from 19 to 12 under the scoring rules (inherent 20 × 0.60). Close the margin-cap plan MP-BR-09, 6 days overdue, with credit notes coded “marketing support” at R$ 184,000. Send tender comments for legal review. Lena adds what she wants to the report.
“Projections use the published scoring rules only and are labelled as projections in the report.”
- 08Drafted
The narrative, in the committee’s language
Narrative writerFive sections — what moved the risk, which issues drove it, mitigation status, where to focus, data notes — opening with a short summary: average residual risk moved from 8.8 to 8.9, Brazil is the only market rated High, 6 of 42 open plans are overdue. Allegations are worded as allegations. The Colombia figure is reported as not available, with nothing carried over from August.
“32 of 32 figures traced to a live query · 2 empty results reported as such.”
- 09Signed
The officer approves, and signs
Lena Ortiz · Chief compliance officerLena reads the draft, hovers the figures she wants to check, and chooses Approve report. She signs with her password and the meaning of her signature — “I approve this report for the Compliance Committee”. Her name, the date and time and the meaning are recorded with the report, and the version is locked before it goes to the committee.
- 10Every quarter
How the narrative is produced, quarter on quarter
Maya Chen · Compliance analytics leadThe dashboard shows residual risk by quarter for Brazil, Mexico and all markets, and the time to write the narrative: 9 days and 8 days by hand, then 2.5 hours, 52 minutes and 38 minutes with the agents. Reports received against new distinct issues, per channel, and distinct issues by risk area sit alongside.