Aranscia
Five acquired healthcare products, nine programming languages, one gRPC data access layer, all migrating onto Azure under HIPAA, HITECH, HITRUST and SOC 2 without a big-bang cutover.
24 engagements · 8 sectors · 1997 to now
Filter by platform, stack or decade. Each entry is what was wrong, what got built, and what happened once it shipped.
Five acquired healthcare products, nine programming languages, one gRPC data access layer, all migrating onto Azure under HIPAA, HITECH, HITRUST and SOC 2 without a big-bang cutover.
SQL Server 7 backups restored into Azure SQL, a Classic ASP app rebuilt in Blazor, and the Visual FoxPro book tools pointed at the new database until their replacements shipped.
Thirteen years as the only developer on one firm's system: LotusScript inside their Notes estate, then Silverlight, then LightSwitch, then Esri ArcGIS cloud sites over SQL Server, each rebuild done while the previous one stayed live.
ASP.NET Core over OData into a Delphi/InterBase back office: self-service ordering, Stripe payments with per-state fee rules, single sign-on, and a thirty-project .NET estate pulled into one solution.
Forty hand-edited flat files replaced with direct Bloomberg BLPAPI calls, futures screens with automatic rollover, and a years-old 'mouse flicker' bug traced to unreleased pointers in the vendor's .NET wrapper.
SQL Server replication repaired, a row-losing data warehouse fixed, and an Access front end replaced with a LightSwitch client over a web-service layer, with Twilio SMS and record locking.
Visio and PDF treatment pathways turned into a data-driven subscription site: merge patient details into the pathway and letter, charge per print via Authorize.Net, stamp every print with a serial number encoding account, user, pathway and print run.
A Delphi rules engine, a dot-notation tree walk generating manufacturing travellers dynamically, prototyped in three days and in a working product in six months, still sold and maintained twenty-five years on.
Delphi, IDC and Classic ASP, barcode capture on every shelf section, one of the first RFID tracking systems, and a PLC integration with the press, still running after a Windows 95 to Windows 10 recompile.
A catalogue dump reconciled field by field against the rights database, core queries from thirty seconds to under one, and an Azure Web Jobs ticketing and cashless-payment back end designed from sequence diagrams instead of contradictory mock-ups.
A Silverlight front end over WCF brokering requests to a pool of VMs each running a headless copy of the WPF sizing program, with a watchdog, an admin router, and generic external logins mapped to companies only on the inside.
Match-3 real-money gaming: a Cocos2d and WebGL client kept dumb, the rules, RNG, pay tables and wallet server-side, a wire protocol for board state and cascades, and a simulation harness for the certification lab.
Moxa serial-to-IP converters on every checkweigher, virtual COM ports into a logger, every reading into SQL Server, a live control chart for the line, and a counting function inside the Siemens WinCC program.
ASP.NET MVC member site, a clearing back end on Azure SQL with balances held per retailer, retailer reporting, and Ingenico PIN pad SDK integration at the till, all built from a functional spec I wrote to plug the holes in the client's.
A residuals engine rewritten from scratch: quarterly revenue per market in, union contract break points and percentages applied, pension and health subtracted, one statement per union out, with back-fill and late-joiner adjustments.
Silverlight and XAML subtitle authoring with waveform sync and safe-area overlays, plus a command-line encoder over the Expression Encoder SDK and a job manager for the GPU farm, with error trapping the original never had.
Around ten WinForms apps on click-once over WCF services and SQL Server, a logged chat system, ASP.NET reporting for a poker site, and a gambling-floor system converting every figure at the day's exchange rate.
Power Apps, Power Automate and Power BI inside bp from 2021, then a six-month direct appointment in Trading & Shipping against a defined set of data requirements.
C# WinForms reading a Solartron Orbit probe over USB, a gauge-block lookup in SQL Server Express, iButton operator identification, and a fixture drawn to true proportions from the client's engineering drawings as the operator types.
WPF field capture with a signature step, a Silverlight approval module, a self-mailing five-day report, duplicate-date and pay-period rules in T-SQL, and a web-service layer ripped out when it would not hold up over the VPN.
iOS, Android and Windows clients over a C# and Azure back end, with cell-number registration, authorisation codes, invitations, and delivery over text and email, all written by one developer.
A Silverlight and C# application for the network's advertising operation, managing and scheduling the spots that go to air.
C# and .NET on one side, PHP and WordPress on the other, and the integration between them.
Classic ASP and streaming audio when both were new: CTO for John Tesh's first web presence, now tesh.com, and a streaming radio station for Priscilla Presley with a scripted, animated DJ.