Projects

AI ERP Assistant - Fuel Cell Store

Built an AI-powered ERP assistant that answers natural-language questions over inventory, orders, suppliers, and purchase orders using LLM tool calling backed by secure server-side APIs.

Implemented role-based access control, audit logging, read-only query validation, and predefined business tools to prevent unauthorized data access and unsafe database operations.

Developed inventory forecasting logic using sales velocity, supplier lead time, safety stock, and reorder-point calculations to flag stockout risk and recommend purchase quantities.

Inventory System - Fuel Cell Store

Oct 2024 - Jul 2026

Designed and built a full-stack inventory management system covering stock tracking, supplier management, and purchase order lifecycle workflows.

Created real-time analytics for inventory turnover, stock aging, and demand signals to support replenishment decisions.

Implemented reorder alerts based on historical sales data and safety-stock thresholds.

Integrated inventory data with the ERP system for real-time synchronization and reduced stockout risk.

Read case study

OpenCart Upgrade - Fuel Cell Store

Mar 2024 - Sep 2024

Led the company's e-commerce migration from OpenCart 1.5.6.4 to 3.0.3.8, covering 2,000+ SKUs and 70,000+ historical orders with zero data loss and no business interruption.

Wrote SQL migration scripts for data cleaning, field mapping, and relationship rebuilding across major version differences.

Refactored frontend code, improved mobile responsiveness, and resolved third-party module compatibility issues to improve stability.

Read case study

Internal ERP System - Fuel Cell Store

Aug 2023 - Feb 2024

Designed and developed an internal ERP system for order tracking, shipment monitoring, inventory management, and business reporting.

Built dashboards that combine order, inventory, and shipment data to support faster operational decisions.

Automated recurring report generation and scheduled analytics tasks, reducing manual reporting workload by about 80%.

Implemented scheduled backups and recovery workflows to reduce system recovery time to minutes.

Read case study