Hi, I’m
Joshua Klyne Pudadera
I build systems that turn data into decisions.
I work across AI integrations, analytics dashboards, and backend systems to turn raw data and disconnected automations into reliable, usable tools. I also bring a research background and technical writing experience to give depth to my work.
- AI & Automation
- Data & Analytics
- Backend Engineering
01 — About
Early-career software engineer building reliable systems.
Backend Development · AI Integration · Data Analytics
I'm an early-career software engineer working across backend development, AI integration, and data-driven applications. My work combines software implementation with data quality, documentation, and verification. I'm currently a Backend AI Engineer Intern at FlyRank AI, translating written specifications into implementations and delivering documentation alongside my work.
My experience includes leading a scholarship-tracking program, nearly five years of maintaining records for a TESDA-registered training institution, and a published first-author research paper. I also run an AI-assisted research and writing pipeline that helps me turn information into clear, structured outputs.
Current role
Backend AI Engineer Intern
FlyRank AI
Implementation based on written specifications, with documented deliverables.
Education
Notre Dame of Marbel University
Bachelor of Science in Computer Science
2021–2025GPA 1.67
College of Engineering, Architecture and Computing
- PSITS Chapter President (Jul 2023 – May 2024)
- Overall School Regional Champion - PSITS Region XII
- Best Student Research: CS, Data Science and Algorithms Category, NDMU 18th Araw ng Parangal
- Published Research @International Journal of Latest Technology in Engineering, Management & Applied Science
Certifications
- Oracle Cloud Infrastructure 2025 Certified AI Foundations Associate
- Introduction to Machine Learning on AWS
- AWS Educate Introduction to Generative AI
- Leveraging AI for Text Analysis: NLP Using Orange Data Mining
02 — Featured Projects
View all projects
WEB APPLICATION
Nenita Farm Lechon Haus Restaurant Management System
Order-to-receipt system built for Nenita Farm Lechon Haus and Catering Services — React 19 on Vite, Supabase behind row-level security policies, sales trends charted with Recharts, and receipts, daily reconciliation and payroll reports generated as PDFs in-app. Past the point of sale it carries inventory and menu management, staff scheduling, financial reporting and catering bookings.
- React 19
- Vite
- Supabase
- PostgreSQL RLS
- PDF reporting
Automation
Multi-label Gmail → Sheets & Drive automation
An n8n automation that polls Gmail every 30 minutes for messages under monitored labels, extracts the metadata, detects attachments, and archives them into a Google Drive hierarchy keyed by label/date/sender while logging one row per email to Google Sheets. Now running on a self-hosted n8n instance, deployed via Docker on a VPS.
- n8n
- Gmail API
- Google Sheets
- Google Drive
- Docker
- Self-hosted
Automation
Telegram receipt photo processing automation
An n8n automation that takes receipt photos sent through Telegram, runs them through Google Gemini Vision with a receipt-specific prompt to extract merchant, amount and date, archives the original photo to Google Drive by submission date, and logs the extraction with a direct Drive link in Google Sheets. Runs on the same self-hosted n8n instance, deployed via Docker on a VPS.
- n8n
- Telegram Bot API
- Google Gemini
- Google Sheets
- Docker
- Self-hosted
03 — Capabilities
View all capabilitiesCapabilities
Dashboards and analysis first, then the engineering that supports the data work and keeps it running. Written from what I have shipped, not what I have read about.
AI & Automation
API integration, agents, automation design, and MCP integrations.
Data & Analytics
Data cleaning, analysis, dashboards, reporting, and visualization.
Backend & Full-Stack
REST APIs, authentication, databases, frontend integration, deployment.
Research & Writing
Research methodology, technical documentation, and data interpretation.
01
Dashboards & reporting
- Excel
- Lookups & pivot summaries
- Google Sheets / Looker Studio
- Status & funnel reporting
- Recurring report cycles
- Charts and Dashboards
02
Analysis & modelling
- pandas / NumPy
- SQL
- Cleaning & Reshaping data
- matplotlib / seaborn
- scikit-learn
- Orange Data Mining
- Jupyter
- Time series analysis
- Geospatial analysis (QGIS, Google Earth)
03
Backend & APIs
- Python
- REST endpoint design
- API validation
- Error handling
- Relational schema design
- Cloud integration
- FastAPI
- PostgreSQL
- Supabase
- MySQL
- JWT authentication
- Row-Level Security
- Docker
04
LLM integration
- LLM API calls
- LLM function-calling / tool-use
- Prompt engineering
- Structured output (Pydantic validation)
- Custom Claude skills
- Grounding in real sources
- Output review against spec
05
Automation & pipelines
- Scripted ETL
- Firecrawl scraping
- n8n (self-hosted)
- Repeatable runs
- Multi-source reconciliation
- Failure & retry handling
- Google Workspace automation
06
Engineering practice
- Git & GitHub
- GitHub Actions CI/CD
- Code review of AI output
- Technical documentation
- Version-controlled revisions
- Verification before merge
- Architecture & system design
- Full-stack delivery
04 — Tech Stack
Tech stack
The tools the work actually runs on. Analysis on top, dashboards and documentation in the middle, what ships at the bottom.
- Claude
- Gemini
- Hugging Face
- Python
- Jupyter
- Colab
- pandas
- NumPy
- scikit-learn
- Streamlit
- Looker Studio
- MySQL
- GitHub Actions
- QGIS
- Google Earth
- Sheets
- Docs
- Drive
- Forms
- Notion
- Markdown
- JavaScript
- TypeScript
- React
- Node.js
- FastAPI
- Supabase
- Docker
- Vite
- Recharts
- Tailwind CSS
- PostgreSQL
- Git
- GitHub
- Flutter
- Dart
- Android Studio
- Figma
- Postman
- Claude code
- ChatGPT
- Prompt Engineering
- Microsoft Word
- Microsoft Excel
- Google Sheets
- Looker Studio
05 — Projects
Projects
- 01Dashboard
EGACE status dashboard
A recurring Excel dashboard tracking every scholarship trainee through the five EGACE stages — Enrolled, Graduated, Assessed, Certified, Employed — built on lookups against the trainee records so the counts update from one source rather than being tallied by hand.
- Excel
- Lookups
- Charting
- Status reporting
02DevOpsAgentic CI/CD automation
A GitHub Skills challenge completed end to end: an agentic GitHub Actions automation authored in markdown and compiled to a .lock.yml pipeline. Runs on a daily schedule or on demand with read-only permissions, fetches sources over an explicit network allowlist, keeps its credentials in repository secrets, and returns its change as a draft pull request instead of pushing to main.
- GitHub Actions
- CI/CD
- YAML
- Secrets management
03Automationlinear-git-skills
Two custom Claude Code skills that automate the branch-to-PR loop for teams using Linear with the GitHub integration. Linear links a branch to an issue only by matching the branch name it would have generated itself, so create-feature-branch reproduces that format exactly rather than re-implementing the slug, and create-pr runs the project's checks, summarizes the real diff, and updates an open PR instead of failing on one.
- Claude Code skills
- Linear MCP
- GitHub CLI
- Git automation
- 04Published
Dengue Outbreak Forecasting Dataset & Model
A monthly 2015–2024 dataset for SOCCSKSARGEN, reconciled from DOH-CHD case records, Google Earth Engine rasters and NAMRIA shapefiles, and the forecasting model built on it.
- Dataset assembly
- Earth Engine
- Shapefiles
- Forecasting
- 05Process
AI research & verification pipeline
A repeatable pipeline built in Claude: topic and niche validation, source gathering, automated scraping with Firecrawl, claim verification against official documentation and peer-reviewed sources, then an editorial pass for voice and consistency.
- Claude
- Firecrawl
- Prompt engineering
- 06Tooling
medium-draft, a custom Claude skill
A Claude skill that outputs publication-ready drafts directly into Google Docs, so research and publishing meet without a manual reformatting step in between.
- Claude skills
- Google Docs
- Automation design
- 07Internship
Transaction tracking mobile app
Built at LEADSolutions INC as an on-the-job trainee: a Flutter mobile application for transaction tracking, integrated with the company's existing web system on Azure Cloud so data moved between the two without manual re-entry.
- Flutter / Dart
- Android Studio
- Azure Cloud
- UI/UX design
- 08Automation
Multi-label Gmail → Sheets & Drive automation
An n8n automation that polls Gmail every 30 minutes for messages under monitored labels, extracts the metadata, detects attachments, and archives them into a Google Drive hierarchy keyed by label/date/sender while logging one row per email to Google Sheets. Now running on a self-hosted n8n instance, deployed via Docker on a VPS.
- n8n
- Gmail API
- Google Sheets
- Google Drive
- Docker
- Self-hosted
- 09Automation
Telegram receipt photo processing automation
An n8n automation that takes receipt photos sent through Telegram, runs them through Google Gemini Vision with a receipt-specific prompt to extract merchant, amount and date, archives the original photo to Google Drive by submission date, and logs the extraction with a direct Drive link in Google Sheets. Runs on the same self-hosted n8n instance, deployed via Docker on a VPS.
- n8n
- Telegram Bot API
- Google Gemini
- Google Sheets
- Docker
- Self-hosted
- 10Ongoing
TESDA scholarship records, end to end
Trainee, programme and scholarship records encoded into T2MIS, TESDA’s national training management information system, plus the compliance documentation behind them and the billing reconciled against government purchase orders.
- T2MIS
- Compliance
- Billing reconciliation
- 11Tooling
Nenita Farm Lechon Haus Restaurant Management System
Order-to-receipt system built for Nenita Farm Lechon Haus and Catering Services — React 19 on Vite, Supabase behind row-level security policies, sales trends charted with Recharts, and receipts, daily reconciliation and payroll reports generated as PDFs in-app. Past the point of sale it carries inventory and menu management, staff scheduling, financial reporting and catering bookings.
- React 19
- Vite
- Supabase
- PostgreSQL RLS
- PDF reporting
- 12Dashboard
JDVP enrollment dashboard
A Looker Studio dashboard consolidating JDVP enrollment reports for participating schools: total enrollment, learner demographics, barangay-level distribution, client classifications and training status in one live view.
- Looker Studio
- Enrollment reporting
- Demographics
13ToolingTVI-CAMS — TESDA compliance & attendance manager
A multi-tenant compliance and document tracker for TVIs running TESDA scholarship programmes. Each school’s batches move through the internal lifecycle — AOU, NTP, TIP, Training, Assessment, Billing — while a per-programme document checklist holds every required file at missing, pending, submitted or verified. Clerk handles sign-in for Admin, Coordinator, Trainer and Viewer roles, and Supabase row-level security scopes every query to the signed-in school. Billing documents generate only when the compound gate passes: training progress at or above 80% and every required document verified. It stays an internal working layer by design — official records remain in TESDA’s own SIS, T2MIS and BSRS.
- Next.js 16
- Clerk
- Supabase RLS
- Drizzle ORM
- PostgreSQL
14AutomationJob Tracker
Job applications tracked without a spreadsheet. n8n polls Gmail every fifteen minutes, classifies each confirmation or status update with pattern rules, and upserts one row per application into Airtable. Only when the rules fail does an LLM get one attempt, capped at medium confidence so it can never override a rules match. Rows are keyed on company and job title, so a hand-typed entry and a generated one are the same application; a corrected status is never overwritten or regressed, and an email that cannot be classified lands in Needs Review rather than poisoning the feed. An Airtable webhook triggers a GitHub Actions rebuild within seconds, and an hourly health check compares the live n8n instance against the repo and emails when anything is stuck or drifted.
- n8n
- Gmail API
- Airtable
- GitHub Actions
- Vercel
15ToolingT2MIS Encoder
A PySide6 desktop tool that takes the verified masterlist and fills TESDA’s T2MIS learner registration form row by row with Selenium — while a human operator reviews and submits every record. Three stages: encoding from a masterlist CSV, enrollment against an enrollees CSV, and offline attendance-sheet generation as DOCX. The CSV preview shows the first 500 rows with a per-row status — queued, filling, review, done, failed — so the operator can see where a run stands, and a legacy CLI is kept for scripted runs.
- Python 3.12
- PySide6
- Selenium
- DOCX generation
16ToolingStride Running Club
A full-stack app for running communities: group runs with distance, pace category and live RSVP headcounts, verified routes on interactive Leaflet GPS maps with elevation profiles, and a filterable club roster carrying pacer badges and session counts. React 19 and Tailwind v4 on the front, Express and Drizzle over PostgreSQL behind it, with Firebase Authentication and Google OAuth handling sign-in.
- React 19
- TypeScript
- Firebase Auth
- Leaflet
- Drizzle ORM
17InternshipFlyRank Backend AI
FlyRank Backend AI Engineering internship — FastAPI, Postgres, Docker, Auth, scraping, one task per folder
- Python
- FastAPI
- PostgreSQL
- Docker
18ToolingThe Polite Scraper
A Python web scraping pipeline featuring HTML caching, data normalization, Pydantic validation, and fault-tolerant request handling.
- Python
- Pydantic
- Web scraping
19InternshipTask CRUD API (Week 3)
A FastAPI REST API for managing a task list with full CRUD (Create, Read, Update, Delete) operations. This week the tasks moved out of an in-memory Python list and into a real SQLite database, so they survive a server restart.
- Python
- FastAPI
- SQLite
- REST API
06 — Experience
Experience
Jul 2026 – present
Backend AI Engineer — Intern
FlyRank AI
- Complete hands-on assignments on LLM applications, AI Agents and automation.
- Participate in technical webinars and mentoring sessions on AI Engineering and Software Development
- Complete Anthropic certification courses
- LLM applications
- AI Agents
- Automation
Nov 2021 – present
TVI Admin Staff / Registrar /Processing Officer
Nenita Farm Rice-Based Farm Training Center
- Build the Excel dashboards and status reports that track each batch across the EGACE stages: Enrolled, Graduated, Assessed, Certified, Employed, so programme staff can see where a cohort stands without opening the underlying records.
- Encode trainee, programme and scholarship records into T2MIS and maintain the compliance documentation behind them.
- Keep records audit-ready across three vocational programmes, working to agency documentation standards rather than internal convenience.
- Coordinate scholarship batch records with TESDA offices through the full lifecycle, from enrolment through training and assessment to billing.
- Prepare billing statements against government purchase orders.
- Excel dashboards
- EGACE reporting
- T2MIS
- SOPs
- Audit checklists
- Billing reconciliation
Jan 2026 – Jun 2026
AI Content Producer & Technical Writer
Freelance (Remote)
- Long-form technical articles on AI and software engineering for professional audiences.
- Built the research pipeline behind them in Claude.
- Generated explanatory diagrams and facts sheets so verified facts read at a glance.
- Shipped a custom skill that puts publication-ready drafts straight into Google Docs.
- Claude
- Firecrawl
- Medium
- Diagrams
- Apify
Jun 2024 – Jul 2024
Mobile Application Developer & UI/UX Designer Lead
LEADSolutions INC, Koronadal City (Internship)
- Developed a document-approval mobile application using Flutter, enhancing user experience and functionality.
- Created a comprehensive uploader flow for end users and a viewer/approver dashboard for administrators.
- Designed a complete UI/UX in Figma, adhering to company branding guidelines and establishing a reusable component library.
- Collaborated with the development team using a sprint-style Trello automation, delivering 75% of the project scope within 200 hours.
- Flutter
- Figma
- Trello
- UI/UX
07 — Contact
Interested in working together?
Open to full-time work in research, verification and technical writing, and to freelance or consulting engagements where claims need checking before they ship. Backend AI and documentation work included.