SAO Psychotherapy

About the project

Technical audit and stabilization of a production clinical platform for a psychology clinic in Barcelona. I cross-referenced database records, bank logs, and Stripe events to detect silent webhook and billing failures. The work recovered more than EUR 1,200, fixed critical billing issues, and added safeguards against duplicates in automated charge flows.

Technologies

Features

• Technical financial audit with more than EUR 1,200 recovered and full traceability
• Stripe Connect bug fixes: migration to destination charges, 4-level anti-duplicates
• Atomic webhook stabilization and automatic billing system fixes
• Complete traceability of every euro to Stripe transaction ID
• Multi-system diagnosis and fixes (PostgreSQL + Stripe API + cron jobs + webhooks)

Technical challenges

• Joining production codebase with real money without breaking anything
• Diagnosing multi-system financial bugs (PostgreSQL + Stripe API + cron jobs + webhooks)
• Complete traceability of every euro to Stripe transaction ID
• Migration to destination charges without interrupting production service
• Implementing 4-level anti-duplicates for automatic charges

Learnings

• Technical financial auditing in real payment systems
• Advanced Stripe Connect: destination charges, idempotency, atomic webhooks
• Working with real money in production — zero tolerance for errors
• Forensic documentation of bugs with economic impact
• Full-stack development in regulated clinical environment