Competitive & Financial Intelligence Engines

A retail company needed to track competitor pricing, market trends, and their own financial performance across multiple stores, but their team was doing it manually. Reports were always late, incomplete, and inconsistent.

I built two interconnected intelligence engines: one for competitive analysis and one for financial monitoring, both powered by multiple LLMs working in parallel.

The competitive engine scrapes and analyzes competitor pricing, promotions, and product launches

Claude API and Gemini process unstructured market data into structured insights

The financial engine pulls transaction data from Supabase and generates real-time P&L, margin analysis, and trend reports

Both engines feed into a unified dashboard with alerts for significant changes

Multi-LLM orchestration (Claude API for analysis, Gemini for summarization)

Automated competitor price tracking across 50+ SKUs

Real-time financial dashboards with store-level breakdowns

Anomaly detection for unusual pricing moves or margin drops

Weekly intelligence briefs auto-generated and emailed to leadership

LLMs: Claude API, Gemini

Backend: Python

Database: Supabase

Competitive response time reduced from weeks to hours

Identified 3 pricing opportunities worth $200K+ in annual margin

Financial reporting fully automated, saving 12+ hours per week

Leadership now receives daily intelligence briefs instead of monthly summaries