Case Study · Project Management

Digital Transformation Program Management Platform

Supply Chain Wizard supported one of the world’s largest pharmaceutical companies in building a standardized, centralized, integrated, and automated project planning and reporting platform for a complex, multi-year digital transformation program.

Client profile Global pharmaceutical company operating in 25+ countries
Program scope Digital transformation across 15+ production sites
Technology foundation Microsoft 365, MS Project, SharePoint, Power Automate
SCW role Project management platform design and delivery partner
Background

A complex global transformation program needed a stronger planning and reporting backbone.

Digital transformation requires integrated systems, aligned processes, and continuous data flow. For this global pharmaceutical company, new digital capabilities were being designed and developed at a global level, then implemented across globally distributed management and production facilities.

Multi-year transformation scope

The program included a 5+ year roadmap for foundational enablers and digital capabilities across more than 15 production sites, with prioritization and sequencing based on each site’s baseline status.

High dependency environment

Some digital capabilities were developed internally, requiring IT solution development planning and tracking, while hardware and software vendors were also needed to deliver key digital capabilities.

Challenges

Non-standard planning, siloed schedules, and limited visibility made proactive governance difficult.

01

Non-standard way of working

Emails, spreadsheets, project planning tools, and different working methods were used without harmonization across projects.

02

Siloed project plans

Interconnected projects had dependencies, but bottlenecks could not be identified on time due to fragmented project planning.

03

Decentralized planning

Project timelines were maintained in different formats and locations, making it nearly impossible to track data across projects.

04

Heavy manual effort

The complexity of the program created significant manual effort for planning, tracking, reporting, and follow-up activities.

05

Limited visibility

Upcoming risks, late tasks, and project progress were only checked manually, limiting data-driven decision-making.

06

Missing PM artifacts

Risk registers, action item logs, and executive reporting were difficult to maintain and required extensive manual work.

Solution

SCW aligned teams around standardized, centralized, integrated, and automated project planning and reporting.

Supply Chain Wizard worked with the customer to share industry and project management best practices, onboard project teams, and develop a platform that improved governance across the digital transformation program.

01

SME interviews

Digital capability subject matter expert interviews defined project needs, pain points, required tasks, and key milestones.

02

Technology foundation review

SCW assessed the existing project planning technology landscape to avoid rework and leverage current tools.

03

Urgent project focus

Urgent projects were prioritized to demonstrate platform value, prevent delays, and capture lessons learned.

04

Platform development

A customized project management platform was built and maintained using the Microsoft 365 suite.

Platform architecture

The platform combined Microsoft 365 tools, project schedules, risk tracking, action logs, and automated reporting.

Project Management Platform Components

MS Project Project task and schedule planning with Active Directory integration.
SharePoint synchronization Real-time synchronization of project task and schedule planning data.
Risk Register Centralized risk tracking to support governance and executive visibility.
Action Item Log Structured action tracking to improve ownership and follow-through.
Power Automate Automated project status reporting, notifications, and late-task reminders.
Dashboards and Gantt charts Customized automated views showing progress, KPIs, percent complete, and project status.
Results and value

The platform improved visibility, standardization, scalability, and reporting efficiency across the program.

01

Increased visibility

The platform enabled better visibility through real-time status reporting, automated dashboards, and centralized project information.

02

Scalability and standardization

Standardized project schedule plans made it easier to deploy next-site implementation plans and align project teams.

03

Increased efficiency

Automated reporting, reminders, and dashboards reduced heavy manual project management and reporting work.

80%+ Savings enabled by the project management platform.
Every morning Automated project progress dashboard sent to stakeholders.
150+ plans Project schedule plans built across the transformation program.
Conclusion

The customer gained a scalable, customizable project management platform for stronger digital transformation governance.

Through close collaboration with the customer, Supply Chain Wizard successfully delivered a best-in-class project management platform that improved visibility, enabled data-driven decisions, and automated reminders and notifications. With this platform, the customer became more confident in project progress, priorities, and risk management.

Work with SCW

Need stronger governance for your digital transformation program?

Supply Chain Wizard helps life sciences organizations structure complex transformation programs with standardized planning, automated reporting, real-time visibility, and scalable execution models.