Solution Architect / .NET Developer
Region SkåneRS eArkiv
Long-term technical contributor and de facto solution architect in a restricted, offline environment with end-to-end responsibility for archiving sensitive data, primarily medical records, from decommissioned systems. Owned the full lifecycle from needs analysis through implementation to operational handover, collaborating with archivists and healthcare experts to scope preservation needs, assess risk, and design the technical specifications within the region's governance and decision processes. Classified data sensitivity per GDPR and patient-data regulatory requirements to determine access restrictions, retention, and preservation handling for each archived system.
Led the region's two largest archival projects (Melior for open care, Orbit for surgical data), each spanning 1 to 1.5 years and processing multi-terabyte databases. Reverse-engineered data models from undocumented databases through stored procedure tracing and semantic analysis.
Sole developer of the eArkiv AdminInterface, a three-tier ASP.NET MVC 5 application (DDD) used by ~30 archivists. Built its access control from scratch on IIS Windows Integrated Authentication, validating each user's RSID against a DB allow-list and injecting a role-based security principal. Upgraded the app from .NET Framework 4.5.2 to 4.8.1 and jQuery 1.x to 3.x, and cut SQL that previously ran 1-2h down to seconds.
Developed multi-threaded BLOB extraction, streaming XML parsers, and high-performance SQL with batching, strategic indexing, and staging tables, including the stored procedures that measured storage consumption across the ~5 TB production database to distribute operating costs per care unit. Maintained a GDPR-relevant Web API for personnummer correction, and contributed to HL7 FHIR and SIARD preservation standards.
- C#
- .NET Framework 4.5-4.8.1
- .NET Core 3.1-10
- SQL Server
- T-SQL
- Stored Procedures
- ASP.NET MVC
- XML/XSD/XSLT
- JSON
- SIARD
- HL7 FHIR
- MySQL/MariaDB
- PostgreSQL
- DDD
- Git