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

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

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.

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.

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.

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

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

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.

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

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.

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.

Power BI portfolio project analyzing workforce, productivity, operational performance, and profitability using synthetic data.