Selected work
Flagship systems are shown first. Additional featured builds provide depth across automation, inventory, pricing, APIs, dashboards, and reporting.
Flagship projects
Cloud ETL Platform
Cloud-ready ETL and analytics platform that transforms fragmented OrderTime operational data into governed, analytics-ready datasets for inventory, procurement, and reporting decisions.
Power BI Inventory Dashboard
Power BI semantic model and inventory dashboard suite that turns stock health, replenishment, procurement, velocity, and deadstock analytics into one connected decision layer.
Procurement Intelligence
Procurement intelligence engine that turns fragmented inventory, sales, vendor, pricing, and receipt signals into action-ready replenishment recommendations.
CCC Stateful Insights
Stateful reporting pipeline that detects new and changed CCC quote runs, tracks processing history in JSON state, and refreshes downstream analytics only when operationally necessary.
AI Analytics Copilot
AI-guided analytics workspace that helps users ask operational questions, routes requests through controlled tools, and returns structured answers through a SQL-safe decision layer.
Ops Analytics API
Operational analytics layer that turns KPIs, trends, alerts, and export-ready outputs into a reusable FastAPI backend and an executive-friendly dashboard experience.
PartsTrader Monthly Pipeline
Monthly reporting orchestrator that uses a stage registry, dependency graph, manifests, dry-run planning, and JSON state to run only the work that needs to be refreshed.
Pegasus Scanner
Inventory scanning and cycle-count application that turns scanner input, BIN-based counts, receiver checks, and export-ready audit records into a controlled warehouse workflow.
Additional featured builds
CCC Quote Automation
Browser automation and extraction system that turns CCC quote portal workflows, grid results, quote detail screens, XML downloads, and requested-part records into structured reporting-ready outputs.
PartsTrader Automation
Automation system that transforms messy PartsTrader item and summary exports into clean master files, customer-specific reports, manufacturer splits, and downstream-ready reporting artifacts.
CCC Monthly Builder
One-runner monthly reporting orchestrator that modernizes legacy CCC reporting stages with a step registry, fast/full rebuild control, output-marker checks, fingerprints, JSON state, and JSONL run history.
OnPart Feed Automation
Partner inventory-feed automation that turns OrderTime API inventory records into a mapped, validated, audit-ready CSV feed delivered through controlled FTP / FTPS publishing.
Customer History Loader
CSV-to-Azure SQL ingestion pipeline that normalizes customer movement history, validates period and quantity fields, prevents duplicate records, and loads append-ready data into a reporting foundation.
DNet Price Movement
Period-over-period pricing analytics engine that compares Dealer Net and List price movement across monthly snapshots, classifies part-level changes, and produces executive-ready summaries.
Gross Margin DNet Engine
Pricing policy engine that turns Dealer Net, landed cost, deductions, margin targets, and DNet bucket rules into buy, hold, review, and exception recommendations.
Deadstock Engine
Inventory health workbook system that classifies stale, dormant, dead, and never-sold stock, layers in pricing exposure, and compares workbook periods to track recovery and deterioration.
Partsnap Portal
Internal Flask and Dash portal that consolidates DNet/List lookup, sales-file uploads, parsing previews, missing-value summaries, monthly analytics, and exports into one operational dashboard.