Published on January 6, 2014
Oracle Analytics Case study Jamal Syed - Director, BI
Agenda Introduction Client Profile Engagement Drivers Business Challenges Solution Results Emtec, Inc. Proprietary & Confidential. All rights reserved 2013. 2
Who is Emtec?
Emtec… ‘Big enough to do the work, small enough to care’ EMTEC THE COMPANY • Serving clients for over 46 years • 14 locations, including 8 development centers • Voted One of the Top 100 Places to Work by Crain’s Chicago in 2012 • Our consultants have an average of 14 years of experience. Nearly 45% have advanced certifications • 73% of our PMs, Architects & Consultants worked at Tier 1 consultancies in a previous life • $255M IT Services Provider • Regularly compete & win against larger IT service providers US Locations • Radnor, PA (HQ) • Atlanta, GA • Chicago, IL • Dayton, OH • Fremont, CA • Jacksonville, FL • Herndon, VA • Minneapolis, MN • Springfield, NJ • St. Louis, MO THE WORLD Global Offices • Toronto, Canada • Ottawa, Canada • Pune, India • Bangalore, India Emtec, Inc. Proprietary & Confidential. All rights reserved 2013. • Emtec has completed more than 1,100 Package Application engagements, including: - • Over 1,000 full-time professionals EMTEC AROUND EMTEC SERVICES AT A GLANCE 200+ Oracle ERP clients with more than 415 engagements - 206 EPM / Hyperion & OBIEE clients and 323 engagements - 186 Microsoft clients and more than 255 projects • Emtec is a premier provider of SaaS and Emerging technologies solutions, including 51 Salesforce Clients with more than 75 engagements, Including Sales Cloud, Service Cloud and Custom Cloud • Emtec has performed more than 6.3M hours of application development and maintenance work ranging from Business Analysis to Product Development • Emtec has served more than 565 Infrastructure services clients where we have: - Deployed more than 1.85M servers, personal computers, tablets and mobile devices - Installed or provided more than 925 exabytes of storage (That’s a whole lot…) - Triaged more than 30,000 L1 support incidents - Implemented service management solutions for more than 125 clients 4
Emtec’s five practice areas offer focused solutions to help our clients solve complex business & IT challenges From up-front strategy & consulting all the way to application, infrastructure & procurement services, Emtec’s 1,000 professionals are what makes us special, and we invite you to see the difference for yourself. Consulting Services • IT Strategy & Planning • IT Process Improvement OFFERINGS • IT Performance and Governance • Information Management: − Big Data − Business Intelligence − Analytics • Mobility Solutions • Program and Project Management Package Application Services (PAS) Cloud Technologies Application Development & Management Services (ADMS) Infrastructure Services • Oracle − Fusion − EBS − PeopleSoft − EPM : Including Hyperion − OBIEE • Cloud Strategy & Planning • Portfolio Analysis • IT Service Mgmt. • Salesforce.com Solutions − Sales Cloud − Service Cloud − Marketing Cloud − Force.com • Application Advisory Services • Data Center • Business Application Infrastructure • End User Computing • Microsoft − AX and GP − BI − CRM • Workday • Platforms • Package Application: Development, Maintenance & Support • SAP • Functional: HCM, FM, SCM • Cloud Application Development & Technology • Private Virtual Cloud • Cloud Applications • Product Development • Custom Application Development & Maintenance • Mobile solutions • Quality Assurance & Testing Services PRACTICE FACTS • Managed Services, Capacity Management & Staffing Services • SWAT team of 45 highly skilled Strategists, Architects and Consultants • 10 years of experience and more than 75 projects • 180 Specialists, including Project Managers, Architects, Consultants and Analysts • More than 300 ERP & CRM projects completed • Expert team of Big Data, business intelligence and analytics professionals Emtec, Inc. Proprietary & Confidential. All rights reserved 2013. • Specialized team of 25 Strategists, Project Managers, Architects, and Consultants • More than 90% certified • 62 Customers & 112 engagements 5 • Global workforce of nearly 750 associates (approximately 250 associates based in North America) • Provided more than 6.3M hours of application development and maintenance services. • Special expertise in Business Analysis and Testing (among other things) • More than 100 associates providing data center, compute, network and storage related services • Value Add Reseller providing full device lifecycle management services for more than 30 years • IT Service Mgmt. BU having supported more than 70 distinct clients
Client Profile • A leading healthcare company • Over 40,000 employees and over $36 Billion in revenue • Company markets its health insurance services in all 50 U.S. states, D.C. and Puerto Rico, and has international business interests in Western Europe and Asia. • Growth through mergers and acquisitions Emtec, Inc. Proprietary & Confidential. All rights reserved 2013.
Engagement Drivers •Build a cross-functional reporting platform •Self enablement of business users •Mobile BI capability •Dashboards and reports for quick analysis •Build a foundation for an enterprise BI solution Emtec, Inc. Proprietary & Confidential. All rights reserved 2013.
BI Challenges - Business •Data access: Data is not available when needed by decision makers •Multiple data silos: Access databases pulled data from EBS for departmental BI •Total IT dependency: Reports had to be run by IT against source systems •Excel-based reporting: Only reporting tool for business user •Manual calculations: All KPI calculated manually in Excel •Only static reports: Business users cannot drill into the actual issues •Delay in accessing business critical data: Delays from 2-6 weeks •No standard definitions: Risk of inconsistent calculations and meanings •Multiple reports for same information: Stitching and recalculation efforts Emtec, Inc. Proprietary & Confidential. All rights reserved 2013.
BI Challenges - IT •Disparate data silos: Through acquisitions and multiple data capturing tools, there are several data silos within organization •Poor data quality: No data governance in place on both business and IT side. Data duplication and conflicts are common •IT as reporting warehouse: IT was overwhelmed with all ad-hoc report requirements from business •Multiple reporting tools: 2nd and 3rd generation tools required IT involvement for all report development •Broken stream of data: IT is forced to generate multiple reports for a single request. Business would combine results to form a final report. This would result in multiple versions of truth •Transactional system overload: EBS is overloaded with duplicate report runs on daily basis against live data Emtec, Inc. Proprietary & Confidential. All rights reserved 2013.
Overloaded ERP System DAYS Real-Time Only ~2%! REPORTS Most Real-time Analysis Limited to • a few days • a few users • a few reports Emtec, Inc. Proprietary & Confidential. All rights reserved 2013. 10 Reliance on ERP reporting tools creates a burden on ERP system performance • Multiple reports for similar data set • No real BI capabilities • A lot of IT involvement
Engagement Goal • Single version of truth • Timely data for analysis • BI for everyone • Scalable solution Emtec, Inc. Proprietary & Confidential. All rights reserved 2013.
Single Version of Truth •Establish single version of truth: Build a centralized enterprise information model •Build an information delivery infrastructure: Put the right tools in place to establish the right infrastructure and standards •Build a foundation for a true enterprise data warehouse: Start with the corporate then extend it to the whole organization Emtec, Inc. Proprietary & Confidential. All rights reserved 2013.
Timely Data for Analysis • Enable automated integration of data • Create enterprise wide calculations for specific KPIs • Enable multiple delivery mechanisms Emtec, Inc. Proprietary & Confidential. All rights reserved 2013.
BI for Everyone •Build a self service BI model that enables end users to get to their data on their own, without heavily relying on IT •Provide end users with ad-hoc capability •Replace Excel with a true BI centric toolset •Transform static reports into interactive drillable reports Emtec, Inc. Proprietary & Confidential. All rights reserved 2013.
Scalable Solution • Reportable data mart that can grow to be an enterprise data warehouse • Start with a focus group for quick wins • Expand to rest of the organization one group at a time • Build a framework to extend BI to users who have no exposure to BI Emtec, Inc. Proprietary & Confidential. All rights reserved 2013.
BI Optimization Roadmap Optimization Roadmap Optimizing BI Extend Reach and Capabilities Build a Framework for Enterprise BI Align the Business and IT Govern the Process BI for everyone Build a BICC Establish Accountability Empower the People Improve EndUser Adoption Train EndUsers Leverage Technology Reduce Fragmentation Emtec, Inc. Proprietary & Confidential. All rights reserved 2013. Reduce Pain with Standardization Measure and Communicate Success Manage Change Agile Development for Quick Wins
Solution • Implemented four BI modules – Financials – Procurement & Spend – HR – Projects • SSO with EBS • Security integration and drill back capabilities • Integrated Essbase with EBS data in OBIEE • Implemented Mobile BI Emtec, Inc. Proprietary & Confidential. All rights reserved 2013. 17
Oracle BI Application 1 Integrates Data for Analysis and Reporting • Pre-built integration of data from Oracle EBS, PeopleSoft, Siebel, JD Edwards and other sources into an integrated data warehouse optimized for analysis 2 3 Provides User-Friendly Analytic Model of Enterprise Information and Metrics • Embedded best practice calculations, metrics, and KPIs • Easy for business people to access, analyze, and use the information Delivers Personalized Performance Dashboards for Everyone • Thousands of pre-built dashboards, reports, and alerts by business function and role 2 1 3 18 Emtec, Inc. Proprietary & Confidential. All rights reserved 2013. 18
Results •Common Enterprise Information Model •Self-enabled business users •Executive dashboards •Mobile BI •Business Intelligence Center of Excellence
Questions? Jamal Syed Director, BI Emtec Inc. Jamal.Syed@emtecinc.com (312) 216-6929 Emtec, Inc. Proprietary & Confidential. All rights reserved 2013. 20
Presentación que realice en el Evento Nacional de Gobierno Abierto, realizado los ...
In this presentation we will describe our experience developing with a highly dyna...
Presentation to the LITA Forum 7th November 2014 Albuquerque, NM
Un recorrido por los cambios que nos generará el wearabletech en el futuro
Um paralelo entre as novidades & mercado em Wearable Computing e Tecnologias Assis...
Collaborate 2014: Humana Case Study - Paradigm Shift in Reporting by Deploying Four OBIA Modules Across Enterprise
Humana Case Study: Paradigm Shift in Reporting by Deploying Four OBIA modules across enterprise ... About Us. Board of Directors ...
Humana Case Study: Paradigm Shift in Reporting by Deploying Four OBIA Modules Across Enterprise Presenter: Jamal Syed OBIEE National Practice Lead
Collaborate 2014: Humana Case Study - Paradigm Shift in Reporting by Deploying Four OBIA Modules Across Enterprise
Data Integration with Hyperion and Why this is Imp ... Humana Case Study: Paradigm Shift in Reporting by Deploying Four OBIA Modules Across Enterprise ...
@ 1-800-FLOWERS. 1-800-FLOWERS.COM implements a technology roadmap to provide a single view of the company to its customers. 1-800-FLOWERS.COM. This client ...
... Author: Prestige Media, Name: m2m_now_insight_report ... In some cases this ... It is a tremendous shift in paradigm for utilities to ...
(II) COMMITTEE ON HOMELAND SECURITY AND GOVERNMENTAL AFFAIRS THOMAS R. CARPER, Delaware Chairman CARL LEVIN, Michigan MARK L. PRYOR, Arkansas MARY L ...
Advertising Programmes Business Solutions +Google About Google Google.com © 2016 - Privacy - Terms. Search; Images; Maps; Play; YouTube; News; Gmail ...