Leonardo FilhoData Engineering Specialist
Download resumePDFPTEN
All projects

Internal product

Financial audit automation

A bot that audits ERP accounts payable against 14 rules, goes through human review and alerts each owner.

PythonBigQueryCloud RunMicrosoft GraphGemini
The bot's daily flow, from the ERP to the owner's inbox, and the funnel of a 30-day window.

Developed at Quadra Engenharia. This overview describes the work while keeping internal code and data private.

2 → 32companies covered
58% → 34%false positive rate
66% → 88%PDF matching precision

A production bot that checks the payables posted in the ERP. Each operational rule (due date, attachment, chart of accounts, tax document) becomes a reproducible check, and no alert goes out without human review.

How it works

  • The ERP is copied into BigQuery throughout the day. The bot applies 14 rules and drops known exceptions such as taxes, fees and reimbursements.
  • A reviewer marks each alert as valid or not. Only approved alerts become emails, one per owner.
  • The next morning the bot rechecks the source to see whether each item was fixed, paid or is still open, feeding a weekly scoreboard.
  • Runs on Cloud Run with per-run telemetry shared by the platform's 9 bots.

Results

  • Coverage grew from 2 companies to all 32 in the group.
  • The false positive rate fell from 58% to 34% by aligning the run schedule with posting patterns.
  • AI-based PDF reading raised amount-matching precision from 66% to 88%.
  • Within 30 days, owners fixed 258 of 427 fixable alerts.