π― Financial & Audit Analytics | Business Intelligence | Data Visualization
I build data solutions that turn financial and audit data into clear, actionable insights β from automated reports to interactive dashboards.
π I apply these tools to real-world financial and audit analytics problems β each project below solves a specific pain point faced by finance and audit teams.
- Design audit analytics dashboards that automate CAATs testing and flag high-risk GL entries
- Build financial reconciliation tools that surface mismatches across multi-entity, multi-currency trial balances
- Create procurement spend dashboards that standardise vendor data and track off-contract spend
- Develop ETL pipelines that merge messy multi-source financial data into clean, analysis-ready tables
| Project | Description |
|---|---|
| AuditLens | Power BI dashboard that flags high-risk GL journal entries β round numbers, weekend postings, after-hours entries, and duplicates β using CAATs audit logic |
| TrialPulse | Multi-entity, multi-currency Trial Balance reconciliation dashboard that flags mismatched GL accounts and quantifies variances across 3 entities in Power BI |
| FinancialReporting | Tableau P&L analytics dashboard for TurtleCo covering FY2018β2020 β tracks gross profit, EBITDA, net profit margins, and marketing spend across regions |
| DataBridge | Power BI ETL pipeline that merges GL exports from SAP, Oracle, and manual sources into one clean consolidated table with a 97.5% data quality score |
| SpendMap | AP procurement dashboard that standardises vendor names, flags Β£4.56M in off-contract spend, and surfaces Pareto concentration insights across 1,000 transactions |