operations-analytics

UNS-native, cybersecurity-aware multi-agent reference architecture for U.S. small-to-mid manufacturers. Industrial agentic intelligence aligned with ISA-95, NIST AI RMF, and CMMC L2.

End-to-end café inventory project: clean transaction data, build daily item-level demand series, backtest strong baseline forecasters, generate next-30-day demand forecasts, convert forecasts into safety stock + reorder points, and validate policies with Monte Carlo stockout-risk simulations, wrapped in a Streamlit dashboard.

Operational performance and MI reporting using SQL and Power BI, focused on backlog, SLA and workload monitoring for management decision-making.

[Python & Gurobi] Adopted Game Theory & Linear Programming models to optimizing the price and sourcing strategy for Catfish producers in the United States

This project presents an end-to-end analysis and solution for a real-world business case focused on **reducing Total Order Time** and **improving delivery efficiency** in a fast-growing foodtech startup. It demonstrates strong data analysis, business insight generation, and dashboarding skills using Excel and Power BI.

Interactive Excel dashboard — 1,000 call records, dynamic slicers, KPI tracking for operational analytics, rep performance, and regional analytics

End-to-end E-Commerce Delivery Operations Intelligence platform with analytics, demand forecasting, capacity planning, operational risk insights, Streamlit dashboard, Docker, CI/CD, and cloud deployment.

Data, business and operations analyst portfolio — Power BI, SQL, Excel and process improvement.

Toyota Production Analytics Dashboard using Excel VBA to simulate Lean manufacturing analytics, production monitoring, defect analysis, and automated factory KPI reporting.

An end-to-end business intelligence project that cleans and reconciles 49k+ real-world mobile money transactions in Excel Power Query and surfaces agent network dynamics, liquidity patterns, and product profitability in Tableau.

AI-powered operations monitoring system that detects issues, scores severity, chains root causes, and delivers automated PDF reports via email — built with Python, Claude API, and ReportLab

Streamlit app for courier and logistics analytics using Excel and Google Sheets. Supports month-wise packet tracking, sender and mode analysis, and payment reporting with drill-down insights.

Power BI dashboard tracking operator downtime and efficiency in a production environment; found a 62% efficiency gain and 21% downtime reduction opportunity.

Multi-agent AI system for logistics, finance, and growth marketing intelligence using FastAPI, LLM orchestration, memory, and real-time streaming.

Exploratory data analysis of 10,500 call center customer interactions in Python — analyzing ticket SLA compliance, handle time thresholds, and CSAT ratings across support channels.

SQL-based analytics pipeline for identifying revenue leakage in CPG supply chains using DuckDB, Python, and synthetic trade spend data

SQL & Tableau manufacturing analytics project comparing rule-based diagnostic modeling vs leakage-safe predictive risk modeling using the AI4I 2020 dataset.

Operational analytics pipeline that detects workflow inefficiencies in ITSM ticket lifecycles and simulates cost-saving interventions.

Synthetic multi-branch operations analytics portfolio demonstrating KPI design, SQL, Python, Power BI modeling, data quality, and business requirements.