Overview
Brand Path Suite is a full ecosystem of tools (Chrome extension, offline EXE, and a Flask web app) used to quickly look up, verify, and reuse standardized brand paths. It was built to eliminate repetitive manual searching and ensure consistent outputs across teams and projects.
- Problem: DS and QA spent minutes per SKU manually searching brand lists and taxonomy paths.
- Solution: Centralized lookup and bulk-processing tools with a rule + SQL + fuzzy-match engine.
- Outcome: Cut lookup time from minutes to seconds and let teams reuse past brand decisions at scale.
My Role
- Designed the end-to-end workflow based on actual Data Specialist (DS) production use cases.
- Built the Chrome extension, EXE desktop tool, and full Flask backend.
- Integrated rule-based matching, SQL lookups, and brand list enrichment.
- Added admin utilities to update brand lists and rules without code changes.
Tech Stack
- Python, Flask, SQL (MySQL)
- Chrome Extension (JavaScript, Manifest V3)
- Standalone EXE (Python → PyInstaller)
- Excel/CSV support with a rule-based logic engine for brand and category normalization
Key Features
- Instant Chrome lookups: highlight text → get normalized brand paths instantly.
- Accent-insensitive search: handles diacritics automatically.
- Offline EXE mode: bulk process large lists with no internet dependency.
- Web app: centralized search, SQL enrichment, history, and admin updates.
- Rule + SQL hybrid engine: powerful brand/category matching.
- Admin Panel: update rules, brand lists, taxonomy entries without redeploying.
Impact
- Reduced manual brand-path lookup from minutes to seconds per SKU.
- Deployed to the Chrome Web Store with 70+ installs in 30 days.
- Improved catalog consistency with automatic diacritic correction.
- Enabled DS teams to scale output by removing repetitive steps.