the one oracle project: shared services with oracle e-business suite and bi applications
DESCRIPTION
This is an implementation of Oracle EBS, and OBIEE Applications and SOA as a shared service for 6 local councils in London using Capgemini’s branded T-Gov proposition. This model is a very interesting project aimed at reducing cost and delivering services in a multi-tenanted model which revolutionizes local government delivery of services by ensuring a consistent system and model which will build in a drive for better quality for each council. Other additional councils are now lining up to join in this model.TRANSCRIPT
The One Oracle Project Shared Services with Oracle E-Business Suite and BI Applications Moscone West 2000, 09/25/2013,
Giles Cuthbert
2 Copyright © Capgemini 2013. All Rights Reserved
Presentation Title | Date
Table of Contents
The Situation, and Challenge in London.
The Project and Solution.
The Potential for the Future to add further value.
3 Copyright © Capgemini 2013. All Rights Reserved
Presentation Title | Date
Situation and Context
4 Copyright © Capgemini 2013. All Rights Reserved
Presentation Title | Date
Local Government vs Central
•National Health Service (NHS)
•Social security
•Defence
•Foreign Policy
•Most forms of taxation
Local Government
•Education
•Social services
•Housing
•Planning
•Environment and waste
Central Government
5 Copyright © Capgemini 2013. All Rights Reserved
Presentation Title | Date
London and Local Government
London‟s 32 boroughs: 7.8m people and cover 600 square miles
Comparison
New York City: 8 million people
Los Angeles: 3.8 million people
San Francisco: 800,000 people
6 Copyright © Capgemini 2013. All Rights Reserved
Presentation Title | Date
Greater London Authority
7 Copyright © Capgemini 2013. All Rights Reserved
Presentation Title | Date
The Challenge
8 Copyright © Capgemini 2013. All Rights Reserved
Presentation Title | Date
Starting Position
Organisations have common suppliers and systems
• 4 suppliers providing 28 finance systems in London
• 4 suppliers providing 23 of the procurement systems in London
• 4 suppliers providing 29 of the payroll/HR systems in London
Procuring and managing systems and suppliers as individual boroughs
9 Copyright © Capgemini 2013. All Rights Reserved
Presentation Title | Date
Starting Position
Organisations are not fully utilising all the modules available to them
Organisations are utilising the modules differently
Organisations are not getting the benefits and efficiencies from a fully
integrated solution
Organisations set processes around the systems which are not consistently
applied and which may or may not be efficient
Organisations are using different processes yet deliver exactly the same
services
ICT is one of the main barriers preventing organisations connecting
10 Copyright © Capgemini 2013. All Rights Reserved
Presentation Title | Date
The Solution
11 Copyright © Capgemini 2013. All Rights Reserved
Presentation Title | Date
Project Athena
Three mobilised projects:
• Oracle (6 boroughs, plus 10 possible)
• SAP (2 boroughs)
• Neutral (3 boroughs, plus 16 possible)
May 2
010
?
Individual authorities using:
houses platforms
- standardise
- consolidate
This includes:
- processes
- software modules used
- software
- contract arrangements
- joint procurement
- shared use
Groups create
consolidated
Further consolidationEach group is working
to:
- simplify
- different processes
Local authorities have been
grouped into key software
Programme Athena - The Journey
- different software for HR,
- different modules in each
software
Finance, Procurement
and service hubs
Journey to date
12 Copyright © Capgemini 2013. All Rights Reserved
Presentation Title | Date
One Oracle project - What
Project involving 6 boroughs:
• Lambeth, Brent, Barking & Dagenham, Croydon, Havering and Lewisham
• 1 additional borough in progress with other potential additions
Implementing:
• Oracle E-Business suite (HR, Payroll, Projects, Financials, Procurement)
• Oracle BI Applications.
Working together towards establishing a shared service for finance and
procurement transactional processing and HR transactional processing
services; all delivered using Oracle E-Business Suite Release 12
13 Copyright © Capgemini 2013. All Rights Reserved
Presentation Title | Date
One Oracle project - How
Various work packages set out scope and concepts agreed by Governance
Board
Strong Leadership and Governance
Gathering core information e.g. interfaces, modules
Sharing ―as is‖ and developing ―to be‖ processes
Scoping the options and discussing the features
Gathering metrics
Agreeing principles
Identifying quick wins
14 Copyright © Capgemini 2013. All Rights Reserved
Presentation Title | Date
We will work together to deliver a
common system for Local authorities,
adopting best practice and efficient
process, maximising the benefits from
One Oracle.
We
- Barking & Dagenham
- Brent
- Croydon
- Havering
- Lambeth
- Lewisham
- Capgemini
Together
- Collaborative working
- Joint decisions
- Leading cross-council working
- Innovative
- Shared outcomes
Common system
- t-Gov
- Better value for money
- Vanilla version
- Standardised process
- Modern working practices
Local authorities
- Tier 1 Councils
- Tier 2 Councils
- Joint Services
- Athena
Best practice - Local government specific
- t-Gov proven - Ensures compliance and control
- Councils pooling knowledge
Efficient process
- Effective and efficient ways of working
- Modern and future proofed
- Aligned processes
Benefits - Cost and efficiency savings
- Lower running costs
- Responsive
- Modern working practices
- Control & Compliance
One Oracle
- ERP programme (R.12)
- Finance, Procurement, Human Resources, Payroll & Business Reporting
One Oracle Programme vision
15 Copyright © Capgemini 2013. All Rights Reserved
Presentation Title | Date
Design Principles
Capgemini has implemented similar solutions for local government before
We proceeded directly to Solution Validation
A large 3 day workshop with over 100 attendees
Walkthrough end-to-end processes agreed during solution validation to gain support and agreement to the solution. Highlight key design decisions and discuss as appropriate.
Highlight key Organisation Impacts and how they will be addressed for each Council
Sign off solution
Templatised PDD and Design
Solution Validation
event
Sign off in principle
Action plan to close issues Build
16 Copyright © Capgemini 2013. All Rights Reserved
Presentation Title | Date
Where decision making happens
Joint
Partnership
Board
Joint
Design
Authority
Project
Boards
Project
Managers
Escalated
Programme
risks / issues
weekly update
risks / issues
(Council)
Working Groups
recommendations
Change
requests
weekly update
risks / issues
Joint
Commercial
Board
Capgemini Programme Councils
Change Requests
Consultants
Design
Issues
Options and Recommendations
CMT
17 Copyright © Capgemini 2013. All Rights Reserved
Presentation Title | Date
Governance Structure
B&D
Lam
Lew
Croy
Hav
Bre
Human Resources
Payroll
Finance
Procurement
Technical
Organisational Change
Reporting
Joint
Partnership
Board
Programme Executive
Joint
Design
Authority
Project
Board
Project
Board
Project
Board
Project
Board
Project
Board
Project
Board
Joint
Commercial
Board
Six separately accoutable Councils have committed to ‗share‘ workload and decisions.
The governance structure divides into two distinct elements: an element which is shared between Councils and another which is devolved, as shown right.
The workshare in the shared element is split across Councils through the formation of working groups and other joint bodies.
The joint governance, to which every Council makes a contribution is shown in grey whilst those which remain devolved are shown in purple.
Wo
rkin
g G
rou
ps
18 Copyright © Capgemini 2013. All Rights Reserved
Presentation Title | Date
Process followed for BI:
Data warehouse requirements and report
themes identified.
Workshops held to refine requirements
with all functional work streams:
Procurement
Financials
Projects
HR/Payroll.
19 Copyright © Capgemini 2013. All Rights Reserved
Presentation Title | Date
The Future
20 Copyright © Capgemini 2013. All Rights Reserved
Presentation Title | Date
More councils
One More in progress
21 Copyright © Capgemini 2013. All Rights Reserved
Presentation Title | Date
City Operation Roadmap to Cloud
Private Cloud
• Self-service
• Auto-scaling
• Metering & chargeback
• Capacity planning
Public Cloud
• Specialized
• Shared
• Standardized
Hybrid Cloud
• Federation across public & private clouds
• Interoperability
• Cloudbursting
Traditional Silos Consolidated
• Physical
• Dedicated
• Static
• Heterogeneous
• Virtual
• Shared platform & shared infrastructure
• Dynamic
• Standardized platform & infrastructure
Start with consolidation • Extend to private cloud • Use public cloud where
appropriate
Copyright © Capgemini 2012. All Rights Reserved 22
Our market is changing — rather rapidly
95% Traditional
5% Non-Traditional
Now 2015
Non-Traditional Business
“50% of services in
the cloud by 2015” UK Gov
„BAU‟ Under Threat:
Competitive pressure – client budgets
Clients buy ‗inputs‘
RFP processes – reactive
Bottom-up pricing
End of ‗big long deals‘
Response:
Cut (BD) costs
Industrialise (rightshore)
Our business mix
Characteristics:
Outcomes focused
Deal shaping
Multi-party
New business/commercial
models
Cloud/aaS/Shared service
Traditional Business
What actions do we need to take us “over the line”, and how different is the
world on the other side?
...a fundamental shift in business model; a fundamental shift in incentives and behaviours;
a fundamental shift in market interaction
The thesis is that this shift holds significant potential in Cities
Copyright © Capgemini 2012. All Rights Reserved 23
Capgemini‘s Cities model provides a sound basis to describe the scope, and engage the market
Integrating solutions across multiple domains to transform city outcomes
Sustained Collaborative Leadership
Digitisation &
Innovation
Smart Buildings
Digital Utilities
Digital Cities
Electric Vehicles
Community Generation Smart Meter
Smart Grid
Connectivity Security
Learning
Economy Place
Public Administration
Health & Social Care
Mobility
Sustainability Customer Insight &
Engagement
Copyright © Capgemini 2012. All Rights Reserved 24
―Solution Frameworks‖ offer structure, method, and (IP) ‗apps‘ to aggregate demand and accelerate value
Urban Mobility
Transform 12
way energy chain
IT Landscape
Rationalisation
City Leadership
Major Event Mgmt
Health & Wellbeing
Business Friendliness Community Safety
Customer Access
Customer Insight Public Lighting
―In-Touch Gov‖
Asset Mgmt
Technical
Masterplan
• Partners: Group Partners strategic
plan; Vanto Ldshp align’t
• Acceltr: City Leadership Model
• Platform: IBM Max-aaS • IP: iNotify ; MyWoCo
• IP:Senda; Harmonav; Parkering
• IP: Ms Care Optimiser
• IP: iBABS • Acceltrs: e.g. ‘Total Place’
Counting; Channel Optimiser; Service Evaluation f’work; RFSC...
• IP: InSieme • Acceltr: Customer Insight; • Community Signature;
Spigit; (BIM) visualisation
• IP: Immediate; CVQ • Acceltr: Architecture
• IP: ALERT!; CCTV-Analytics (in process w/IBM)
• Acceltr: TNO blueprint
• Acceltr: BSP design • (IP in process w/Ms)
• Partners: IBM; Cisco • Acceltr: in devlpt
• Acceltr: WARP
• Cases: Rome • Acceltr: Open Data
Portal
• Case: Texel
• IP: SESP/IOC (IEM); iNotify
• Partners
25 Copyright © Capgemini 2013. All Rights Reserved
Presentation Title | Date
Oracle City Platform
City
Service
City
Operation
City
Infrastructure
Citizen
Empowerment
Business
Productivity
Sustainable
City
26 Copyright © Capgemini 2013. All Rights Reserved
Presentation Title | Date
City Operation Command and Control Center
Geographical, Spatial insight
Business Intelligence & Analysis
Closed Loop
Real-Time Emergency Management
Operational Planning & Control
Across departments and agencies
Risk profiling
24x7 in Control of the City
27 Copyright © Capgemini 2013. All Rights Reserved
Presentation Title | Date
City Operation Reporting Center
Sustainability Reporting
Transparancy to Citizens
Accountability
Impact of policies
Open Data for Constituents
Smarter City Taxation
Optimal use of Resources
Operational Planning & Control
28 Copyright © Capgemini 2013. All Rights Reserved
Presentation Title | Date
Contact information
Name
Last Name Title/Role
Capgemini Office (Optional) Address Line 1
Address Line 2
Address Line 3
Insert
contact
picture
Insert
contact
picture
Insert
contact
picture
Insert
contact
picture
Name
Last Name Title/Role
Capgemini Office (Optional) Address Line 1
Address Line 2
Address Line 3
Name
Last Name Title/Role
Capgemini Office (Optional) Address Line 1
Address Line 2
Address Line 3
Name
Last Name Title/Role
Capgemini Office (Optional) Address Line 1
Address Line 2
Address Line 3
www.capgemini.com
The information contained in this presentation is proprietary.
Copyright © 2013 Capgemini. All rights reserved.
Rightshore® is a trademark belonging to Capgemini.
About Capgemini
With more than 125,000 people in 44 countries, Capgemini is one
of the world's foremost providers of consulting, technology and
outsourcing services. The Group reported 2012 global revenues
of EUR 10.3 billion.
Together with its clients, Capgemini creates and delivers
business and technology solutions that fit their needs and drive
the results they want. A deeply multicultural organization,
Capgemini has developed its own way of working, the
Collaborative Business Experience™, and draws on Rightshore®,
its worldwide delivery model.
Learn more about us at www.capgemini.com.