A .NET solution: console app downloads/parses/upserts OFAC SDN data into SQL Server (MediatR, Serilog, caching), plus a Web API with paged endpoints and fuzzy name search — SQL full-text retrieval re-ranked via n-gram cosine similarity, backed by FusionCache, behind a PR-only branch-protected workflow.
-
Updated
Sep 4, 2026 - C#