gulmezeren2-byte
UserDeterministic verification for AI-generated analysis. Reconciliation, consistency and Excel-integrity checks that stop the line when the numbers don't add up.
Categories
Indexed Skills (16)
verify-with-andon
After producing or editing any data analysis artifact (report, Excel file, summary table), write an andon verification spec and run it. Use whenever numbers are derived from data and are about to be presented as results.
abc-xyz-segmentation
Segment a SKU portfolio on value (ABC) and demand variability (XYZ), produce the 9-box with a planning policy per cell, and reallocate planner attention accordingly. Use when the user mentions ABC analysis, inventory segmentation, SKU rationalization, stok segmentasyonu, envanter sınıflandırma, or asks which items deserve forecasting effort. Differentiator - ABC alone is treated as half an answer; policy lives in the value x variability combination.
forecast-accuracy-review
Evaluate demand-forecast quality honestly - WMAPE, bias and Forecast Value Added against a naive benchmark over a rolling-origin backtest. Use when the user mentions forecast accuracy, MAPE, demand planning performance, tahmin doğruluğu, talep tahmini, or asks whether a forecasting process or tool is worth it. Differentiator - judges the process (value added vs doing nothing), not just the model.
otif-analysis
Audit delivery performance from order-level data - compute the OTIF metric ladder (tolerant to strict), find where lateness concentrates, and quantify the gap between the reported KPI and what customers experience. Use when the user mentions OTIF, on-time delivery, delivery performance, late orders, teslimat performansı, zamanında teslimat, or asks why customers complain despite a high on-time score. Differentiator - exposes measurement choices before optimizing operations.
root-cause-pareto
Build a decision-grade Pareto for downtime, defects, complaints or delays - with unit-of-measure discipline, category hygiene, exposure normalization and a follow-up metric. Use when the user mentions pareto analysis, kök neden, duruş analizi, downtime, arıza analizi, defect ranking, şikayet analizi, 80/20 analysis. Differentiator - treats the Pareto as the start of a causal investigation, not a bar chart deliverable.
safety-stock-review
Size or audit safety stock with assumption checks - the z*sigma*sqrt(LT) formula plus an empirical stress test of what it actually delivers (cycle service vs fill rate) per variability class. Use when the user mentions safety stock, emniyet stoku, emniyet stoğu, reorder point, service level, stok seviyesi belirleme. Differentiator - refuses to hand back a number without validating the demand-distribution assumptions behind it.
using-ops-method
Entry point for any operations or supply-chain data analysis - routes the work through a fixed method (brief, data contract, honest metrics, driver decomposition, stress test, decision memo) and calls the specialized skills at the right step. Use when starting any ops analysis, KPI study, delivery/forecast/inventory question, operasyon analizi, veri analizi, or when unsure which ops skill applies. Differentiator - enforces sequence and validation, not just tool choice.
weekly-ops-report
Turn raw operational data into a weekly management report that answers exactly three questions - what changed, where is it concentrated, what needs a decision. Use when the user mentions weekly report, haftalık rapor, yönetim raporu, ops review, KPI summary, or asks to summarize operational data for managers. Differentiator - contract-first reporting with plain-language findings and driver decomposition, never a chart dump.
skilldoctor
Diagnose the Claude Code skills installed on this machine — why one never triggers, and whether Claude can see it at all. Use when the user says a skill isn't firing, isn't triggering, or is being ignored; asks to check, audit, or debug their skills; mentions the skill description budget, truncated skills, or duplicate skills; or asks whether a skill they installed is safe to trust. Runs a deterministic CLI over every installed skill at once, so it catches whole-system problems no single-file check can see.
migration-review
Review a database migration before it runs in production. Covers lock acquisition and how long each statement holds one, the difference between a metadata lock and a row lock, adding a column with a default on a large table, backfilling in batches with a bounded window, creating an index concurrently and what happens when that fails halfway, dropping a column that application code still references, renaming in two deploys instead of one, foreign keys added as NOT VALID and validated separately, the difference between a transactional and a non-transactional migration and which engines allow which, statement timeouts as a safety net, estimating table size and row count before choosing a strategy, checking replica lag before and during, the rollback that is not actually possible once data is written, and how to stage a destructive change so that each step is independently reversible. Also covers reading the query plan after the change to confirm the index is used, verifying constraint validity, and writing the r
aws-iam-review
Least-privilege review of IAM policies: spotting wildcard actions, confused-deputy exposure in cross-account roles, and the difference between a resource policy and an identity policy in an access decision.
django-orm
Query construction, N+1 detection and migration safety for Django: select_related vs prefetch_related, when a migration needs a separate data step, and how to read the SQL a queryset actually emits.
k8s-debugging
Diagnose a failing workload on Kubernetes: reading events before logs, distinguishing CrashLoopBackOff causes, probe misconfiguration, and the resource-limit symptoms that look like application bugs.
nextjs-app-router
Routing, layouts, streaming and cache semantics in the Next.js App Router: which boundary makes a component a server component, why a fetch is deduplicated, when revalidation actually happens, and reading the build output to see what became static.
postgres-tuning
Index selection, EXPLAIN reading and lock diagnosis for PostgreSQL: which scan the planner chose and why, when an index is not used, and how to find the query holding the lock everyone else is waiting on.
react-patterns
Component composition, hooks discipline and render-cost review for React 19: when to reach for a server component, why a context provider re-renders more than you expect, and how to read a Profiler flame chart before reaching for memo.
Bio shown is the top-scored skill's repo description as a fallback — real GitHub bios land in a future update.