“EN-02-Social-Marketing-Commercial”

Code Generation from Issue/PRD

Turns a product requirement into a shippable implementation plan + skeleton with acceptance criteria traceability. Useful at sprint start.

Acceptance criteria in Gherkin (Given/When/Then) — every PRD claim traced to

Technical design: architecture sketch (ASCII), data model changes, API

Task breakdown: small (<1 day) tickets with title, acceptance criteria, files

Test plan (unit/integration/E2E mapping to ACs), rollout plan (flag → % rollout

Then implement the foundation layer (models + migration + contract + validation)

Polyglot Translation Between Stacks

Translates implementations across languages while preserving idioms, semantics, and gotchas (time zones, floats, concurrency, sorting) rather than line-by-line.

Summarize behavior and identify semantic pitfalls in translation:

Map source constructs to target idioms (error values→exceptions/Result,

System Design Interview / Real Design Partner

Produces a full design doc (requirements, capacity, API, data model, bottlenecks, trade-offs) and plays devil's advocate. Works for interviews and real projects.

ADR (Architecture Decision Record) Drafter

Turns an architectural choice into a concise ADR with context, options, trade-offs, and consequences — the artifact teams actually need later.

Distributed Systems Trade-off Analyst

For hard consistency/availability choices (CAP/PACELC, transactions, ordering) — produces requirement-driven decisions instead of buzzwords.

API-First / Schema-First Design Facilitator

Forces contract design before implementation, with evolution/versioning rules and consumer review — prevents costly API mistakes.

Multi-Tenancy Architecture Selector

Selects and details an isolation model (shared DB / schema per tenant / DB per tenant) against real requirements, including noisy-neighbor and backup isolation.

Event-Driven / CQRS / Saga Designer

Designs reliable event flows (Kafka/RabbitMQ/EventBridge): contracts, ordering, duplicates, sagas, and read models — including when NOT to use events.

Caching Architecture Advisor

Designs layered caching with explicit invalidation and consistency contracts — the hardest part of real systems.

Rate Limiting, Quota & Throttling Designer

Designs limiters (per-user/IP/tenant/API key), algorithm choice, and 429 contracts — including distributed counters and fairness.

File Upload / Media Pipeline Architect

Designs reliable uploads for large files with virus scanning, image/video processing, and storage lifecycle.

Search & Recommendation System Designer

Designs search (ES/OpenSearch/vector/hybrid) with relevance tuning pipelines — includes ranking eval and zero-result handling.

RAG / LLM-Application Architect

Designs a production retrieval-augmented generation system: chunking, embedding, hybrid retrieval, reranking, evaluation, and guardrails. (LLM-native dev category.)