← Back to Portfolio
Download .PDF

Jiggy B. Palconit

Software Developer

Summary

Software developer specializing in modern Java (Spring Boot) and enterprise legacy systems, offline-first Flutter/SQLite apps, and real-time TypeScript systems. Proven track record maintaining production ERP modules, engineering greenfield microservices with optimistic concurrency, adhering to strict architectural conventions (such as AutoCloseable session lifecycles), and designing event-driven architectures.

Technical Skills

Languages
Java (7/8, 17, 21), Dart, TypeScript, JavaScript, SQL (MySQL, PostgreSQL, SQLite), HTML5/CSS3
Backend & ERP
Spring Boot 3.3 (Web, Security, Actuator), Java Swing, Hibernate/JPA, JDBC, JasperReports, Java RMI
Mobile & Web
Flutter (BLoC architecture, SQLite, local-first), React Native (Expo, Reanimated), Vite, PWA, Supabase
Engineering
Legacy Modernization, Concurrency Control (Optimistic @Version, Queue-Locking), Multi-Branch Sync, Git

Work Experience

Software Developer • Viajero Motorcycles Inc.
Feb 2026 – Present
  • Engineered greenfield JRF system: Built a Job Request Form service in Spring Boot (Java 17) bridging into a legacy Java 7/8 ERP database with optimistic concurrency (@Version) and zero regressions across production branches.
  • Eliminated UI freezing on EDT: Refactored legacy Swing reporting and transaction modules by enforcing AutoCloseable session lifecycles, background worker isolation, and indexed SQL queries.
  • Built algorithmic inventory engine: Implemented automated reorder calculation (ROQ: AMC × [ABC - SM]) with day-anchored windowing across dealership branches, cutting stockout risk.
  • Prevented multi-store race conditions: Designed transaction lock checks and out-of-stock guard restrictions for cross-branch transfers (Viajero ↔ Jicjam).
  • Engineered FACC ↔ ACC bridge: Built bidirectional inter-module accounting adapter with reusable transaction components, in-memory caching (HashMap), and locked payroll queues.
Technical Support VA • Prime Developments — User account sync and virtual environment troubleshooting
2024 – 2025
IT Support (SPES) • LGU General Santos City (ICTD) — PC hardware diagnostics and LAN routing across offices
2023

Shipped Projects

Rent-a-Box SQLite Ledger GitHub
Offline-first Flutter retail management APK with 53 passing automated tests; features real-time vacancy audits and automated seller payout reconciliation.
Flutter • Dart • SQLite • BLoC
Race Clock LED Wall PWA Live PWA
Real-time dual-screen timing app syncing director controls to stage LED walls under 5ms latency via localStorage bus; deployed to live sporting heats.
TypeScript • Vite • WakeLock • PWA
MIS Operations Calendar Live App
Enterprise scheduling system with Supabase PostgreSQL and automated 07:30 daily cron dispatches (pg_cron) pushed directly to company Viber channels.
Supabase • PostgreSQL • Edge Functions
Langga Loan Tracker Mobile
Mobile debt ledger app featuring 60 FPS Reanimated spring physics, intuitive amortization schedules, and zero-latency local state persistence.
React Native • Expo • Reanimated

Education & Certifications

BS in Information Technology (BSIT)
STI College General Santos City • 2019 – 2024 • DICT Scholar
Computer Systems Servicing NC II (CSS NC II)
TESDA • Certified 2024 • SAP Business One Certified