Back to case studies
Case Study

Cenový nástroj pro farmaceutickou firmu

A pricing engine with a simulation sandbox for a pharmaceutical company

AI-generated illustrative visualization, project under NDA
AI visualization, not a real screenshot

About the project

The client, a pharmaceutical company, needed a pricing engine that automatically recalculates prices for several thousand products based on predefined criteria. The app is connected to the company's other internal systems, drawing input data from them for a more accurate calculation. It includes a simulation mode (sandbox) where the client can simulate how a price would change under different criteria settings before rolling the change out to production. The pharmaceutical market is heavily regulated, so a wide range of edge cases had to be carefully handled in the calculation. The client is bound by an NDA, so this case study includes no screenshots or identifying details.

Project information

Client

Pharmaceutical company (under NDA)

Platform

Web application

Status

Completed

Development time

5 months

Year

2024

Technologies used

Check out the stack I used for this project

Frontend

Next.jsReactTypeScript

Backend

.NETC#

Database

MS-SQL

Key features

Automatic price recalculation for several thousand products

Company-configurable rules and criteria for price calculation

A simulation mode (sandbox) for testing the impact of changes

Connection to internal systems for a more accurate calculation

Challenges

  • 1

    Performant recalculation of prices for several thousand products at once

  • 2

    A large number of edge cases due to pharmaceutical market regulation

  • 3

    Simulating changes without affecting production data

  • 4

    Connecting to multiple internal systems for input data

Solutions

  • 1

    A pricing engine with configurable rules and criteria

  • 2

    A sandbox mode kept separate from production data for safe testing

  • 3

    A test suite covering regulatory edge cases

  • 4

    Integration with internal systems via API to refine inputs

Results

Prices recalculated for thousands of products without manual work

The client can verify the impact of criteria changes in the sandbox beforehand

Lower risk of error thanks to edge case coverage

The app is in live use at the pharmaceutical company

Development timeline

From analysis to deployment - how the project evolved

3 weeks

Analysis and design

Mapping pricing criteria, designing the data model and integrations

8 weeks

Pricing engine

Price calculation for thousands of products, edge case coverage

5 weeks

Simulation sandbox

Simulation mode and connection to internal systems

3 weeks

Testing and rollout

Testing regulatory scenarios, rollout to production

Have a similar project?

I'll be happy to help you build your application. Feel free to contact me for a free consultation.

Contact me