AI automation command center dashboard on a modern workspace
Available for web development and AI automation projects
John Francis M. Venancio profile photo

John Francis M. Venancio

AI Automation Specialist & Web Developer

I build modern websites, full-stack web apps, AI automations, API integrations, dashboards, and browser workflows that help businesses move faster.

Websites + automationsFull-stack web appsHuman-approved outputsRemote-ready
Manila, Philippines / Remote
Available for freelance web development, AI automation, web app, dashboard, and browser automation projects.

10+

Portfolio projects

Web + AI systems

Primary focus

Remote

Work setup

Focus

Websites, automations, and backend systems for everyday business work.

Website and web app development

AI workflow automation

API integrations, dashboards, and browser automation

Services

Web development and automation offers for clients.

These are practical service packages based on the strongest website, app, integration, and automation projects in this portfolio.

Realistic AI automation workspace with dashboards and workflow screens

Website & Web App Development

Build modern, responsive websites and web apps with clean UI, strong structure, fast pages, and conversion-focused user flows.

Best for

Health and wellness brands, service businesses, coaches, e-commerce operators, and startups that need a polished web presence.

  • Responsive website
  • Landing pages
  • Frontend build
  • Backend/API routes
  • Deployment support

Technical Integrations & Automations

Connect websites to payments, scheduling, forms, CRM, email tools, databases, and third-party APIs so business systems work together.

Best for

Business owners who need their website, backend tools, and customer workflows connected without manual copying.

  • API integrations
  • Webhooks
  • CRM/form sync
  • Payment or booking flow
  • Automation documentation

AI Client Intake Automation

Turn service inquiries into structured leads with summaries, priority, budget, timeline, and follow-up notes.

Best for

Agencies, freelancers, service businesses, and local companies receiving messy inquiries.

  • Lead form
  • AI summary
  • Admin dashboard
  • Optional email notification

AI Support Ticket Automation

Create a support workflow that triages tickets, drafts replies, searches knowledge, and keeps a human approval gate.

Best for

Small teams that need faster support handling without risky auto-send behavior.

  • Ticket intake
  • AI triage
  • Draft replies
  • Knowledge citations

Invoice Processing Automation

Build invoice workflows that upload files, extract fields, score risk, route exceptions, and generate audit-ready reports.

Best for

Finance teams, AP teams, small businesses, and operators handling repeated invoice review work.

  • Invoice upload
  • Field extraction
  • Review queue
  • Risk scoring
  • Executive report

Product Research Automation

Automate product or competitor research with scraping, data checks, scorecards, and Excel-ready reports.

Best for

E-commerce sellers, researchers, agencies, and operators comparing product opportunities.

  • Scraper workflow
  • Data QA
  • Scorecard CSV
  • Excel report

Dashboard & Reporting Systems

Build dashboards that turn raw comments, leads, sales, costs, model metrics, or workflow data into usable views.

Best for

Teams that need clear metrics, filters, charts, and operational visibility.

  • KPI cards
  • Charts
  • Filters
  • Export-ready data

Browser & QA Automation

Use Playwright to test websites, repeat browser workflows, verify e-commerce flows, and produce reports.

Best for

Web apps and online stores that need repeatable daily health checks.

  • Playwright tests
  • Page objects
  • Reports
  • Screenshots and traces

Case studies

Proof from real web and automation builds.

The top case studies show the problem, the system built, the output, and a visual proof asset from the project folder.

ApplyPilot AI dashboard with resume match metrics and next actions

Live app

ApplyPilot AI

An AI job application assistant that compares resumes with job descriptions, scores fit, identifies gaps, and helps track applications.

Problem

Job seekers waste time applying without knowing whether their resume matches the role.

Automation

Gemini analyzes resume text and job posts, returns a match score, keyword gaps, suggested resume fixes, approval gates, and tracker actions.

Output

The user gets a scored fit review, keyword gaps, and next actions before saving or submitting a job opportunity.

Next.jsTypeScriptTailwind CSSGemini APISupabaseVercel
SupportPilot AI visual workflow dashboard

Full-stack product

SupportPilot AI

An AI support operations system for ticket intake, triage, reply drafting, knowledge base search, routing, and analytics.

Problem

Support teams need to move from intake to useful replies without losing review control.

Automation

The system creates tickets, classifies priority and risk, drafts replies, pulls knowledge context, routes work, and keeps a human approval step.

Output

The team gets triaged tickets, draft replies, knowledge context, and approval control before any risky response is sent.

Next.jsFastAPISQLAlchemySQLitePostgresJWTRecharts
InvoiceOps Command Center case study and finance automation dashboard

Local-first finance automation app

InvoiceOps Command Center

A local-first invoice automation command center for AP teams, with invoice intake, field extraction, risk scoring, review controls, audit history, automation jobs, and executive reporting.

Problem

Accounts payable teams spend too much time manually checking invoice fields, payment terms, due dates, vendor identity, and exception risk.

Automation

The app uploads invoice files, extracts text and fields, scores risk with deterministic rules, routes exceptions into review, simulates automation jobs, and records audit events.

Output

Finance users get a reviewable invoice queue, explainable risk evidence, role-aware approvals, local audit history, and a PDF-ready executive report.

Next.jsTypeScriptTailwind CSSpdf-parseLocal JSON persistenceVitestPlaywright
Automated product research browser crawl and dashboard preview

Local automation system

Automated Product Research Agents

A multi-agent research workflow that scrapes product data, checks quality, performs analysis, and exports spreadsheet-ready reports.

Problem

Manual product and competitor research is slow, repetitive, and hard to review consistently.

Automation

A staged workflow runs research lead, scraper, data QA, analysis, Excel export, and final reviewer steps.

Output

The workflow turns repeated research into reviewable CSV scorecards, normalized data, and an Excel workbook for faster buying decisions.

PowerShellPlaywrightExcel automationCSVJSONLocal dashboard

More proof

Additional automation and dashboard builds.

These support the same positioning: practical websites, apps, dashboards, and workflows that turn business needs into working systems.

Client intake landing page and service request flow

Portfolio-ready app

AI Client Intake Assistant

A business owner gets organized lead details, an AI summary, and clearer follow-up steps instead of messy inbox messages.

Next.jsGemini APISupabaseResend
View case study
AI automation dashboard on a developer laptop

Python automation engine

Automation System

Automations become inspectable, testable, and reusable from a CLI or local dashboard.

PythonJSON SchemaCLIWebhooks
View case study
YouTube comments analytics dashboard preview

Analytics dashboard

YouTube Comments Analytics Dashboard

Creators can see what viewers are asking for and decide what content to make next.

ReactViteRechartsLucide React
View case study
Playwright e-commerce automation workflow diagram

QA automation framework

Playwright E-Commerce Automation

A store team can run daily health checks and get clear test artifacts when something fails.

PlaywrightTypeScriptPage Object ModelGitHub Actions
View case study
AI Campaign Studio contact sheet with generated campaign workflow frames

Local AI product

AI Campaign Studio

The user gets a complete campaign kit that can be reviewed before publishing.

AI workflowImage generationLocal storageExport kits
View case study
AI operations dashboard layered interface icon

Dashboard prototype

AI Ops Monitoring Dashboard

AI systems become easier to inspect and manage from one operational interface.

ReactViteReact FlowRecharts
View case study
AI automation portfolio hero dashboard

Current portfolio

AI Automation Portfolio Assistant

Visitors can ask practical questions without the AI inventing credentials or links.

Next.jsGemini APITypeScriptTailwind CSS
View case study

Process

From business need to working technical system.

Each build starts by understanding the website, workflow, and tools, then moves into a tested web app, assistant, dashboard, browser flow, or integration.

01

Map

Identify the business goal, current website, tools, data sources, and handoff points.

02

Design

Plan the site structure, user flow, data model, integrations, and automation boundaries.

03

Build

Create the website, web app, dashboard, assistant, browser automation, or integration layer.

04

Launch

Test the system, document the setup, and prepare it for local use or free-tier deployment.

Skills

Stack used across the portfolio projects.

The portfolio assistant reads this same project and resume context, then answers through a server-side route so the AI key stays private.

Frontend & Web Development

Next.jsReactTypeScriptTailwind CSSResponsive UILanding pagesPortfolio websites

Backend & Integrations

FastAPIAPI routesREST APIsWebhooksSupabaseSQLitePostgres

AI Automation & Agents

Gemini APIClaude/Codex workflowsAI assistantsAgentic workflowsPrompt designHuman approval flows

Workflow Automation

n8n-style automationZapier-style automationMake-style workflowsCRM automationsCSV/JSON pipelinesLocal-first workflows

Data & Dashboards

RechartsExcel automationSupabaseSQLitePostgresAnalytics dashboardsReporting views

Browser & QA Automation

PlaywrightBrowser scrapingE2E testsPage Object ModelTest tracesGitHub Actions

Deployment & Delivery

VercelNetlify/Cloudflare PagesRenderSupabase free tierDocumentationDemo videos

Start here

Need a website, integration, or automation? Request a free technical audit.

Share the current site, workflow need, tools, and expected output. I can map the system, recommend the simplest build, and prepare it for local use or free-tier hosting.