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 matching finds the closest Dot item instead of returning nothing. 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 74.3%, and fixed the recurring morning connection timeouts.

Server-side errors
−74.3% all 5xx responses
Per 1M requests on public Production hosts: 5,531 before → 1,424 after.
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

▸ 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×

Server-side errors−74.3%

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.