Accelerate your BI Solutions with Oracle's BI Applications

1. Accelerate your BI Solutions with Oracle's BI Applications NorCal OAUG Training Day January 19, 2010

2. Agenda • Introductions • Matthew Vranicar, Vice-President BI/DW, Rolta TUSC • Delivering Successful BI Solutions • The Oracle BI Framework & Tools • Accelerate Your BI Solution Delivery • Customize the BI Applications • Why & How • Summary

3. Rolta – a Global Workforce Worldwide Presence: USACanadaUKGermanyNetherlandsSaudi ArabiaMiddle EastAustralia Worldwide Headquarters: Mumbai 82 offices across India Development and Delivery Centers: MumbaiRiyadhAtlanta Denver Rolta Regional, Branch and Support Offices Rolta UK Ltd. United Kingdom Rolta Canada Ltd. Toronto Rolta Deutschland GmbH Germany Rolta Benelux The Netherlands • Rolta ME FTZE • Dubai Rolta International Inc. Atlanta Rolta India Ltd (Parent Company) Mumbai Rolta Saudi Arabia Ltd Riyadh Rolta Asia Pacific Sydney Rolta US powered by TUSC and Piocon

4. Rolta Facts • 25 years of experience as a Global Company • Forbes list of “Best Under A Billion” companies, 3 consecutive years; ranked among the 100 most valuable companies in India • Annual Revenue of $350M run rate • 26% annual growth rate • Large reseller and service provider for Oracle in North America and Intergraph in India • 5000 Employees total with 600 in North America • Highly selective world-class new hire training institute “Rolta Academy” which supports the training of all new employees

5. The Evolution of Rolta • 1984++: Rolta founded as India-based Engineering firm • Early Joint Ventures and Partnerships fuel growth • Adds OnPoint Geospatial Information System with Orion acquisition • Adds large world-class off-shore capabilities and training center • Jan 2008: Acquired TUSC, “The Oracle Experts” • Provides Oracle System Integrator and VAR practices focused on: • Database Services Remote DBA / Managed Services • Fusion Middleware Oracle E-Business Suite • July 2008: Acquired WhittmanHart Consulting • Adds Hyperion EPM and Essbase • Plus Hosting, Performance Engineering/Testing and initial BI • Jan 2009: Acquired Piocon Technologies • Reinforces Oracle foundation • Award-winning Data Warehousing & Business Intelligence practice

6. Custom Development Fusion Middleware Application Integration Systems Migrations Database Services Operational Support Infrastructure Planning Health Check Upgrade Services BusinessIntelligence Data Warehousing Data Modeling Executive Portals and Dashboards BI Applications Data Mining Security & Architecture Identity & Access Mgmt Enterprise Sys Management Security Info Management Business Service Optimization Rolta TUSC Services and Solutions Planning, Implementation, and Support Services • Describe your core competencies, i.e. VAR, Implementation, Reseller Workshops - Assessments Project Management Oracle Applications Full lifecycle project management Implementation andsupport services Enterprise Performance Mgmt Financial Planning, Budgeting, Consolidation, and Reporting Performance Scorecards Managed Services - Remote DBA & Hosting Global Sourcing Training & Mentoring Software Sales

7. Recognitions and Award-winning Solutions • Oracle Pillar Partner in 3 areas in both NC & SE (NC: BI & Platform/Grid; SE: IdM & Platform/Grid) • Oracle Certified Advantage Partner in 5 areas (DB, EBS, BI, Fusion, SOA) • 2 Oracle Titan Awards in both 2008 and 2007(TUSC and Piocon including Business Intelligence Award) • Hyperion America’s Integrator of the Year – 2005 (WhittmanHart Consulting) • Oracle Partner Solution of the Year – 2004, 2002 • Ernst & Young Entrepreneur of the Year – 2001 "E-developer" • Arthur Andersen-Chicago Best Practices – 1998 "Unleashing the Power of Technology“ • Five Oracle ACEs (4 Directors) • Database App Development • Middleware & SOA (2) • Database Management & Performance

8. Rolta TUSC BI Service Offerings • OFFERING If you need help with… • BI Strategy & Roadmap Alignment with your enterprise goals • BI Discovery Project Level scoping and definition • BI Foundation Project Install, configure, optimize BI environment • BI Project Custom BI & DW solutions • BI Applications Oracle BI Applications implementations • Data Warehousing Star schema, ETL development, optimization • BI Rationalization Consolidating BI tools and platforms • BI POC Quick wins using OBIEE SE1 or even EE+ • BI Competency Center (BICC) Establishing your Center of Excellence • BI Training OWB, BI Publisher, OBIEE • BI Leadership & Assistance Mentoring and staff augmentation

9. Question: What does it take to DELIVER Successful BI solutions?

10. BI Process Framework ROLTA Deliver Results Consume/ Feedback Strategy Roadmap Program Management Current Technology Strategy Business Strategy (Plans, Practices, and Budgets) BI “N State” Vision and Architecture Deliverable Financial Review Foundation Projects “As Is” Technology Environment Risk Review BI Application Projects Business Impact Review “Quick Win” Opportunities “As Is” Application Environment BI Strategy / Roadmap Deliverable BI Industry Trends & Best Practices BusinessInsight / Feedback

11. Rolta TUSC BI Approach – Timeline • BI Roadmap – align solution with strategy • Foundation – establish BI environment • BICC – governance, Center of Excellence, training • BI Project I – Quick-win to deliver ROI and gain user adoption • Support – post-production support • BI Projects II & III – subsequent efforts • Led by Piocon until Client team ready to lead • Governed by BICC

12. Data Warehousing & Business Intelligence The Typical Life-Cycle Data Warehouse / Marts Legacy Operational Single Version of Truth Integrate Operational Insight Foresight ERP External Store, Secure & Manage Access & Analyze Distribute & Share Build/Cleanse End-to-End Business Intelligence System

13. Question: Can you DESCRIBE THE Oracle BI Framework & tools?

14. Oracle BI Framework & Tools Ad-hoc Analysis Interactive Dashboards Search Reporting & Publishing Proactive Detection and Alerts Disconnected & Mobile Analytics MS Office & Outlook Integration Common Enterprise Information Model Integrated Security, User Management, Personalization Multidimensional Calculation and Integration Engine Intelligent Request Generation and Optimized Data Access Services Essbase SAP, Oracle EBS PeopleSoft, Siebel, Custom Apps Files Excel XML OLTP & ODS Systems Data Warehouse Data Mart Business Process

15. Question: How can you accelerate your BI solution delivery?

16. What are the Oracle BI Applications • Oracle’s packaged BI Applications provide: • Pre-built BI solutions, built using typical BI/DW approach • Leverage core BI technologies – OBIEE, ETL • Pervasive, role-based dashboards • Drive decisions based on facts • Aligned with business processes • Based on industry best practices • Integrate data sources and applications • Lower time to market and TCO of BI – increase ROI • Extensible to meet specific business and analytical needs • Fantastic accelerators for BI and DW solutions

17. Oracle BI Applications & the OBIEE Framework Oracle BI Applications Financial HumanResources Procurement & Spend Supply Chain & Order Management Sales Service Contact Center Marketing Project Accounting Ad-hoc Analysis Interactive Dashboards Search Reporting & Publishing Proactive Detection and Alerts Disconnected & Mobile Analytics MS Office & Outlook Integration Oracle BI Server ETL ERP Solutions, e.g. Oracle E-Business Suite Data Mart

18. Pre-built warehouse with 15 star-schemas designed for Financial Analytics 1 Oracle BI Applications – 4 Parts Pre-mapped metadata, including embedded best practice calculations and metrics for Financial, Executives and other Business Users. 3 • Presentation Layer • Logical Business Model • Physical Sources 2 Pre-built ETL to extract data from over 3,000 operational tables and load it into the DW, sourced from Oracle, PSFT, JDE or SAP ERP systems. A “best practice” library of over 350 pre-built metrics, Intelligent Dashboards, Reports and alerts for CFO, Finance Controller, Financial Analyst, AR/AP Managers and Executives 4

19. 3 4 Meta-data Mapping Design & Build Metrics, Dashboards & Reports 1 Analyze, Design & Build D/W and Marts Design & Build ETL 2 Data Warehousing & Business Intelligence The Typical Life-Cycle Accelerated by BI Applications Data Warehouse / Marts Legacy Operational Single Version of Truth Integrate Operational Insight Foresight ERP External Store, Secure & Manage Access & Analyze Distribute & Share Build/Cleanse End-to-End Business Intelligence System

20. BI Applications Demo Business Objectives / Issues Maximize Cash Flow Is DSO on target? Drill to Detail Is Overdue Balances trending up? Gain Insights How long is the underlying Overdue Balance pending? Who are the Customers? Drill to Overdue Invoice Detail Take Action Target collection efforts to reduce overdue balances

21. Question: Why would I Need to Customize the BI applications?

22. More than just dashboards and reportsValue of BI Apps lies under the surface • DASHBOARDS& REPORTS • Prebuilt best practice library • “One size does NOT fit all” • SUBJECT AREAS • Many metrics and dimensional attributes not surfaced by prebuilt dashboards and reports • Possibilities are endless • Incremental work to build exponential content from this foundation

23. Some Reasons to Customize BI Applications • Modify out-of-the-box analytics to meet your business analysis needs • Adding new facts, dimensions, hierachies • Re-format analytic reports to meet user demands • Add additional comparisons • Ensure the quality and completeness of your analysis • Include flex-fields in your analysis • Ensuring all necessary EBS data is included • Confirm the mappings of segments, flex-fields, etc. • Add additional data to your analysis • Include other (non-EBS) data sources to extend analysis • Or, even feed ERP data from unsupported data sources

24. Question: How do I customize the BI Applications?

25. Additional dashboards and reports, guided and conditional navigations, iBots, etc. Dashboards & Reports Easy Additional derived metrics, custom drill paths, exposing extensions in physical, logical and presentation layer, etc. OBIEE Metadata Moderate Extension of DW Schema for extension columns, additional tables, aggregates, indices, etc. DW Schema Intermediate Extension of ETL for extension columns, descriptive flexfields, additional tables, etc. ETL Involved Degree of Customization Level of Effort Typical Effort & Customization balance

26. Customizing Dashboards & Reports • Web-based Dashboard Editor • Answers for reports and analytics • Chart & graph formatting • Tabular reporting • BI Publisher available too • Modifications typically made to support your business processes and analytical needs

27. Customizing OBIEE Metadata • Client based OBIEE Administrative tool • Pre-built aggregates, functions, etc. • Dimensions, measures, facts presented in DW format • Common metadata additions include aggregates and functions • Once added, metadata must be exposed in dashboards/reports

28. Customizing the DW Schema • Star schema format, for DW-type performance • Subject matter focused stars, in data mart fashion • Thousands of tables and 10’s of thousands of columns • Already houses much of your ERP data, some not even exposed in pre-built reports • DW customizations require both metadata and dashboard/report modifications to use data

29. Customizing ETL Code • ETL architecture facilities ease of modification • Source Dependent layer has knowledge of ERP data source • Staging Tables provide standard format • Source Independent has none • Universal Adapter allows you to create ETL from any data source • ETL tool used to modify mappings – Informatica or Oracle Data Integrator (limited) • ETL additions must be exposed in the DAC (Data Warehouse Administration Console) • ETL additions/changes may require DW, Metadata and report mods

30. Summary • Delivering Successful BI solutions requires • BI & DW expertise, experience and a proven approach • A solid, reliable and flexible BI/DW framework • Oracle BI Applications are • Built on Oracle’s core BI platform, OBIEE Plus • Based on industry accepted best practices for BI & DW • Equipped with a complete set of data models, ETL solutions, OBIEE metadata, dashboards and reports • Extensible – at any level – to meet all of your needs • A great accelerator for your BI solutions

31. For help Accelerating your BI success… Contact: Matthew Vranicar Vice-President Business Intelligence and Data Warehousing Rolta TUSC vranicarm@tusc.com 630.607.7401 Office 630.965.1860 Cell