The Pattern

In every workplace I've been in, there's a system that technically exists — and a separate, informal process people actually use. The workaround is the workflow.

→
What I Do

I study the gap between how a process is designed and how people actually move through it. Then I redesign the system around real behavior — not org-chart assumptions.

→
What Happens

At K-Pick Trading, I turned that into six running systems — an ERP, a BIR-ready accounting module, an HRIS, a real-time dispatch board, a B2B website, and KORA, the Telegram assistant that reports on all of them.

README.md

About Me

Jhon Wilfred Drio

System and Automation Engineer / Technical Manager

  • Email: jhonwilfreddrio@gmail.com
  • City: Navotas City, PH
  • Phone: +639085918691
  • Status: Open to full-time, freelance & contract roles
Save Contact Open Digital Card

Bio

I'm a System and Automation Engineer / Technical Manager at K-Pick Trading Corp. I translate day-to-day operational problems into reliable systems, then carry them from workflow discovery and requirements through architecture, development, testing, controlled release, documentation, and user support.

My main program of work is K-Pick ERP-lite, a Python, FastAPI, and PostgreSQL operations platform running in production in parallel with the company's official records: 133 API routes, 30 schema migrations, and 33 module views covering inventory, marketplace imports, order management and barcode checking, FEFO stock allocation, returns and expiry, physical counts, purchase planning, a multi-platform Finance Board, and role-based access. In September 2026 it grew an accounting module built for a BIR Computerized Accounting System application: serialized invoices, double-entry books, landed costing, and an audit trail that cannot be edited even at the database level.

Around it I built K-PICK HRIS, a standalone Philippine HR, timekeeping, and payroll system now in development; a real-time dispatch board for office and packing coordination; KORA, a Telegram operations assistant that reports, monitors, and answers questions through an on-premise AI model; and K-Pick's public B2B website with a quotation-to-purchase-order workflow that syncs stock and prices from the ERP every 15 minutes. I focus on correctness, traceability, recovery, and tools that fit the people doing the work.

toolbox.json

What I Work With

Systems & Automation
  • Workflow discovery & requirements
  • Python / FastAPI / REST APIs
  • ERP, accounting & HRIS platform design
  • Telegram bots & scheduled automation
  • Local LLM integration (Ollama, MCP workers)
  • Excel VBA / PowerShell / Bash
Data, Controls & Reporting
  • PostgreSQL / SQLAlchemy 2 / Alembic
  • Append-only ledgers, FEFO & audit trails
  • BIR-style serialized documents & double-entry books
  • Shopee / Lazada / TikTok Shop data integration
  • Finance, KPI, payroll & PDF document reporting
  • Backup, restore, health checks & rollback
Real-time & Web Systems
  • JavaScript / HTML / CSS
  • React 18 / TypeScript / Vite
  • Node.js / Express / Socket.IO / SQLite
  • Role-based access & session hardening
  • SEO / AEO, structured data & llms.txt
  • Git, GitHub Actions CI & guarded releases
// philosophy I use the right tool for the operation — not the most impressive-sounding one.

Testimonials

Working with him has really made things easier for our team. The systems and automations he built helped us save a lot of time, reduce manual work, and cut unnecessary costs. What I like most is that he always finds practical solutions that actually help the company work smarter.

Leila Almario

Social Media Manager, K-Pick Trading Corp

Jhon taught me how to think in systems. Rather than simply handing me finished tools, he took the time to explain how our systems worked until I could build, troubleshoot, and improve things on my own. His guidance is a big reason I feel confident working with automation today.

He is patient with questions — even those outside his immediate scope — and precise when solving problems. Jhon is the kind of System Engineer who does more than fix systems; he leaves the people around him more capable than he found them.

Jamielyn Ludovice

Multimedia Manager, K-Pick Trading Corp

Jhon Wilfred was the most skillful student I've encountered in a long time. He's a fast learner, and he always makes sure to deliver quality output given a period of time. He is also very keen on learning new technologies, and I find him to be objectively passionate about tech. He's definitely someone you want on your team.

Richard Villavilla

High School Friend

Jhon Wilfred is a good student who shows professionalism and dedication in whatever he does. His software projects during his academic years are up to standard and were used by his professors for some of their operations. Jhon Wilfred also demonstrated social awareness and leadership skills through his involvement as an officer/member in various student and special interest groups in the university.

Mary Grace Porcal

Senior High School Classmate

Jhon Wilfred and I worked together in various projects where I saw his tenacity to deliver what he promised to do. He is able to meet deadlines without sacrificing the quality of the output, and at times even exceeding the set goals. His enthusiasm at new opportunities makes him a great asset because he does everything with renewed energy and finds ways to optimize existing processes. Jhon Wilfred sure is a great addition to any team!

Arianne Perdagorda

Senior High School Friend

Intelligent Student. Takes lead during his high school life and can handle teams well.

Reu Yonzon

Senior High School Friend

career.log

Work Experience

Experience

System and Automation Engineer / Technical Manager

February 2026 - Present

K-Pick Trading Corporation — Korean medical supplies distributor, Philippines

  • Lead the full lifecycle of internal systems: workflow discovery, requirements, architecture, implementation, testing, controlled releases, recovery documentation, staff support, and continuous improvement.
  • Built and run K-Pick ERP-lite in production: a Python, FastAPI, and PostgreSQL platform with 133 API routes, 30 migrations, and 33 module views across inventory, fulfillment, purchasing, finance, and reporting, validated in parallel with the company's official records.
  • Designed audit-oriented controls: an append-only stock ledger, FEFO allocation with lineage, unit conversion, marketplace mapping, duplicate prevention, reversible returns, stock-condition and expiry tracking, and server-enforced roles with custom-role support.
  • Shipped an accounting module for a BIR Computerized Accounting System application: gapless serialized sales invoices, the six-document set, double-entry books with a database-level balance constraint, landed costing, marketplace receipt reconciliation, and a trigger-enforced append-only audit log.
  • Building K-PICK HRIS, a standalone Philippine HR, timekeeping, and payroll system (FastAPI, React, 188 endpoints) with biometric attendance import, request-based overtime authorization, statutory contribution tables, and role-scoped pay visibility.
  • Integrated Shopee, Lazada, and TikTok Shop workflows for imports, order management, barcode checking on phones, multi-user count sessions, sales history, purchase planning, a multi-platform Finance Board, staff KPIs, and generated documents.
  • Built the Shopee Dispatch Display System, a Node.js, Express, and Socket.IO workflow that synchronizes office and packing teams with audio alerts, staged statuses, notes, and persistent state.
  • Developed KORA, a Telegram operations assistant with 10 commands and 8 scheduled jobs: daily reports, an idempotent developer-report feed, off-site health monitoring, and bounded on-premise AI answers behind an identity guard, with system authority kept in verified application data.
  • Launched and hardened kpicktradingcorp.com: 21 pages, a quotation-to-purchase-order workflow with PDF output and email, a 15-minute stock and price sync from the ERP, structured data and AI-crawler policy for search and answer engines, rate limiting, and a full security-header set.
  • Established guarded delivery from Windows development to Mac production: locked deploy script with pre-migration backups, upgrade-only migrations, health-check gates, one-command rollback, off-machine backup sync, a 10-job CI pipeline, and a self-generating code index for AI-assisted development.

MFP Operator

September 2025 - January 2026

Optimal Systems Distribution

- Operated and monitored multifunction printing systems for high-volume document production and office support workflows
- Observed how small inefficiencies compound at scale; developed sharper instinct for operational bottlenecks
- Organized files, print requests, and production records while maintaining accuracy, confidentiality, and turnaround targets
- Coordinated with users and technical staff to resolve equipment issues and keep daily document operations running smoothly

Service Crew

May 2023 - July 2025

Red Ribbon

- Worked in high-pressure, customer-facing operations — learned firsthand what breaks when systems are designed for the manager, not the worker
- Became the go-to person for technical questions and device troubleshooting among colleagues
- Strengthened operational awareness, multitasking, and team communication under real-world conditions

Shop Assistant

May 2022 - April 2023

- Managed online orders, warehouse operations, and shipments
- Handled basic tech troubleshooting and built trust with the team as the informal IT resource
- Gained hands-on experience with logistics, inventory systems, and digital tools

Technical Support

March 2020 - April 2022

- Provided technical support during the pandemic — facilitated online classes and managed e-documents
- First formal exposure to systems support; built skills in remote assistance, documentation, and problem-solving
- The unofficial IT person before it became an official role

Canteen Worker

August 2018 - March 2020

- Managed daily operations in a busy school canteen
- Built time management, multitasking, and organizational skills that still inform how I approach operational work

Education

Bachelor of Science in Information Technology

2021 - 2025

City of Malabon University

Graduated with a strong foundation in both theoretical and practical aspects of IT. Gained hands-on experience through academic projects, collaborative development, and real-world simulations.

Core Skills Acquired:

  • Software development and debugging
  • Database design and management (SQL, MySQL)
  • Web development (HTML, CSS, JavaScript)
  • Basic networking and cybersecurity principles
  • UI/UX design fundamentals
  • Version control using Git
  • Project documentation and technical writing
  • Team collaboration using Agile methodologies
  • Problem-solving and analytical thinking

Resume File

Download Resume Save Contact

available_for.txt

What I Can Build

Process Automation

I identify manual workflows that slow your team down and build automation around them — Python services, Telegram assistants, scheduled jobs, Excel VBA. The goal isn't just automation; it's something your team will actually use.

ERP & Internal Platforms

Inventory, order, purchasing, finance, reporting, and role-based workflows designed as one traceable operational system.

Technical Management

I turn operational needs into scoped releases, coordinate priorities, review risk, document decisions, and support users after a change ships.

Reliability & Recovery

Database migrations, focused testing, backups, health checks, rollback safeguards, and recovery procedures for systems people depend on.

Accounting, Data & Reporting

Serialized documents, double-entry books, landed costing, finance dashboards, KPI and payroll reports, and PDF generation built from traceable business events.

Web & Integrations

Public websites, internal web tools, real-time interfaces, marketplace data flows, APIs, email delivery, and automation integrations.

case_studies/

My Work

  • All
  • Production Systems
  • Excel VBA
  • Web

// system_leaps.log

What shipped across the K-Pick systems, July → September 2026 · 125 commits · 25 new migrations

  • Returns intake — returned stock is sellable by default, with a production order-lookup fix and regression test. live
  • BIR CAS accounting module — serialized sales invoices, the six-document set, double-entry books, landed costing, marketplace receipt parsing, and an append-only audit log enforced by a database trigger. live
  • Session hardening — token revocation, forced password change, idle logout, login throttling, password rules. live
  • K-PICK HRIS — standalone Philippine HR, timekeeping and payroll system: 23 route modules, 188 endpoints, React UI. dev
  • Engineering platform — self-generating workstation code index, 10-job GitHub Actions CI, and on-premise LLM worker orchestration for AI-assisted development. tooling
  • Movement log — FEFO splits across batches shown as one logical transaction while keeping every batch reference for audit. live
  • Customer monthly reporting — printable per-customer statements for the direct-sales channel; cached Finance Board as the executive landing view. live
  • Access & reconciliation — per-role action permissions, faster Finance Board search, and a guarded cleanup tool with backup and row-count verification. live
  • Website hardening + AEO — timing-safe auth, rate limits, full security-header set, Schema.org data on 15 pages, llms.txt and AI-crawler policy. web
  • Installation / vault job orders — persistent job tracking with its own API and UI; unified income math and a multi-product daily trend report. live
  • Safeguards release — audited batch reclassification, catalog guards, and route-level authorization tests. live
  • Reliability release — bounded, indexed, timeout-safe movement and returns lookups; safe custom-role controls. live
  • Performance + KORA feed — compressed large API responses, in-app change log, and the idempotent developer-report API behind KORA's daily report. live
  • Multi-platform Finance Board — per-platform fee rates, Boss Board visibility, returns condition and expiry capture, bulk import revision. live
  • FEFO allocation + website sync — first-expiry-first-out stock-outs with lineage, and sellable stock plus box prices pushed to the public site every 15 minutes. live
  • KORA is born — daily report, ERP queries, and the first automation commands on Telegram. Meet KORA → live
K-Pick ERP-lite API documentation
kpick_erp_lite/

K-Pick ERP-lite — Inventory, Operations & Finance Platform

Production · parallel validation with the official records
PythonFastAPIPostgreSQLSQLAlchemy 2AlembicVanilla JSRole-based accesslaunchd on macOS
133API routes
30schema migrations
52data models
33module views
100test files
209commits since June 2026
Problem

Inventory, marketplace orders, returns, purchasing, finance, and reporting lived in spreadsheets and manual follow-up. The business needed traceability, duplicate controls, consistent product mapping, and a safe path toward a real system without breaking the records people already trusted.

What I Built

A FastAPI and PostgreSQL platform with a product master and unit conversion, an append-only stock ledger with FEFO (first-expiry-first-out) allocation, Shopee / Lazada / TikTok Shop imports with mapping and duplicate prevention, an order-management and barcode-checking pipeline, a phone-based packing scanner and multi-user count sessions, returns with condition and expiry, purchase planning, a multi-platform Finance Board, staff KPIs, customer statements, and configurable roles — all migration-driven and covered by CI.

Result

Runs in production on a Mac mini with guarded deploys, pre-migration backups, health-check gates, and one-command rollback. The company's spreadsheets stay the official reference while ERP-lite validates every workflow in parallel, and the same platform now carries the accounting module below.

  • Product Master
  • Stock Ledger
  • FEFO Allocation
  • Platform Imports
  • Order Management
  • Mobile Checker
  • Count Sessions
  • Returns & Expiry
  • Direct Sales
  • Purchase Planning
  • Finance Board
  • Staff KPIs
  • Installation Jobs
  • Customer Statements
  • Website Sync
  • Audit Log
  • Roles & Sessions
kpick_erp_lite/accounting

Accounting & BIR Computerized Accounting System Module

Shipped 2026-09-06 · parallel module · CAS-application ready
Double-entry ledgerSerialized invoicesLanded costingAudit trailPostgreSQL triggers
6BIR document types
8migrations in one release
4numbering series by channel
Problem

Applying for a Bureau of Internal Revenue Computerized Accounting System permit requires gapless serialized documents, books of accounts, and an audit trail that cannot be edited — even by someone with database access.

What I Built

Sales Invoice with the required face, per-series gapless numbering, senior-citizen and PWD tax-exempt math, void-not-edit with reprint marking, and a specimen print mode. The full six-document set (invoice, collection receipt, credit and debit memo, purchase order, receiving report), a chart of accounts, journal with a database-level balance constraint, general ledger, trial balance, and sales journal. Landed cost frozen per shipment and consumed FIFO, with no silent fallback when a cost setting is missing.

Result

The audit log is append-only at the database level, an audit viewer supports filters, print, and CSV export, and marketplace payout files reconcile against the books. Built as a parallel module, so inventory, orders, and finance behaved exactly the same the day it shipped.

kpick_hris/

K-PICK HRIS — HR, Timekeeping & Payroll

In development · not yet deployed
FastAPISQLAlchemy 2AlembicReact 18TypeScriptViteDecimal math
23route modules
188API endpoints
22pure service modules
28React pages
43test files
Problem

Attendance came from a biometric device export, overtime and holiday work were approved informally, and payroll math lived in spreadsheets that only one person understood. HR needed a system that follows Philippine labor rules without exposing pay figures to everyone who touches it.

What I Built

A standalone modular system: 201 records, biometric attendance import, day-type and night-differential resolution, request-based overtime and rest-day authorization, failure-to-swipe corrections, statutory leave types, versioned SSS / PhilHealth / Pag-IBIG / withholding-tax tables, a pure payroll engine that rounds once to the centavo, A5 payslip PDFs, 13th-month and final-pay computation, recruitment, appraisals, disciplinary cases under the twin-notice rule, and an employee self-service portal.

Result

Role-based pay visibility means HR can approve attendance and leave without ever seeing amounts, while accounting gets the computed payslip on the same rows. Every service module is DB-free and unit-tested, including a golden payslip regression. Statutory tables are flagged for accounting sign-off before the first live run.

kora.pet · v2 atlas · hover to wave
telegram_bot/ · KORA

KORA — Telegram Operations Assistant

Production · reports, monitoring & local-AI Q&A
Pythonpython-telegram-botOllama · Qwen 2.5Scheduled jobsIdempotent API
10commands
8scheduled jobs
3report sources merged
Problem

Daily reports, work logs, reminders, and "is the system okay?" checks depended on me being online. Automation also needed a hard boundary between AI assistance and authoritative business data, and between what the group sees and what stays private.

What I Built

A Telegram assistant that reads the ERP database for a 7 PM operations report, assembles my daily associate report from git commits, an idempotent developer feed, and manual notes, monitors system health every 10 minutes while I'm off-site, answers questions through an on-premise model with an application-level identity guard, and routes sensitive figures to private recipients only.

Result

Coordination that used to be manual now arrives on schedule, fails closed on bad input, and claims delivery only with evidence. KORA also has a face: a hatched desktop mascot with a validated animated sprite atlas.

Meet KORA: profile, duties & flowcharts
Shopee Dispatch office view
shopee_dispatch/

Shopee Dispatch Display System

Production · office LAN
Node.jsExpressSocket.IOWeb Audio APIJSON persistence
Problem

Shopee Instant Delivery orders were tracked verbally or on paper. Staff had no shared view of which orders were urgent, who was handling what, or where each order stood in the packing process.

What I Built

A real-time Node.js + Socket.IO app serving two synced browser views across the office LAN. Office staff dispatch rider codes and create picklists; the packing display shows large-format order cards with five distinct audio alerts, a flashing RUSH banner for nudged orders, a five-stage order lifecycle and a five-stage picklist pipeline with per-stage timestamps. State persists through restarts with atomic writes and corrupt-file quarantine. No internet required.

Result

Office and packing staff coordinate through one shared live workflow. Status changes, notes, and urgent alerts stay synchronized, and active work survives service restarts.

Ordering System

Ordering System

Excel VBA · form validation · audit log

Attendance Checker

Attendance Checker

Excel VBA · automated calculations · summary reports

Sudoku in Excel VBA

Sudoku

Built to explore the limits of what VBA can do.

K-Pick Trading Corp Website
kpicktradingcorp.com

K-Pick Trading Corp Website

Deployed public platform

21-page B2B site with a hand-written Node.js backend: branded PDF quotations emailed to buyers, a quote-to-purchase-order workflow with role-based staff logins, published manufacturer certificates, a Learning Centre of interactive device infographics, and brand films that only load in view. Sellable stock and box prices sync from the ERP every 15 minutes. Hardened with timing-safe auth, rate limits, and a full security-header set; Schema.org data on 15 pages plus llms.txt and an AI-crawler policy for answer engines.

Revised CMU IT Department Website

Revised CMU IT Department

Redesigned department site for City of Malabon University's IT department.

kora/pet.json

Meet KORA

KORA is the operations assistant I built for K-Pick. She lives in Telegram, runs as a managed background service next to the ERP, reports at 7 PM Philippine time, watches the systems when I'm off-site, and answers questions with a local AI model that never gets the final word — verified application data does.

// kora.sprite online
displayName

KORA

Telegram-native operations assistant for K-Pick Trading Corp

Pythonpython-telegram-botOllama · Qwen 2.5 14BPostgreSQLPHT-scheduled

A cheerful glossy 3D mascot who helps with focused work and automation. On the desktop she is a hatched Codex pet with a 16-direction look loop; in production she is a Python service that reads the ERP, writes to Telegram, and keeps sensitive figures on private routes. 

{
  "id": "kora",
  "displayName": "KORA",
  "role": "operations assistant · reports · monitoring · Q&A",
  "firstCommit": "2026-07-01",
  "hatched": "2026-08-26",
  "atlas": "8 x 11 sprite sheet · 9 animations + 16 look directions",
  "spriteVersionNumber": 2,
  "authority": "verified application data, never the model"
}
10Telegram commands
8scheduled jobs (PHT)
5.6klines across 8 modules

// responsibilities

What KORA handles on my Telegram, every day

Daily operations report

19:00 PHT · scheduled + on demand

Reads today's figures straight from the ERP database, builds the report, and routes it: operations to the group, sales figures only to configured private recipients.

  • /report
  • /today
  • /shipment

Associate report

18:30 cutoff reminder · 19:00 send

My daily work report, written for me: merges git commits landed since the last report, an automated developer feed, and my manual notes, grouped by module and deduplicated.

  • /mytask
  • /mytask dev
  • /mytask pending
  • /mytask preview

Off-site & day-off monitoring

every 10 min · digests 08:00 & 20:00

When I'm away, KORA polls database, API, model, and bot health and only speaks up privately with fixed status phrases. Raw errors, URLs, and data never enter a chat.

  • /dayoff
  • /away on
  • /away status
  • /away off

Live status & incident snapshot

on demand

One message with three live checks: today's direct-sales count from PostgreSQL, local model availability, and ERP API reachability. A sanitized snapshot can be pushed to the group by the owner.

  • /status
  • /error

Ask KORA

local AI · bounded timeouts

Free-form operational questions get a live ERP snapshot plus a local Ollama model. Identity questions never reach the model, and every answer passes an identity guard before delivery.

  • /ask
  • @KORA mention
  • browser chat

Competitor price watch

08:00 PHT daily

A daily price monitor for a benchmark consumer product line, with an optional browser-capture bridge for sources that block plain requests. Results go to private recipients.

  • /nespresso

// how she handles each task

Flowcharts traced from the bot's code and delivery gates

KORA runtime and automation entry points

KORA runtime and automation entry points on demand when enabled Production host boots launchd starts KORArun at load · keep alive Wait for ERP backend10-second grace Load configurationroutes · schedules · flags Register handlersand scheduled jobs Parallelautomation fork Telegram commands/report /status /ask … Daily operations job19:00 PHT Associate report job19:00 PHT · 18:30 reminder Optional monitorsday-off · away · prices
  • start / end
  • process
  • decision
  • input / output
  • stored data
  • document / manual input

// guardrails

Rules KORA cannot break

  • Identity is enforced in code. Identity questions get a fixed reply, and every model answer is scanned for foreign self-identification before it is sent.
  • Private stays private. Sales figures and system errors go to configured private recipients; the group only sees operations and sanitized snapshots.
  • Owner-only commands. Work-log and away-mode commands answer only to one account, on top of an optional allowlist for everything else.
  • Sanitized developer feed. Report items are scrubbed of control characters, secret-looking values, and private file paths before they are accepted.
  • Idempotent by design. Each report item carries a stable work ID: exact repeats are acknowledged, conflicting reuse is rejected with HTTP 409.
  • Fail closed. Malformed or wrong-date feed data stops the report build instead of sending a partial report.
  • Delivery is evidence. The "delivered" marker is saved only after a successful group send, so nothing is claimed that did not happen.
  • The model is an adviser. Local AI calls run on-premise with bounded timeouts; system authority stays in verified ERP data.

// changelog

How KORA grew

  1. First commits

    Daily report, ERP queries, and a trigger command replace manual Telegram updates.

  2. Old bot retired

    The earlier Google-Sheets-based bot is deleted; KORA becomes the single ERP-integrated assistant.

  3. Local-AI orchestration

    Free-form answers backed by an on-premise Ollama model with live ERP context.

  4. Model-independent identity

    Application-level identity guard so KORA is KORA whichever model runs underneath.

  5. Private recipient routing

    Sales and sensitive output split away from the group chat.

  6. Associate report

    7 PM daily work report from git commits, /mytask and /dayoff, plus a 6:30 PM cutoff reminder.

  7. Developer feed + day-off monitor

    Idempotent report-item API and 10-minute system checks while the owner is off.

  8. Off-site mode

    Multi-day /away windows with private morning and evening digests.

  9. Hatched as a desktop pet

    KORA gets a face: a validated 8 × 11 animated sprite atlas with 9 states and 16 look directions.

  10. Release digests

    Every release's commits and developer-feed items flow into the nightly associate report, so the group sees what shipped without a manual write-up.

jhon/navigator

Ask JHON

chat with JHON built-in knowledge engine

JHON answers from Jhon's published profile. For anything else, email jhonwilfreddrio@gmail.com.

ping_me

Contact

Location

Navotas, Philippines

Social Media

Email

jhonwilfreddrio@gmail.com

Phone

+639085918691

Digital Contact Card

Save my public contact details directly to your phone, or open the lightweight page made for NFC business cards.

Save Contact Open Digital Card
open_to_work: true
Full-time Freelance Contract

If you have a process your team works around instead of through — let's talk.

Loading