Overview

Built an enterprise-grade reporting portal delivering real-time claims analytics through seamless Tableau integration and modern micro frontend architecture. The solution enables healthcare organizations to make data-driven decisions with live operational metrics.

Client Profile

• Industry: Healthcare Technology / Pharmacy Benefit Administration
• Region: North America

1. 1. HQ: Midwest, USA (Ohio)
   2. Operations: Nationwide

• Company Size: Mid-Sized Enterprise (Est. 150–200 employees)

What They Do:

• Core Business:
  

  An independent provider of pharmacy data processing and administrative services. They build backend technology that allows Health Plans, Hospital Systems, and Hospice organizations to manage their own prescription drug programs.
  
  

• Key Services:

1. 1. Claims Processing: Handling high-volume pharmacy transaction data.
   2. 340B Administration: Managing federal drug pricing compliance for hospitals and clinics.
   3. Data Transparency: Unlike traditional competitors, they utilize a “pass-through” model, granting their clients full ownership and 24/7 access to their own operational data.

• Client Base:
  

  They serve private-label Pharmacy Benefit Managers (PBMs), commercial health plans, and vertically integrated hospital systems.

Features

This project delivered an enterprise-grade, real-time claims analytics portal for a healthcare/insurance technology organization — transforming how teams access, visualize, and act on operational insights.

Core Capabilities:

• Unified Dashboard Experience: Single pane of glass replacing 5+ legacy reporting systems.
• Real-Time Metrics (Sub-Minute Latency): Live updates on claims processing volumes, adjudication rates, pending claims, payment status, and exceptions.
• Seamless Tableau Integration: Embedded Tableau dashboards with full interactivity, filtering, and authentication.
• Role-Based Access Control (RBAC): Custom views for operations, finance, compliance, and provider management teams.
• Micro Frontend Architecture: Independent deployment of analytics modules (e.g., Adjudication Monitor, Payment Tracker).
• Custom Filtering & Parameter Passing: Dynamic data sync between React UI and Tableau via URL parameters and JavaScript API.
• Responsive UX: Fully mobile-optimized interface for desktop and tablet access.
• Export & Share Functionality: Export reports to PDF, CSV, or share embed links securely.

 Outcome:

• Decision velocity improved from days → minutes
• 3x increase in dashboard adoption across teams
• Eliminated context-switching across fragmented systems
• Identified bottlenecks saving ~200 hours/month in manual reporting

Technologies

A modern, scalable stack combining advanced frontend architecture with deep BI integration.

Bonus Tools Used: Terraform (IaC), Redis (caching), S3 (report storage), OpenTelemetry (tracing)

Security Model

Built with HIPAA-aligned controls to protect sensitive healthcare data.

Key Security Controls:

• Private Network Access: Portal hosted behind VPC; no public exposure.
• JWT-Based Authentication: Secure session management with short-lived tokens.
• Least Privilege Access: RBAC enforced at both frontend and backend layers.
• Secure Embedding: Tableau dashboards embedded using signed URLs and token-based authentication.
• Audit Logging: All user actions logged (view, export, filter) for compliance.
• Data Minimization: Only necessary metrics exposed; PHI excluded from visualizations.
• Encryption:

1. 1. In transit: TLS 1.3 enforced at all endpoints.
   2. At rest: Data encrypted in databases and storage (S3/KMS).

Compliance Alignment: HIPAA (with BAA), SOC 2 Type II, NIST SP 800-53

Data Types & Standards

Handles regulated healthcare data under strict standards.

Data Types Handled:

• Claims Processing Metrics: Volume, time-to-adjudicate, success/failure rates.
• Payment Statuses: Paid, pending, denied, rejected.
• Provider & Member Analytics: Top pharmacies, prescribers, high-risk claims.
• Exception Tracking: Failed claims, system errors, validation failures.
• Operational KPIs: SLAs, backlog trends, throughput per region/team.

Regulatory & Industry Standards:

Note: All PII/PHI masked or excluded from dashboards and logs.

Infrastructure Architecture

Designed for scalability, performance, reusability, and enterprise readiness.

Deployment Topology:

• Region: us-east-1 (multi-AZ)
• Environment Strategy: dev → staging → production (separate EKS clusters or namespaces)
• Scaling: Auto-scaled via Kubernetes or ALB-based load balancing
• Network: Private subnets, VPC endpoints, security groups

Data Flow:

[Claims Processing Pipeline (Kafka/SQS)]    ↓[Real-Time Data Sync Service (Node.js)]    ↓[REST API Middleware → Cache (Redis)]    ↓[React Host App (Module Federation)]    ↓[Micro Frontend Modules: Adjudication, Payments, Exceptions]    ↓[Embedded Tableau Dashboards (via Embedded API)]    ↓[User Interface: Responsive, Filtered, Interactive]

Key Architectural Patterns:

• Module Federation (Webpack):

1. 1. Each analytics module is a standalone React app.
   2. Bundles loaded dynamically at runtime by the host shell.
   3. Enables independent CI/CD pipelines per module.

• Shared Component Library:

1. 1. Reusable UI components (buttons, cards, modals) with consistent design system.
   2. Versioned and published via npm.

• Event-Driven Updates:

1. 1. Kafka events trigger real-time refreshes in Tableau and React widgets.
   2. WebSocket or polling fallback if needed.

• Parameter Passing:

1. 1. Filters (e.g., date range, plan ID) passed via URL hash or postMessage.
   2. Tableau receives dynamic parameters via tableau.embed() API.

• Containerization:

1. 1. All modules packaged as Docker images for consistent deployment.

The Challenge

Healthcare organizations struggle with:

• Fragmented reporting systems across multiple departments
• Delayed access to critical claims metrics
• Poor user experience in legacy BI tools
• Difficulty scaling analytics across different teams
• Need for real-time operational insights

Technical Solution

Architecture Highlights

• Micro Frontend Framework

  1. React-based Module Federation architecture
  2. Independent deployment of analytics modules
  3. Shared component library for consistency
  4. Runtime integration with host application
     
     

• Tableau Integration Layer

  1. Embedded Tableau dashboards with seamless authentication
  2. Real-time data refresh from claims processing pipeline
  3. Custom filtering and parameter passing between React and Tableau
  4. Responsive embedding for mobile and desktop experiences
     
     

• Key Technical Components

  1. React 18+ with TypeScript
  2. Webpack Module Federation for micro frontend orchestration
  3. Tableau Embedded API v3
  4. JWT-based authentication flow
  5. RESTful API middleware for data synchronization
     
     

• Real-Time Data Pipeline

  1. Streaming claims data from processing systems
  2. Sub-minute latency for critical metrics
  3. Event-driven architecture for data updates
  4. Scalable backend supporting concurrent users

Key Features Delivered

• Unified Analytics Dashboard

  1. Single pane of glass for claims operations
  2. Role-based access to different metric views
  3. Customizable KPI widgets
  4. Export capabilities for reporting
     
     

• Real-Time Metrics

1. 1. Claims processing volumes (hourly/daily trends)
   2. Adjudication rates and pending claims
   3. Payment processing status
   4. Error and exception tracking
   5. Provider and member analytics

• Micro Frontend Benefits

  1. Independent team deployment cycles
  2. A/B testing of analytics features
  3. Technology flexibility for future modules
  4. Reduced bundle size and faster load times

Business Impact

• Decision Velocity: Reduced time-to-insight from days to minutes with real-time dashboards
• Operational Efficiency: Single portal eliminated context-switching across 5+ legacy systems
• Scalability: Micro frontend architecture enables rapid deployment of new analytics modules
• User Adoption: Modern UX led to 3x increase in dashboard usage across operations teams
• Cost Optimization: Identified process bottlenecks saving in manual reporting

Technical Capabilities Demonstrated

• Frontend Engineering

1. 1. Advanced React patterns and state management
   2. Micro frontend architecture design and implementation
   3. Performance optimization for data-heavy applications
   4. Responsive design for cross-device analytics

• Integration Expertise

  1. Tableau Embedded API deep integration
  2. Authentication and authorization flows
  3. API gateway patterns for data orchestration
  4. Real-time data synchronization
     
     

• DevOps & Deployment

  1. CI/CD pipeline for independent micro frontend deployment
  2. Container orchestration for scalable hosting
  3. Monitoring and observability for production analytics
  4. Version management across federated modules
     
     

• Healthcare Domain Knowledge

  1. Claims processing workflows
  2. Healthcare data standards and compliance
  3. HIPAA-compliant architecture patterns
  4. Insurance operations metrics

Why This Matters for Your Project

This project demonstrates expertise in:

• Building scalable, modern analytics platforms
• Integrating best-in-class BI tools with custom applications
• Architecting enterprise-grade micro frontend systems
• Delivering real-time insights for operational excellence
• Working with complex healthcare/insurance domains

Summary Table

Available Services

Based on this project, I can help with:

• Tableau integration and embedded analytics solutions
• Micro frontend architecture design and implementation
• Real-time data pipeline development
• Healthcare/insurance technology modernization
• Legacy reporting system migration
• Custom dashboard and analytics UI development

Tech Stack:

• React
• TypeScript
• Tableau 
• Module Federation 
• AWS 
• Real-time Data Streaming 
• Healthcare Analytics

Final Thoughts

This project is a blueprint for modern healthcare analytics platforms — blending cutting-edge frontend architecture with powerful business intelligence tools.

By leveraging:

• Webpack Module Federation for true micro frontends,
• Tableau Embedded API v3 for rich, interactive visuals,
• Real-time data streaming for live insights,
• Role-based access and secure embedding,