Built EDI ingestion pipelines: Designed and developed an 837 and 835 file parsing engine to power initial data ingestion for coding audits. This automated the extraction of encounter, claim, and payment data, enabling auditors to quickly initiate reviews with clean, structured inputs.

Optimized and modernized backend SQL logic: Refactored complex SQL functions, views, and queries to be DRY, reusable, and highly performant—improving load times and reducing redundant logic across the platform.

Modernized authentication and authorization: Migrated the application’s authentication model from legacy user/password tables to Microsoft Entra External ID, strengthening security, enabling SSO, and aligning with enterprise identity standards.

Implemented a saved search feature allowing auditors to quickly reload frequently used patient search filters.

Built a templating system for generating coding audit communication forms, improving consistency and reducing manual work.

Added a pseudo-Elasticsearch mechanism for large structured datasets (e.g., diagnosis code dropdowns), significantly improving lookup speed and user experience.

Modernized authentication architecture: Migrated the system from a legacy username/password model to the enterprise-wide Microsoft Entra External ID setup shared with RAFVue—strengthening security, simplifying onboarding, and unifying identity management across applications.

Performed a full security review and refactor: Conducted an in-depth audit of the codebase (originally implementation-heavy with minimal structure), refactored core components, and resolved major security issues. This included overhauling backend authorization rules to ensure strict tenant scoping and preventing cross-client data exposure.

Delivered collaboration-enhancing features: Built a robust commenting system with @mentions, enabling users to tag colleagues and trigger relevant notifications during the rebuttal workflow.

Added personalized notification capabilities: Implemented user-configurable email alerts for key system events—helping supervisors and reviewers stay informed without manual monitoring.

Integrated external data systems: Connected Sureclaim with Quickbase to seamlessly pull client profiles, project metadata, and rebuttal details, ensuring consistent, up-to-date information across systems.

Automated a formerly manual file-loading process - Designed and built the full upload portal, allowing users from HR, Finance, and other departments to submit files directly. The system automatically identifies data types and routes them to the correct Azure storage container for downstream ADF processing.

Implemented authentication with the existing domain tenant - Leveraged Microsoft Entra ID for authentication, ensuring all users log in through existing organizational credentials with no additional account management overhead.

Added granular authorization controls - Built role- and group-based authorization rules to ensure only permitted users could upload specific file types—strengthening security and reducing accidental misuse.

Introduced staged upload workflow - Implemented guardrails so that certain files (e.g., HR uploads) must be submitted before subsequent departments (e.g., Finance) can upload theirs, ensuring data pipelines run in the correct order.

Provided real-time ingestion status - Built dynamic upload and processing indicators that reflect the current ADF pipeline status, giving users visibility into the ingestion process without needing engineering support.

User enablement & training - Delivered hands-on training sessions for HR, Finance, and operational teams, ensuring smooth adoption and empowering users to independently manage their own uploads.

Format all resume data in a structured manner consistent with JSON Resume schema

Provide direct links to it from my personal portfolio website

Seamlessly integrate the JSON data into a fully autonomous system, allowing changes to tracked in source control, processed by a CI/CD pipeline, deployed to all necessary backend systems.

Craft the content with the assistance of AI technology (ChatGPT) to enhance clarity and impact.

The primary goal of the application was to act as an additional communication tool between end users and administrative staff to ensure acknowledgement of announcements.

The tool allowed administrators or operational leaders to present users with relevant information in PDF format, and then track each users' receipt.

Enable the means to securely send Crystal Reports without exposing credentials by either processing by delegation or through encrypted credentials.

Configure report delivery details by report through a human readable XML Schema.

Enable built in error log review, or emitting to notification systems.

Use a predefined wordlist, randomly select a valid and guessable puzzle for the user to solve.

Provide hints to the user after each guess based on character location and correctness.

Celebrate a successful puzzle solution.

Facilitated the conversion from a paper tracked process to a fully electronic system.

Systematically ingested legacy paper forms using OCR and image scanning to migrate into the electronic system.

Enabled revision tracking for individual business form changes with a managed approval system.

Embedded form functionality in the enterprise medical health record system allowing for automating payment adjustments and restricting services to allowables in the B2B agreement.