Transcription
Oracle Business IntelligenceforNorCalOAUG
TUSC–Overview HQ in Chicago since 1988 300 Consultants 20 years experience providing IT solutions tothousands of companies 2000 Clients Oracle Certified Advantage Partner–Applications and Technology Purchased by Rolta in Jan 2008 Purchased WhittmanHart Consulting in Aug 2008 Purchased Piocon in Jan, 2009May 09 / Slide 2 / Title of Document
TUSC–Core Service Areas Oracle Applications Implementation and Support Hyperion Implementation and Support Managed Services -- Remote DBA Support Oracle and Open Systems Development Oracle DBA and Database Services Oracle Infrastructure Services Oracle Business Intelligenceand Data Warehouse Development Oracle Identity Management Services Oracle Training Oracle Product SalesMay 09 / Slide 3 / Title of Document
Piocon – Overview Oracle Business Intelligence Experts since 1993 2 Time Award Winner 2008 Titan Award Winner - Business Intelligence 2007 Titan Award Winner – Industry Solution Now a part of the Rolta & TUSC family With 6 Titan Awards between us!
Rolta – a Global rlandsSaudi ArabiaMiddle EastAustraliaWorldwideHeadquarters:MumbaiRolta Canada Ltd.TorontoRolta UK Ltd.United KingdomRolta BeneluxTheNetherlandsRolta International Inc.AtlantaRolta Regional, Branchand Support OfficesRolta Deutschland GmbHGermanyRolta MEFTZEDubaiRolta Saudi Arabia LtdRiyadhRolta India Ltd(Parent Company)Mumbai82 officesacross IndiaDevelopmentand DeliveryCenters:MumbaiRiyadhAtlantaDenverRolta AsiaPacificSydneyRolta US powered byTUSC and PioconMay 09 / Slide 5 / BI
BIDW Success Stories IPSCO / SSAB BI Roadmap of 2 year projects, w/ multiple BI Projectsdeployed A.M. Castle OBIEE custom development, BI Apps buy vs buildassessment
BIDW Success Stories Chevron Pascagoula Refinery Intelligence Operational Excellence & Reliability Intelligence, globalroll-out Pascagoula OBIEE Dashboards – replaced Crystal Reports Continuing VCA Antech - Santa Monica OBIEE custom development BI Publisher Lab Test Reporting Sales Rep Account Tracking
IPSCO Highlights Started in November 2005 with a Roadmap project Laid out BI Vision, 2006 / 2007 plans Delivered BI Infrastructure early 2006 Delivered Executive Dashboard early 2006 Delivered Procurement Analytics in late 2006
BI Process trategy“As Is”TechnologyEnvironment“As Is”ApplicationEnvironmentConsume/FeedbackProgram ManagementBI “N State”Vision andArchitectureDeliverableBI Strategy ewBI ApplicationProjectsRisk Review“Quick Win”OpportunitiesBI IndustryTrends & BestPracticesBusiness Insight / FeedbackMay 09 / Slide 9 / TUSC OverviewBusinessImpact Review
IPSCO BI ‘N State’ VisionOtherInternalDataExternalDataBusiness ActivityMonitoring (BAM)ProcessAlertsBAM Event Delivery andDisplayten esEv ssageMLocalOperationalData StoreEvent Messages esgssaMetenEvETL / Data Quality FirewallL1,L2,L3SystemsDashboardsand irelessDeliveryDataWarehouseEmailPartners &CustomersSuppliersEnterprise PortalAuditing andReconciliationProcess
2006 IPSCO BI Roadmap TimelineJan 06Feb 06Mar 06Apr 06May 06Jun 06Jul 06Aug 06Sep 06Oct 06Nov 06Dec 06Deploy BIEnvironmentNew Data ModelDashboardPhase I:Foundation ProjectsAd-HocExt Data LoadPhase II 2007 RoadmapPhase II:Prioritized BI ProjectsProcurement Analytics11
IPSCO 2007 BI Project TimelineJan 07Feb 07Mar 07Apr 07May 07June 07Jul 07Aug 07Sep 07Oct 07NS Exec Dash 1NS Exec Dash 2NS PARSBI PARS P2Scrap (SMS)Capital Spend RFECorporate, Coil,TransportationQuality BI Phase 1Quality BI Phase 2BICC / Maintenance ------------------- 2/5/0712Nov 07Dec 07
IPSCO Procurement Analytics “Poweruser” focus In-depthanalysis Sharableworksheets
AM Castle Highlights Started in late 2006 with an assessment of BI Apps Selected build (vs buy) Delivered BI Infrastructure early 2007 Delivered BI application covering FinanceInventorySalesTremendous praise from customer’s user base
AM Castle SolutionData tory GL BalancesHistoryJournalEntriesOracle ApplicationsSalesInventoryFinanceAP Invoices
Chevron Highlights - 200716 April - Collaborate ’07 (National Event) August – begin Discovery project December – deliver first iteration Data Warehouse /Reliability Dashboard On-time / On-budget Provided an intuitive tool to support URIP Tremendous business-side buy in
Chevron Highlights - 200817 Selected as the corporate solution for reliability brief /dashboard (URIP) March through May – Discovery and Design for remaining 7refineries worldwide During this process, Piocon solution was also selected as thestandard for Operational Excellence effort URB and OE projects were combined into one August – Began work on first refinery
Project Deliverables Refinery 1 Data Warehouse Reliability Intelligence Dashboard ETL ProcessesIndividual URB MetricsUser Input Screens (APEX)Automated URB reports BI PublisherJava merging application18
Chevron’s General ETL ProcessApprox. 80 staging ETLsApprox. 60 warehouse ETLs1919
Reliability DW Project Source SystemsIntelatracOperatorRoutine DutiesSAP PMPi / XANSProcessMonitoring20PassportCMMS(Maximo coming)Chevron’s ReliabilityData WarehouseTLRTemporaryLeak RepairMeridiumReliabilityPrimaveraMOCManagement ofChange
RI Dashboard Highly intuitive Supported process thatallowed for collaborativeand horizontal work effort Individual chart metrics Tremendous value inachieving URIP goals21
VCA Antech Santa Monica, Ca
VCA Antech – Santa Monica, Ca VCA Antech - Santa Monica 1B Public Company- “WOOF” 500 Veterinary Clinics in the US (VCA) 70% of all Vet Medical Lab Tests in US (Antech) Home Grown Systems Home Grown Data Warehouse Oracle Database Disco for Reports – Wanted More – Chose OBIEE And BI Publisher to replace Oracle Reports
VCA Antech – Santa Monica, Ca VCA Antech – OBIEE Usage since July ’08 8 Week POC - Develop 5 Reports – IT Sponsored CFO, COO, VP Sales became Sponsors Lab Test Results by Lab Lab Test Analysis by Veterinarian by Sales Rep Pet Disease Tracking with Google MapsSales Analysis by Sales Rep by Veterinarian Daily Tracking of Test Purchases by Veterinarian Sales analysis by Rep by Vet with Google Maps
Drilldown
Usage Tracking
Client Samplewww.tusc.com
Contact InformationEric Camplinecamplin@piocon.com(630) 607-7401Hank Deckerdeckerh@tusc.com(626) 432-5423www.tusc.comSlide 30 / BI Rationalization
Disco for Reports –Wanted More –Chose OBIEE And BI Publisher to replace Oracle Reports. VCA Antech –Santa Monica, Ca VCA Antech –OBIEE Usage since July ’08 8 Week
