monday, october 2, 2017 case study: american … · • centralized planning and reporting platform...

14
© 2017 Cognizant Monday, October 2, 2017 Case Study: American Institute of Physics’ Shift to Planning and Budgeting Cloud

Upload: vocong

Post on 07-Sep-2018

214 views

Category:

Documents


0 download

TRANSCRIPT

Page 1: Monday, October 2, 2017 Case Study: American … · • Centralized Planning and Reporting platform with mobile and dashboardingcapability • Shifted the Budgeting and Forecasting

© 2017 Cognizant

© 2017 Cognizant

Monday, October 2, 2017

Case Study: American Institute of Physics’ Shift to Planning and Budgeting Cloud

Page 2: Monday, October 2, 2017 Case Study: American … · • Centralized Planning and Reporting platform with mobile and dashboardingcapability • Shifted the Budgeting and Forecasting

© 2017 Cognizant 2

About Cognizant-KBACE

Oracle’s Cloud and other technologies play a critical role in supporting your digital transformation initiatives.

• We are a long term, award winning Oracle partner

• A proven leader in digital transformation

• Launched more than 200 successful projects using the Oracle Cloud

• We have the end-to-end, best practice services, backed by deep industry expertise needed to deliver successful solutions for our clients across:

• Oracle HCM, ERP, SCM, CX, PaaS and IaaS

Page 3: Monday, October 2, 2017 Case Study: American … · • Centralized Planning and Reporting platform with mobile and dashboardingcapability • Shifted the Budgeting and Forecasting

© 2017 Cognizant 3

Today’s Presenters

Emily YeeDirector, Financial Planning & Analysis

Gwendolyn ShawEPM Global Capability Lead

Page 4: Monday, October 2, 2017 Case Study: American … · • Centralized Planning and Reporting platform with mobile and dashboardingcapability • Shifted the Budgeting and Forecasting

© 2017 Cognizant 4

Agenda

AIP Introduction

AIP – Oracle Cloud Footprint

High Level Architecture

Oracle PBCS Implementation

Our Approach

Solution Highlights & Benefits

Q&A

Page 5: Monday, October 2, 2017 Case Study: American … · • Centralized Planning and Reporting platform with mobile and dashboardingcapability • Shifted the Budgeting and Forecasting

© 2017 Cognizant 5

American Institute of Physics Overview

AIP exists to:

• illuminate science;• bring it into the public eye;• underscore its impact on our way of life;• advocate for its broad-based support; and • cultivate a diversity of students in their education

and physical scientists in their career

AIP advances, promotes, and serves the physical sciences for the benefit of humanity.

Page 6: Monday, October 2, 2017 Case Study: American … · • Centralized Planning and Reporting platform with mobile and dashboardingcapability • Shifted the Budgeting and Forecasting

© 2017 Cognizant 6

American Institute of Physics: A Federation

AIP - A Federation of Physical Science Societies

10 Member Societies (~123,300 combined membership)

AAPT American Assoc. of Physics Teachers (7,200)

AAPM American Assoc. of Physicists in Medicine (8,800)

AAS American Astronomical Society (7,400)

ACA American Crystallographic Assoc. (1,200)

Numbers rounded to the nearest 100

AMS American Meteorological Society (12,900)

ASA Acoustical Society of America (6,400)

APS American Physical Society (54,000)

AVS Materials, Interfaces, and Processing (4,000)

OSA The Optical Society (20,000)

SOR Society of Rheology (1400)

Page 7: Monday, October 2, 2017 Case Study: American … · • Centralized Planning and Reporting platform with mobile and dashboardingcapability • Shifted the Budgeting and Forecasting

© 2017 Cognizant 7

Consolidated Financial and Operational Overview2016 ($M)

Investments $144

Total Assets $205

Unrestricted Net Assets $150

Total Revenue $68

AIP Publishing, net $16

AIP Programs, net ($10)

Net Operating Revenue $6

Current Employees 237

Office Locations College Park, MD & Melville, NY

Page 8: Monday, October 2, 2017 Case Study: American … · • Centralized Planning and Reporting platform with mobile and dashboardingcapability • Shifted the Budgeting and Forecasting

© 2017 Cognizant 8

American Institute of Physics Oracle Cloud Footprint

Financial Management Planning & Budgeting

General Ledger

Account Receivables

Fixed Assets

Account Payable

CostManagement

Revenue

Expenses

Reporting

Reporting

Transactional Reporting

Management Reporting

Page 9: Monday, October 2, 2017 Case Study: American … · • Centralized Planning and Reporting platform with mobile and dashboardingcapability • Shifted the Budgeting and Forecasting

© 2017 Cognizant 9

Planning and Budgeting Cloud Solution

Data Forms

Dashboards, Financial Reports & SmartView

Simplified Interface

Identity Management

PBCS Application Reporting

Revenue and Expenses

Smar

t Pus

h

Financials Reporting

Planner Planner

Enter Budget, Forecast or Projections

Planner

Solution Highlights• Centralized EPM budgeting platform• Reduction of budget creation and

consolidation lead time• Enabled Internal Budget Accountability• Automated Intercompany Eliminations

for Budget and Forecast• Automated Allocations Process of

Indirect Expenses• Direct Integration with ERP Cloud

Fusion for Actuals with Drill-through capabilities

• Enabled Direct Write Back of the Budget back to Fusion ERP from PBCS

• Trained Administrator/End Users business users on end-to-end application functionality including Reports creation & Smart View Ad Hoc Analysis

AIP Cloud ERP

Cloud ERP

AR AP

Cash Management FA

Reporting

OTBI BI Publisher FR

Actuals &

Data Management

Budget

Drill Through

Page 10: Monday, October 2, 2017 Case Study: American … · • Centralized Planning and Reporting platform with mobile and dashboardingcapability • Shifted the Budgeting and Forecasting

© 2017 Cognizant

Solution Benefits

Solution Benefits

10

“PBCS Improves the Budgeting Process” – Emily Yee, Director of Finance, AIP

Realized Future State• Centralized Planning and Reporting platform with

mobile and dashboarding capability

• Shifted the Budgeting and Forecasting process to a self service model where Department owners are able to enter, build and report their own Budget data

• Increased Budget and Forecast accountability tracking and visibility through form comments, workflow and Budget versioning

• “Real Time” reporting and analytics capability

• Standardizations of calculations and Budget and Forecast creation process

Current State Challenges• Departments completed an excel template that

was then uploaded by Accounting. Upload took days.

• No centralized way to track notes.

• Reporting was not “real-time”. Departments had to wait several weeks to review their complete budget reports

• Accounting only process

• Accounting often had to resend monthly and/or budget reports to departments since they were lost in e-mail.

• KPIs not tracked centrally. No standardization. No targets

• Had to update all forms, reports and calculations with relevant years every cycle.

• Time-consuming since member inputs in row/column sets were done individually.

• Business Rules existed, but not as flexible.

PBCS shifts the efforts of the Budgeting from data entry and “excel work” to analytics

PBCS improves the Budgeting Process through the standardization of the Budgeting and Planning processes

PBCS provides “real time” reporting for AIP Budget/Forecast Stakeholders

PBCS reduces the Budget cycle through the centralizing data entry and reporting

PBCS empowers the AIP departments to own their Budget performance

PBCS increases visibility and accountability of the Budgeting and Forecasting cycle

Page 11: Monday, October 2, 2017 Case Study: American … · • Centralized Planning and Reporting platform with mobile and dashboardingcapability • Shifted the Budgeting and Forecasting

© 2017 Cognizant 11

Our Approach to the Engagement

Implement & Configure Solution

As-Is Understanding and Future Requirements

Requirements and Design workshops

Enterprise Application Architecture and Requirements

Fit-Gap Analysis, Solution Walkthrough

Design and Solution Overview

Business Requirements Specification (BRS) & Overall Enterprise Structure

Design

Foundation, Alignment to Overall Enterprise Structure Design

BRS updated withFit-Gap Analysis

RequirementTraceability Matrix

Rollout andImplementation Plan Work product per

Deliverable MatrixActivity Group,

Details

Key

Common Design Review Session(s)

Testing and Rollout

Post Production Enhancements

Page 12: Monday, October 2, 2017 Case Study: American … · • Centralized Planning and Reporting platform with mobile and dashboardingcapability • Shifted the Budgeting and Forecasting

© 2017 Cognizant 12

Lessons Learned

• Learn to Walk before you Run: Implementing this new system is a big enough challenge on its own. There is a significant learning curve for all involved. Do not undertake too many changes at once.

• Design Thinking 101: The form design meetings should include end users from multiple departments. They do not think like Accounting and will bring a very different perspective.

• Post-Implementation Dedication and Support is Vital: Similar to a home, you will want to continuously improve your system after it is built. You will also have to troubleshoot problems as they arise. Although you are the owner, you do not have the expertise to make all changes. Be prepared to spend time on this and find a good partner.

Page 13: Monday, October 2, 2017 Case Study: American … · • Centralized Planning and Reporting platform with mobile and dashboardingcapability • Shifted the Budgeting and Forecasting

© 2017 Cognizant 13

Join our leadership at our Digital Innovations Center @ JilliansRequest a meeting now at http://cogniz.at/oow17

Jillian's San Francisco 175 Fourth Street

San Francisco CA 94103415.369.6100

Across from Moscone WestTo download this presentation visit

this page after the show:ADD Your Speaker Page Short URLTBD

Join us at Jillian’s and receive an Ebook version of “What to do When

Machines Do Everything”, by Malcom Frank, Ben Pring, and Paul Roehrig