I have many years of experience working with data and was working with ‘Big Data’ before the term came into popular use. I also have extensive experience with high volume/low latency OLTP systems. I have repeatedly demonstrated the ability to create productized data processing applications that customers are happy to buy. I am currently in charge of promoting new aspects of Volt’s technology, in a role which spans Sales, Marketing and Engineering. I have four patents in the areas of distributed databases and database backups.

• Transaction processing: The design and deployment of sub-second OLTP systems that handle thousands of updates per second while providing low latencies and high availability.
• Big Data: Extensive experience designing and working with systems that handle billions of records and Terabytes of data each and every day.
• Distributed databases, specifically error correcting conflict resolution algorithms and bandwidth efficient Active-Active systems.
• World class high performance database design and performance tuning knowledge.
• Commercial application development in Java.

• Pragmatic and creative problem solver with a proven track record of resolving situations involving multiple technologies and groups of people with differing objectives.
• Can understand every aspect of a complicated problem space simultaneously.
• Expertise in leading blue sky projects that involve leading edge technology while maintaining a business perspective.
• Experience leading global specialist teams effectively and efficiently.

• LinkedIn
• PersonalWebSite
• Substack

Over time I've accumulated around 100 repos. The more interesting public ones are below.

The product now known as "MCP Db Wizard" was launched as "OrindaBuild" in 2003.

When I moved back to Ireland from America I wrote and sold a product called "OrindaBuild", subsequently renamed "JDBCWizard". I wrote it over the course of a year after moving back from the US to Ireland. It was a 100% proprietary product delivered via a Windows Installer. While it saw a reasonable degree of commerical success, it didn't take off and I moved on to other things. It looks at stored procedure definitions in an Oracle database, and writes all the Java code needed to run them. This isn't benign or simple, as Oracle's JDBC implementation allows you to pass multiple different kinds of complex objects back and forth, but the resulting API is a nightmare. Which is why I automated it. While I sold the product to some well known businesses, I eventually moved on to other things.

23 years later the industry had seen big changes. Two of them matter for our purposes:

• LLMs have resulted in the cost of writing software plummeting
• MCP means that LLMs now need to interact with legacy Oracle databases.

It turns out the the OrindaBuild code base is really, really good at this, and has already solved problems that are really hard to solve with an LLM coding assistant.

MCP DB Wizard is available as an open source docker image, with enterprise features such as auditing, logging and metrics being chargable.

The open source code base is mcpdbwizard-open

The Demo is mcpdbwizard-demo

Below are some JDBCWizard related examples.

• jdbcwizard-pub Public utility library for JDBCWizard. This code contains useful functionality for working with Oracle, JDBC and PL/SQL
• jdbcwizard-demo-code Examples of code generated for the built in demo.

At Volt Active Data I am the authority on how to use the product in the real world. This involves writing large quantities of Volt centric code.

This is publicly available code that's used for demos and frequently benchmarks.

• voltdb-charglt Charging Demo: A non-trivial telco focused Volt Active Data example
• voltdb-xdcrchargingdemo Version of charging demo that has changes needed to work in an XDCR universe.
• voltdb-tatpbenchmark An VoltDB implementation of "Telecom Application Transaction Processing" benchmark
• volt-tpcc-sandbox TPCC implementation.
• voltdb-subway Sandbox based on real Transport For London data set
• voltdb-javacache-sandbox A sandbox application for a VoltDB JSR107 implemtation.
• voltdb-simbox-with-rules Simbox demo with DML driven rule engine
• voltdb-simbox Simbox detection sandbox
• voltdb-policysandbox A Sandbox Policy Implementation for VoltDB
• voltdb-cvmsandbox Customer Value Management Sandbox
• voltdb-aggdemo A demonstration of how VoltDB can be used for the kind of streaming aggregation tasks common in Telco
• volt-aggdemo-voltsp Demo of Volt's new stateless processing functionality
• voltdb-iotcars A voltDB IOT sandbox for matching electric cars with chargers and using a prepaid phone to pay

"XDCR" stands for "Cross Data Center Replication", also known as "Active-Active"

• voltdb-xdcr-aware-client Client that can switch XDCR clusters if needed.
• voltdb-xdcrchargingdemo Version of charging demo that has changes needed to work in an XDCR universe.

• voltdb-h2o-mojo-demo A demonstration of how to use H2O's MOJOs in VoltDB
• voltdb-task-and-migrate-demo A demo of Volt's scheduled tasks and MIGRATE functionality.
• voltdb-rules A prototype rules engine.
• voltdb-nwaysettlement N Way Settlement with compound procs example
• volt-flightcache A example of how to use Volt compound procedures for rapid lookup of flight data
• volt-timeseries Prototype time series data handling
• volt-simple-kafka A simple Kafka demo for Volt Active Data
• volt-vlmc2 Example code for tracking interbank exposure.
• volt-vlmc Example code for tracking interbank exposure.
• voltdb-deleteallrowsExample of how to delete all rows
• volt-secure-tokens Simple demo to show how volt can be used to provide secure tokens
• voltdb-clite A simplistic sandbox charging demo.
• binarydiff This repository contains FastAndRuthlessDiffImpl, which is used to reduce network bandwidth when working with byte[] objects that are being changed slightly by a client before being sent back to a server.
• smartdenserank A Dense Rank leaderboard example.
• volt-activeSD101 Tutorials for moving Kafka workloads to Volt Active Data

• voltseconvert VoltSeConvert is used to do a crude, once-off conversion from Oracle or TimesTen to VoltDB
• voltseconvertoracleexample An example of VoltSeConvert in use
• voltdb-autojar Builds and loads a JAR file for procedure classes with the "@IsAVoltDBProcedure" annotation.
• voltdb-schemabuilder Utility to create and load procedure JAR files
• VoltSeUtils Core utility classes for VoltDB SE

Volt is an in memory DB. Usually not a problem, but if it is I implemented a prototype LRU cache framework.

• lrucache_client
• lrucache_client_cassandra
• lrucache_client_oracle
• lrucache_client_postgres
• lrucache_sdk
• lrucache_server

TMForum is a telco industry body that defines standard APIs for the many different API calls used in the mobile phone network. I have written code that takes the public API definitions and generates stub Volt code to support them. This code is in a private repo, but examples of generated code for TMF654 - Prepay Balance Management are in the public repos below.

• TMF654-PrepayBalance-v4.0.0-client
• TMF654-PrepayBalance-v4.0.0-server
• TMF654-PrepayBalance-v4.0.0-volt

• volt-run-ycsb Runs a YCSB benchmark on Volt, assuming AWS

• addToDeploymentDotXml
• binarydiff

As a side project I have implemented the charging benchmark for REDIS, SingleStore and MongoDB. Note that none of these have been tested at scale, as each one would run up an AWS bill to properly test.

• voltdb-charglt Charging Demo: A non-trivial telco focused Volt Active Data example
• s2-charglt SingleStore implemention of charglt
• redis-charglt REDIS implementation of ChargLT
• mongodb-charglt Mongo implementation of Charglt
• postgres-charglt Postgres implementation of Charglt

I got fed up with the lack of a countdown timer on my Bosch dishwasher, so I implemented one using a Raspberry Pi and an ePaper display

• bosch-dishwasher-control An example of reading MQTT data from a bosch dishwasher and updating an ePaper sign.
• hcpy-hacked - A not very good tweak of HCPY. First up against the wall when the refactoring comes...

• CrateDB Explore - A repo supporting CrateDB's scenarios for web site users who want to try the product.
• Linksys Velop Watcher - An application to extract as much data as possible out of my misbehaving Linksys Velop mesh network.

• filewrangling-utils Utility classes for fixing flat files