ClearCert

ClearCert is a web-based insurance compliance and certification management platform used by insurance agents, education providers, and hiring agencies across the United States. The system enables users to track state-specific certification requirements, manage producer profiles, and generate regulatory reports. The platform was originally built on a Microsoft .NET-based architecture, supporting complex compliance logic across multiple U.S. states.

ClearCert was operating on a legacy .NET and MSSQL monolithic architecture, fully hosted on Windows Server. Over time, the system became difficult to monitor and maintain due to limited logging, tightly coupled reporting services, and complex state-specific certification logic embedded in C#.NET services. Debugging production issues, especially within reporting and qualification workflows, was time-consuming, and infrastructure scalability was constrained. The client required improved observability, stronger validation, and infrastructure separation while preserving the existing .NET-based business logic.

Frontend (Website): jQuery-based web interface

Backend: C#.NET (core application services and reporting services)

Database: Microsoft SQL Server (MSSQL)

Infrastructure/Hosting: Windows Server (legacy hosting for frontend and backend), AWS EC2 (separate QA and Production instances for Certification & Reporting services)

Monitoring/Logging: New Relic (application & API logging), AWS CloudWatch & SNS (alerts), custom MSSQL log tables with archival and truncation strategy

We delivered a stabilization and observability upgrade for the ClearCert .NET platform, focused on enhancing logging, validation accuracy, reporting reliability, and infrastructure resilience. The solution improved transparency across C#.NET services, introduced centralized monitoring, and separated critical certification services into dedicated environments—without altering existing compliance logic.

Our engineering team enhanced the existing C#.NET codebase by introducing centralized logging using New Relic, building a reusable logging service that captured execution flow, decision branches, and state-specific logic within reporting and certification services. Detailed logs were added to key .NET methods such as GetQualificationData and multiple GetMemberQualificationData<State> functions, covering all conditional paths for states. Logging logic was corrected to prevent valid certification responses from being removed due to flawed positioning rules in the MSSQL logs table.

We strengthened validation and reporting stability within the .NET services by implementing both client-side and API-level checks for qualification dates, license expirations, and state compliance rules. Critical defects, such as recursive StackOverflow exceptions in Illinois certification logic, incorrect Wisconsin course date handling, repeated report submissions, and file access errors during PDF certificate generation, were resolved through targeted refactoring of C#.NET reporting components and permission handling on Windows Server.

From an infrastructure perspective, we introduced service-level separation by deploying the .NET Certification and Reporting Services onto dedicated AWS EC2 instances for QA and Production. Monitoring and alerting were configured using AWS CloudWatch and SNS, while historical certification logs were safely backed up and truncated to restore MSSQL performance. API request logs were migrated into New Relic for long-term analysis. These improvements significantly increased the reliability, debuggability, and operational scalability of the .NET-based ClearCert platform, while fully preserving its regulatory behavior and data integrity.