yahoo finance epm building a cohesive heterogeneous technical environment n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Yahoo Finance EPM: Building a Cohesive Heterogeneous Technical Environment PowerPoint Presentation
Download Presentation
Yahoo Finance EPM: Building a Cohesive Heterogeneous Technical Environment

Loading in 2 Seconds...

play fullscreen
1 / 18

Yahoo Finance EPM: Building a Cohesive Heterogeneous Technical Environment - PowerPoint PPT Presentation


  • 97 Views
  • Uploaded on

Yahoo Finance EPM: Building a Cohesive Heterogeneous Technical Environment. January 17 th , 2008. Key Performance Ideas. Agenda. Introductions Application Delivery Lifecycle Yahoo! Corporate Landscape How Yahoo! Supports its Corporate Landscape

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Yahoo Finance EPM: Building a Cohesive Heterogeneous Technical Environment' - alika


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
yahoo finance epm building a cohesive heterogeneous technical environment

Yahoo Finance EPM: Building a CohesiveHeterogeneous Technical Environment

January 17th, 2008

Key

Performance

Ideas

agenda
Agenda
  • Introductions
  • Application Delivery Lifecycle
  • Yahoo! Corporate Landscape
  • How Yahoo! Supports its Corporate Landscape
  • Finance Organizational Requirements Overview
  • Systems Environment
  • Key Performance Ideas - Solutions Delivered and Data Integration
  • Star Analytics at Yahoo!
  • Bob’s 10 Insights and Learnings
  • Q&A
the kpi value proposition
The KPI Value Proposition
  • We are an Oracle partner with specific focus on Hyperion:
    • Hyperion Focus – The Hyperion product suite is the focus of our technical competency
    • Best-of-Breed Expertise – We are capable of augmenting Hyperion with world-class 3rd party tools
    • Proven Track Record – We have successfully implemented a full range of Hyperion solutions
  • Our team has extensive experience with:
    • The Planning Process – We understand the impact of a coherent budget & planning process on the operations and financials of a company
    • Meaningful Business Intelligence – We can help turn your data into useful information for decision making
    • Process Transformation – we understand the importance of engaging the users, not just the technology
    • A Complete Solution – We have all the technical expertise necessary – as well as project management, change management, infrastructure, documentation & training experience to make a project successful
  • You have our commitment:
    • Leadership by our Leaders – Every project is led by hands-on participation of the KPI management team
    • Customer Satisfaction – We are passionate about our customer’s success & helping achieve their goals
    • Ethical & Transparent – KPI is committed to doing business “the right way”
introduction to star analytics
Introduction to Star Analytics
  • Founded 2004 by Hyperion veterans
  • VC backed software company
  • Fortune 500 referenceable customers

Partial List of Star Analytic’s Customers

yahoo business landscape
Yahoo! Business Landscape

Strategic

Investments

Monthly

Legal Entities

3,600,000,000

Partnerships

Publishers

Divestures

Advertisers

184M UV

M&A

Manage

Change!

Highly competitive market

Heightened scrutiny on financials

Large and complex legal structures

corporate applications business intelligence team

HR

Sales &

Marketing

Finance

Decision Support

Corporate Applications – Business Intelligence Team

Unique value of Corporate Applications

  • Align for complete end-to-end integration and highly aligned with complementary providers
  • Specifically focused on Hyperion platform and organized with focused roles
      • Help Desk
      • Operations
      • Development
  • Designed to create value-add for Finance instead of just basic services = business partner role
  • Designed to be a catalyst for change (efficiency & automation)
  • Designed to be strategic partner and “be part of the conversation”
  • Designed to provide process design as well as technical solutions
finance overview
Finance Overview

~375 Global Users

Support – Follow the Sun

  • Operate in multiple currencies (25)
  • Financial forecasting – monthly interval, 8 rolling quarters
  • Actuals reporting – Hyperion
  • 5 tier allocation for functional burdening.
  • 9 year data retention policy
  • Detailed forecasting bottoms up –(named employees) (data gathering vs. data analysis and modeling)
  • Partner and affiliate level forecasting
  • Consolidated reporting - frequency
  • Frequent M&A activity
solutions delivered at yahoo
Solutions Delivered at Yahoo!
  • System 9 Planning
    • Includes Workforce Planning
  • Custom Essbase reporting environment
    • Essbase Analytics (BSO)
    • Enterprise Analytics (ASO)
    • Transparent Partitions
  • Custom FX Solutions
    • As part of 4x daily data movement
    • FX Unlimited
  • Outsourced Operational Administration
  • Outsourced Help Desk
yahoo s data integration requirements
Yahoo!’s Data Integration Requirements
  • Extract Hyperion Planning data 4x/day with zero downtime
  • Schedule periodic extracts from Hyperion Applications
  • Update Oracle Data Warehouse
star integration server sis
Star Integration Server (SIS)
  • Enterprise software suite
  • Unifies information across portfolio of financial analysis applications
  • Shares critical financial information throughout the enterprise
  • Lets businesses safeguard, manage, re-use, and capitalize on critical financial information
  • Enables both historical and near real-time financial reconciliation, compliance, and control
how star integration server sis was used to solve yahoo s needs
How Star Integration Server (SIS) Was Used to Solve Yahoo!’s Needs

Business Intelligence Tools &

Other Reporting Standards

Hyperion Reports

Essbase Analysis

Oracle Data Warehouse

Essbase Reporting Environment

Headcount

OPEX

Revenue

HYPERION PLANNING

star analytics at yahoo
Star Analytics at Yahoo!

Requirements

Capabilities

  • Extract Hyperion Planning data 4x/day
  • Hyperion Planning environment online 24*7
  • Schedule periodic extracts from Hyperion Applications
  • “Data Generating” Hyperion Planning data synchronized with Oracle Data Warehouse
  • Ability to use Essbase ASO for roll-ups and Essbase Planning BSO for R/W and calculation intensive operations
  • Improved reporting with greater adherence to corporate reporting standards
  • Extract Hyperion Planning data 4x/day with zero downtime
  • Schedule periodic extracts from Hyperion Applications
  • Update Oracle Data Warehouse
bob s 10 insights and learning s
Bob’s 10 insights and learning’s
  • Partner partnerships – KPI/ Star Analytics product roadmap
  • Hammer mentality – there are many options (SIS, Perl - balanced with sustainability)
  • Keep it simple – Architecture, Object counts, Servers, Platforms [keep ops simple] (fewer load rules)
  • Automated reconciliations are possible (report script, FSG, Perl)
  • Leverage RDBMS principals – incremental loads, fragmentation, 3rd normal form normalization
  • Run away from temporary development solutions = concrete
  • The “D” word - document
  • Rapid application development (RAD) – really awful design, randomly assembled database
  • Stick with it – process rigor
  • Business partner in business process management (examples: calendar, outline maintenance, M&A)
question answer
Question & Answer

Contact Information

  • Bob Yau

Bob_yau_2000@yahoo.com or LinkedIn

  • Nate Coate

nate@keyperformancideas.com (415) 948-3430

  • Quinlan Eddy

qeddy@staranalytics.com (650) 539-4600