Jive Ian Bogwat

Full Stack Developer · WordPress Web Builder · AI Automation Builder

Download PDF

Experience

WordPress Developer and Content Specialist

New Wine

June 2025 to June 2026
  • Developed and maintained business website pages including homepage, landing pages, service pages, and blog pages using Elementor.
  • Wrote and published articles from October 2025 to May 2026, using AI to assist in drafting and fact-checking while keeping content accurate and aligned with brand voice.
  • Followed Rank Math SEO guidelines when creating content, contributing to noticeable improvements in search engine visibility.
  • Created graphic design materials including social media graphics, website banners, and blog thumbnails using Canva and Figma.
  • Leveraged AI tools across writing and design tasks to work efficiently while maintaining consistent output quality.
WordPressElementorRank MathCanvaFigma

Projects

In Progress

A full-stack CRM platform for local businesses to manage leads, appointments, and growth workflows from a single interface.

  • Developed a responsive application shell with sidebar and mobile navigation, along with a reusable design system covering core UI components.
  • Set up authentication UI with form validation and Google Sign-In, backed by Dockerized PostgreSQL and Prisma ORM with core data models in place.
  • Currently implementing authentication backend, Google OAuth, and CRM data layer including lead pipeline and status tracking.
Next.js 16React 19TypeScriptTailwind CSS v4Prisma ORMPostgreSQLDocker

A Python script that automatically categorizes files in the Downloads folder into sorted directories by type.

  • Packaged the script into a standalone executable using PyInstaller and scheduled it to run every hour via Windows Task Scheduler.
  • Fully automated with no manual intervention required.
PythonPyInstallerWindows Task Scheduler
Completed

A self-hosted AI-powered expense tracking automation that accepts inputs via Telegram in text, image, and voice formats.

  • Integrated Google Gemini to parse and extract structured expense data from unstructured multi-modal inputs, then automatically appended entries to a Google Sheets ledger.
  • Exposed the local n8n instance securely to the internet using Cloudflare Tunnel, enabling reliable webhook delivery without a cloud server.
  • Eliminated manual expense logging, creating a zero-friction personal finance workflow accessible from a smartphone.
n8nGoogle SheetsTelegram Bot APIGoogle Gemini AICloudflare Tunnel

Skills

Languages and Frameworks

TypeScript, Python, Next.js, React, Tailwind CSS, HTML

Databases

PostgreSQL, Google Sheets

Tools and Platforms

n8n, Telegram Bot API, Google Gemini AI, Cloudflare Tunnel, WordPress, Figma, Canva

Education

Bachelor of Science in Electronics Engineering

Caraga State University

Butuan City · 2021 to 2025

Languages

English

Professional

Filipino

Native

Visayan

Native