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.
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.
At K-Pick Trading, I turn inventory, fulfillment, finance, reporting, and e-commerce workflows into systems that teams can validate, trust, and improve safely.
README.md
About Me
System and Automation Engineer / Technical Manager
- Email: jhonwilfreddrio@gmail.com
- City: Navotas City, PH
- Phone: +639085918691
- Status: Open to full-time, freelance & contract roles
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 in controlled parallel validation alongside the company's existing records. Its scope spans inventory movements, marketplace imports, order management and barcode checking, returns and expiry, physical counts, purchase planning, finance views, role-based access, and operational reporting.
Alongside ERP-lite, I built a real-time dispatch system for office and packing coordination, developed KORA Telegram and local-AI automations for reports and operational support, and launched K-Pick's public B2B website and digital quotation workflow. I focus on correctness, traceability, recovery, and tools that fit the people doing the work.
toolbox.json
What I Work With
- Workflow discovery & requirements
- Python / FastAPI / REST APIs
- ERP & internal platform design
- Telegram & scheduled automation
- Excel VBA / PowerShell
- PostgreSQL / SQLAlchemy / Alembic
- Inventory ledgers & audit trails
- Marketplace data integration
- Finance, KPI & document reporting
- Backup, restore & recovery design
- JavaScript / HTML / CSS
- Node.js / Express / Socket.IO
- Role-based access control
- Local AI integration (Ollama)
- Git & controlled release workflows
Testimonials
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.
