From chaos to clarity—here's what I've built for finance teams, government, healthcare, and growing businesses.
Turned raw accounting data into actionable financial insights. Client was drowning in manual Xero exports, scattered Excel files, no visibility into overdue invoices, and spending hours on monthly reports.
Production-grade data pipeline: Xero API → Microsoft Fabric → Delta Lake tables → Power BI dashboard. Automated daily refresh with OAuth 2.0 token management. Dashboard answers: How much are we owed? Who owes us the most? What's overdue? AR vs AP—are we cash positive? Which regions drive revenue?
• Automated daily data refresh
• Real-time AR aging analysis
• Instant cash flow visibility
• One-click executive summary
• Manual reporting eliminated completely.
Fast-growing SaaS company spending 5 days every month manually consolidating financial data for board reporting. By the time reports were ready, data was already outdated.
Automated Power BI dashboard showing P&L, cash flow, ARR, MRR, runway, and burn rate. One-click board reports with real-time data.
Month-end close reduced from 5 days to 3 hours (80% time saved). Better visibility into spend decisions extended company runway by 12+ months.
Manufacturing company manually calculating quotes in a massive Excel file. 10+ hours per week on pricing, frequent errors, no version control.
Automated VBA pricing tool with dynamic cost calculations, margin analysis, and instant PDF quote generation. Built-in validation to catch errors.
Pricing time cut from 10 hours/week to 2 hours. Zero pricing errors. Sales team can generate quotes independently.
City of Melbourne needed to track compliance across 25+ KPIs for waste management in CBD laneways. Manual Excel tracking made it impossible to see real-time status or identify problem areas.
Interactive Power BI dashboard tracking 25+ KPIs across all CBD zones. Real-time alerts for compliance issues, drill-down by location and contractor, automated monthly reporting.
Real-time visibility into laneway cleanliness. Compliance issues identified immediately instead of weeks later. Automated reporting saved 20+ hours per month.
Healthcare organization in Austin needed to track mental health crisis response times, resource allocation, and outcome metrics across the city. Data scattered across multiple systems.
Integrated dashboard pulling from multiple data sources. Python scripts for data cleaning and transformation. Real-time tracking of response times, resource deployment, and patient outcomes by district.
Leadership can now identify resource gaps immediately. Response time analysis by district helps allocate teams more effectively.
Healthcare provider needed comprehensive analysis of patient demographics, service utilization, and operational metrics to improve care delivery and resource planning.
Multi-dashboard system analyzing patient demographics, appointment patterns, resource utilization, and service quality metrics. Automated weekly and monthly executive reports.
Identified service gaps in specific demographics. Optimized staff scheduling based on actual utilization patterns.
Manufacturing company had no visibility into inventory levels, supplier performance, or production bottlenecks. Everything lived in disconnected spreadsheets.
Integrated dashboard showing real-time inventory, supplier delivery performance, production status, and quality metrics. Automated alerts for low stock and late deliveries.
Reduced stockouts by identifying issues earlier. Improved supplier accountability through performance tracking.
Personal project: Automate collection of my Spotify listening history for analysis. Wanted to build a production-grade data pipeline using Microsoft Fabric.
Automated data pipeline using Microsoft Fabric, Python, and PySpark. Daily API calls to Spotify, data transformation and loading to lakehouse, automated OAuth token refresh.
Fully automated pipeline runs daily. Demonstrated advanced skills in cloud data engineering and API integration for future client projects.
Let's talk about your data challenges and how I can help you scale.
Schedule a Call →