A comprehensive financial model for a freight forwarding firm, integrating the Income Statement, Balance Sheet, and Cash Flow Statement with dynamic linking and historical analysis.
Built a 13-week rolling cash flow forecast model to track liquidity, simulate scenarios, manage working capital, and improve short-term financial decision making.
Freight forwarding P&L model forecasting revenue, variable costs, and profitability across scenarios, with breakeven, sensitivity analysis, and per-TEU unit economics for pricing and decision-making.
EXIM documentation tracking dashboard monitoring shipment status, freight routes, compliance documents, transit progress, and operational bottlenecks.
Interactive quantitative trading backtesting dashboard analyzing strategy performance, parameter optimization, risk metrics, and equity curves.
Excel-based investment risk dashboard tracking FAANG portfolio with Beta, VaR, correlation, volatility, and drawdown analysis.
Modular Python-based pipeline for collecting and processing real-time and historical market data.
Automated Python pipeline to scrape video metadata, transcripts, and comments from YouTube for research and sentiment analysis.
Interactive shipment workflow dashboard mapping factory-to-buyer logistics operations, Incoterm responsibilities, risk transfer points, operational documents, customs stages,etc.
Capital investment evaluation model analyzing machine acquisition economics through NPV, IRR, MIRR, depreciation, operating costs, production capacity expansion, cash flow projections, and sensitivity analysis for manufacturing investment decisions.
Excel-based financial model for warehouse CapEx decisions. Covers pallet occupancy ramp-up, storage/handling revenue, FCF forecasting.
Comprehensive accounts payable, accounts receivable, and order-to-cash analytics model for tracking working capital, aging, and collection efficiency.
Excel-based currency risk assessment model for manufacturing operations covering forex exposure, hedging strategies, and sensitivity analysis on exchange rate movements.
Email automation workflows, web scraping pipelines, and AI-powered tools built with Python and Antigravity.
A structured reference system covering 130+ hex codes from McKinsey, BCG, Deloitte, Tableau, and Power BI with WCAG accessibility.
Excel-based nutrition database tracking 70+ micro and macronutrients.
An end-to-end B2B CRM analytics platform tracking lead quality, funnel health, and rep performance.
HR analytics dashboard tracking workforce composition, attrition trends, departmental distribution, hiring metrics, tenure analysis, and employee retention patterns through interactive filters, workforce KPIs, and organizational performance visualization.
Manufacturing quality control dashboard built for real-time production monitoring and process analysis. Tracks SPC metrics such as CpK, defect rates, out-of-spec counts, control trends, downtime, and Pareto defect distribution across production lines and shifts.
Interactive freight analytics dashboard covering shipment trends, pricing movement, and operational visibility.