Featured case study

A vintage brown and gray typewriterAI · LegalA Litify Expert That Cites Its SourcesRead the case study
Not sure where to start?Tell us what you’re trying to solve. We’ll point you to the right team.Talk to an expert

Featured case study

A screen showing charts and performance metricsData · HealthcareLive Risk KPIs, Embedded Where Clients Already WorkRead the case study
Not sure where to start?Tell us what you’re trying to solve. We’ll point you to the right team.Talk to an expert

Featured case study

A modern stone building with an evergreen tree out frontGovernment & Nonprofits · Web & DigitalA Member Website a Union Can Rely OnRead the case study
Not sure where to start?Tell us what you’re trying to solve. We’ll point you to the right team.Talk to an expert
Staff Augmentation

Experienced developers and admins who work inside your team, your tools, and your process.

Featured case study

A pink brain outline beside a maze shaped like the other half of a brainCustom Development · HealthcareAn Embedded Engineering Team, Six Years and CountingRead the case study
Not sure where to start?Tell us what you’re trying to solve. We’ll point you to the right team.Talk to an expert
AppExchange Products

Apps BRIO built for Litify and Salesforce, installed and supported by the team that made them.

Featured case study

A tall glass building facade with rows of windowsLegal · LitifyAutomated Client Communication Inside LitifyRead the case study
Not sure where to start?Tell us what you’re trying to solve. We’ll point you to the right team.Talk to an expert
Legal

Litify and legal technology from a team that includes former lawyers and paralegals.

How we help

Common challenges we solve

  • Case data scattered across legacy systems
  • Manual records requests, notes, and court emails
  • Reporting that leadership can trust
Healthcare

Secure platforms and analytics for care providers, benefits firms, and health advocates.

How we help

Common challenges we solve

  • Sensitive data that needs careful protection
  • Enrollment and review deadlines that never move
  • Clients asking for clear, current metrics
Finance & Insurance

Enrollment, claims, and internal tools built on data you can audit.

How we help

Common challenges we solve

  • Internal roadmaps bigger than the team
  • Claims and pricing work stuck in spreadsheets
  • Strict review and release standards
Construction & Utilities

Portals, field data, and reporting for contractors, utilities, and job-site services.

How we help

Common challenges we solve

  • Customers who want self-service requests and reports
  • Field data that is hard to act on
  • Operations running on aging systems
Government & Nonprofits

Mission-driven systems built to serve people well and protect sensitive information.

How we help

Common challenges we solve

  • Several systems for one organization
  • Sensitive records with need-to-know access
  • Small teams managing large websites
Media & Retail

Commerce and back-office systems for businesses with one-of-a-kind products.

How we help

Common challenges we solve

  • Inventory that must stay in sync online and in store
  • Catalogs and publishing done by hand
  • Stores that need steady updates
Technology & Startup

Scalable platforms and integrations for teams that move fast.

How we help

Common challenges we solve

  • Choosing a stack you will not outgrow
  • Shipping fast without piling up debt
  • Adding senior talent without long hiring cycles

Let’s build it

Building something new?Tell us where you’re headed. We’ll help you choose a platform you won’t outgrow.Start the conversation
All industries Browse case studies by industryNot listed? Our process works across sectors.
/
/
From Spreadsheets to Salesforce for Specialty Drug Cost Containment

Case Studies

Open role

From Spreadsheets to Salesforce for Specialty Drug Cost Containment

An employee benefits services firm managed high-cost specialty drug cases in spreadsheets. BRIO built a secure Salesforce platform that tracks every case from clinical review through refills, eligibility, and billing.

Finance & Insurance · Healthcare · Salesforce
Colorful sticky notes pinned to a board

The Challenge

An employee benefits services firm helps self-insured employer groups control costs, working alongside third-party administrators, brokers, and pharmacy benefit managers. One of its core services is drug cost containment: finding lower-cost paths for high-cost specialty medications without disrupting care.

Each case involves clinical review, research across multiple vendor solutions, approvals, monthly refill and eligibility tracking, and fees billed to the client. All of it lived in spreadsheets and free-text notes, which made it hard to see what was due, what had been saved, and what was ready to bill.

The firm needed a platform that could:

  • Track every case from clinical review through ongoing refills.
  • Keep relationships between employers, administrators, brokers, and pharmacy benefit managers accurate over time.
  • Automate the reminders and checks that keep cases on schedule.
  • Protect sensitive health information to the standard the work requires.

The Approach

BRIO began with process analysis and discovery to map how each business line actually works, then designed a Salesforce data model around those processes. Security and compliance came first: the org was set up with single sign-on, multi-factor authentication, and protections for sensitive fields before any health information was stored. Drug cost containment went live first, with the firm’s other business lines following in later releases.

The Solution

A Data Model Built Around the Work: Custom objects track engagements, medical reviews, vendor solutions, prescriptions, drugs, eligibility, and fees. Account types distinguish employers, administrators, pharmacy benefit managers, vendors, brokers, providers, and carriers, and relationships are tracked over time with one active at a time.

Automation That Keeps Cases Moving: Refill reminders arrive two weeks ahead, new-prescription tasks are created when refills run out, and next fill dates calculate automatically. Monthly eligibility checks and billing-readiness alerts keep the team ahead of what is due.

Fees and Billing Without the Scramble: Fees can be set at the client, engagement, or prescription level, with more specific settings taking priority. Items are marked ready to bill and exported monthly to the firm’s accounting system.

Reporting From Day One: A go-live dashboard and a set of reports cover savings tracking, refills due, and data quality checks.

Security to Match the Data: Single sign-on, required multi-factor authentication, encryption, and field-level security protect sensitive information, with role-based access and a dedicated app for each business line.

Connected to Everyday Tools: An email add-in brings Salesforce into the inbox, and document links connect records to the firm’s existing file storage.

Technical foundation

  • Salesforce with a custom data model for drug cost containment
  • Single sign-on with multi-factor authentication
  • Encryption and field-level security for sensitive fields
  • Flow automation for refills, eligibility, and billing readiness
  • Monthly export to the firm’s accounting platform
  • Dashboards and reports for savings and operations

The Impact

The first business line moved from spreadsheets to a purpose-built platform:

  • Drug cost containment live on Salesforce, with the team entering work there from launch.
  • Refills, eligibility, and billing tracked automatically instead of by hand.
  • One view of relationships across employers, administrators, brokers, and pharmacy benefit managers.
  • A secure foundation for the firm’s additional business lines.

When the work is specialized and the data is sensitive, the right platform starts with the process and the protections, then makes the daily work easier from there.

At a glance

About this guide

Share this role

Industry & services

Topics

Finance & Insurance · Healthcare · Salesforce

Share

Have a similar project?

Planning a project?

Tell us what you’re working on and we’ll share how we’d approach it.

Talk with a consultant about your goals, timeline, and data. We’ll help you map out next steps.

Interested in this role?

Apply below with your LinkedIn profile and resume.

Keep reading

Related work

A vintage brown and gray typewriter
AI · Legal · Litify

A Litify Expert That Cites Its Sources

Plenty of people talk about retrieval-augmented generation. BRIO built and runs it: a Litify knowledge expert that answers product questions only from

Read more →

A screen showing charts and performance metrics
Data · Healthcare · Salesforce · Tableau

Live Risk KPIs, Embedded Where Clients Already Work

A healthcare risk management firm wanted its clients to see incident trends without another login. BRIO designed custom risk KPIs and Tableau

Read more →

A white brain model with a cursor and the letters ai on a yellow grid
AI · Salesforce

Estimates You Can Trace Back to the Code

A ticket lifecycle where AI reads the client's actual repository before it writes a technical spec or an estimate, and refuses to

Read more →

Get started

Careers

Apply for this role

Let’s build your success story

Have a question about your project?

Tell us what you’re working on. We’ll follow up to set up a discovery call.

Share a few details, your LinkedIn profile, and your resume. Our team reviews every application and follows up.

What happens next

1

We review your note and follow up

2

A discovery call with a BRIO consultant

3

Clear recommendations and next steps

What happens next

1

We review your application

2

An intro call with our team

3

Interviews and next steps

We only use your information to respond to you.