RECENTLY COMPLETED PROJECTS & STRATEGIC ALLIANCES

Acknowledgment is due to Dirk DeKreek of DTS for his ongoing technical collaboration and strategic recommendations across multiple enterprise and municipal deployments. Good friends are hard to find and it's been about 20 years now!

Municipal Infrastructure: SSC Ultra Platform (Carpinteria Sanitary District)

In coordination with the Carpinteria Sanitary District, we architected and deployed the "SSC Ultra" platform—an enterprise-grade sewer service management system. We extend our appreciation to Craig Murray for his long-standing professional support, to Kim Garcia for her coordination on the SSC Ultra project and for authorizing this architectural overview, and to the Board of Directors for their review and unanimous approval of this deployment. Documentation regarding the deployment and functional verification of this architecture is hosted via the District at: Download Official Board Approval (04/07/26).

Technical Implementation Notes

The platform is optimized for low-latency environments using the following implementations:

// 1. MEGA-SELECT ENGINE: Dynamically builds complex SQL queries by joining APN records with occupant data.
private readonly string _megaSelect = @"SELECT ISNULL(a.APN, o.APN) AS APN, a.RecordYear, 
    a.OwnerName, o.Occupant, v.PrimaryOccupantName 
    FROM tblAPNInformation a 
    FULL OUTER JOIN tblOccupants o ON a.APN = o.APN 
    LEFT JOIN vw_ForensicAuditCentral v ON ISNULL(a.APN, o.APN) = v.APN";

*How it works:* This engine automates data retrieval by performing a full outer join between disparate tables, ensuring unified reporting even when parcel information is incomplete.

// 2. ASYNC EXPORT THREADING: Uses Parallel.ForEach to leverage multi-core processors for intensive fee calculations.
Parallel.ForEach(apnList, new ParallelOptions { MaxDegreeOfParallelism = Environment.ProcessorCount }, apn => {
    using (var threadConn = new SqlConnection(AppState.ConnectionString)) {
        decimal fee = new Ordinance17Calculator(AppState.ConnectionString).CalculateParcelFee(apn, yr, threadConn);
        this.BeginInvoke((MethodInvoker)(() => progressBar.Value = processedCount));
    }
});

*How it works:* By offloading calculations to background threads, the application prevents UI freezing during massive data export operations.

// 3. DETERMINISTIC LIFECYCLE: Ensures consistent control of the form lifecycle.
public AnnualRollOverForm() {
    this.AutoScaleMode = AutoScaleMode.Dpi;
    this.AutoSize = true;
    BuildUI(); 
    UltraTheme.Apply(this);
}

*How it works:* This forces the application to adopt specific screen scaling parameters and pre-apply visual themes before any user interaction occurs.

// 4. TRANSACTIONAL INTEGRITY: Protects database consistency.
using var tx = conn.BeginTransaction();
try {
    new SqlCommand($"DELETE FROM tblOccupants WHERE APN='{apn}' AND RecordYear={yr}", conn, tx).ExecuteNonQuery();
    tx.Commit(); 
} catch { tx.Rollback(); }

*How it works:* This wraps database operations in a transaction; if the deletion fails, the system rolls back to the prior state, preventing partial data corruption.

// 5. TYPE-SAFE SANITIZATION: Validates user input bounds.
private decimal NudVal(NumericUpDown nud, object? v) {
    if (v == null || v == DBNull.Value) return 0m;
    return Math.Max(nud.Minimum, Math.Min(Convert.ToDecimal(v), nud.Maximum));
}

*How it works:* This method clamps numeric inputs between established minimum and maximum bounds to ensure application stability.

// 6. SCHEMA REFLECTION: Dynamic UI generation[.
new SqlDataAdapter($"SELECT TOP 0 * FROM [{_tableName}]", conn).Fill(schema);
foreach (DataColumn col in schema.Columns) {
    t.DataBindings.Add("Text", _bindingSource, col.ColumnName, true);
}

*How it works:* This queries the database structure directly to build input fields, making the UI automatically adapt to any changes in the underlying table structure.

// 7. FORENSIC LATEX INJECTION: Renders mathematical formulas in UI.
LogHtml($"<div class='math-block'>$$ \\boldsymbol{\\mathcal{F}} = \\mathbf{{total:C}} $$ </div>");

*How it works:* This dynamically injects LaTeX strings into the DOM, allowing for precise, professional-grade mathematical reporting within the software.

Industrial & Enterprise Infrastructure

SCADA Support (City of Camarillo Public Works): Following a SCADA alarm event where the Win 911 server became unlicensed after contractors cut power, we were engaged to assist in operational recovery by Dirk at DTS. We appeared and diagnosed the Win911 problem helped confirure a legacy spare alarming system and computer, DDE and OPC configuration, and diagnosed a bad phone line, stealing a functional one from the 66-100 block in the utility room. Operators were glad to get their weekend back! Thanks to the lead operators for the work.

Enterprise Infrastructure (Curia Global): In the pharmaceutical sector, we worked with Shaun Foos of Curia Global and Dirk DeKreek to address technical requirements involving an autoclave contactor within a clean room environment where drugs were being manufactured. I got to wear the Star Wars suit rubber boots and mask, and did the electrical troubleshooting in a live 480V 3-phase panel. Thank you to Shaun and his crew for being accomodating and tolerating my massive physical scale!

Technical Development (V-Grid Energy): We acknowledge the support of SCS Financial —including Alex Cote, Madison Amsberry, and Elizabeth Qua— for their flawless wire coordination and advance capitalization regarding the secure preservation of V-Grid intellectual property assets. Gratitude to Tom Groos for R&D funding in the tens of millions which allowed me to spend 2.5 years acheiving breakthroughs in clean energy. We succesfully made 50-100KVA of 480 three-phase output from agricultural waste while sequestering solid carbon for industrial, ag, and medical use. I also want to thank Tom Groos for using us to do the IP audit. Further, Engineering Director Rick Becker for guidance and decades of detailed experience; one of the sharpest electrical engineers I have ever worked with, and Greg Campbell for leadership. Finally Ted Kovach for being out in the trenches with me many times; making the impossible happen in the middle of nowhere 24x7!

Epoch Carbon & Industrial Infrastructure: We were retained by Greg Campbell CEO of the new Epoch Carbon company to assist with server configuration, MRP integration, database architecture, and VM deployment. Having me be a part of your new startup was a badge of honor after the V-Grid closure.

Industrial Automation (The J.M. Smucker Co.): We executed infrastructure upgrades, focusing on industrial automation systems and instrumentation with a little data reporting work. We were invited by DTS and Jeff Cook owner of Venco Electric.

Professional Network: Thank you to Jeff Cook and Venco Electric for his support and the kind introduction to players at the Camarillo Airport. Gratitude is extended to Simon Hedley of Arcinova and colleagues within the Amgen professional network for their continued industry support on LinkedIn! My Oasis days are long over and Building 99 and that high pressure hydrogen catalysis reactor is probably long gone! Nevertheless I enjoyed working woth everyone on the custom lab software and SCADA; your onging support has been key in my securing further career opportunities.

Thirty plus years of continuous experience and support across these diverse technical domains have thoroughly prepared us for this new executive role. We look forward to applying this depth of knowledge to future critical infrastructure challenges I am about to receive!.