Colin Douglas / Software Engineer

Colin Douglas — Software Engineer · Ecommerce · Dot Foods

▸ Top result for “colin douglas” in Ecommerce › Engineering

Colin
Douglas

Software Engineer Ecommerce Dot Foods

I turn complex problems + ambitious ideas → measurable business value.

12+ years across application development, databases & infrastructure. I started as a database administrator and moved into software engineering — so I build from the database up.

▸ The work

02AI MatchingMy role · Ideated & solutioned

What if we don't carry it?

When a customer searches a product code that isn't in the Dot catalog, AI reads the code and works out a category and a search term. Instead of a dead end, the customer sees similar products from the Dot catalog. It supports a major Dot Foods ecommerce initiative to reduce no-result searches.

Product-code searches
11.6% lower no-result rate
First 21 weeks vs the prior 21 weeks · external visitors searching 11-, 12- and 14-digit codes.
Estimated value
$349,290/yr† net-margin opportunity
03ReliabilityMy role · Diagnosed & fixed

Mornings, fixed.

Reduced all server-side errors on public production by 94.5%, and fixed the recurring morning connection timeouts.

Server-side errors
−94.5% all 5xx responses
On public Production hosts, 30 days before the fix vs the latest full 30 days: 59,133 → 3,253.
Recurring morning outages
06:00 ✓ fixed with automated SQL Server maintenance
04PerformanceMy role · Led & implemented

80+ hours → ~8.

The importer that builds the full catalog XML for the ecommerce site now loads the same full catalog in a tenth of the time, through concurrency, parallel processing and SQL optimization. I also found telemetry overhead that was triggering unnecessary Azure Function scale-outs.

Full catalog load
~8 hrs down from 80+ (−90%)
Azure Functions
~3× throughput · 0 extra scale-outs
~$1,400/mo in Azure costs avoided
05SuperChargeMy role · Co-created, implemented & led

Ticket in.
PR out.

An AI software-development orchestration product. A Jira ticket moves through AI agents and comes out as a pull request ready for human review, with a human in the loop at every step.

  1. Jira ticket
  2. AI agents product owner · business analyst · architecture · developer · security · QA
  3. Pull request
  1. It started as an idea
  2. It became a major Dot Foods IT initiative
  3. Today adopted by a Dot Foods team, with its own roadmap & support

▸ Also shipped

+Cloud costsMy role · Implemented

Two plans → one.

Migrated a Function App onto an App Service plan we were already paying for, one that already ran a few of our functions, then retired the plan it left empty. Same functions, one less plan on the bill.

The Function App migrates over · plan B retired
App Service plans
2 → 1 same functions, one plan retired
Azure spend removed
~$11K/yr† estimated
Separate from the Performance chapter's Azure estimate; not additive.

▸ At a glance

Engineer Facts

1 serving per career

Serving size1 engineer

Amount per serving

Experience12+ yrs

SQL Server databases managed1,000+

AI Matching$349,290/yr†

Product-code no-result rate−11.6%

Fuzzy Search$53,763/yr†

No-result searches−183,563

Azure costs avoided (est.)~$1,400/mo

Importer throughput~3×

App Service plan retired~$11K/yr†

Plans for the same functions2 → 1

Server-side errors−94.5%

Catalog load time−90%

SuperChargeIdea → adopted product

Contains: C#/.NET, SQL Server, Azure, Vue.js, GraphQL, PowerShell, AI agent orchestration.

† Estimated annual value

1 result

Illustrated portrait of Colin Douglas
Best match

Colin Douglas

Software Engineer

Let's connect →

Complex problems → measurable value.