Highlight Project
Python · psycopg2 · PostgreSQL · Docker · WSL2 · SQL
- Data-Automation-Pipeline-V1 — End-to-end data pipeline that uses Python connection drivers (psycopg2) to reach through the network layers of a local, Docker-hosted PostgreSQL instance and fully automate the database lifecycle.
- Containerized database host — PostgreSQL runs inside a Docker container with mapped ports and persistent volumes, so the whole environment can be torn down and rebuilt identically on any machine.
- Network-layer connection — Python connects across the container's network boundary through psycopg2, handling host/port mapping, credentials, and transactional cursors from WSL into the container.
- Automated drops & structural migrations — Scripts drop stale objects and apply schema migrations in order, creating tables, keys, and constraints so the relational model is rebuilt idempotently on every run.
- Batch uploads — Source records are loaded in batches inside transactions, so a failed batch rolls back cleanly instead of leaving partial data behind.
- Analytic SQL cost calculations — Aggregation queries calculate cost metrics directly in the database and return reporting-ready results to Python.
Skills
57 tools across 8 groups
- Languages — Python · SQL · C / C++ · Bash · TypeScript · MATLAB
- Databases & Pipelines — PostgreSQL · SQLite · Relational Schema Design · Batch Ingestion · psycopg2 · Analytic SQL · Cost-Matrix Pricing Logic
- Tools & Infrastructure — Docker Containerization · WSL / Hypervisors · Linux Admin · Git · Self-Hosted Servers · Cloudflare Tunnel · IP Networking
- Web & Application — React · React Three Fiber (3D) · WebAssembly File Parsing · Stripe Checkout · Streamlit · AI-Assisted Automation
- AI & Machine Learning — Local LLMs (Ollama / Gemma) · ComfyUI · Stable Diffusion · PyTorch · TensorFlow · Generative Pipelines · Prompt Engineering
- Industrial Controls & Electrical — Allen-Bradley PLCs · Ladder Logic · HMI Setup · Analog / Digital I/O · Line Control Integration · Pneumatics & Hydraulics · Electrical Diagnosis · Induction Heating
- Mechanical & Design — SolidWorks · Fusion 360 · CAD / CAM · STEP / DWG Workflows · Blueprint Reading · Machining · Welding & Fabrication · PCB Design
- Process & Quality — Process Optimization · Quality Control Integration · Preventive Maintenance · Equipment Calibration · Recipe Management · Troubleshooting Guides · SAP · Technical Writing
Roles
2 data-focused roles
- Data & Automation Engineer (Independent) · 2025 - Present — Built Data-Automation-Pipeline-V1: containerized PostgreSQL with Python-driven migrations, batch loads, and analytic SQL.
- Engineering Technician, Hydro Precision Tubing (Rockledge, FL) · 2021 - 2026 — Integrated measuring equipment with analog/digital I/O for temperature, flow, and pressure data, then used those readings to drive process and quality fixes.
Builds
Shipped work
- Factory Spec Builder · CAD / Web / Pricing — Browser tool that parses uploaded STEP/CAD files with WebAssembly, renders them in interactive 3D, measures part dimensions, and runs a cost-matrix engine for material, process, and assembly pricing through to checkout.
- Self-Hosted Promo Pipeline · Automation / Self-hosting — Automated content pipeline running from a home server.
- Local AI Video Studio · Local AI / Orchestration — Fully local generative workflow.
- AI Artwork Workflow · Generative / QA process — Repeatable AI image pipeline with written briefs, brand-consistency rules, review checkpoints, and optimized delivery formats, documented step by step.
Build Log
Progress with Lovable
- Personal Landing Page — First Lovable build.
- Business Portfolio & Storefront — Grew into a multi-page business site.
- Business Card Generator — Tool that lays out printable business cards (front and back, horizontal and vertical) from a profile of skills and contact details.
- Streaming Hub — Central page for streaming content with integrated social and channel links, published live.
- Signal Identity Creator — Brand-system tool that defines color tokens, typography, and identity pages, with AI-generated artwork held to written art-direction rules.
- Factory Spec Builder (inside the business site) — 3D CAD upload and quoting tool.
- Data & Automation Resume (this page) — Recruiter-ready portfolio with an interactive skill matrix and one-click PDF, Word, RTF, and text resume exports.