otif

Real-time OTIF (On-Time-In-Full) SLA monitoring: SQL window functions, PostgreSQL RLS/materialized views, and Power BI + Power Automate event-driven alerting.

Python portfolio applied to Supply Chain & Operations: OTIF KPI, Inventory ABC/ROP, and report automation (Excel).

End-to-end supply-chain analytics control tower: SKU-level demand forecasting, safety stock & reorder optimization (OR-Tools), OTIF and vendor scorecards. Built with Airflow, dbt, DuckDB, and Streamlit.

How honest is your on-time KPI? A five-rung OTIF metric ladder, driver-decomposition charts and a Streamlit explorer for delivery-performance data.

AI-powered supply chain platform: OTIF Compliance Copilot + Exception Brain. Built with Claude API, Next.js 16, Supabase. UAE/GCC market.

OTIF scoring in LangGraph: deterministic core, LLM at the edges. Typed state, SQLite checkpointing, human-in-the-loop interrupts, versioned scoring policies.

This project contains two PostgreSQL queries used to build widgets for an **OTIF (On-Time In-Full) dashboard**, which helps monitor supplier performance and delivery accuracy across clients and distribution centers.

BI-система коммерческого аудита ритейла: ABC-анализ маржинальности, оценка надежности поставщиков по OTIF и What-If калькулятор заказа (PostgreSQL, DataLens)

Operations analytics that audits its own numbers: OTIF, forecast accuracy, ABC-XYZ and Pareto with a mandatory honesty block. JSON-only, built for AI agents and pipelines.

This dashboard was created at the request of the Trading House Director to provide a comprehensive view of business performance.

Creation a logistics and supply chain dashboard for OTIF Analysis

[1] What if delays are not random - but predictable?

Análise de dados logísticos com o dataset DataCo Smart Supply Chain — OTIF, lead time e taxa de atraso por região, modal e categoria.

Interactive Excel logistics dashboard tracking OTIF, SLA compliance, delay trends and return rates across 200 shipments — revealing a 42.5% SLA breach rate and 235% increase in delays from January to July.

Las ineficiencias en la cadena de suministro representan una fuga del 5-15% de los ingresos en empresas de manufactura y construcción. Este proyecto es una solución **End-to-End** diseñada para proporcionar visibilidad operativa y decisiones proactivas.

Excel dashboard for analyzing Outbound Order Fulfillment and OTIF (On-Time In-Full) performance using Pivot Tables and Excel formulas.

📊 Интерактивный дашборд OTIF и финансовых показателей логистики на Python Dash

End-to-end supply chain analytics project analyzing supplier delivery, forecast accuracy, inventory exposure and quality risk using Power BI and SQL

Excel 365 production planning & control for a garment unit: PO scheduling with OTIF and line-level machine capacity planning (anonymised sample)

OTIF blind spot diagnostic — reconciles internal fulfillment metrics against retailer scorecards and quantifies the gap. Python + Dash.