CNC manufacturing · Procurement · Operations

I keep the shop running,
and write the software that helps.

I'm Johnmarco. I split my day between buying material, planning production and building internal tools that cut out the busywork: quoting, tracking, scheduling and shop-floor automation.

Focus
Ops + software
Environment
CNC job shop
Builds
Internal tools
  • Python
  • JavaScript
  • SQL
  • G-code
  • Excel / VBA
  • Power Automate
  • ERP / MRP
  • REST APIs
  • Node.js
  • Git
  • Fusion 360
  • Raspberry Pi

01 / Projects

Tools built for a real shop floor

Click any project to expand the full write-up, stack and links.

Procurement used to live in email threads and a shared spreadsheet. This tool stores every RFQ, the vendors it went to and each response, then ranks quotes by price, lead time and past on-time delivery. Buyers see what's overdue at a glance, and the history makes the next quote faster.

  • Side-by-side quote comparison with landed-cost math
  • Automatic reminders for vendors that haven't responded
  • Vendor scorecards built from real delivery history
  • Python
  • Flask
  • SQLite
  • HTMX

Small collectors on each machine report cycle state to a central service. The board shows utilization by shift, flags machines that have sat idle too long, and keeps a history so downtime conversations start from data instead of memory.

  • Per-machine run / idle / alarm state with timestamps
  • Shift utilization summaries emailed each morning
  • Runs on low-cost hardware mounted at the machines
  • Raspberry Pi
  • Python
  • MQTT
  • Node.js
  • Chart.js

Inserts, end mills and bar stock are tracked with cheap barcode scanners. When a quantity falls below its reorder point, a draft purchase request is created with the preferred vendor and last price filled in, so nothing runs out mid-job.

  • Scan-to-issue workflow that takes seconds at the crib
  • Min/max reorder points per item and per job
  • Usage reports that feed tooling budget decisions
  • Python
  • PostgreSQL
  • Barcode scanners
  • Power Automate

Pulls open work orders from the ERP export, estimates run time from routing data, and lays jobs out on a per-machine timeline. Jobs at risk of missing their ship date turn amber well before they turn into a problem.

  • Imports nightly ERP exports automatically
  • Capacity view per machine and per shift
  • Late-risk warnings based on remaining operations
  • JavaScript
  • Node.js
  • SQL
  • CSV / ERP export

A set of scripts for catching mistakes early: list every tool a program calls, estimate cycle time from feeds and moves, and show a readable diff between two revisions of the same program.

  • Tool list and offset summary for setup sheets
  • Rough cycle-time estimates from feed moves
  • Revision diff that ignores comments and whitespace
  • Python
  • CLI
  • pytest

No framework and no build step. Colors and motion live in separate stylesheets so they're easy to tune, the dither reveal is a small canvas script, and everything degrades gracefully with JavaScript off or reduced motion on.

  • HTML
  • CSS
  • JavaScript
  • GitHub Pages

02 / Skills

Both sides of the shop

Knowing how parts get bought, scheduled and made is what makes the software useful.

Procurement

  • Supplier sourcing & RFQs
  • Negotiation & cost analysis
  • Material & tooling purchasing
  • Vendor performance tracking

Operations

  • Production planning & scheduling
  • Inventory & MRP
  • CNC process awareness
  • Lean / continuous improvement

Software development

  • Python & JavaScript
  • SQL & data modeling
  • Internal web apps
  • APIs & integrations

Automation

  • Workflow automation
  • Machine data collection
  • Reporting & dashboards
  • Scripting repetitive tasks
  • Supplier management
  • Cost reduction
  • Lead-time planning
  • Blueprint reading
  • GD&T basics
  • Data cleanup
  • Process mapping
  • KPI dashboards

03 / Insights

Notes on manufacturing tech

Short write-ups from building software inside a working shop.

04 / Contact

Let's talk shop

Questions about a project, manufacturing software, or working together? Send a note.