IT subsidiary of a retail group — Senior Systems Analyst (AI Application Engineer)
Cloud architecture and AI application development across cloud architecture, DevOps, data engineering and AI products.
Retail allocation platform (primary project)
- Independently delivered an enterprise retail allocation platform (1,100+ files) in 2.5 months with AI collaboration; heavy requirements interviews, allocation logic designed from per-store sales data and special cases
- Backend Python 3.12 / FastAPI / SQLAlchemy 2 / Alembic / PostgreSQL in a layered architecture (api / core / engine / etl / repositories / services); frontend React 19 + TypeScript / Vite / TanStack Query·Table·Virtual / react-hook-form + zod / Tailwind 4
- Contract-first: openapi.json → openapi-typescript generates frontend types, keeping both sides in sync
- CI/CD on Azure Pipelines: PRs run backend pytest and frontend lint/test/build in parallel; 8 backend test modules, 56 frontend test files, UAT smoke tests
- Requirement alignment via single-file HTML prototypes that stakeholders preview before real development, cutting the spec → build → acceptance cycle; disciplined docs (decisions / lessons / runbooks / roadmap)
Demand-allocation ML models
- Store-level allocation forecasting with LightGBM, CatBoost, Optuna tuning and isotonic calibration
- Systematic pipeline: baseline → feature engineering → ablation → blending → rules overlay → misallocation diagnosis; delivered ML allocation plan draft, ER model and table schema
Enterprise Customer Data Platform (6 repos / 2,200+ files)
- React 19 + TS + TanStack Router/Query frontend, .NET 8 Web API, .NET 8 batch system with unit tests; SQL Server multi-schema design + Azure Synapse warehouse (CTAS / HASH-distributed tuning)
- AI API: Python 3.13 + FastAPI + Google ADK agent pipeline + LiteLLM → Azure OpenAI; automated product tagging (migrated from a legacy service) and a 3-stage marketing-copy pipeline; strict API contract (four status codes, per-user rate limiting, fail-honestly-no-fallback)
- Three environments (dev/test/prod) per repo on Azure DevOps pipelines; incident records and architecture runbooks
MCP Gateway (self-built AI infrastructure)
- Wraps internal HTTP APIs as MCP tools so Claude Code / Codex / Copilot reach internal systems through one secure entry point; tool catalog in DB, approved tools go live without code changes or restarts
- Security: per-client Bearer auth, SSRF protection (blocks localhost/cloud metadata + allowlist), Fernet-encrypted upstream credentials, audit logs with sensitive-parameter masking
- Python 3.12 / MCP SDK (Streamable HTTP) / Starlette / SQLAlchemy 2 / Streamlit admin; 20+ test files incl. acceptance tests (pytest-asyncio + respx); v1 live in 3 days
Log anomaly analysis
- Gradio UI with two-stage filtering of large logs → Azure OpenAI analysis → SQLite; strict three-layer decoupling (filter / ai / db); token and cost estimation before each AI call with threshold warnings
Enterprise chatbot product deployment
- Source governance and dockerization of an enterprise chatbot product (Java/JSP/Kotlin, 700+ files): Compose with MSSQL 2022, Redis Stack, Solr 9.5, custom parser; DB init, health checks, fresh-VM deployment SOP; git filter-repo history cleanup, Git LFS
Azure IaC & data engineering
- Modular Bicep IaC (network / keyvault / storage / postgres / appservice): IP allowlist + Private Endpoint dual path, Key Vault secrets, VNet Integration + RBAC, rollback docs
- Dify (open-source LLM platform) on Azure Container Apps (PostgreSQL + pgvector / Redis / Storage, with cost estimate); Terraform for LLM resource groups; ADF pipeline analysis and design (auto-ordering / inventory / sales forecasting), ML pipeline retry/webhook design
AI engineering methodology (institutionalized)
- One shared AGENTS.md driving Claude Code and Copilot CLI on enterprise projects; git worktree for parallel branches
- Adopted and operated the agent-skill toolchain (open-source superpowers workflow) and built an automated AI code-review loop (AI fixes → commit → replies to review thread → re-review until it converges)
- Packaged team domain knowledge as Claude Skills with evals (Azure Synapse tuning, ADF standards) plus project-specific skills (e.g. an Azure DevOps PR flow)
- Internal tech talk on the requirement → AI prototype → user alignment → build workflow (14-page outline, script, 4 diagrams) with 5 reusable de-projectized skills