1 / 31

Case Study:

Case Study:. The Business Case for Conversion as a Service ( CaaS ). Beer vs Wine consumption in Australia?. 331 standard drinks of beer each year compared to 304 glasses of wine. About UXC Red Rock. UXC Red Rock is the part of the UXC group of companies.

val
Download Presentation

Case Study:

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. Case Study: The Business Case for Conversion as a Service (CaaS)

  2. Beer vs Wine consumption in Australia? 331 standard drinks of beer each year compared to 304 glasses of wine

  3. About UXC Red Rock • UXC Red Rock is the part of the UXC group of companies. • UXC is an Australia listed company and the second largest System Integrator in Australia. The largest Australian owned integrator. 1100+ staff. • Global Leader across Microsoft, Oracle, and SAP. • UXC Red Rock specializes in the Oracle technology stack since 1989. • 500+ employees, 150 customers. • #1 Oracle BI Applications team in Australia / New Zealand. Fastest growing Business Unit • 25%-65% p.a.

  4. Recent Engagements

  5. Agenda

  6. TWE Project Introduction

  7. Brand Business Units

  8. History • February 2009 – Foster’s Launch of Wine Strategic Review – structural separation of Australian beer and wine business • 2010 - Foster’s wine business is named Treasury Wine Estates • May 2011 - Treasury Wine Estates becomes a stand-alone listed company following the Foster’s demerger • December 2012 –IT Separation of CUB and TWE completed. • The new ERP and OBI environment enabled separation of the two businesses. • Network, Infrastructure, Contracts and Applications split globally.

  9. Initial State Information Financial Management Data Integration PL\SQL OLTP CRM ERP HRMS

  10. Initial State Information Financial Management Data • OBI Analytics Implementations • Financial Analytics • Fixed Assets • Job Costing • Procurement and Spend • Supply Chain • Manufacturing (Custom) • Sales (Partially Custom) Integration PL\SQL OLTP CRM ERP HRMS

  11. Target State Information Financial Management Data Integration OLTP CRM ERP HRMS

  12. Our Challenges and Response Strategies Challenge • Moved to a global IT model to support the business change. • Establish Global Views of Information • Standardising on OBI as a DW and Reporting platform • Standardising on Informatica as an ETL and DQ platform • Establishing a Global Data Warehouse on OBI/A • Moving to OBI EE as standard reporting platform globally. • Retiring regional reporting platforms.

  13. Our Challenges and Response Tactics Strategies • Establish OBI EE as the global reporting platform. • Retrain IT and Business in OBI • Convert all non OBI, Microsoft Reporting systems to OBI EE (CaaS). • Replace Microsoft Reporting Services \ Analytics with OBI. • Deliver global reporting requirements into OBI/A • Place legacy systems in read only • Standardise on OBI EE platform • Upgrade OBI EE to latest version for improved functionality and mobility (ipads)

  14. Case Study: Scope Update the OBI Platform to latest version OBI 11g Conversion of Legacy Technology Crystal Reports -> BI Publisher BOXI Dashboards and Reports -> OBIEE Universes -> OBI Repository Training / Change Management Re-skilling Business in OBI

  15. Conversion of Legacy TechnologyWhat are we doing? Initial Phase BI Publisher OBIEE Crystal Reports Business Objects XI Oracle 9i. VDW (5TB DW) Oracle 11g. VDW (5TB DW) Oracle Business Applications Warehouse Transactional systems Transactional systems

  16. Conversion of Legacy Technology Timeframe Aggressive Resources / Team Mixture of on-site (1.5 FT resources) + offshore (distributed team) Offshore team with different specialised sub-teams: OBIEE metadata, BI Publisher, Reports/Dashboards Scope / Prioritisation Selecting key elements for migration Tools / Partners Dynasoft Risk mitigation strategies: communication, frequent releases, code review sessions

  17. Conversion of Legacy TechnologyScope # of Universes: 11 3 high-complexity Universes, including multiple data sources. # of Reports: 67 55 webi reports, each of these converted to OBIEE dashboards (approx 200 individual Answers analyses) 12 Crystal reports, converted to BI Publisher reports.

  18. Tools / PartnersUXC Red Rock – Dynasoft: collaboration Dynasoft UXC Red Rock TWE Low-cost, high-quality solution • QA • PM • Conversion Tool • Unit Testing • Coordination • Requirements • Environments • Strategic value • add activities

  19. Typical Daily Activities Australia Problem resolution / clarifications from previous day Testing morning afternoon India Issues Register Status Reports Build Activities morning afternoon US PM QA Issues Register Status Reports afternoon morning

  20. Conversion as a Service (CaaS) Benefits

  21. Conversion as a Service Cost Comparison

  22. About dynasoft • Dynasoft has been in Oracle ebusiness suite and Business Intelligence software consulting and conversion business since 2009. • CAAS – Conversion Application As Service. Dynasoft automates conversion of reports and metadata. Turnkey solution with guarantee of pixel to pixel reports conversion. • Operations are based in California and offshore services in India. • Global referable customers are available to share customer experiences. • CAAS – Conversion Application As Service.

  23. Conversion engine Converts various BI products • OBIEE / BI Publisher • (11g)

  24. Conversion Automation advantages • Consistency - Same look and feel in every single report converted achieved with automation in conversion. • Bulk processing – Conversion of large volume of reports in bulk processing mode. • Accuracy and speed – Tool converts with very low human interaction. • Cost – With the speed we save time and savings in time will translate to cost. • Experience – Dynasoft has converted 1000’s of reports with real time customers. • Pay as you accept – Milestone payments. There is no large upfront investment. • Transparency – Dynasoft group and classify the reports and costing information upfront.

  25. Data source Independence Sequential File Databases Any DATA SOURCE SOURCE TECHNOLOGY DYNAFLUX* CONVERSION ENGINE OBIEE CURRENT REPORTS NEW REPORTS Apples to Apples comparison

  26. CAAS - Conversion Application As Service DYNASOFT CONVERSION AS SERVICE SOURCE TECHNOLOGY OBIEE / 11i BI Publisher CONVERSION Extract Convert Publish CURRENT REPORTS CONVERTED REPORTS Quality Assurance Project Management

  27. Conversion step by step approach • Customer saves the reports and uploads to secured FTP server. • Dynasoft conversion specialist in onshore / offshore converts reports using unique proprietary tool. • Dynasoft team of QA analyst validate reports by comparing to source and target for data and presentation consistencies. • Dynasoft team deploys into customer preferred server. • Customer performs internal validation in IT as well with business users. • Dynasoft team performs full scale project management on number of reports converted and monitors the delivery time lines.

  28. Automation benefits One year project reduced to 3 months. $10,000 cost reduced to $3500. RESTRICTED

  29. Question 1.Which Australian wine won a 100 point (perfect score) in the Wine Advocate? www.redrock.net.au+614 0484 8615vellap@redrock.net.au www.dynasoftusa.com510-304-2381jmurugan@dynasoftusa.com

  30. Question 2.What is the name of the product that Dynasoft uses to convert BI models between Technologies? www.redrock.net.au+614 0484 8615vellap@redrock.net.au www.dynasoftusa.com510-304-2381jmurugan@dynasoftusa.com

  31. ContactWe can provide US based multiple customer references.FREE POC – We take sample of one or two reports and provide free conversion. www.redrock.net.au+614 0484 8615vellap@redrock.net.au www.dynasoftusa.com510-304-2381jmurugan@dynasoftusa.com

More Related