// hello world

I'm Joseph Leyco.
I build Python automation
that saves teams hours.

Web scrapers, RPA bots, API pipelines, and system-level tools. I turn repetitive work into background jobs you forget exist.

View Projects Get in touch
10+years in IT
50+automations shipped
18projects on display

01 / about

A bit about me

I'm a Python automation engineer with 10+ years in IT. My work runs quietly in the background: scrapers refreshing dashboards every few hours, bots reconciling finance reports at 2 AM, and pipelines keeping BigQuery, Google Sheets, and Slack in sync so nobody has to do it by hand.

I specialize in the messy problems that don't fit a tidy SaaS box: 2FA login flows, anti-bot evasion, flaky third-party APIs, and lately AI systems, from local RAG assistants to a natural-language-to-SQL chatbot running in production.

Before going full-time into automation I spent 6+ years in enterprise IT infrastructure, so I'm as comfortable with Active Directory, networking, and hardware as I am with Python. Teams know me for flexibility, fast turnaround, and impeccable follow-up: the "never say no" person who owns a problem until it's solved.

Currently exploring: Local LLMs (Ollama) LangGraph agents MCP servers 

class Joseph:
    role     = "Automation Engineer"
    stack    = ["Python", "Flask", "FastAPI",
                "Selenium", "Scrapy", "BigQuery"]
    loves    = "fixing things at 2am"
    location = "Philippines" # remote-friendly

    def solve(self, problem):
        return "automated"

02 / projects

Featured projects

local-ai · 100% offline

❯ ask "what does the Q3 contract say about renewals?"

⠸ searching 1,240 chunks · bge embeddings · ChromaDB

Auto-renews unless cancelled 60 days before term end
(contract_q3.pdf, p. 14)

qwen2.5:7b · local · 0 cloud calls

Project 01

Local AI Assistant: Private RAG

A fully local, privacy-first AI assistant that indexes personal PDFs and answers questions over them with zero cloud calls. Modular pipeline: PyMuPDF ingestion, BGE embeddings, ChromaDB vector store, LangGraph agent over Ollama, plus 4 custom MCP servers (RAG, persistent memory, web search, model routing) that plug straight into Claude Code.

  • Python
  • Ollama
  • LangGraph
  • ChromaDB
  • MCP
  • sentence-transformers
GitHub
strategylab · backtest #42 ✓

Project 02

StrategyLab: Trading Backtest Platform

Full-stack platform for building and backtesting trading strategies with a visual node-based strategy builder. Async FastAPI backend with JWT auth, Celery + Redis job queue, Postgres + MongoDB persistence, and a React 19 frontend with financial charting, fully Dockerized behind nginx.

  • FastAPI
  • React 19
  • TypeScript
  • PostgreSQL
  • Redis + Celery
  • Docker
GitHub
watchdog · localhost:47564

Project 03

AI Script Watchdog

A background supervisor that watches every scheduled Python script on the machine and has headless Claude review each run: did it finish, are the outputs valid, why did it fail, all in plain English. Auto-discovers unregistered scripts by watching processes, raises Windows toast alerts, caps daily AI spend, and serves a live status dashboard.

  • Python
  • Claude Code (headless)
  • Toast API
  • HTTP dashboard
GitHub
job-board · 8 sources · auto-refreshed
remote
freelance
full-time

Project 04

Multi-Source Job Board Aggregator

A Flask web app powered by 8 custom spiders that scrape OnlineJobs.ph, RemoteOK, Freelancer, Indeed, Hubstaff, Guru, PeoplePerHour, and WeWorkRemotely. Auto-updates every few hours on a schedule and pushes fresh data to git. Public via Cloudflare Tunnel.

  • Python
  • Flask
  • Scrapy
  • BeautifulSoup
  • Cloudflare Tunnel
GitHub
commission-sync · scheduled run

❯ run commission_sync.py

fetching PartnerStack reports · 2FA code auto-read from Gmail

1,482 rows reconciled → BigQuery · QuickBooks export done

finished in 4m 12s · saves ~10 hrs/week

Project 05

PartnerStack & QuickBooks Commission Automation

Pulls partner transactions, commission reports, and lead data from PartnerStack and QuickBooks using a hybrid of REST APIs, Selenium, and Gmail OAuth (for auto-fetching 2FA codes). Replaces ~10 hours/week of manual finance work with a single scheduled script.

  • Python
  • Selenium
  • REST APIs
  • Gmail OAuth
  • Pandas
  • BigQuery
GitHub
wpndatabase.db · watching
messenger
chrome
toast sent ✓

Project 06

Windows Messenger Notifier

System-level utility that hooks into the Windows Push Notification SQLite database to detect Messenger and Chrome notifications, then routes them through a PowerShell toast bridge. Solves a real Windows quirk no off-the-shelf tool fixes.

  • Python
  • PowerShell
  • SQLite (WAL)
  • Windows AUMID
  • Toast API
GitHub

More builds & automations

DigiBot: Chat with BigQuery

Natural-language business questions translated into BigQuery SQL by Claude, executed, and summarized back with AI analysis. Ships as a CLI and a web API with company-restricted Google OAuth.

  • Claude API
  • BigQuery
  • OAuth
  • Docker

AI Skills Suite + Sync Service

~25 production Claude skills powering a YouTube media operation (revenue analyzers, script/title/thumbnail generators, keyword research), backed by a FastAPI transcript-pipeline service on a cloud VM.

  • Claude skills
  • FastAPI
  • BigQuery
  • Supabase
  • systemd

TubeBuddy A/B Test Harvester

Headless Playwright bot that logs in through Google OAuth + TOTP 2FA, scrapes thumbnail split-test results across channels into Google Sheets, and prunes old assets from Drive.

  • Playwright
  • pyotp
  • Sheets API
  • Drive API

YouTube Studio Analytics Harvester

Automated export of per-video views and impressions from YouTube Studio, consolidated into Google Sheets on a schedule, with Slack alerts when a run fails.

  • Selenium
  • Playwright
  • pandas
  • Slack SDK

Self-Hosted MMO Game Server

A complete MU Online private server running locally: OpenMU game and connect servers in Docker with PostgreSQL, plus a custom-rebranded C++/.NET game client and Python tooling for items and packaging.

  • OpenMU (.NET)
  • Docker
  • PostgreSQL
  • C++

Headless-WordPress News Site

A Next.js news site that serves entirely from a local JSON content layer exported from WordPress via REST: fast pages with no live WP backend, plus affiliate link rewriting and sitemap generation.

  • Next.js
  • React
  • TypeScript
  • Tailwind

Internal Web Portal

A Django portal with a custom accounts app (custom auth backend, email flows, and user models) behind a clean template-driven UI.

  • Django
  • SQLite
  • Custom auth

Computer Vision Lab

Real-time webcam face analysis (emotion, age, gender) with DeepFace, and a hand-tracking mouse that maps MediaPipe landmarks to multi-monitor cursor control through direct Win32 calls.

  • OpenCV
  • DeepFace
  • MediaPipe
  • Win32

BigQuery Ops Toolkit

Utilities that audit every scheduled query in a GCP project, parsing SQL for source/destination tables and reporting to Sheets, plus ETL loaders that push analytics rows from Sheets into BigQuery.

  • google-cloud-bigquery
  • Data Transfer API
  • gspread

Remote Script Trigger

A lightweight Flask + ngrok bridge that exposes local automation scripts as HTTP endpoints, so any job on the machine can be fired remotely with streamed output.

  • Flask
  • ngrok
  • subprocess

Universal Page Scraper Extension

A Manifest V3 Chrome extension that scrapes Facebook groups and arbitrary pages using a network-level interceptor, with a popup UI and JSON export.

  • Chrome MV3
  • JavaScript
  • Interceptor

Thumbnail SERP Analyzer

Pulls a video's thumbnail, compares it against competitor thumbnails from search results using OpenCV image processing, and logs the comparison to Google Sheets.

  • OpenCV
  • NumPy
  • Sheets API

03 / skills

Tech I work with

Languages

  • Python
  • PHP
  • JavaScript
  • VB.NET / C#
  • SQL
  • PowerShell / Bash

Web & APIs

  • Flask
  • FastAPI
  • REST
  • HTML / CSS
  • OAuth 2.0

Scraping & RPA

  • Selenium
  • Scrapy
  • BeautifulSoup
  • Playwright
  • undetected-chromedriver

Data

  • BigQuery
  • Pandas
  • MySQL
  • SQLite
  • PostgreSQL

WordPress & SEO

  • WordPress
  • On/Off-page SEO
  • Keyword research
  • Affiliate marketing
  • Interlinking strategy

IT & Infrastructure

  • Active Directory
  • Computer networking
  • PC hardware & software
  • L1–2 IT support
  • Microsoft Office admin

DevOps

  • Cloudflare Tunnel
  • Cloudflare Pages
  • Docker
  • Render

Tools

  • Git
  • VS Code
  • Claude Code
  • n8n
  • Adobe Suite
  • Linux / Windows

04 / experience

Where I've worked

Mar 2022 – Oct 2025

Automation Engineer / Python Developer

Freelance · Remote

End-to-end automation across dozens of production systems: web scraping and browser automation at scale (Scrapy, Selenium, Playwright, anti-bot and 2FA flows), deep API integrations (QuickBooks, Xero, YouTube, Meta Ads, ClickUp, Slack, and a dozen affiliate networks), BigQuery data pipelines with automated alerting, FastAPI services deployed on Google Cloud VMs, and AI software development: LLM chatbots, natural-language-to-SQL tools, and local RAG assistants.

Mar 2022 – Jun 2024

WordPress Product Manager

Freelance · Remote

Managed WordPress sites end-to-end: content and image integration, affiliate link creation, interlinking strategy, and comprehensive keyword research.

Jan 2024 – Jun 2024

Tasker / Reviewer Annotator

AI training-data platform · Remote

Evaluated and annotated AI training tasks with strict guideline adherence, QA feedback, and high-precision analytical review.

Oct 2015 – Feb 2022

Junior Infrastructure Engineer

Multinational IT services firm · On-site at the country's largest electric utility

Supported executives and every operations department of a major power utility: L1–2 incident and request handling with escalation, software rollout and account provisioning across desktops, laptops, and mobile devices, Microsoft Office configuration, folder permissions, and Active Directory enrollment for new hires.

May 2015 – Jul 2015

Assistant Programmer

Software development firm · Makati City

Developed modules of an insurance management system for a US-based insurance company: data validations, premium computations, and reporting in VB.NET/C# backed by SQL stored procedures. Also handled database administration including backups and restores.

Education

BS in Information Technology

Jose Rizal University · 2015

Diploma in Communication Information Technology

Asian Summit College · 2010

05 / contact

Let's build something

Have a repetitive task that's eating your week? A scraping project that keeps getting blocked? An AI workflow you want running on your own hardware? I'd love to hear about it.

josephleyco@gmail.com GitHub LinkedIn

📍 Philippines · open to remote roles worldwide