Back to PortfolioCase Study

Regeneron Pharmaceuticals

End-to-end portfolio management and reporting platform that unified Regeneron's financial and operational systems — giving program managers and executives a single, trusted view of every active R&D program.

Portfolio ManagementReporting SystemSAP IntegrationOracle FinancialsPower BIAzure Data Factory

50+

Active programs tracked in real time

80%

Reduction in manual reporting effort

6

Enterprise systems integrated

Solutions Delivered

Portfolio Management System

Active Program Overview
Dupixent Next-GenPhase III
On Track
REGN-4461Phase II
On Track
ItepekimabPhase III
At Risk
OdronextamabPhase II
On Track

Centralized system tracking all active R&D programs — phase, budget utilization, milestones, and risk status in one view.

Automated Reporting System

Scheduled Report Queue
Board Portfolio Review
MonthlyGenerated
Budget vs Actuals
WeeklyGenerated
Regulatory Submission Pack
QuarterlyPending
Operational KPI Summary
WeeklyGenerated

Automated report generation for board, regulatory, and operational audiences — eliminating manual data assembly.

Financial Dashboard

Total R&D Budget

$3.2B

Actuals YTD

$1.8B

Forecast Variance

+2.1%

Programs At Risk

3 / 54

Real-time budget vs actuals dashboard pulling live data from SAP ERP and Oracle Financials via Azure Data Factory pipelines.

Operational Integration Hub

Integration Status
SAP ERP
REST APILive
Oracle Financials
SOAP APILive
Manufacturing MES
REST APILive
Supply Chain WMS
REST APILive
Clinical CTMS
REST APILive
Regulatory eDMS
REST APILive

Six enterprise systems connected through a unified integration layer — eliminating data silos across finance, operations, and clinical.

Key Deliverables

  • Enterprise portfolio management system consolidating pipeline assets, R&D programs, and capital allocation across all therapeutic areas
  • Automated reporting platform generating regulatory, executive, and board-level reports from a single source of truth
  • Bi-directional integration with SAP ERP, Oracle Financials, and internal operational systems via REST and SOAP APIs
  • Real-time financial dashboard tracking budget vs actuals, project burn rates, and milestone-linked spend across 50+ active programs
  • Operational KPI reporting system aligned with manufacturing, supply chain, and commercial launch timelines
  • Role-based access control enabling program managers, finance leads, and executives to view relevant data without manual data pulls
  • Automated variance analysis engine flagging budget deviations above configurable thresholds for immediate stakeholder notification
  • Historical reporting archive with audit trail supporting regulatory submissions and internal compliance requirements

Technology Stack

Power BI

Portfolio & reporting dashboards

SAP Integration

ERP financial data pipelines

Oracle Financials

Budget & actuals sync

Azure Data Factory

ETL & system orchestration

SQL Server

Unified data warehouse

REST / SOAP APIs

Cross-system connectivity

Looking for a similar solution?

Let's discuss how we can build the right tools for your organization.

Get in Touch