UD4D — Use data for decisions

Unifying 30+ medical and R&D reports on a single Snowflake data mart

We replaced manual Veeva exports and scattered Excel files with one governed Snowflake data mart, giving medical and R&D teams a single, trusted view.

Get in touch Download PDF
Unifying 30+ medical and R&D reports on a single Snowflake data mart

About the client

Global pharmaceutical company specializing in women’s health, operating across the whole world.

The challenge

The client managed Medical Affairs, Quality, and Regulatory data across multiple Veeva applications and internal systems, with no central analytical layer and no reporting beyond manual Excel exports.

  • Fragmentation of data across regional Veeva CRM instances, Veeva Vault, and regulatory and quality systems
  • Reliance on predefined CRM filters, local exports, and manual Excel analyses for all Medical Affairs reporting
  • Absence of a shared model for HCPs, MSLs, products, countries, clusters, and therapeutic areas
  • No consistent, timely view of MSL activities, medical insights, trainings, certifications, and claims across regions

The solution

UD4D designed and implemented an R&D data mart on Snowflake as a single analytical layer for medical and R&D use cases.

  • Integration of regional Veeva CRM instances as primary sources for HCP and MSL profiles and interactions
  • Modeling of shared subject areas, including HCP and MSL identity, medical insights, and quality and compliance
  • Ingestion through external stages and external tables, or via automated Informatica IICS workflows, into an integrated data layer
  • Transformation through Snowflake Dynamic Tables, orchestrated by Snowflake Tasks
  • A published layer inside the governed data mart, feeding around 30 Power BI reports connected to live data

Business impact

  • 30+

    standardized reports

    Fragmented Veeva exports and ad-hoc Excel were replaced by around 30 Power BI reports on one consistent metric and dimension model.

  • 50

    user groups on one platform

    Approximately 50 user groups across Medical, Quality, and Regulatory now work from the same R&D data mart.

  • 2-3 hrs

    saved per user per week

    Each user reclaims an estimated 2 to 3 hours previously spent downloading, cleaning, and reshaping Veeva data in Excel.

  • 1

    single source of truth

    Data from multiple Veeva applications and internal systems was consolidated into one daily-refreshed R&D data mart on Snowflake.

Frequently asked questions

What was the challenge?

Medical Affairs, Quality and Regulatory data was spread across multiple Veeva applications and internal systems, with no central analytical layer and only manual Excel reporting.

What did UD4D build?

An R&D data mart on Snowflake as a single analytical layer, integrating regional Veeva CRM instances and modeling shared subject areas such as HCP and MSL identity.

How is data loaded and transformed?

Through external stages and tables or automated Informatica IICS workflows, with transformation via Snowflake Dynamic Tables orchestrated by Snowflake Tasks, feeding around 30 live Power BI reports.

What were the results?

More than 30 standardized reports, about 50 user groups on one platform, an estimated 2 to 3 hours saved per user per week, and a single daily-refreshed source of truth.

Related case studies