01
Websites for small businesses
Fast, modern websites that look professional on any phone — with an enquiry form that lands straight in your inbox.
Data & Insights Analyst · AI Builder · Butuan City, Philippines
I turn messy business problems into working AI tools.
15+ years turning data into decisions. Now I build websites, booking systems, chat assistants and automations with AI — for businesses that want them, and for teams that want to hire me.
Answers come from this page, word for word.
- 15+ Years in data & reporting
- 3 Client businesses live
- 10 Projects built with AI
- 1 Youth basketball club founded
What I can build for you
02
AI chat assistants
A chat assistant on your site that answers customers 24/7 from your own information, and hands over to you when a real person is needed.
03
Booking & scheduling systems
Let customers book courts, appointments or classes online, pay by card or GCash, and get a dashboard to manage it all.
04
Automation & reporting
The weekly spreadsheet work that eats your time, turned into reports that build themselves.
Client work
Real businesses, live today.
Rongcales Group
Mandaue City, CebuWebsites for a customs brokerage and a trucking company, plus Clara — an AI chat assistant that answers importers' questions from the owner's own answers, passes pricing questions to a human, and emails the team every new lead.
- Websites
- AI chat assistant
- Lead alerts
Meatopia Foods
CebuA website for a meat supplier, with an enquiry form that sends every request straight to the owner's inbox.
- Website
- Enquiry form
Match Point Tennis Academy
Cebu CityA website and a full court-and-coach booking system: guests book and pay online by card, GCash or Maya, coaches see their day's sessions, and the owner manages courts, bookings and refunds from one dashboard.
- Website
- Booking system
- Online payments
Things I've built
My own products and experiments, built with Claude Code.
Faceless Channel
One topic in, a finished YouTube video out.
Researches a business or tech topic, writes a cited script, narrates it, draws the charts and renders a finished 8–12 minute video — at $0 per video.
- AI pipeline
- Video
Are These Plausable
A skeptic in your pocket for "make money with AI" videos.
Share a video from your phone to a Telegram bot. It transcribes it, checks the claims against a strict checklist and replies BUILD, PARTIAL or SKIP. 103 automated tests.
- Telegram bot
- AI analysis
Sidekick
An AI teaching assistant for Filipino teachers.
Writes DepEd MATATAG lesson plans, worksheets and report comments, and downloads them as Word files. Every document is marked for teacher review. In development.
- Web app
- Education
Gleamo
Airbnb-style booking for cleaners.
Property owners post cleaning jobs and pay by GCash or Maya; cleaners grab jobs, check in with photos and track their earnings. Mobile app in development.
- Mobile app
- Marketplace
Guild Master
A strategy game — and an AI crew that films its devlog.
A browser game where you run an adventurers' guild. A team of AI agents plans, scripts and films its YouTube devlog episodes.
- Game
- AI agents
Spritesheet Studio
A free tool for game artists.
Packs loose sprite images into animation sheets in the browser, with an AI button that draws the next frame.
- Browser tool
- AI images
Built for my own community
Founder & volunteer organizer
Rosewood Ball Club
I started a youth basketball club for kids in our subdivision. We practise Fridays and Saturdays at the Rosewood court. I built its tools too: a one-link attendance board where kids tap IN or OUT, and a club website with player cards, coach approvals and a league-age roster.
- Youth sports
- Ages 13 and up
- Volunteer
Photo coming soon
Hi, I'm Josaphat.
I'm a data analyst from Butuan City with 15+ years of turning numbers into decisions for companies in the Philippines, Australia and the US. In 2026 I started building with AI every day — client websites, a booking system that takes real payments, chat assistants and automation pipelines. On weekends I run a youth basketball club in our subdivision. Yes, I built its tools too.
Tools I work with
- SQL
- Mixpanel
- Looker
- Redshift
- Snowflake
- Google Data Studio
- Claude Code
- Python
- Node.js
- Supabase
- PayMongo
- ComfyUI
Experience
Hiring? Here's the short version.
-
Design.com
Data and Insights Analyst
Sep 2024 – Present
Lead the analytics for A/B testing, and built AI-assisted tools that automate experiment reporting and catch broken tracking.
-
AptDeco
Data and Insights Analyst
Mar 2024 – Sep 2024
Finance and marketing dashboards, A/B test analysis, automated reporting.
-
Berkner Group
Data Analyst
Sep 2023 – Mar 2024
Hiring analytics for green-tech startups.
-
MySale (OzSale · NZSale)
Data Analyst, Marketing
Mar 2022 – Aug 2023
Board reports and marketing dashboards from Redshift and Snowflake.
-
BARK
Ops / Reports Coordinator
Oct 2019 – Jun 2021
Replaced a manual spreadsheet with an automated team dashboard.
-
Telstra International Philippines
Business Analyst
Sep 2014 – Oct 2018
Reporting, process improvement and workforce tools.
-
Convergys Philippines
Reports Analyst Team Leader
Dec 2007 – Sep 2014
Led the reports team; built a coaching tool on Excel and MySQL.
How a project works
-
1
Tell me the problem
A message or a quick call. What's slow, broken or missing?
-
2
I build a working version
You see something real you can click, not a slide deck.
-
3
We refine it together
You try it, I adjust it until it fits how you work.
-
4
Launch & look after it
I put it live and stay on hand when you need changes.
Let's build something
Tell me what you need. I'll reply with a free quote.
Prefer to chat?
Emailhello@josaphatrabago.com
WhatsApp+63 968 366 1889
Messengerfacebook.com/Josapz
LinkedIn — coming soon
Butuan City, Philippines