Custom Drug Pricing Intelligence Platform Development

About the client

The client operates in the Swedish pharmaceutical market, requiring regulated drug pricing intelligence to support market access, compliance, and competitive monitoring across nationally published TLV pricing datasets.

The Story

The client relied on manually reviewing TLV Excel files to track AIP and AUP price updates. This process was slow, error-prone, and unsuitable for regulatory-sensitive pricing decisions. FiftyFive was engaged as a custom software development partner to design and build a secure, production-grade pricing intelligence platform. The objective was to automate ingestion, historical tracking, and alerting while ensuring enterprise-level security and reliability.

Challenges

• > Manual Excel-based price monitoring workflows.

• > Automated ingestion of daily TLV Excel datasets.

• > Historical price versioning and change detection logic.

• > Secure multi-user authentication and authorization.

• > Row-Level Security (RLS) enforcement in PostgreSQL.

• > Email alert scheduling, cron reliability, and delivery stability.

• > Performance optimisation for large historical datasets.

• > Regression risks in edge functions and authentication flows.

• > GDPR-compliant logging and PII protection.

The Solution

• > Delivered full-cycle custom software development (architecture to deployment).

• > Built frontend using React 18, TypeScript, Vite, Tailwind CSS, and shadcn/ui.

• > Implemented Auth0-based authentication and secure role management.

• > Designed Supabase PostgreSQL schema with RLS policies and indexing.

• > Developed Edge Functions for event-driven processing.

• > Implemented automated Excel ingestion with streaming and chunking.

• > Built price change detection triggers and historical tracking models.

• > Configured scheduled cron jobs for ingestion and email alerts.

• > Integrated Resend API for transactional and digest notifications.

• > Applied rate limiting, endpoint hardening, and performance tuning.

The Outcome

FiftyFive delivered a production-ready SaaS platform that eliminated manual price tracking, automated daily ingestion, and enabled real-time alerting. The solution reduced operational monitoring effort, improved pricing accuracy, minimized compliance risk, and provided a scalable, secure system capable of handling large historical datasets while supporting enterprise-grade user access controls.