Inventory System - Fuel Cell Store

Oct 2024 - Dec 2025

Independently designed and built a full-stack inventory management system from scratch, covering stock level tracking, supplier management, and full purchase order lifecycle management to support daily business operations.

Designed a multi-dimensional real-time analytics dashboard integrating inventory turnover, stock aging, and demand forecasting metrics to provide management with data-driven replenishment decisions.

Implemented intelligent reorder alert mechanisms triggered by historical sales data and safety stock thresholds.

Deeply integrated with the ERP system for real-time inventory data sync, reducing stockout rate to near zero.

OpenCart Upgrade Project - Fuel Cell Store

Mar 2024 - Sep 2024

Led the migration of the company’s e-commerce platform 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 zero business interruption.

Independently wrote complex SQL migration scripts to handle data cleaning, field mapping, and relationship rebuilding across version differences, ensuring historical data integrity and consistency.

Refactored frontend code architecture to improve page load performance and mobile responsiveness; resolved multiple third-party module compatibility issues, significantly improving system stability and user conversion rate.

Internal ERP (Enterprise Resource Planning) System - Fuel Cell Store

Aug 2023 - Feb 2024

Independently designed and developed a comprehensive internal ERP system covering order tracking, shipment monitoring, inventory management, and multi-dimensional business reporting to support cross-department daily operations.

Built a unified data dashboard integrating orders, inventory, and shipment data to enable one-stop business metrics visualization, significantly improving management decision-making efficiency.

Implemented fully automated report generation and scheduled analytics tasks, reducing manual reporting workload by approximately 80%.

Ensured data security through cron-based automated backup mechanisms, with system recovery time reduced to minutes.