Create Your First Project
Start adding your projects to your portfolio. Click on "Manage Projects" to get started
AI-Driven Supply Chain Analysis & Automation – Inventory & OTIF Monitoring
Project type
Data Analysis using AI tools
Tools: n8n, Supabase (PostgreSQL), Quadratic AI, ExchangeRates API, Python, SQL
Scenario: Aimed to help the supply chain team track OTIF (On-Time In-Full) rates across regions by automating data ingestion and generating real-time KPIs.
Built an AI-powered automation workflow using n8n (AI Automation agent) to monitor email inbox for new .csv sales and order line attachments and trigger ingestion into a cloud database.
Connected Supabase (PostgreSQL on Cloud) using session pooling and mapped uploaded datasets to fact and dimension tables and integrated with the n8n workflow
Integrated real-time currency conversion using the ExchangeRates.org API with secure APP ID authentication.
Used Quadratic (AI spreadsheet) to join fact and dimension tables, created a dynamic date table, and built actionable KPIs (e.g., OTIF %, inventory coverage by region).
Enabled real-time insights to optimize inventory management and improve visibility across regional supply chains.
