Skip to main content
Codentures logo
Codentures
Discuss your project

Operations case study

Real-time operational intelligence API and data portal

A real-time operational intelligence API and data portal, with deep query and index optimisation on an existing SQL Server estate.

Client
A high-volume operations business
Industry
Operations
Engagement
Software delivery

The challenge

What the client needed

The people running the operation needed live data with sub-second response times, but the queries behind it were complex and the SQL Server estate was already under load.

How we delivered it

  1. Query plans, index usage and wait statistics measured before anything changed
  2. Targeted query rewrites and index changes on the existing estate
  3. An ASP.NET Core API exposing operational data to a live portal
  4. Automated delivery through Azure DevOps

Results

  • 4x query performance gain
  • Live operational data portal
  • No platform replacement required

Technology

  • ASP.NET Core
  • SQL Server
  • LINQ
  • Azure DevOps
  • IIS

Services involved

More client work

Related case studies

See all client work

  • E-commerceEU

    Multi-vendor marketplace with automated payouts

    A European retail group

    A multi-vendor marketplace on Stripe Connect with automated seller payouts, payout reconciliation and real-time inventory sync.

    • 40+ active vendors
    • Automated payout reconciliation
  • Enterprise identity

    Zero-downtime legacy authentication migration

    An enterprise with 3,000 users

    Legacy authentication migrated to modern identity with SAML SSO across six integrations, run as a phased cutover with zero downtime.

    • 3,000 users migrated
    • Zero minutes of downtime
  • FintechUS

    Peer-to-peer currency exchange platform

    A US fintech company

    A secure peer-to-peer currency exchange platform with regulated fund transfers, a KYC-compliant document workflow and a full Azure delivery pipeline.

    • Two financial-provider integrations
    • KYC-compliant document workflow

Facing a similar challenge?

A system to build or modernise, or engineers to strengthen your team. The first conversation is with a senior engineer, and you will leave it with a clear recommendation.

Discuss a similar project