CLIENT CASE STUDIES

Top Pharmaceutical Manufacturer, Spark Implementation

A Large Pharma manufacturer wanted to add automation and greater auditability to the state price transparency reporting (SPTR) process to create efficiencies around legislation tracking, monitoring of reporting triggers, gathering data required for submissions, and approvals. ​

CHALLENGES

  • The company was manually tracking and complying with state price transparency reporting (SPTR) across 200+ NDC’s using a combination of third-party and manual processes:​
    • Third-Party: tracking updates to legislation as new laws were approved across states or existing laws were updated and providing updates via e-mail​
    • Manual: tracking WAC pricing history across products and monitoring any price changes that triggered state specific thresholds using formulas in excel spreadsheets​
    • Manual: downloading reporting template formats from states, compiling data needed for reports, reviewing completed reports for approval via e-mail and submitting to state entities​

SOLUTION

  • Deployed Spark, a Salesforce-based solution, in 14 weeks to enable automated compliance with SPTR in one place by tracking, storing and providing on- demand updates to:​
    • State legislation, reporting requirements and thresholds that trigger reporting​
    • Templates required for submission by states and capabilities to support the submission process​
    • What-if analysis capabilities to assess WAC increases or product launches that trigger reporting​
    • Ability to store 300+ unique data elements required to maintain compliance across all states​
  • Provided trainings on how to utilize solution across team responsible for the company’s SPTR process​

RESULTS

  • Enabled the company to automate SPTR process by:​
    • Storing all data required for SPTR in Spark​
    • Streamlining the creation of reports required to be submitted to states​
    • Modeling the reporting impact of future WAC increases and product launches​
  • Onboarded 7 users to the Spark solution​
  • Implemented auditable approval workflows within Spark to track review and approval of reports prepared for submission to states​
  • Ability to store historical SPTR submissions due to creation of a central repository​
  • Since implementation, the company successfully created 200+ reports on Spark and submitted to states without facing any compliance penalties​​