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

This margin analysis quantifies unrecovered profit, identifies loss making jobs, clients, and routes, and delivers clear recommendations to improve pricing and operational efficiency.

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.

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.

End-to-end Business Intelligence & Data Engineering project analyzing food delivery logistics, financial performance, and customer cohorts.

A Python-based decision support tool that forecasts short-horizon demand, evaluates capacity utilization risk, and produces prioritized mitigation actions with backtest accuracy (MAE/MAPE) and a professional PDF report.

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

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.

Sales forecasting and inventory optimization pipeline. Cleans 105k+ transactions in Python and renders a responsive C-suite dashboard in HTML/CSS/JS loading dynamically from JSON.

End-to-end food delivery operations analytics using SQL, Microsoft Fabric & Power BI to identify delivery delays, performance drivers, and actionable operational insights.

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.

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