Build catalog

AAsseeaarrcchhaabblleelliibbrraarryyooffrreeaallssyysstteemmss..

Filter by flagship, featured, build library, collection, domain, or technology stack.

Showing 30 of 30 builds.
OrderTime Cloud ETL & Inventory Intelligence Platform visual
Flagship

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.

PythonAzure SQLETLDocker
Power BI Inventory Intelligence Dashboard & Semantic Model visual
Flagship

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.

Power BIDAXPower QuerySemantic Modeling
Procurement Intelligence & Replenishment Automation visual
Flagship

Procurement Intelligence

Procurement intelligence engine that turns fragmented inventory, sales, vendor, pricing, and receipt signals into action-ready replenishment recommendations.

PythonPandasSQLCSV
CCC Stateful Insights & Incremental Reporting Pipeline visual
Flagship

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.

PythonJSON StatePowerShellExcel
Pegasus AI Analytics Copilot & SQL-Safe Query Assistant visual
Flagship

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.

FastAPIReactOpenAI APIAzure SQL
Pegasus Ops Analytics API & Executive Dashboard visual
Flagship

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.

FastAPIAzure SQLT-SQLTailwind
PartsTrader Monthly Reporting Pipeline & Changed-Only Orchestrator visual
Flagship

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.

PythonCLIJSON StateExcel
Pegasus Scanner — Inventory Scanning & Cycle Count App visual
Flagship

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.

FastAPIHTML/JSAzure SQLBarcodeDetector
Featured

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.

PythonPlaywrightPandasXML
Featured

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.

PythonPandasCSVExcel
Featured

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.

PythonCLIJSONJSONL
Featured

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.

PythonOrderTime APIFTP/FTPSCSV
Build Library

Exclusion Feed Automation

Stateful CSV automation that generates stable exclusion feeds with part normalization, duplicate removal, SQLite change tracking, historical snapshots, rotating logs, dry-run support, and audit summaries.

PythonCSVSQLiteLogging
Build Library

Inventory Emailer

Python SMTP automation that validates recurring inventory files, creates timestamped ZIP bundles, applies delivery-window logic, and sends stakeholder-ready inventory packages without manual attachment handling.

PythonSMTPZIP.env
Build Library

Webhook Receiver

FastAPI webhook service that validates operational payloads, applies controlled intake rules, writes append-only event logs, persists structured records to Azure SQL, and exposes health and download endpoints for later analysis.

FastAPIPydanticAzure SQLJSON
Featured

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.

PythonPandasAzure SQLSQLAlchemy
Featured

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.

PythonPandasParquetDash
Featured

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.

PythonPandasPricing AnalyticsExcel
Featured

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.

PythonPandasOpenPyXLExcel
Build Library

Phase-Out Hit Comparison

Workbook comparison engine that loads phase-out lists, normalizes part numbers, matches them against internal part references, scores inventory exposure, and generates executive and audit-ready outputs for review.

PythonPandasExcelMatching Logic
Featured

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.

FlaskDashSQLitePandas
Build Library

PDF Invoice Toolkit

Document ETL toolkit that extracts structured invoice data from PDF files, converts it into clean workbook and CSV outputs, and supports reconciliation against eBay transaction records.

PythonpdfplumberRegexExcel
Featured

eBay Seller Ops Toolkit

API extraction toolkit that turns eBay orders, line items, payouts, fees, cancellations, traffic, and pricing context into repeatable CSV and JSON outputs for seller operations and profitability analysis.

PythoneBay APIOAuthCSV
Build Library

Tariff History Pipeline

Master-data ingestion pipeline that loads tariff files into Azure SQL with controlled validation, staging, stored-procedure upserts, and current-plus-history data modeling.

PythonAzure SQLPandasStored Procedures
Build Library

OnParts OEM Ingestion

OEM reference-data ingestion pipeline that validates lookup files, normalizes OEM numbers, parses fitment years, prevents duplicate SQL records, and incrementally loads clean reference data into Azure SQL.

PythonPandasAzure SQLSQLAlchemy
Build Library

PartsTrader Catalog Ingestion

Catalog ingestion pipeline that accepts CSV, TXT, XLSX, and related source formats, normalizes catalog fields, applies fitment-aware de-duplication, and publishes clean append-only records plus reporting-ready SQL views.

PythonPandasAzure SQLXLSX
Featured

Weekly Inventory Export

Weekly inventory availability workflow that collects inventory data, normalizes manufacturer groups, generates grouped audit workbooks, packages ZIP bundles, and delivers stakeholder-ready reports by email.

PythonOpenPyXLSMTPCSV
Featured

Customer Sales Engine

Sales analytics workbook generator that converts customer and manufacturer sales data into margin metrics, period-over-period movement, top movers, risk flags, and executive-ready Excel summaries.

PythonOpenPyXLPandasExcel
Build Library

Crypto Analytics Dashboard

Market analytics prototype that combines data extraction, technical indicators, forecasting experiments, portfolio analytics, and dashboard storytelling into one structured decision-support workspace.

PythonDashPlotlyyfinance
Build Library

Automation Courier

Procurement output dispatcher that validates generated report artifacts, builds controlled ZIP packages, sends personalized stakeholder emails, and raises missing-file or failure notifications when delivery cannot complete cleanly.

PythonSMTPZIPLogging