Case Study

Case Study Powering Public Health at Scale: Multi-State Vaccine Tracking Portal

How we scaled and secured a multi-state vaccination tracker and clinic management portal for thousands of concurrent users.

The Client

Coordinating critical healthcare infrastructure across multiple states.

The client manages a government-supported healthcare initiative operating across several US states. Their mission is to coordinate public health activities, manage medical inventory, and track patient healthcare records. The primary portal serves health departments, medical clinics, volunteers, and citizens, providing tools for patient pre-registration, inventory monitoring, and clinical operations.

With the rollout of large-scale public health programs, the portal had to support a significant increase in user traffic. Thousands of users, including healthcare providers, clinic administrators, and patients, accessed the platform simultaneously. The platform had to handle sensitive health information securely while remaining responsive during peak booking hours.

To scale the platform and resolve security and performance issues, the client partnered with Intelegencia. The goal was to build robust access control systems, run high-load performance tests, and automate patient and clinic workflows.

The Challenge

Scaling clinic operations and data access controls.

The client's vaccination tracker portal had to manage operations across multiple clinics, states, and booking systems. With different groups of users, from state health officials to local volunteers, accessing the system, the portal needed precise access controls to protect patient privacy and comply with health data regulations.

Furthermore, during public health enrollment periods, the platform experienced sudden traffic spikes that put significant strain on the server infrastructure. The client needed to ensure the portal could handle high-volume transactions, such as patient registrations and inventory updates, without experiencing downtime or slow load times.

Needed access level functionality across multiple states, vaccine types, clinics, and booking systems without overwhelming end-users or admins.

Required a full-fledged vaccine tracker capable of handling thousands of concurrent users across mass clinic sites.

Manual verification of vaccine provider applications created processing backlogs.

Traffic surges threatened portal stability and database response times.

What our audit found

Identifying role-based permission conflicts and load vulnerabilities.

Our engineering team performed a detailed system and security audit of the healthcare portal. The audit showed that the system's permission settings were not clearly defined. Users in one state could occasionally view configuration data for another state, creating data compliance risks and operational confusion.

We also conducted load tests to evaluate how the database handled concurrent transactions. The diagnostic showed that database read-write cycles became slow when thousands of users searched for open appointments or updated patient records at the same time, leading to interface delays.

1

Undefined permission rules caused data visibility conflicts across states.

2

Database write queues caused transaction lag during peak appointment booking times.

3

Legacy provider enrollment workflows required manual verification, slowing clinic onboarding.

4

Lack of performance validation tools to test system stability before software updates.

The Solution

How we turned it around.

Access Control

Implementing access level management and role-based charts

To resolve the permission conflicts, we designed a role-based access control system. We built detailed access level charts that define permission rights for every user group, including state administrators, clinic managers, volunteer coordinators, and patients.

We integrated these charts into the portal’s security layer. This setup ensures that users can only access data, inventory records, and booking settings related to their assigned roles and regions. These changes resolved cross-state visibility issues and helped the client meet health data compliance standards.

What we shipped

  • Created detailed role-based access charts for all user groups.
  • Configured data filters to restrict access based on state and clinic roles.
  • Resolved permission conflicts to prevent unauthorized data access.
  • Enabled secure login and access management across multiple states.
Performance Testing

Developing high-load performance scripts and testing

To address stability issues during peak booking periods, we developed custom performance scripts. These scripts simulated high-load scenarios, allowing us to test how the portal performed with thousands of concurrent users accessing appointment searches and registration forms.

We ran these tests in staging environments to identify database query bottlenecks and network latency issues. We optimized index configurations and database query flows, ensuring the platform remained stable and responsive during real-world traffic surges.

What we shipped

  • Created automated scripts to test portal performance under high user loads.
  • Simulated concurrent transactions to identify database query bottlenecks.
  • Optimized database indexes to speed up appointment search responses.
  • Verified system stability across mass clinic locations during peak hours.
Automation & Support

Deploying workflow automation and dedicated engineering support

To reduce administrative overhead, we automated the portal's core processes. We built a paperless vaccine provider enrollment system that digitizes the application and validation process, reducing manual verification delays and helping new clinics onboard quickly.

We deployed a dedicated support team to manage ongoing development, database optimization, and feature rollouts. This team works continuously to update code, adjust server resources, and ensure the platform remains stable as user volume grows.

What we shipped

  • Replaced manual workflows with automated patient and provider enrollment pipelines.
  • Deployed a dedicated engineering team to handle feature rollouts and updates.
  • Automated registration and confirmation loops to reduce manual administration.
  • Provided 24/7 system monitoring to resolve operational issues immediately.

The Numbers

Outcomes we can talk about.

The integration of role-based security and workflow automation resolved the portal's operational bottlenecks. By automating the registration-to-vaccination workflow, the platform achieved faster processing times and increased throughput at mass clinic sites.

The automated system simplified clinic operations, allowing administrative teams to coordinate multiple sites across states with less manual effort. The role-based access control charts resolved permission conflicts and improved data security. Additionally, the performance testing scripts helped optimize server configurations, ensuring portal reliability even under peak load conditions.

Note on Metrics: Due to the client's strict security guidelines and the public-health nature of the portal, quantitative metrics were restricted from public release. The success of the project was measured qualitatively by the successful automation of clinic registrations, the elimination of cross-state data conflicts, and the platform's stability during peak appointment booking periods.

What We Built

Role-based access level control chartsHigh-load performance testing scriptsAutomated patient pre-registration portalPaperless vaccine provider enrollment systemMulti-clinic inventory management dashboardVolunteer recruitment portalDedicated support and feature rollout pipeline

What's Next

Introducing automated vaccine inventory routing and predictive forecasting.

Following the successful portal optimization, the next phase will focus on automated logistics. We plan to develop inventory tracking modules that automatically alert clinics when supplies run low and recommend optimal stock levels based on booking history.

Additionally, we are planning to build reporting dashboards that help state health departments forecast vaccination trends, allowing them to allocate resources efficiently.

Frequently Asked Questions
About This Project

The questions teams usually ask when they want to run a similar engagement.

The system enforces strict data boundaries, ensuring that local clinic workers can only see patient data for their specific clinic, while state-level officials only see aggregated, de-identified reports.

The Real Numbers

Need real numbers? Let's talk.

We kept the names off the page. The story is real, the outcomes are real, and we're always happy to walk a serious team through the rest of it.

Start a Conversation