Projects

AI ERP Assistant - Fuel Cell Store

LLM Tool CallingRBACForecasting

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.

Warehouse & Inventory Subsystem (WMS) - Fuel Cell Store

Oct 2024 - Present
InventoryWMSLot TraceabilityAnalytics

Designed and built the warehouse and shop-floor side of the internal operations platform, covering stock tracking, receiving, 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.

Built directly on the platform's shared SQL Server schema rather than behind a sync layer, so stock reads and writes are immediate and cannot drift out of step with orders.

Read case study

OpenCart Upgrade - Fuel Cell Store

Mar 2024 - Sep 2024
OpenCartSQL MigrationZero Data Loss

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 Operations Platform (ERP / WMS / MES) - Fuel Cell Store

Aug 2023 - Present
ERPWMSMESAutomation

Designed and developed the company's internal operations platform, covering order management, warehouse and inventory operations (WMS), shop-floor production execution (MES), shipment monitoring, 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