LANGUAGE / 語言
Side Projects · 2023 – Now
這裡不是正式 career timeline，而是我從 2023 到現在持續探索的 AI、資料系統、供應鏈、web/API 和個人基礎設施 project。This is not my formal career timeline; it is where I document the AI, data systems, supply chain, web/API and personal infrastructure projects I have explored since 2023.
Why Side Projects Matter
我會把正式工作中學到的 data modelling、automation、system thinking 與 operations design，延伸到個人資產管理、F&B supply chain、AI workflow 和 personal infrastructure。I extend the data modelling, automation, system thinking and operations design I learn at work into personal asset management, F&B supply chain, AI workflows and personal infrastructure.
AI · Automation · 2023 – Now
我持續探索如何把 AI 接進日常工作流，讓資料整理、內容生成、分析輔助、文件草稿、SQL logic review 和 decision support 可以更自動化。I continue exploring how AI can be embedded into daily workflows to automate data organization, content generation, analytical support, document drafting, SQL logic review and decision support.
Infrastructure · Network · 2023 – Now
我使用 Mac mini、MacBook Pro、Synology NAS、Tailscale 等設備，規劃個人分散式服務與資料基礎設施。I use Mac mini, MacBook Pro, Synology NAS and Tailscale to plan personal distributed services and data infrastructure.
Finance · Database · 2023 – Now
我構想以 SQLite + FastAPI 建立個人資產資料庫，支援 FIFO 成本計算、估值、資產追蹤，以及 macro / meso / micro 指標庫。I am designing a personal asset database with SQLite and FastAPI to support FIFO cost calculation, valuation, asset tracking and macro/meso/micro indicator structures.
F&B · Supply Chain · 2023 – Now
我把家族榴槤 / F&B 生意中的採購、庫存、銷售、導遊合作、促銷核銷與員工 SOP 轉成流程化管理。I translate procurement, inventory, sales, tour guide partnerships, promotion redemption and staff SOPs from my family durian/F&B business into structured operating processes.
Forecasting · Tools · 2023 – Now
我建立 forecasting model、calculator prototype 和小型 analytical tools 的概念，希望把分散在 Excel、手算或聊天紀錄裡的邏輯，變成可重複使用的小工具。I build concepts for forecasting models, calculator prototypes and small analytical tools to convert logic scattered across Excel, manual calculations or chat records into reusable tools.
Web · API · Personal Brand · 2023 – Now
我探索個人網站、web server、API endpoint 與前端展示方式，讓履歷、生平介紹、side projects 和 personal brand 可以用更互動的方式呈現。I explore personal websites, web servers, API endpoints and frontend presentation to make my résumé, biography, side projects and personal brand more interactive.
Inside the Projects
每個 project 都是一次完整的問題拆解練習：先釐清需求與使用情境，再設計資料結構、流程、驗證規則與交付方式。有些仍在 prototype 階段，有些則持續隨真實需求迭代；共同目標是讓工具可重複使用、結果可追溯，也能真正融入日常決策。Each project is an end-to-end problem-framing exercise: clarify the need and usage context, then design the data structure, workflow, validation rules and delivery method. Some remain prototypes while others keep evolving with real needs; the shared goal is to make tools reusable, results traceable and outputs useful in everyday decisions.
AI · Automation
我把重複、耗時但仍需要判斷的知識工作拆成可管理的步驟，探索 AI 在資料整理、研究摘要、文件起草、SQL logic review 與 decision support 中最合適的角色。I break repetitive, time-consuming knowledge work into manageable steps and explore where AI best fits in data preparation, research summaries, document drafting, SQL logic review and decision support.
How I Approach It
先定義輸入、輸出和品質標準，再安排 prompt、工具呼叫與人工 review checkpoint。AI 負責加速初稿與模式辨識，關鍵假設、敏感資料和最終判斷仍保留人工驗證。I define inputs, outputs and quality standards first, then arrange prompts, tool calls and human review checkpoints. AI accelerates drafts and pattern recognition, while key assumptions, sensitive data and final decisions remain human-validated.
Infrastructure · Network
我以現有的 Mac mini、MacBook Pro 與 Synology NAS 為基礎，規劃一套兼顧儲存、運算、備份與遠端存取的個人基礎設施，讓資料和服務不再分散於單一裝置。Using a Mac mini, MacBook Pro and Synology NAS, I am planning personal infrastructure that combines storage, compute, backup and remote access so data and services are not trapped on one device.
System Thinking
我會明確劃分各裝置角色，透過 Tailscale 管理安全連線，並把權限、服務清單、備份頻率與復原流程一併納入設計。重點不只是「能連線」，而是長期維護時仍清楚、可靠。I assign clear roles to each device, use Tailscale for secure connectivity, and include permissions, service inventory, backup frequency and recovery procedures in the design. The goal is not merely connectivity, but clarity and reliability over time.
Finance · Database
這個 project 希望把交易紀錄、持倉、價格、成本與研究指標整合成單一可信的資料來源，減少不同試算表之間口徑不一致，也讓每一個估值結果都能回查原始交易。This project aims to combine transactions, holdings, prices, costs and research indicators into one trusted source, reducing inconsistencies across spreadsheets and making every valuation traceable to its original transaction.
Core Logic
我以 SQLite 規劃標準化 schema，再透過 FastAPI 提供查詢與計算介面。FIFO engine 需要處理交易先後、部分賣出、手續費與幣別等細節，並分離 raw data 與 calculated output，保留完整 audit trail。I use SQLite for a normalized schema and FastAPI for query and calculation interfaces. The FIFO engine accounts for transaction order, partial disposals, fees and currencies, while separating raw data from calculated output to preserve an audit trail.
F&B · Supply Chain
這是最貼近真實營運場景的 side project。我從家族榴槤與 F&B 生意出發，觀察高損耗、價格波動、短銷售週期與多人交接下，資訊容易中斷或難以核對的問題。This is the side project closest to a live operating environment. Starting from my family durian and F&B business, I examine information gaps caused by perishability, price volatility, short sales cycles and multi-person handoffs.
Operational Scope
我把採購、收貨、批次庫存、銷售、促銷核銷、導遊合作與佣金結算串成流程，並同步思考員工 SOP、例外情境與管理報表。這讓我練習把 frontline language 轉成清楚的 system requirement。I connect procurement, receiving, lot inventory, sales, promotion redemption, tour-guide partnerships and commission settlement, while considering staff SOPs, exceptions and management reporting. It helps me translate frontline language into clear system requirements.
Forecasting · Tools
許多日常判斷依賴重複手算、複製 Excel 公式或翻找聊天紀錄。我把這些零散邏輯整理成輸入、假設、計算與輸出，逐步建立可重複使用的小型 forecasting 與 calculator prototype。Many everyday decisions rely on repeated manual calculations, copied Excel formulas or old chat records. I restructure that scattered logic into inputs, assumptions, calculations and outputs, then turn it into reusable forecasting and calculator prototypes.
Decision Support
除了算出單一答案，我也加入 scenario comparison、sensitivity analysis、break-even logic 與 forecast-versus-actual 檢查，讓使用者能看懂結果如何形成，並快速比較不同假設的影響。Beyond producing one answer, I include scenario comparisons, sensitivity analysis, break-even logic and forecast-versus-actual checks so users can understand how results are formed and compare the impact of assumptions.
Web · API · Content
這個網站本身就是 project 成果。我不只把傳統履歷搬到網頁，而是重新設計閱讀順序、雙語內容與互動方式，讓不同背景的讀者能快速理解我的經歷、能力與職務適配。This website is itself a project outcome. Instead of moving a conventional résumé online, I redesigned the reading flow, bilingual content and interactions so readers from different backgrounds can quickly understand my experience, capabilities and role fit.
What I Built
網站包含 responsive UI、全站導覽、語言切換、inline content editor 與 content manifest，也透過 local web server 支援預覽和內容維護。這個過程同時練習前端實作、內容架構與 product thinking。The site includes a responsive UI, global navigation, language switching, an inline content editor and a content manifest, supported by a local web server for preview and maintenance. The process combines frontend implementation, content architecture and product thinking.