BI for e-Governance Unleashing IT Democracy

1. BI for e-Governance Unleashing IT Democracy Rohan Kumar Business Manager – Oracle BI

2. Oracle in Government SolutionsDid You Know? 25 of the top 25 governments get better results with Oracle 15 out of 15 US Federal Cabinet agencies get better results with Oracle 10 out of 15 Major UK Government Departments get better results with Oracle 50 out of the largest 75 UK Local Authorities get better results with Oracle 24 of the top 25 US Cities and 15 of the top 15 US counties get better results with Oracle

3. Process:Top to Bottom Support for Government • Leading Enterprise Software Vendor • #1 in CRM, HCM, EPM, Middleware, and more • Most scalable, reliable, secure infrastructure • Most complete range of on-demand and on-premise deployment options • Built-In Government Solution Capabilities • Government sourcing, procurement contracts • Constituent service via multi-channel contact center and case management • Enterprise tax management including consolidated viewof tax payer • Financial management, human capital management • Largest Software Assistance Team • 64,500 development, support, and services professionals • 145 countries Support& Training Consulting Applications Middleware Database OperatingSystem & VM Servers& Storage

4. Oracle Oracle’s Government Footprint ISV Partners Constituent Channels Self-Service Portals Constituent Outreach Field Service Government Offices Contact Center Overlay Infrastructure for Shared Services Customer & Distribution Channels Analytics & Business Intelligence Service Provider Management Master Data Management Payments & Collections eCommerce Engine Case Management Government Segments Defense* & Intelligence Environment Protection & Resource Management Justice & Public Safety* Public Administration Public Education* Tax/Collections & Revenue Management* Healthcare* & Social Services* Public Infrastructure Economic Development Foreign Relations Administration & Enterprise Management iLearning & Classroom Training Financials / Cash Mgmt Procurement, Contract, and Supply Chain Management Facilities Management & Field Services Automotive Human Resources and Workforce Management Projects, Program Management & GRC Records Management Helpdesk HR IT Infrastructure Mobility Hubs / Data Warehousing Integration Framework / SOA Development Tools Identity & Security Services Networking Database & Security Ext. Operating System Virtual Machine Server Storage Systems & Data Center Mgmt * Separate Industry Footprints Provided

5. Management Excellence : The Next Competitive Edge Smart – Deep Insight Agile – Decisive Action Aligned– Across the Extended Enterprise Competitive Advantage MANAGEMENT EXCELLENCE Cost– Lean and Mean Quality – Six Sigma, TQM Speed – Real-time, JIT OPERATIONAL EXCELLENCE Time 5

6. Government IT – Market Direction 2010 “Funding cuts will dictate the public service agenda..........” 2010 Top Ten Predictions for Europe, Middle East &Africa “……..There will be an increased attention on how money is being spent at all levels of government” “The word for 2010 will be rightsizing, underpinned by government transformation or modernization. Establishing priorities to guide rightsizing efforts will rise to the top of the administrative policy agenda” • In INDIA - Recession Proof • NeGP, JnNURM, APDRP, SDC, • Increase in Governmental Spend “.............Governments will be required to change the way they manage themselves and public money”

7. Public Sector Business Drivers Tough days are coming A year ago... “do MORE with LESS” Now: “do BETTER with LESS... and LESS and LESS...”

8. Public Sector Business Drivers Tough days are coming Keep the public debt under control Support the economy Support the citizen / stakeholders Gain Public Trust

9. Daniel K. Moran said “You can have data without information, but you cannot have information without data”

10. Getting Started with BI • BI – a term borrowed from control panel in airplanes • Government is in the ‘Business of Citizen Support” • Measurable – profit & loss / Social welfare • Fundamental objective is superior delivery of results from Govt. initiative • Exemplary r’ship between Govt. and citizen

11. Usage of BI – Govt. v/s Private

12. Who – What – Why – How

13. Usage of BI – In Government • Increasing Accountability • How can I improve trackingand reporting of public funds? • What is the best way to enforce proper approval and document key decisions / awards? • Fiscal Management • How can we maximize revenue collections without increasing taxes? • What work processes canbe automated to reduce costs? Suppliers CivilianServices Constituents • Citizen Centricity • What is the best way to improve responsiveness to citizen demands? • How should cases be distributed to improve workload and consistency of outcomes? • Data Security and Access • How can I automate collaboration and still protect sensitive data? • What is the best way to provide controlled, remote access to centrally managed information?

14. Challenges for Government by Segment Social Welfare • Shrinking resources require a tight cost management in order to guarantee an efficient delivery of services • When delivering benefits, being able to identify potential fraud is a key point to efficiently consume resources • Social Welfare organisations need to understand what are the right services to invest on • Social Welfare organisations need to know at any moment what they have already spent, what is committed and what still is available. Public Safety • Guarantee that the available resources are adequate to fight crime successfully, and that those resources are used efficiently • It is crucial to understand the trends of crime in order to be able to effectively forecast resource requirements and allocate resources where they are needed, when they are needed • Support to investigations

15. Challenges for Government by Segment Defence • Defence capability and defence readiness measurement • Measurement of contingent risk is critical • Internal service level measurement between Army, Navy, Air Force, Support organisations and industry partners • Increasing importance of internal and external contract monitoring and performance measurement and management • Many countries are increasingly turning to membership of alliances and coalitions such as NATO, EU and the African Union, and are looking to collaborative equipment programs. Membership requires strict management of funds. Government Fiscal Management • Expected revenue need to be assessed with great accuracy. It requires to take into account factors such as price trends, estimation of GDP and debt rate. • The tax gap estimation and tax gap reduction is the main challenge in order to avoid to raise taxes. Being able to identify tax evasion is key.

16. Challenges for Government by Segment Education • Outcomes, performance measurement, financial results, predictive analytics and capacity planning are the hot topics being discussed in education today • The economic challenges and changing demographics are driving the need for more accurate analysis and planning. The key is agility and turnaround time. Local Government • Different standards in each Department, Local Authorities. Need for integrated performance measurement and management. • Many services are under severe financial pressure (e.g. waste disposal, road repairs) • Requirements for fairness, accountability, transparency, efficiency and effectiveness of Local Authority funding • Pressure on local taxes incomes and public safety.

17. e-Health is all over the place!National and regional initiatives Sweden: Developing a National Patient Summary Denmark: New National IT-strategy to standardize EHR´s Canada – Infoway set up to design and procure National EHR - $2 billion of government backing for regional EHR projects Finland: National eHealht-Archives to be established Netherlands: National Switch Hub Russia: 15 Diagnostic Centers project in progress. Plans being developed for national HER for 145 million people. Ireland: Procurement contracting has started to drive national EHR effort China: Plans to develop a national EHR Germany: One regional deal underway. Future EHR efforts are expected to be regional England: EHR initiative in process, PACS project is running in north region USA – Federal ONC NHIN contract underway. Multiple State initiatives for RHIOS. Still emergent – national EHR by 2014 – Obama Stimulus Plan Hong Kong: Territory wide Patient Master Index Spain: Regional initiatives are being considered Singapore: EMR system tender expected Q1 2005 SEE: Bulgaria, Romania, Turkey and Serbia all developing national eHealth strategies. France: EHR mandated by 2007. National RFP has been issued Mexico: No EHR but aim for HL7 Integration – National Disease Surveillance going on Opportunity Status Current Work Italy: EHR regional initiatives have begun Australia: HealthConnect is developing a National Information Network Malaysia: Lifetime Health Record (LRH) by 2010 Planning Brazil: National Health Card Project. Chile: National RFP for EHR project is expected soon Monitor Considering EHR Argentina: 1st adoption of a digital radiography solution- 2004 South Africa: No EHR – but infrastructure being developed New Zealand: National EHR system in place (complete) Data N/A or No EHR Presence * Target opportunities identified by text in red Source: Accenture + Oracle

18. Payer Regulator Employer Payer RegulatoryAgency Government Patient/Consumer Life Sciences Provider Retailer/ Distributor/Wholesaler Hospital/AMC/IDN Biotech Outpatient Care Medical Eqpt Pharmaceutical Tertiary Care BI in Healthcare – Industry TrendsHealthcare information needs are complex, but need single source of data HIS - Hospital Information System Reporting Soln on Clinical Application

19. Typical Healthcare InformationSpanning Operational & Management Excellence

20. BI in State Governance – New York City • Launched on New York City’s website February 2008. • Includes reporting data from more than 40 City agencies and organizations. • Covers reporting periods from July 2002 (Fiscal 2003) to the present. • Data is updated monthly, quarterly, or annually depending on the specific measurement. • There are more than 500 performance measures reported in the CPR tool.

21. City-wide approach - Themes

22. Management Excellence in Local Govt http://www.nyc.gov/html/ops/cpr/html/cpr_home/cpr_home.shtml

23. Sustainability Reporting – NY State http://www.nyc.gov/html/ops/planyc/html/home/home.shtml

24. NYC Stat - Stimulus Tracker http://www.nyc.gov/html/ops/nycstim/html/summary/summary.shtml

25. The Unique Challenges: BI in Government • Mapping Mission to Metric • User Adoption • Intra departmental usage – cut duplicate IT spend • Political Influence – flavor of the season & long term approach

26. Must Have BI Functionality • Dash boarding for City Administrators • Slice & Dice • Drag & Drop (Interactive indicators) • Guided Analytics, Alerts and Ad hoc reporting • Online publishing • Sharing information with the community • Reporting in MS Excel / PDF / PPT / Website your findings aren’t effective till the time it is shared with colleagues/public

27. Must Have BI Functionality • Fast, easy installation • self service by business and not IT • Predictive Analytics • prevention is better than cure • Trial, training & support • Allow citizens to analyze and collaborate in governance

28. Must Have BI Functionality

29. From Warehouse to Workspace Data Sources Data Warehouse BI Foundation (BI Server) Workspace PRESENTATION LAYER • Interactive Dashboards • Ad Hoc Analysis • Reporting & Publishing • Disconnected & Mobile Analytics • Proactive Detection & Alerts • MS Office Integration • Single Database • Multiple schemas, logical separation • Staging Data Layer (SDL) • Foundation Data Layer (FDL) • Access and Performance Layer (APL) • User Roles, Preferences • Simplified View • Logical SQL Interface SEMANTIC OBJECT LAYER • Dimensions • Hierarchies • Measures • Calculations • Aggregation Rules • Time Series Acquire Manage Consume PHYSICAL LAYER • Map Physical Data • Connections • Schema Security

30. Aligning to Strategy

31. Fix Send e-mail alert when a problem is detected Business Intelligence Analyze STRATEGY ANALYSIS E-MAIL ALERT How the Scorecard System Works

32. Escalate Interdepartmental CollaborationAutomate Manual Processes and Share Information Service Agents Other Agencies • Intelligently route workflow requests / approvals, assign activities, and track audit trail • Conveniently and securely access case details and affected party relationships • Efficiently manage case work, associated documents, and knowledge base • Make informed decisions based on an accurate, single source of data Knowledge Base Transaction Info Case details Citizen Info

33. Interdepartmental BI Service &Contact Center ServiceEffectiveness Citizen Satisfaction ResolutionRates Service RepEfficiency Service Cost Churn & Service Trends Marketing Procurement & Spend Fulfillment Management Financials HumanResources Direct / Indirect Spend Buyer Productivity Off Contract Purchases EmployeeExpenses Purchase Cycle Time SupplierPerformance Revenue andBacklog Inventory FulfillmentStatus CustomerStatus Order Cycle Time BOM Analysis Campaign Effectiveness CitizenInsight Product Propensity Loyalty &Attrition Market Basket Analysis Campaign ROI General Ledger Accounts Receivable Accounts Payable Cash Flow Profitability Expense Management Employee Productivity Compensation Compliance Reporting WorkforceProfile RetentionAnalysis Return on Human Capital

34. Government of Uttaranchal - India Consolidates Data • OVERVIEW • Uttaranchal is the 27th state of India with a population of 21 million CUSTOMERPERSPECTIVE The World Bank have funded a project named, Central Data Vault. Citizen data is being collected from multiple departments to be used for a variety of purposes. In addition a multi-purpose household survey is being carried out in 70 urban areas with the information gathered from these activities forming a single citizen repository. • CHALLENGES / OPPORTUNITIES • Difficulty identifying and targeting the “right” citizens for social benefits. The Public Distribution System (PDS) provides food rations to citizens but does not have systems or data to enforce rules: • Death certificates and death dates not shared with PDS resulting in distribution of food inappropriately. • Housing Bureau information not shared with PDS and so families with greater than 4 acres of agricultural land are participating in this benefit. • Pensions are being distributed to citizens who should not qualify • Electoral Department cannot verify date-of-birth for election registration • EXPECTED RESULTS • Only qualified citizens will receive social benefits resulting in a significant decrease in current aid • More accurate payments can be made to qualified senior citizens resulting in significant savings • Age limit enforcement for voter registration • Sharing of key citizen information to all government departments resulting in more focused service and savings • SOLUTIONS • Oracle Customer Data Hub (CDH)