Case study · HR & Workforce

Rebuilt on .NET Core, on the database it already had

A US screening firm’s portal took four to five minutes to load its records. We rebuilt it on ASP.NET Core, kept each vendor integration on its own release line, and the same load now takes under 15 seconds.

  • ClientA US screening firm, through Best Database Solutions
  • SystemPre-employment screening
  • Delivered2021 to 2023, in production
  • StackASP.NET Core · SQL Server
The outcome

Four to five minutes became under 15 seconds

Loading all the records, as the client measured it, on a platform that now runs the whole operation.

  • 4 to 5 min → 15 s

    Loading all the records
  • ~60,000

    Applicant screenings a year (2021)
  • 1,400+

    Employer accounts (2021)
  • 46

    Production releases
At a glance

Project snapshot

Client
A US background screening and hiring-services firm
Partner
Best Database Solutions
Domain
HR & Workforce
Engagement
Modernization
Build
ASP.NET Core MVC on .NET 5 and .NET 6
Integrations
Drug-test network API, laboratory SOAP service
The story

What we rebuilt, and what we kept

Context

Aditi IT Software Solutions rebuilt and ran the screening platform of a US background screening and hiring-services firm from 2021, working through its software partner, Best Database Solutions. For decades the firm has served employers with background checks, criminal history searches, drug testing and applicant tracking, for clients from car dealerships to healthcare and manufacturing.

When Aditi started, the work ran on two parts sharing one SQL Server database: an older customer-facing web portal built on .NET Framework, and the firm’s internal Access application. The results that drug-testing and laboratory networks sent back were chased separately from the applicant’s record.

Constraint

Three things could not be negotiated. Drug-test and laboratory results come from two outside networks, each with its own interface, and neither changes for one customer. Applicant consent is a generated document with a California version and a version for the other forty-nine states. And the service was live: Aditi took over the customer’s code base of June 2020 after knowledge-transfer sessions in July and August 2021, so every change shipped into a running operation.

Decision

Aditi’s first deliverable was not code. A technical-debt assessment and a .NET portability analysis made the case to rebuild on ASP.NET Core and Azure rather than keep patching the .NET Framework portal. The rejected path was the cheaper one in the short term, and the one that would have kept every later change slow and risky. The rebuild kept the customer’s database and its data structure, because the firm’s internal Access application works on the same database and was never replaced: the classic .NET application served as the reference, the new one added features and performance, and the database changed only where a new feature needed it.

The second decision followed from the constraint. The drug-test and laboratory integrations were built as separate services outside the web application, so a change on one vendor’s side ships without releasing the whole platform; the laboratory service has its own release line, versions 1.0 to 1.6 in 2022.

Build

Four areas with their own sign-in and layout: employers order screenings and follow them; applicants complete their forms and consent online, with saved and completed states; the firm’s staff administer the work; auditors read the reports.

One record per applicant: every vendor result lands in it, and each employer sees its applicants in one list, filtered by name, account, pending status and date range.

Two vendor integrations: an API that receives drug-screen results and documents from the testing network, and a SOAP service that receives laboratory results.

State-specific consent documents generated for each order; card payments through Authorize.Net; a mailbox read through Exchange Web Services.

Stack: ASP.NET Core MVC on .NET 5 and .NET 6 for the new platform, .NET Framework 4.8 and 4.5.2 where older integration code lives, Entity Framework Core and Entity Framework 6, SQL Server with about 600 change scripts, Serilog, OpenAPI. 21 .NET projects, 5 of them web applications.

Hosting: Azure web servers behind a load balancer, with a written runbook for adding a second server. Tested on Android, iOS and across browsers (February 2022).

Stack

What it is built on

  • ASP.NET Core MVC
  • .NET 6
  • .NET Framework 4.8
  • Entity Framework Core
  • SQL Server
  • WCF
  • Serilog
  • Azure
The result

What changed

Release 1.0 went to production on 29-Oct-2021, and the platform was released 46 times up to version 4.9 on 06-Jul-2023. Paging was the old portal’s worst problem: loading all the records took four to five minutes. On the new platform the same load takes under 15 seconds, as the client measured it. The old portal is retired. The new platform is still in production today, maintained by the client’s own developers since Aditi’s team built it.

The firm runs about 60,000 applicant screenings a year for more than 1,400 employer accounts (2021), all of them now on the new platform.

Proof

In the client’s words

All members of the Aditi IT Software Solutions team have always made themselves available during the U.S. times zones for meetings, support and implementation wherever needed. The developers have worked long hours during the U.S. business day to ensure that any issues are solved on a timely basis. I would highly recommend Aditi IT Software Solutions to any prospective client.
Alison Balter President, Best Database Solutions
65+ systems delivered since 2011

Named where the client has given written permission, described by sector where they have not.

See the full delivery record