Driver pay and settlement automation
Dispatch updates arrived as chat messages, and settlement invoices ran to hundreds of rows. We built a chat-message parser, an invoice importer, a pay engine that supports several pay policies, and automatic reconciliation of promised versus paid.
The reconciliation exposed a structural calculation error worth five figures a week.
Python, PostgreSQL, Telegram Bot API, Airtable sync