About

I'm a data analyst with 3+ years of experience building end-to-end analytical solutions across transport and financial services. I'm drawn to teams where AI tools and rigorous data science are central to how work gets done — not side interests.

At Ventura Bus Lines, I've grown from coordinating performance reports to architecting a data platform that ingests, validates, and surfaces 100M+ rows of operational data. I care about building things that are scalable and reusable: robust ETL pipelines, well-modelled databases, and analytical assets the whole team can build on.

I take a systematic approach to problems — understanding the business need first, then translating it into a technical solution with proper data quality checks and documentation. I use AI tools (ChatGPT, Claude) daily in my analytical work, both to accelerate delivery and to critically evaluate outputs. Before transport, I spent two and a half years at Prospero Markets automating financial reporting and delivering data-driven client insights to senior stakeholders.

  • Python (Advanced)
  • SQL · PostgreSQL
  • ETL / ELT Pipelines
  • Database Design
  • Power BI · DAX
  • Git · GitHub
  • ChatGPT · Claude · AI Tools
  • Excel (Advanced)

Experience

  1. Ventura Bus Lines

    Jun 2024 — Present

    1. Senior Data Analyst

      Sep 2025 — Present
      • Architected a scalable end-to-end data platform — designed systematic data preparation and validation pipelines ingesting raw CSV data into optimised PostgreSQL structures, integrating 100M+ row datasets to surface high-performance executive dashboards.
      • Automated and optimised analytical workflows using Python and SQL, applying rigorous data quality assessment to improve reliability, scalability, and processing efficiency. Integrated AI tools (ChatGPT, Claude) into daily analytical work to accelerate development and critically evaluate outputs.
      • Designed reusable, modular approaches to data modelling and reporting, enabling analytical assets to be adapted and scaled across different business challenges.
      • Led systematic data lineage analysis across GL and inventory subledger systems, establishing traceability from financial postings to underlying inventory transactions.
      • Owned regulatory and operational reporting to ensure compliance with Department of Transportation requirements.

    2. Data and Performance Analyst

      Jun 2025 — Aug 2025
      • Designed and implemented the initial PostgreSQL database architecture to support large-scale, multi-source operational data, with a focus on data quality and long-term maintainability.
      • Built automated ELT pipelines in Python — including SharePoint API integration and systematic data transformation — documented for team reuse and maintainability.
      • Applied data preparation and modelling to integrate Myki and Consat datasets, surfacing touch-on rate insights that directly supported the achievement of government incentive targets.
      • Created an executive performance tracking solution translating complex Department of Transport data into rapid-access KPI dashboards for senior stakeholders.

    3. Data and Performance Coordinator

      Jun 2024 — Jun 2025
      • Coordinated with cross-functional stakeholders to deliver accurate and timely monthly performance reports.
      • Developed Power BI dashboards providing management with insights into FlexiRide operational performance.
      • Monitored daily bus allocations, validated missed trips, and analysed the operational impact of service disruptions on route performance.
      • Produced ad-hoc analytical reports by consolidating and analysing diverse data sources.

  2. Prospero Markets

    Apr 2021 — Dec 2023

    1. Data Analyst

      Jul 2022 — Dec 2023
      • Developed Python-based analytical models for withdrawal monitoring and floating profit analysis, applying systematic validation methods to replace manual processes and improve accuracy.
      • Wrote complex SQL queries to support weekly executive reporting and ad-hoc analytical requests, translating business questions into technical approaches.
      • Built and maintained finance databases, designing scalable data structures to support reporting and reconciliation across multiple business functions.
      • Delivered client analytics — equity, trade volume, demographic breakdowns — to senior stakeholders, making complex data clear and actionable for strategic decisions.

    2. Operations Assistant

      Apr 2021 — Jun 2022
      • Reviewed and validated client onboarding documentation in compliance with AML requirements.
      • Processed deposits, transfers, and third-party refunds with a high degree of accuracy.
      • Collaborated with Sales, Operations, and Compliance teams to support daily business operations.

Projects

  1. End-to-End Operational Data Platform

    Designed and built a scalable data platform from the ground up at Ventura Bus Lines — ingesting raw CSV exports into a normalised PostgreSQL database, automating ELT pipelines in Python (including SharePoint API integration), and delivering executive Power BI dashboards over 100M+ rows of operational data.

    • Python
    • PostgreSQL
    • ETL/ELT
    • Power BI
    • DAX
    • SharePoint API

  2. Myki & Consat Integration Dashboard

    Integrated Myki fare payment and Consat AVL data into a unified Power BI reporting layer, surfacing touch-on rates and service performance metrics. Insights from this dashboard directly supported the achievement of government incentive targets.

    • Power BI
    • DAX
    • Python
    • SQL
    • Data Integration

  3. Financial Reporting Automation

    Automated withdrawal monitoring and floating profit analysis at Prospero Markets using Python, replacing manual Excel processes. Also built SQL-driven weekly executive reports and client analytics covering equity, trade volume, and demographic breakdowns.

    • Python
    • SQL
    • Excel
    • Financial Analytics