Loading in 2 Seconds...
Loading in 2 Seconds...
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
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.
Yahoo Finance EPM: Building a CohesiveHeterogeneous Technical Environment January 17th, 2008 Key Performance Ideas
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 • 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 • Founded 2004 by Hyperion veterans • VC backed software company • Fortune 500 referenceable customers Partial List of Star Analytic’s Customers
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
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 ~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! • 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 • Extract Hyperion Planning data 4x/day with zero downtime • Schedule periodic extracts from Hyperion Applications • Update Oracle Data Warehouse
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 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! 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 • 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 Contact Information • Bob Yau Bob_yau_2000@yahoo.com or LinkedIn • Nate Coate email@example.com (415) 948-3430 • Quinlan Eddy firstname.lastname@example.org (650) 539-4600