1 / 18

Yahoo Finance EPM: Building a Cohesive Heterogeneous Technical Environment

Discover key performance ideas and solutions for creating a cohesive and heterogeneous technical environment at Yahoo Finance. Learn about data integration, Star Analytics, and insights for success.

mellington
Download Presentation

Yahoo Finance EPM: Building a Cohesive Heterogeneous Technical Environment

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Yahoo Finance EPM: Building a CohesiveHeterogeneous Technical Environment January 17th, 2008 Key Performance Ideas

  2. 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

  3. 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”

  4. A Partial List of KPI Clients

  5. Introduction to Star Analytics • Founded 2004 by Hyperion veterans • VC backed software company • Fortune 500 referenceable customers Partial List of Star Analytic’s Customers

  6. Yahoo Finance EPM

  7. Application Delivery Fundamentals

  8. 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

  9. 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

  10. 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

  11. Yahoo! Systems Environment

  12. 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

  13. Yahoo!’s Data Integration Requirements • Extract Hyperion Planning data 4x/day with zero downtime • Schedule periodic extracts from Hyperion Applications • Update Oracle Data Warehouse

  14. 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

  15. 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

  16. 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

  17. 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)

  18. 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

More Related