Automation-Driven VA Work
That Moves The Needle

Challenge

Executives spent 60+ hours each month manually compiling financial reports from multiple invoice sources and expense sheets, leaving little time for strategic decisions.

Solution

Built a Python + Google Sheets automation pipeline that ingests raw invoice data, reconciles expenses automatically, flags discrepancies, and generates formatted monthly reports in under 30 minutes.

Challenge

Managing 150+ inbound messages per week from parents and students manually, with responses taking 12+ hours on average and causing scheduling confusion.

Solution

Fine-tuned a BERT-based NLP model to automatically categorise and draft responses to common scheduling questions, reducing average response time by 90% while maintaining a personal tone.

Challenge

Coordinating schedules for 2 executives and 5+ instructors across time zones (PST) with frequent reschedules, conflicting availability, and no proactive conflict detection.

Solution

Implemented a layered Google Calendar system with colour-coded overlays, automated Calendly routing for external bookings, and a daily briefing email script that surfaces conflicts 24 hours in advance.

Challenge

Government census data required 5 days of manual analyst work before reports could be delivered to stakeholders, creating critical decision-making delays.

Solution

Built automated ETL pipelines to ingest and validate data from 10+ local government sources, feeding a live Power BI dashboard. Trained 15 government staff on self-service reporting.