Technical Contacts:

Edmundo Guzman-Meza, Denise Tabilas

Description:

This project focuses on developing a secure, enterprise-grade web application to streamline the management of medical claim workflows for Leidos QTC Health Services. Currently, QTC administrators rely on manual SQL scripting to configure complex workflows, which poses risks to data integrity and operational efficiency. Our team is building a robust, standalone ASP.NET Core MVC application that serves as a graphical interface for the existing Workflow Queue (WFQ) system. By leveraging Entity Framework Core for direct database transactions and strictly adhering to Microsoft enterprise standards, this solution will allow administrators to dynamically configure workflows, reassign tasks, and audit system changes. The project emphasizes strict adherence to HIPAA/HITECH compliance, role-based access control, and data integrity within a high-volume medical processing environment.

Objective:
Fall 2025:

- To analyze the existing legacy SQL Server database schema and design a monolithic architecture that interfaces with it securely without modifying the underlying structure. We focused on requirements consolidation, environment configuration (IIS, SQL Server 2022), and the development of the core Data Access Layer using Entity Framework Core. Key achievements include the creation of the Software Design Document (SDD) and the implementation of the primary Workflow Dashboard UI.

Spring 2026:

- To finalize the implementation of critical administrative features, including dynamic step configuration, task reassignment, and "safe delete" logic with dependency checking. We will focus on rigorous integration testing to ensure data consistency, polish the user interface for Section 508 accessibility compliance, and deliver a production-ready deployment package to Leidos QTC.