// hello, world

Miko R.
Vargas

› Full-Stack System Developer | Network Administration

Building scalable, production-ready systems from database schema to server deployment. Former Team Lead on enterprise-level e-procurement infrastructure with LDAP integration and document workflow automation.

View Projects Get in Touch
LAMP
Stack expertise
LDAP
Auth integration
Lead
Team role
~/miko — bash
~ whoami
Miko R. Vargas
~ cat role.txt
Full-Stack Developer
Network Admin Background
Team Lead @ ICT Unit
~ ls skills/
PHP   MySQL  Python
Nginx SSH   Linux
HTML  LDAP  LAMP
~ uptime
Passionate. Available. Ready.
~ _
scroll
About

Developer by design,
problem-solver
by nature.

I'm a full-stack system developer with a strong foundation in network administration. My work focuses on building internal tools and enterprise systems that actually solve real-world operational problems — not just prototypes, but production systems people depend on.

During my internship at the ICT Unit of the City Schools Division Office of Dasmariñas, I was appointed as Team Lead for a cross-functional system development project, working under the guidance of Carlou Adao, LPT, MPA.

I take ownership from database schema design all the way through server deployment — comfortable with the full LAMP/LEMP stack, SSH access, and everything in between.

Internship · ICT Unit
City Schools Division Office
Dasmariñas, Cavite
  • › Appointed as Team Lead for system development projects
  • › Supervised by Carlou Adao, LPT, MPA
  • › Developed full-stack e-procurement solution
  • › Led team through architecture decisions and deployment
Full-Stack
Front-to-back ownership
LAMP Stack
Production ready
Team Lead
Leadership experience
Net Admin
SSH & server ops
Technical Skills

Tools I build with.

A focused, battle-tested toolkit — each technology chosen for real projects, not resume padding.

Backend

PHP (Vanilla) Python LAMP Stack LEMP Stack REST API LDAP Integration

Database

MySQL MySQL Workbench Schema Design Query Optimization Relational Modeling

Frontend

HTML5 CSS3 JavaScript Bootstrap Responsive Design

Server & DevOps

Nginx Apache SSH Linux Server Deployment System Admin

Libraries & Tools

PhpOffice TemplateProcessor Git MySQL Workbench Postman

Concepts

Role-Based Access Workflow Automation Doc Generation Network Admin MVC Pattern
Projects

What I've shipped.

Real systems, built for real organizations. Not toy projects.

Featured Project · 2024

E-Procurement System

Full-Stack Team Lead

A complete internal e-procurement solution developed for the City Schools Division Office of Dasmariñas. The system digitizes and automates the entire procurement workflow — from request submission and LDAP-authenticated access to role-based document routing, status tracking, and automated Word document generation. Built on a vanilla PHP + MySQL stack and deployed on a local Nginx server.

Core Features

LDAP Authentication
Integrated with existing directory services
Role-Based Access Control
Granular permission system per role
Document Tracking
Status-based workflow progression
Workflow Automation
Automated procurement process routing
Dynamic Word Generation
PhpOffice TemplateProcessor automation
Office → Unit Hierarchy
Structured org data modeling

My Responsibilities

01. Designed and implemented the complete database schema from scratch using MySQL Workbench
02. Developed all system logic in vanilla PHP — no frameworks
03. Integrated LDAP authentication with the existing organizational directory
04. Built automated document generation pipeline using PhpOffice TemplateProcessor
05. Led team coordination, code review, and delivery milestones

Challenges & Solutions

PhpOffice TemplateProcessor — First-time implementation
Had no prior experience with PhpOffice's TemplateProcessor. Navigated underdocumented behavior around placeholder binding, nested data structures, and complex Word document formatting. Solved through systematic testing, reading source code, and iterative placeholder design.

Tech Stack

PHP MySQL Nginx HTML / CSS LDAP PhpOffice Bootstrap MySQL Workbench

Screenshots

Dashboard Overview
Document Tracking View
Role-Based Access Panel
Project · 2024

OJT Management System

Full-Stack

A web-based system designed to manage the full On-the-Job Training (OJT) lifecycle—from company endorsement and MOA processing to internship monitoring, term-based reporting, and final completion validation. The system streamlines coordination between students, coordinators, and partner companies while ensuring accurate tracking of requirements and progress.

Core Features

Endorsement & MOA Workflow
Request, approval, notarization tracking
Term-Based Internship Monitoring
120-hour intervals with required submissions
Document Management System
DTR, evaluations, narrative reports, final PPT, certificate upload
Real-Time Progress & Completion Tracking
Coordinator verification with status visibility

My Responsibilities

01. Designed and implemented the full system architecture, database schema, and workflow logic based on real academic OJT processes
02. Developed backend using Django and integrated file handling, validation logic, and role-based access control
03. Built responsive UI dashboards for students and coordinators using Tailwind CSS

Challenges & Solutions

Complex Workflow & Validation Handling
One of the main challenges was implementing a strict term-based system where students cannot proceed without completing prior requirements. This required precise validation logic, progress tracking, and handling edge cases such as missing reports, incomplete hours, and certificate verification.

Tech Stack

Django Django REST Framework MySQL Tailwind CSS

Screenshots

OJT Dashboard
OJT Reports
OJT Coordinator Panel
Project · 2024–2025

VARGAS POS System

Desktop App Solo

A fully offline, desktop-based Point-of-Sale system built for a small grocery store. The system handles the complete retail workflow — from product management and barcode scanning to checkout, receipt generation, and end-of-day reporting. It includes a role-based access control system and a full cashout/shift management module that tracks every peso from opening cash to closing reconciliation.

Core Features

Role-Based Login System
Admin, Cashier, IT access levels
Barcode Scanning & Cart
Decimal qty support for kg and piece units
Atomic Checkout
Auto stock deduction with rollback on failure
Shift Management System
Open/close shift, cash-in/out, discrepancy reporting
Inventory Management
Add, edit, restock, deactivate + low stock alerts
Sales Reports & CSV Export
Date range filtering, daily summary dashboard
Auto Receipt Generation
Text receipts saved to local storage
Crash Recovery Detection
Detects and handles abandoned/stale sessions

My Responsibilities

01. Designed the full database schema — users, products, sales, sale_items, stock_movements, cashier_sessions, and cash_adjustments with constraints and indexes
02. Built the service layer (inventory_service, sales_service, user_service, shift_service) with clean separation from the UI layer
03. Implemented atomic checkout transactions with full rollback safety and double-validated session integrity
04. Built the complete cashout/shift system — opening cash, adjustments, expected cash formula, discrepancy computation, and session lifecycle enforcement
05. Designed all UI screens using Qt Designer and implemented non-destructive database migrations
06. Wrote a comprehensive self-check test suite (check_all.py) covering 72 test cases across all system modules

Challenges & Solutions

Race Condition in Shift-Checkout Integrity
The core challenge was preventing a cashier from processing a sale against a session already closed by an admin in another window, while keeping the expected cash formula accurate across all adjustments. Session status is validated twice — at the UI layer before the transaction begins, and again inside the atomic SQL transaction before the INSERT commits — eliminating the race condition entirely. Expected cash uses SUM(sales.total) instead of per-row payment - change, keeping the formula clean and future-proof for multi-payment-method support. The end_shift function also reads the updated row within the same database connection to avoid a SQLite WAL visibility issue.

Tech Stack

Python 3.10+ PyQt5 SQLite (WAL) bcrypt Qt Designer Service Layer Pattern

Screenshots

POS Checkout Screen
Inventory Management
Shift Management & Reports
POS Screen 4
POS Screen 5
POS Screen 6
POS Screen 7

// more projects coming soon

Contact

Let's build
something together.

Open to full-time roles, internship extensions, or freelance projects. If you need a developer who owns the problem end-to-end — let's talk.

Email
mikovargas5@gmail.com
Location
Dasmariñas, Cavite, PH
Availability
Open to opportunities
// find me online