Real-time OTIF (On-Time-In-Full) SLA monitoring: SQL window functions, PostgreSQL RLS/materialized views, and Power BI + Power Automate event-driven alerting.
-
Updated
Jul 6, 2026 - Python
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.
Creation a logistics and supply chain dashboard for OTIF Analysis
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 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.
End-to-end supply chain analytics project analyzing supplier delivery, forecast accuracy, inventory exposure and quality risk using Power BI and SQL
This dashboard was created at the request of the Trading House Director to provide a comprehensive view of business performance.
Supply chain KPIs with dbt: ABC inventory classification, OTIF, supplier performance | PostgreSQL
How honest is your on-time KPI? A five-rung OTIF metric ladder, driver-decomposition charts and a Streamlit explorer for delivery-performance data.
OTIF scoring in LangGraph: deterministic core, LLM at the edges. Typed state, SQLite checkpointing, human-in-the-loop interrupts, versioned scoring policies.
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.
[1] What if delays are not random - but predictable?
AI-powered supply chain platform: OTIF Compliance Copilot + Exception Brain. Built with Claude API, Next.js 16, Supabase. UAE/GCC market.
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.
Excel dashboard for analyzing Outbound Order Fulfillment and OTIF (On-Time In-Full) performance using Pivot Tables and Excel formulas.
OTIF blind spot diagnostic — reconciles internal fulfillment metrics against retailer scorecards and quantifies the gap. Python + Dash.
Interactive analysis tool that quantifies the full cost of short-shipping orders for a specialty food brand. Four cost dimensions, adjustable parameters, buffer simulation, and exportable PDF. React + Python.
Dashboard Power BI para métricas OTIF (On-Time In-Full). Relatórios executivos e modelo semântico.
To associate your repository with the otif topic, visit your repo's landing page and select "manage topics."