# IT Oversight
> High-integrity AI engineering, lightweight custom systems, and secure web bridges.

This site serves as the portfolio, resource hub, and services directory for Steve Vogelaar, an LLM Systems Engineer, full-stack developer, and creator of the local-first HAL Agent framework.

## Key Information
- **Location:** Windsor-Essex, Ontario, Canada
- **Contact Email:** steve@itoversight.ca
- **Core Specialty:** Building local-first AI infrastructures, security-hardened web integrations, and custom database plugins. Business management consultation services.

## Core Capabilities
- **LLM Systems Engineering:** Design and implementation of secure, local-first RAG (Retrieval-Augmented Generation) pipelines and persistent database memory systems (MySQL/MAMP).
- **Custom Plugin Development:** Robust, secure PHP and WordPress plugin development featuring offline synchronization, licensing systems, and clean structural architectures.
- **Security Hardening:** Implementation of multi-layered web protection, zero-trust configurations, and API bridge hardening.
- **Business Management Consultation:** Partnering with businesses to analyze operations, streamline digital frameworks, find structural cost savings, and unlock hidden profitability.

## Active Projects & Products
- [Restaurant Costing](#restaurant-costing): High-performance inventory, nutritional costing, and P&L WordPress plugin.
- [SDF (Software Development Foundation) Portal](#sdf): A comprehensive, zero-dependency suite integrating licensing, client databases, affiliate management, secure auto-updates, and web-bridge APIs.
- [The HAL Project](#hal-project): Local-first, private AI assistant built on persistent MySQL context with automated task performance tracking.

---

## Detailed Specifications

### Restaurant Costing
An enterprise-grade WordPress plugin for restaurants, offering complete inventory tracking, weight-to-volume unit conversions, automated nutritional calculation grids, per-supplier order print matrices, and a companion POS sales/labor importer add-on. Developed under a secure, local-first database architectural pattern.
- **Current DB Schema Version:** 1.2.4 (WP Options: `wp_rc_version`)
- **Key Features:** Portion weight calculation, missing AJAX handlers fallback, global nutrition-hide settings, and low-stock highlighting.

### SDF (Software Development Foundation) Portal
A robust, secure portal backbone and software distribution engine designed to be highly modular, zero-dependency, and isolated from standard CMS security vulnerabilities. It combines client portal facilities, billing analytics, and the Salamander API web-bridge architecture.
- **Licensing & Web-Bridge Core:** Secure API endpoints, validation logic, and domain-locking controls utilizing zero-dependency PHP architecture with invisible Google reCAPTCHA v2 integrations.
- **Customer & Sales Infrastructure:** Encryption-hardened database housing customer and lead profiles, manual offline-sale invoice generation, and real-time financial reporting with P&L-style analytics.
- **Affiliate & Distribution System:** Affiliate registration, tier structures, automated commission calculations, audit trails, and direct lead-generation click tracking.
- **Automatic Updates & Support:** Multi-channel updater serving signed files directly, built-in HelpDesk ticket system with revision tracking, and client-facing support documentation.
- **Architecture:** Monolithic code refactored into domain-focused classes separating administrative services, updates management, and licensing packages.

### HAL (Local Agent Framework)
Steve Vogelaar's proprietary AI agent framework. Powered by localized orchestration, HAL utilizes a customized MySQL schema (`agent_memory`) to track sessions, isolate parallel database tasks, record performance success metrics, and maintain a strict long-term semantic memory.
- **Foundational Rules:** Emphasizes absolute clarity, extreme conciseness, and high-integrity execution of technical plans.