MDS Pharma Services: turning the microscope onto business performance

Published on 07-Jul-2009

Validated on 17 Feb 2011

"You can create an agent in IBM Cognos Now! that connects to most data sources and eliminates all the manual work of consolidating and crunching numbers. Now we can see not only our pipeline and projects, but the longevity and profitability of our projects, so we can target the most profitable opportunities." - Kellie Terry, IT Director, Program Management Office, MDS Pharma Services

Customer:
MDS Pharma Services

Industry:
Life Sciences

Deployment country:
United States

Solution:
Business Intelligence

Overview

MDS Pharma Services was looking for a business monitoring solution that would enable rapid response to fast-changing market conditions, better insight into its sales opportunity pipeline, and improved financial performance. The company needed to understand the entire customer relationship - from sales proposal to signed contract - monitor project milestones, and calculate and compare the value of strategic opportunities year over year, by customer and other key competitive factors.

Business need:
Enable rapid response to changing market conditions, achieve better insight into sales opportunity pipeline and improve financial performance.

Solution:
An IBM® Cognos® Now! solution that bridges disparate information sources and delivers highly visual, interactive and self-service operational dashboards, streaming analytics and reports.

Results:
Information in minutes rather than days; total view of customer relationships; faster accounts receivable; on-demand metrics for business agility and better customer service; rapid deployment - to over 100 users in 5 days.

Benefits:
IBM Cognos Now! has helped MDS Pharma understand the entire customer relationship - from sales lead to signed contract to project milestones - and which of its managers and business units have the best customer relationships. Managers can proactively monitor strategic accounts on a daily or hourly basis. And week after week, financial managers have continuously improved accounts receivable, reduced DSO and finetuned year over year financial metrics.

Case Study

In the race to bring much-needed drugs to market faster, leading pharmaceutical and biotechnology companies worldwide rely on clinical research organizations (CROs). MDS Pharma Services is one of the world’s leading CROs, providing innovative drug discovery and development services.

A business unit of MDS Inc. (TSX:MDS; NYSE:MDZ), MDS Pharma Services applies advanced scientific and technological expertise throughout the drug discovery and development process – from lead optimization, early clinical research and bio-analysis to global clinical development, central lab and centralized cardiac services. The company’s goal is to bring speed, precision and productivity to drug discovery and development.

Challenges Faced
MDS Pharma Services was looking for a business monitoring solution that would enable rapid response to fast-changing market conditions, better insight into its sales opportunity pipeline, and improved financial performance. The company needed to understand the entire customer relationship - from sales proposal to signed contract - monitor project milestones, and calculate and compare the value of strategic opportunities year over year, by customer and other key competitive factors. And, it needed this information in hours, not days.

Accurate, timely forecasts of revenue and customer demand would help sales teams close more deals, bring higher profits and align expenses with revenue growth. With a better understanding of the most profitable strategic accounts and improved decision-making capability, MDS Pharma Services would also serve the needs of its customers better.

MDS Pharma Services needed a business monitoring solution that could tap into its existing customer relationship management (CRM) platform, its enterprise resource management (ERP) system, and other applications, to deliver key financial metrics, such as the number of signed contracts as a percentage of total sales opportunities, or the number of days sales outstanding (DSO) in accounts receivable.

However, getting these kinds of metrics was difficult and time - consuming using the company’s existing reporting platform. Adding to the challenge was the storage of relevant information in multiple systems. To improve the ratio of closed contracts, it was critical to have a seamless flow of information from the CRM and ERP systems.

“We wanted to see the whole picture - the date when a sales lead was created, and how long it took to become a closed opportunity and contract, so we could compare our performance to the prior year. And we wanted this information now,” explains Kellie Terry, IT Director, Program Management Office at MDS Pharma Services.

Strategy Followed
To bridge the gap between its CRM and ERP systems, and gain immediate insight into opportunity, revenue and profitability metrics, MDS Pharma Services sought a continuous monitoring solution that would meet these business and technology requirements:

• Financial dashboards to provide daily metrics and analyze profitability year over year
• Ability to connect to multiple data sources and multiple data objects, and display them in a single view
• Accurate, timely forecasts of revenue and customer demand to help sales teams close more deals, realize higher profits and align expenses with revenue growth
• Low total cost of ownership (TCO) through an easy-to-maintain solution with an adaptable user interface for business user self-service.

MDS Pharma Services selected IBM Cognos Now!, the industry’s first continuous business monitoring appliance that helps decision makers proactively track, monitor and respond to continuously updated operational metrics in real time or near real time. IBM Cognos Now! delivers highly visual, interactive and self-service operational dashboards, data integration, streaming analytics, and reports - all prepackaged in either a hardware, software or VMware appliance.

With all required software pre-installed for fast and easy deployment, IBM Cognos Now! was installed and running at MDS Pharma Services in just five days. Over 100 users were provided access to the system in the first implementation phase, including the sales, finance, IT and operations frontlines, as well as C-Level executives. Many were up and running in just eight weeks. The solution’s easy integration with existing systems and ability to consolidate data from multiple sources greatly accelerated time to results.

“One of the nice features of the IBM Cognos tool is the consolidated data stream,” observes Ms. Terry. “You can create an agent in IBM Cognos Now! that connects to most data sources and eliminates all the manual work of consolidating and crunching numbers. Now we can see not only our pipeline and projects, but the longevity and profitability of our projects, so we can target the most profitable opportunities.”

Benefits Realized
IBM Cognos Now! has helped MDS Pharma understand the entire customer relationship - from sales lead to signed contract to project milestones - and which of its managers and business units have the best customer relationships. Managers can proactively monitor strategic accounts on a daily or hourly basis. And week after week, financial managers have continuously improved accounts receivable, reduced DSO and fine-tuned year over year financial metrics.

Financial and AR professionals can drill down to the actual invoice level, see AR aging, back-load aging by business unit, view the top 10 customers with open transactions and slice invoicing data by any criteria. Users can also upload Microsoft® Excel® spreadsheets for look-up in context. Even if the header data is different, IBM Cognos Now! can consolidate data from disparate sources into a single dashboard view.

About IBM Cognos BI and Performance Management
IBM Cognos business intelligence (BI) and performance management solutions deliver world-leading enterprise planning, consolidation and BI software, support and services to help companies plan, understand and manage financial and operational performance. IBM Cognos solutions bring together technology, analytical applications, best practices, and a broad network of partners to give customers an open, adaptive and complete performance solution. Over 23,000 customers in more than 135 countries around the world choose IBM Cognos solutions.

For further information or to reach a representative: www.ibm.com/cognos

Products and services used

IBM products and services that were used in this case study.

Software:
Cognos Now!

Legal Information

© Copyright IBM Corporation 2009 IBM Canada 3755 Riverside Drive Ottawa, ON, Canada K1G 4K9 Produced in Canada February 2009 All Rights Reserved. IBM, the IBM logo, ibm.com and Cognos are trademarks or registered trademarks of International Business Machines Corporation in the United States, other countries, or both. If these and other IBM trademarked terms are marked on their first occurrence in this information with a trademark symbol (® or ™), these symbols indicate U.S. registered or common law trademarks owned by IBM at the time this information was published. Such trademarks may also be registered or common law trademarks in other countries. A current list of IBM trademarks is available on the Web at “Copyright and trademark information” at www.ibm.com/legal/copytrade.shtml. Microsoft and Excel are trademarks of Microsoft Corporation in the United States, other countries, or both. Other company, product and service names may be trademarks or service marks of others. This case study is an example of how one customer uses IBM products. There is no guarantee of comparable results. References in this publication to IBM products or services do not imply that IBM intends to make them available in all countries in which IBM operates. Any reference in this information to non-IBM Web sites are provided for convenience only and do not in any manner serve as an endorsement of those Web sites. The materials at those Web sites are not part of the materials for this IBM product and use of those Web sites is at your own risk.