Built a full-stack accounts payable reconciliation system from raw
transactional data to executive dashboard, covering every layer of
the data pipeline.
What was built:
• Python pipeline to generate and clean 194,000+ AP records
• PostgreSQL database with 6 analytical views (aging, risk scoring,
3-way matching, duplicate detection)
• Power BI dashboard across 6 pages: Executive Summary, Exception
Analysis, Supplier Risk, Three-Way Matching, Invoice Aging,
Invoice Details
Key findings surfaced:
• $193.5bn invoiced value · 72.5% payment coverage
• 9,933 exceptions flagged · $39.7bn value at risk
• 48 high-risk suppliers identified · 340 duplicate payments caught
• 88.1% three-way match rat
Tools: Python · PostgreSQL · Power BI · DAX · SQL
0 likes · 0 views · Nov 14, 2026
End-to-end AP analytics, Python pipeline, PostgreSQL, Power BI, tracking $193.5bn across 802 suppliers.