Selected projects / Public source
Work
Reporting, data pipelines, internal tools and AI workflows. Explore what I built, the decisions behind it, and the public source on GitHub.
01Case study
Power Query/M pipeline and Power BI model for aligning Shopee, Lazada and advertising exports into one inspectable reporting layer.
Power Query/M · Power BI · DAX · CSV · Excel · Star schema
What it enables: Creates one comparable reporting layer so a team can inspect channel performance, payout and advertising signals without stitching exports by hand.
Boundaries: ข้อมูลตัวอย่างเป็น synthetic/anonymized demonstration data — not client performance.
02Simulated case study
SQL analysis modules and a documented Power BI/DAX model for examining sales, customer behavior, campaigns and delivery performance.
SQL · Power BI · DAX · Star schema · Kaggle simulated dataset
What it enables: Turns separate commercial and logistics questions into a shared analytical model for clearer review of sales, retention, campaigns and delivery.
Boundaries: กรณีศึกษานี้ใช้ข้อมูลจำลอง; displayed figures are not Shopee or client internal results.
03Pipeline case study
A Python pipeline design for extracting KBank e-statements, validating transactions, loading PostgreSQL idempotently and preserving operational audit records.
Python · Pydantic · psycopg 3 · pdfplumber · pandas · PostgreSQL · Supabase · Gmail IMAP · Google Sheets API · pytest · GitHub Actions
What it enables: Creates a repeatable path from statement input to validated, traceable records, reducing ambiguity when financial-data loads are retried or reviewed.
Boundaries: KBank-specific parser scope; do not imply broad multi-bank production support.
04Desktop application
An Electron/TypeScript desktop widget that makes long-term deadlines visible through timestamp-based time calculation, deduction rules and local persistence.
Electron · TypeScript · Vite · Vitest · electron-builder · HTML · CSS
What it enables: Keeps a long-term deadline visible and derived from the current timestamp, so local users can review remaining time without relying on a drifting counter.
Boundaries: No claim of independently verified public CI execution, signing or hardened production security.
05System utility
Automated extraction of PostgreSQL schema relationships, constraints and foreign keys into interconnected Obsidian Graph notes and Markdown documentation.
PostgreSQL · Python · SQLAlchemy · PLpgSQL · Knowledge graph · Obsidian
What it enables: Automatically maps PostgreSQL catalog tables and foreign key dependencies into an interactive graph network, enabling instant relationship exploration and visual schema audit.
Boundaries: Snapshot utility: re-run after schema changes. Row counts require table SELECT access and may be costly on large tables.
06Analytics application
A Python/FastAPI application that collects brand observations, stores their provenance in DuckDB, and compares results by answer surface.
Python · FastAPI · DuckDB · Pydantic · Provider APIs
What it enables: Makes each observation traceable to a provider, query and run, with separate metrics for generative answers and search results.
Boundaries: Live-key integration tests and production hardening remain gaps in the source status document.
07Engineering framework
A documented operating model with workspace templates, a SQLite record schema and small Python utilities for coordinating AI-assisted engineering.
Markdown · SQLite · Python · Git
What it enables: Provides a concrete starting structure for task ownership, handoffs, documentation freshness and recorded changes.
Boundaries: The SQLite schema does not enforce immutability through triggers or access controls.