Annel Venter

I build the systems behind insurance claims, and make them agree with each other.

Lead systems developer in South Africa. I work across claims and assistance platforms, the integrations that feed them, and the reporting people make decisions from.

Most of my job is finding where the same thing lives in five places, and turning it into one.

Five separate lines converging into a single line
One supplier, recorded in five systems with one proven link between them. That's the kind of problem I like.

Selected work

Platform architecture

A single source of truth across claims systems

Designing a core platform that sits above two established claims systems and gives them shared master records: one record per supplier, one claim spine for cases that move between systems, one identity per person, and one definition of every scheme and product.

SQL Server, cross-database modelling, data reconciliation

Customer integration

Claim intake over WhatsApp

A multi-screen WhatsApp Flow that takes a policyholder from first notice of loss to a complete claim: peril, incident details, damage, address lookup and a summary to confirm. Backed by an encrypted data-exchange endpoint and a webhook that lands submissions straight into the claims system.

WhatsApp Business API, C# / ASP.NET Core, PHP, Google Places

Reporting

Supplier performance across two systems

A reporting set covering volume and spend, turnaround against SLA, quality and rejections, and panel compliance, built on a verified crosswalk between two supplier masters. Validating against live data caught a satisfaction score that was understated by more than twenty points.

T-SQL, Power BI

Learning platform

A training and compliance academy

Took a learning-management web app from prototype to production on Windows servers, with a repeatable deploy script, and designed the academy's sub-brand identity from the parent brand.

React, Vite, PHP API, SQL Server, IIS, PowerShell

Infrastructure

Web server migration

Moved a production IIS server hosting thirteen application pools, resolving certificates, missing server modules and per-site permissions along the way, and scripted the permissions so the next migration is one command.

IIS, ARR, PowerShell

How I work

Check the live database

Schema dumps and documentation drift. Before I conclude a column doesn't exist or a join is right, I test it against the real data.

A zero isn't always a score

Half of good reporting is knowing what a value means. "Not rated" stored as 0 will quietly wreck an average if nobody asks.

Leave it repeatable

If I had to fix it by hand once, the next person gets a script, a skill file, or a query they can run without me.

What I work with

Data
SQL Server and T-SQL in depth: multi-database queries, stored procedures, table-valued functions, performance tuning.
Reporting
Power BI and Power Query, operational and SLA reporting, bordereaux extracts.
Backend
C# and .NET, PHP, REST APIs and webhooks.
Frontend
React with Vite, HTML and CSS.
Infrastructure
Windows Server and IIS, Azure DevOps, PowerShell.
Tools
PhpStorm, Navicat, Bruno, Claude Code.

Off the clock

Snake catching

When a snake turns up in a garage, a garden or a pool pump, I catch it and move it somewhere it can get on with its life.

Most of the job is calm handling and keeping people at a safe distance. The rest is explaining that the snake wants to be there even less than they want it there.

Gaming

I play, and lately I build. My latest is a co-op 3D game about raking up every leaf on a property, in a single HTML file, with a small LAN server so a few people on the same network can play together.

It turns out game physics and claims data have something in common: both look fine until someone pokes at the edge cases.

Have a system that won't agree with itself?