JHSCPortal

Overview

JHSCPortal is an internal web application built for the organization's Joint Health and Safety Committee. It centralizes reporting, authentication, and document workflows that were previously handled through manual processes or disconnected tools.

What I Built

• Designed and implemented the full application architecture from scratch, including database schema, authentication flow, and deployment pipeline
• Built a multi-role authentication system backed by Azure AD
• Integrated SQL Reporting Services (SSRS) for generating and exporting structured reports
• Implemented an LLM-based PII redaction pipeline for sensitive report content, using GPT-3.5 after evaluating multiple models for cost and accuracy

The PII Redaction System

The redaction feature was the most technically interesting part of this project. The organization needed to redact personally identifiable information from reports before sharing externally. Commercial solutions were evaluated but ranged from $30,000–$80,000/year.

Instead, I built a custom pipeline that:

1. Extracts text from reports
2. Sends chunks to GPT-3.5 with a structured prompt for entity detection
3. Applies redactions to the original document
4. Returns a clean, auditable output

After benchmarking against the commercial tools, the custom solution matched accuracy at a fraction of the cost — saving over $10,000 in the first year alone.

Impact

• Replaced manual processes across the department
• Saved $10,000+ compared to commercial PII redaction alternatives
• Used daily by internal staff for compliance reporting