Outpace competition

with real-time responses

Gavin Targonski

Director - Sales & Business Development - EMEA

26th Oct 2017

© confidential 2

Industry

challenges

IT Challenges

• Exponential data growth

• Data Silos

• Inherent data latency

• High cost

• Combine variety of data sets

Business Needs

• Right information to right

user at right time

• Access information in real

time

• Unified business views

from all sources

• Time to market

Issues

Delays Costly Lack of

Trust

Poor

Scalability

Outdated

Data

© confidential 3

Problem -

building DWH the old way

• Specifications

• Profile

• Logical Model

• Physical

Model

• Create tables

• Build ETL

• Unit Test

• Integrate test

• System Test

• UAT

• Build

Deployment

• Validate

• Promote to

production

Ready to

Build

Build Test Deploy

• Efforts to Identify physical copies to be

removed

• Develop additional programs to remove

physical copies

• High cost to implement small changes

• Longer period to implement small changes

• Identify multiple skills to implement change

• Provision test environments

IT - Impact

• Significant delay in Business transformation

programs

• Business need to wait for data (12 hours to 48

hours)

• 3 to 6 months waiting time to bring new

functionality

Business impact

© confidential 4

Need - unified reusable view for

real time data access

Data

Virtualization

Co

ns

um

ers

In-Memory

Fabric

SQL (JDBC/ODBC, Other), RESTful Web Services, SOAP, JMS, etc

Reporting Data Science API Gateways

Cache

So

urc

es

ERP

MDM

Mainframe

Multi

Dimensional

OLAP

Unstructured Semi

Structure

• Access various sources

data in real time

• Combine various types of

data (structured,

unstructured, semi

structured data)

• Ability to connect various

types of applications

• Ability to transform data

as per business

requirements

• Support Data Governance

initiatives

• Support Role level and

Row level data security

requirements

• Support Data Lineage

• Ability to meet Non-

Functional Requirements

such as Performance

© confidential 5

Benefits - unified reusable view

for real time data access

Faster time to

market

• New sources can be configured

in days

• 100’s of application entities can

be integrated in weeks

• New business functionality can

be added in weeks

• Existing functionality allows to

bring various types of sources

• Pre-built in functionality to

support Agile development

• Approximately 40% to 60% of

cost savings from development

• Approximately 30% to 40% of

test cycle reduction results cost

saving

• Operational cost reduction by

40% by eliminating possible

physical copies

• Zero cost to remove physical

copies

• Automatic query re-writing

• Dynamic query optimizer

• Query pushdown

• On-The-Fly-Data-Movement

• Caching

ExecutionOptimized cost

© confidential 6

..Leverage wipro’s in-house accelerators and

frameworks for speed up delivery

Unified framework

Customer 360

• Leveraged Banking

Customer Data Model

• Leverage Communication

Customer Data Model

Asset 360

• Leverage Asset Data Model

NextGen DI™

Wipro’s transformation tool

• Identification of Integration

patterns to automate Integration

creation in bulk

• Provides UI to configure &

operate

• Design pattern based approach

to automate the development

• Analysis & migration

Cook Book

• Reference Architecture

• Implementation approaches

• Review check list

• Learnings, Possible mitigation

options

• Common problems, solutions

• Re-usable frameworks

Smart Data Validation

• Extensive usage for Regression

test execution facilitating

DevOps, CICD methodologies

• 100% Data validation with

complete coverage on Test

cases, test execution, data

• Batch execution – Scheduler to

trigger test execution with no

manual intervention

© confidential 7

Success stories - large energy

customerKey Achievements

250+ Sources integrated

200+ Consumption application

Real time and Batch applications

based on business need

1000+ concurrent business users

Combine various formats

(Ex: RDBMS, XML, Excel, Big Data

Sources)

Publish Information as a service in

various formats

(Ex: JDBC, Rest API)

Achieved all non-functional

requirements (Ex: Data delivery

SLA’s, High Availability, Operations)

© confidential 8

Success stories - global pharmaceuticals, eye

care and generics customer

WEB

INTERFACEMobile

interface

cloud

interface

B2B

interface

API Gateway

Hadoop Cluster

HDFS Files

ERP ExcelDWH

Key

Achievements

Real time data access through API

Gateway

Read-Write operations from various touch

points to ERP and Data Lake

24/7 Support for 30+ customer markets

Combine various applications data (Ex:

Oracle applications, Teradata, XML,

Excel, Big Data Sources)

Publish Information as a service for

various touch points like Mobile, Cloud,

B2B applications

Meet all non-functional requirements (Ex:

Data delivery SLA’s, High Availability,

Operations

Data

Virtualization

© confidential 9

Success Stories - Multi channel customer

Service for a large Financial company

KANA Agent

Desktop

CAPITA

CCM Desktop

SOA Services

Data Services

KANA CCMCCM

Archive

Access

OneOCDB

Unified view of Case and contact history

Key Achievements

• Data virtualisation technology to create a virtualised

view of case and contact history across multiple

heterogeneous data sources

• Agents can read customer master attributes and write

customer feedback on real time to the OLTP systems

• 24/7 Support for 18+ customer markets

• Meet all non-functional requirements (Ex: Data delivery

SLA’s, High Availability, Operations

© confidential 10

Success stories -

functional use cases

Customer

Experience

Management

• A much wider view

of integrated data

with capability to

integrate structured

& unstructured data

• An ability to connect

and virtualize multi-

structured enterprise

data for canonical

views with single

version of definitions

providing greater

success to Data

Governance

initiatives

Data Governance

Initiatives

• Enables an efficient,

faster and cost

effective way of data

integration of varying

data sources

providing significant

functional value to

the Risk and

Compliance

initiatives

Risk and

Compliance

• Providing an efficient

and faster way of

enterprise data

integration, the 3600

view of many key

entities can be taken

up and can be

achieved at reduced

times and budgets

3600 view of

Enterprise Data

Entities:

• Faster turnaround

times providing

quick wins and

prototypes of

integrated entities

that can be part of

overall scheme of

merger and

acquisition systems

integration solution

Mergers and

Acquisitions

Scenarios

• such as Supply

Chain Management,

ERP Data

Integration,

Enterprise Data

Services, Data

Portals, Agile

Business

Intelligence, Big Data

Analytics

enablement,

Integrated Patient

Records etc.

Enterprise Use

Cases

Thank you

for your time