customer spotlight: hyperion financial planning at colorcon

Contact Us510.818.9480 | www.kpipartners.com

© KPI Partners Inc.

Start Here

David Graeber Director of Global Finance, Colorcon

Heather Tees Manager of Global FP&A, Colorcon

John Ronga Director of Client Services, KPI Partners

Larry Manekin Hyperion Architect, KPI Partners

December 11, 2014

Customer Spotlight:

Hyperion Financial Planning at Colorcon

Agenda

2

Industry: Pharmaceutical

Presence: Global

Projects:

Financial Planning

Workforce Planning

At A Glance

① About Colorcon

② Business Drivers

③ Obstacles

④ Success Criteria

⑤ The Solution

⑥ Results/Return on Investment

⑦ What To Do Differently

⑧ Q & A

Agenda

Customer Spotlight: Hyperion Financial Planning at Colorcon 3

About Colorcon

4

5

About ColorconWorld-Class Supplier of Pharmaceutical

Excipients and Services

Customer Spotlight: Hyperion Financial Planning at Colorcon

Business Drivers

6

Business Drivers

Customer Spotlight: Hyperion Financial Planning at Colorcon 7

Shorten budget cycle & improve accuracy

Improve ability to plan resources and “see around corners”

Create efficiencies in making budget changes

Business Drivers

Customer Spotlight: Hyperion Financial Planning at Colorcon 8

Improved ability to monitor performance against expectations

Improved ability to adjust spending based on budget vs. current expectations

Build a platform to accommodate periodic forecasts during fiscal year

Obstacles

9

Business Drivers

Customer Spotlight: Hyperion Financial Planning at Colorcon 10

Approx. 3,000

person-days to

complete budget

Spreadsheets are labor

intensive, a source of manual

error and require many levels of

mechanical review.

Business Drivers

Customer Spotlight: Hyperion Financial Planning at Colorcon 11

Timing of Budget

Processes

Begins in July & August

Leads to stale data

Business Drivers

Customer Spotlight: Hyperion Financial Planning at Colorcon 12

Inability to make

changes and

reconsolidate results

in an efficient &

timely manner

No consistency with financial statement preparation across regions

Unable to recycle changes such as FX assumptions efficiently

Business Drivers

Customer Spotlight: Hyperion Financial Planning at Colorcon 13

No ability to

perform scenario

analysis, which

would help drive

timely decision-

making

Business Drivers

Customer Spotlight: Hyperion Financial Planning at Colorcon 14

Our Version of Hyperion

Planning Was Outdated

No update in 8+ years

Out-of-the-box solution

Lack of ownership

Lack of on-going development

A table-based repository of disparate

data

Business Drivers

Customer Spotlight: Hyperion Financial Planning at Colorcon 15

Personnel Planning/Headcount Analysis

Was Cumbersome & Disconnected

Inconsistent methods across regions

Different ownership (i.e. Finance vs. HR)

Inconsistency around classification of headcount & workforce (e.g.

temp staff, contractors, etc.)

Business Drivers

Customer Spotlight: Hyperion Financial Planning at Colorcon 16

Needed Structural

Changes To Align

With Current

Organization of Data

Account Structure

KPIs & Metrics

Entity Structure

Multi-Currency

Security

Business Drivers

Customer Spotlight: Hyperion Financial Planning at Colorcon 17

Financial Reporting

Needed To Be

Enhanced To Facilitate

Reports &

Consolidations

Current financial reports were not

built in an optimized way

Not all regions took an initiative

in financial report development

Success Criteria

18

① Leverage and enhance the budgeting and forecasting

tools at our disposal

② Re-engineer certain processes (Sales, RMs, Workforce)

③ Enhance collaboration across organization Improve guidance & harmonize process

④ Develop consistent assumptions and calculations

⑤ Develop consistent driver-based planning features

Success Criteria

Customer Spotlight: Hyperion Financial Planning at Colorcon 19

① Create format to accommodate efficient analysis (instead

of time spent on data manipulation)

② Enable an efficient statement and consolidation process

③ Workforce planning functionality for improved visibility of

headcount and related costs

④ Efficient currency conversion

⑤ Limit the use of Excel as an intermediary step

Success Criteria

Customer Spotlight: Hyperion Financial Planning at Colorcon 20

21

Ultimately, rebuilding the Hyperion

structure would allow us to…

leverage the tool on the front end

eliminate some of the feeder

spreadsheet needs

better support process

enhancement going forward

Customer Spotlight: Hyperion Financial Planning at Colorcon

The Solution

22

The Solution

Customer Spotlight: Hyperion Financial Planning at Colorcon 23

Why Hyperion? Colorcon already licenses the tool

We are an experienced Oracle shop

Why KPI? We have a technology roadmap, which includes

plans for evolving our BI Tools.

KPI brings a variety of skills to the table, in

addition to Hyperion Planning

The Solution

Customer Spotlight: Hyperion Financial Planning at Colorcon 24

Current System Not

Structured The Way

We Look At And

Report Our Data

Accounts

Locations

Etc.

The Solution

Customer Spotlight: Hyperion Financial Planning at Colorcon 25

Foreign Currency

Capabilities Did

Not Mirror How

Colorcon Has

Conducted

Business

The Solution

Customer Spotlight: Hyperion Financial Planning at Colorcon 26

Workforce & Finance

In One Combined

Application

Organizational hierarchy was

built based on

roles/responsibilities vs.

locations.

Inflexible to changes in

personnel responsibilities.

Not intuitive for drill-down

analysis for financial reporting

27Customer Spotlight: Hyperion Financial Planning at Colorcon

PHASE I

Separate

Workforce into

Separate

Application

No previous Workforce

Application

Understand each

location’s budgeting

needs

External Factors taxes

benefits

Internal Factors merit increases

Incentive

headcount

28Customer Spotlight: Hyperion Financial Planning at Colorcon

PHASE I

Rebuild

Dimensions

Within

Finance

Application

Account Structure mirror Oracle structure

build hierarchy based on

financial statement roll-up

include account calculations

include sub-totals/totals

include KPIs

Organizational Structure mirror Oracle structure

build hierarchy based on global

consolidation

Currency Load data in all currencies

Accommodate multi-currency

Security Set at location/department level

29Customer Spotlight: Hyperion Financial Planning at Colorcon

PHASE I

Develop

Reports for

Global &

Regional Use

30Customer Spotlight: Hyperion Financial Planning at Colorcon

PHASE I

Implement

Smart View

Implement Smart View

31Customer Spotlight: Hyperion Financial Planning at Colorcon

PHASE I

Testing &

Training

The Solution

Customer Spotlight: Hyperion Financial Planning at Colorcon 32

Accommodating 5

Different Regions

Each had their own unique

budgeting process.

Balancing current regional

budget processes with a future

streamlined global vision.

The Solution

Customer Spotlight: Hyperion Financial Planning at Colorcon 33

Building Account

Dimension To Align

With Oracle Row Sets

Used in Oracle FSG

Which Support

Financial Reporting

One account can go into multiple

lines on the P&L depending on the

department/cost center (ex. salaries)

The Solution

Customer Spotlight: Hyperion Financial Planning at Colorcon 34

Timing The

Completion Of Phase I

Phase I began at the end of 2014

budget cycle.

Phase I completed before the

start of the 2015 budget cycle.

The Solution

Customer Spotlight: Hyperion Financial Planning at Colorcon 35

Education & Support

Learning an unfamiliar tool and

simultaneously being an “in-house

subject matter expert” to users

needing training.

Results/Return on

Investment

36

Results & ROI

Customer Spotlight: Hyperion Financial Planning at Colorcon 37

Enabled A More

Efficient Financial

Statement And

Consolidation

Process

Time savings for all users

Limited the use of MS-Excel

Single source of truth

Consistent formulas and metric

definitions

Results & ROI

Customer Spotlight: Hyperion Financial Planning at Colorcon 38

Better

Organization of

Data & Ability to

Perform Ad-Hoc

Analysis

More analysis for decision

making vs. time spend on

data manipulation.

Improved transparency.

Results & ROI

Customer Spotlight: Hyperion Financial Planning at Colorcon 39

Ability To Process

Changes In A More

Timely Manner

Limited use of MS-Excel

Immediate currency conversion

and translation

Results & ROI

Customer Spotlight: Hyperion Financial Planning at Colorcon 40

Workforce Planning

Functionality Allowed

Improved Visibility of

Headcount and

Workforce Costs.

What to Do Differently?

41

What To Do Differently?

Customer Spotlight: Hyperion Financial Planning at Colorcon 42

Additional strategic consideration for system performance within the existing infrastructure.

What To Do Differently?

Customer Spotlight: Hyperion Financial Planning at Colorcon 43

Have an organized CRP (Conference Room Pilot) in advance of go-live.

What To Do Differently?

Customer Spotlight: Hyperion Financial Planning at Colorcon 44

System was built for data input at a department level. This is not efficient for certain data points.

Need different solutions for loading data to various departments at one time.

What To Do Differently?

Customer Spotlight: Hyperion Financial Planning at Colorcon 45

Figure out how to have alternative monthly phasing of P&L items.

There is always room for more planning.

Q & A

46

47

2011 Oracle Titan Award

2012 Oracle Specialized Partner of the Year

2013 Oracle Specialized Partner of the Year

Email: info@kpipartners.com

Web: kpipartners.com/contact

KPI World Headquarters

39899 Balentine Drive

Suite #375

Newark, CA 94560

Phone: (888) 988-4KPI

Contact Us

The Leader In Cloud Applications & Big Data 48

New York, NY

Boston, MA

Chicago, IL

Minneapolis, MN

Los Angeles, CA

San Francisco, CA

North America Offices

Bangalore, India Hyderabad, India

Global Offices

www.kpipartners.com

49