Joel Jr. Cabase Rioflorido

SitePilot AI

Category: SaaS | AI Chat Assistant | Widget

Description: SitePilot AI is a SaaS platform that turns website content into an AI-powered support assistant. Its customizable chat widget answers visitor questions and captures leads, while a central dashboard lets businesses manage websites, conversations, and analytics.

Problem: SitePilot AI helps businesses answer repetitive customer questions, make website information easier to find, and capture inquiries that might otherwise be missed, reducing manual support work and helping turn visitors into leads.

Architecture: SitePilot AI uses a three-part architecture: - Dashboard: React and TypeScript for managing websites, assistants, leads, and analytics. - Chat widget: A lightweight TypeScript embed for visitor conversations and lead capture. - Backend: NestJS API with PostgreSQL and pgvector for accounts, business data, and knowledge retrieval. A background worker crawls and indexes website content. The API retrieves relevant knowledge and uses OpenAI or Ollama to generate grounded answers. Services run through Docker Compose.

My role: Sole Fullstack Developer

Result: SitePilot AI brings automated customer support, lead capture, and conversation insights into one platform, helping businesses reduce repetitive inquiries and turn website visits into sales opportunities.

Highlight: Turns website content into a branded AI assistant that answers customer questions and captures lead, all managed from one dashboard.

Technologies: React, TypeScript, Tailwind, NestJS, TypeORM, PostgreSQL, pgvector, OpenAI, Ollama, Docker

Concepts: SaaS, Multi-tenancy, Retrieval-augmented generation (RAG), Semantic search, Vector embeddings, Web crawling, Background processing, Conversational AI, Lead generation, API integration.

Caf-IO

Category: SaaS / CMS / Website Builder

Description: Business website builder for local cafe, restaurant, salon, retail, studio, services, events and more here in Philippines. SaAs multi-tenant website / website builder. Website CMS

Problem: Currently a lot of business shops doesn't have websites where they showcase their menu, services and manage online booking inquiries.

Architecture: Laravel, Vue, JavaScript, and MySQL, VPS and Payment Integration application with relational data modeling and cms.

My role: Sole Fullstack Developer

Result: Shipped a live full-stack product website with authenticated workflows, organized records, responsive screens, and maintainable frontend/backend separation.

Technologies: TypeScript, Vue.js, Laravel, MySQL, Docker, RBAC, CMS

Vehicle Hub

Category: Flagship Public SaaS Product

Description: Live vehicle management SaaS for records, mileage, maintenance, expenses, fuel, documents, issues, drivers, assignments, reports, audit logs, and subscriptions.

Problem: Vehicle operators need one reliable workspace for operational records, maintenance history, documents, team access, and reporting.

Architecture: Separate Vue 3 TypeScript frontend and Laravel REST API backed by MySQL, queue and scheduler services, role-based access, and VPS deployment infrastructure.

My role: Designed and built the Vue 3 frontend, Laravel REST API workflows, authentication, authorization, relational data models, and Dockerized deployment setup.

Result: Shipped a live full-stack SaaS product with authenticated workflows, organized records, responsive screens, and maintainable frontend/backend separation.

Technologies: TypeScript, Vue.js, Laravel, MySQL, Docker

Concepts: Vehicle records, Fullstack architecture, REST APIs, Authentication, Operational workflows

The Aristocrat Restaurant

Category: Restaurant

Description: Business website of a local restaurant here in Philippines.

Problem: Old website look.

Architecture: Laravel, Vue, JavaScript, and MySQL application with relational data modeling and cms.

My role: Sole Fullstack Developer

Result: Create and update new UI / website llok.

Technologies: PHP, Laravel, Vue.js, JavaScript, Typescript, MySQL

High-Availability Transaction Platform

Category: Backend Engineering

Description: Private production platform involving transactional workflows, provider integrations, reporting, cache strategy, and backend reliability work.

Problem: Production workflows lacked centralized observability, making integration failures difficult to trace and diagnose.

Architecture: Laravel and NestJS services using Redis caching, indexed MySQL/MariaDB queries, DynamoDB, structured retries, service boundaries, and AWS-ready deployment patterns.

My role: Implemented structured logging, improved cache and query behavior, and strengthened retry and failure-handling strategies for external integrations.

Result: Improved production observability and shortened root-cause analysis for integration-related issues.

Highlight: Confidential production system. Proprietary code and internal metrics are intentionally not displayed.

Technologies: Laravel, NestJS, TypeScript, Redis, MySQL, MariaDB, DynamoDB, AWS

Real-Time Operations Backoffice

Category: Fullstack Development

Description: Administrative backoffice work covering transaction monitoring, user management, reports, reusable frontend components, and production diagnostics.

Problem: Operations teams needed faster access to internal workflows, clearer monitoring screens, and consistent interfaces for repeated administrative tasks.

Architecture: Vue and React interfaces connected to Laravel and NestJS APIs, reporting queries, authentication flows, and cloud-hosted services.

My role: Built reusable Vue and React interface patterns, backend endpoints, reporting workflows, and diagnostic views for support and operations teams.

Result: Improved consistency across backoffice workflows and made repeated operational tasks easier to support and maintain.

Highlight: Private internal systems. Public details are anonymized to protect proprietary workflows.

Technologies: Vue.js, React, Laravel, NestJS, AWS

Enterprise Device Management Platform

Category: Enterprise Web Application

Description: Internal business platform supporting device asset management, inventory tracking, maintenance planning, operational reporting, telemetry integrations, and secure user access.

Problem: Internal teams needed better visibility into devices, inventory, telemetry, maintenance, and access control.

Architecture: Laravel, Vue, JavaScript, and MySQL application with relational data modeling, third-party telemetry APIs, operational reports, and role-based permissions.

My role: Implemented business workflows, telemetry integration, reporting, and RBAC-backed access patterns.

Result: Created a practical internal platform for tracking assets, maintenance signals, and operational status.

Technologies: PHP, Laravel, Vue.js, JavaScript, MySQL

PHP Developer (Full Stack) — Vavasoftware Corporation

February 2026 - July 2026 · BGC Taguig City, Philippines

• Maintain high-availability Laravel applications supporting real-time transactions, reporting, and administrative workflows.
• Build and improve third-party API integrations with clear validation, error handling, and retry behavior.
• Implement structured error handling and retry strategies for external integrations.
• Optimize database queries and Redis caching strategies.
• Improved core API responsiveness through query tuning, caching, and backend optimization.
• Use AI-assisted development tools responsibly for coding, refactoring, debugging, testing, and documentation.

Mid Fullstack Developer — FYB Technologies

July 2025 - February 2026 · BGC Taguig City, Philippines

• Developed and maintained multi-tenant web applications used across multiple production environments.
• Implemented region-specific business rules and reusable application workflows.
• Designed high-throughput RESTful APIs using NestJS and Laravel.
• Implemented logging, monitoring, and resilient error handling for 24/7 applications.
• Collaborated with cross-functional teams.
• Delivered product features with attention to reliability, maintainability, and user experience.

Backend / API Developer — 8Bacus / Coding Collective

May 2024 - July 2025 · Makati City, Philippines

• Built backoffice applications for user management, operations, and internal workflows.
• Developed transaction monitoring and activity tracking systems.
• Built operational reporting features for teams that need clear business visibility.
• Created reusable Vue.js and React component libraries.
• Improved frontend delivery speed by creating reusable component patterns.
• Integrated AWS S3, EC2, and RDS.
• Diagnosed and resolved memory leaks.
• Resolved critical N+1 database query problems.
• Performed application performance optimization.

Programmer / Web Developer — ESCO Pte. Ltd.

March 2024 - May 2024 · Makati City, Philippines

• Developed internal web applications.
• Built device asset management functionality.
• Developed inventory tracking.
• Implemented predictive maintenance functionality.
• Built operational reporting.
• Integrated third-party telemetry APIs.
• Implemented Role-Based Access Control (RBAC).

Fullstack Developer - Freelance — Independent Technical Consulting

April 2021 - February 2023 · Remote - Philippines, United States, Australia

• Delivered end-to-end web applications.
• Developed e-commerce platforms.
• Integrated POS systems.
• Developed secure healthcare portals.
• Developed academic dashboards.
• Managed projects from requirements gathering through development, deployment, and maintenance.