Nelito Systems Limited
This presentation is the property of its rightful owner.
Sponsored Links
1 / 19

Nelito Systems Limited Data Quality PowerPoint PPT Presentation


finacle data management services, core banking vendors, core banking implementationhttp://www.nelito.com/services/finacle-cbs-implementation.html

Download Presentation

Nelito Systems Limited Data Quality

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Nelito systems limited data quality

Nelito Systems Limited

Data Quality

© Nelito Systems Ltd. 2013

1


Nelito systems limited data quality

Table of contents

About Us

Business Drivers

Solution Architecture

Case study

Differentiators

3

6

10

12

13

© Nelito Systems Ltd. 2013

2


Nelito systems limited data quality

Our Commitment

“Solutions that Perform”

We solve business problems of our clients through solutions

based on customer involvement, deep domain knowledge,

innovative technologies and personalized service support

We deliver what we commit

3

© Nelito Systems Ltd. 2015


Nelito systems limited data quality

Corporate Snapshot

Head Quartered at Mumbai

45+ Service Locations

800+ Professionals

100+ Banking Clients

BFSI Focused Solutions with own IPR

Products and product based services in the area of Transaction and Payment

Systems, Analytics and DW, Mobility & e-Governance

Leadership position in Automated Data Flow (ADF) MIS vis-à-vis compliance to

Central Bank of thecountry

Providing Manpower with varied Professional IT Skill sets to Banking and Non

Banking organizations in India & International locations.

Partners

4

© Nelito Systems Ltd. 2015


Nelito systems limited data quality

Offerings Portfolio :- Products

Analytics

Transaction &

Payment

Systems

Payment systems

Mobility

Mobility

&

DW

Transaction &

Payment Systems

• Mobile Banking

• CTS

• Transaction:

• Data Quality

• Internet Banking

• NACH

• FinCraft CBS

• Cleansing

• Door Step Banking

• SWIFT

• PACS

• Classification

• E-KYC and

• IMPS

• SACOS

• Enhancement

Customer On-

• DBT

• AML

Boarding

• ABPS

• Reconciliation

• LMS

5

© Nelito Systems Ltd. 2015


Nelito systems limited data quality

Offerings Portfolio : Services

Data

Payment

management

services

Transaction

IT Services

Mobility

management

services

management

services

Transaction &

Payment Systems

• BPO Services

• IT Infrastructure

Management

Services

• Professional

Consulting

Services

• 3rdParty CBS

Implementation

and Roll out

Services

• Customer On-

Boarding services

• Card management

services

• Reconciliation

services

• Customer

identification

services

• Financial inclusion

• NPA monitoring

and management

• SAP BO

• IBM Cognos

• Data quality

services

• Data enrichment

services

• MIS

• CTS

• MMS

• SWIFT services

6

© Nelito Systems Ltd. 2015


Nelito systems limited data quality

Customers

FinCraft CBS Banks

Other Banks

7

© Nelito Systems Ltd. 2015


Nelito systems limited data quality

Customers

Other Solutions and Services

International

e-Governance

Hutch Telecom

Sri Lanka

8

© Nelito Systems Ltd. 2015


Nelito systems limited data quality

Business Drivers

• Unique customer ID (UCIC)

• Identifying High risk customers

• Complying with KYC process

• Anti Money Laundering

Fraud

Detection

• TDS

• Rating requirements and delinquency analysis

• Upsell/cross sell/analytics/alerts

• Reduction of transaction costs by moving them

to alternate channels like mobile/internet

banking

• Customer House holding

Knowing the

Customer

better

9

© Nelito Systems Ltd. 2013


Nelito systems limited data quality

Sources of Poor Quality Data

Causes

Careless data entry/lack of validations/direct

updates

Duplicate customers records

Incomplete records especially Loans/Advances

Lack of standardization

Lack of data attributes

Inconsistency in data

Forms and other Paper Sources

Spellings

Legibility

Purposeful Misrepresentation of identity by

customers

Data Corruption is

Unavoidable

10

© Nelito Systems Ltd. 2013


Nelito systems limited data quality

Impact of Poor Quality Data

Impacts

Time wasted in reconciling data

(CBS&LAPS)

Fraud

Lack of cross selling

Duplicate mailings

Customer Dissatisfaction

Cannot move customers to alternate

channel

Compliance Problems

Duplicate customer references

Impacts your ROI

11

© Nelito Systems Ltd. 2013


Nelito systems limited data quality

Nelito’s End to end Data Quality solution

Data Analysis

Design of data standardization rules

Data health analysis

Auto standardization process using tool

User interface for Manual data cleansing

Rerun of standardization process

De duplication report

Out put data to source data base

Final check

12

© Nelito Systems Ltd. 2013


Nelito systems limited data quality

Data Quality Tool

Data Warehouses,

MDM Solutions

Load

Transform

SAP

R/3

ERP

Mainframe

CRM

Call Ctr

SAP

CRM

M e t h o d o l o g y

DE duping

Custom

RDBMS

Survive

Enrich

Match

Certify

Standardize

Investigate

Postal Reference

CRM

SFA

Siebel

Business

Rules

Business Reference

PC Data

SCM

Personal Reference

i2

Other Reference

Finance

HR

People

Soft

External

Data

Validate Business Rules

Profile Sources

Extract

Staging

Master Data Integration: Assess – Align – Harmonize – Load

13

© Nelito Systems Ltd. 2013


Nelito systems limited data quality

Data Quality process

INPUT

RAW

DATA

Manual

CLEANSE

PROCESSED

DATA

PROFILING

Standardization

DEDUPE

MATCH

CLUSTER

REPORT

Text report as

.csv

Name & Address

Unique ID

generated for

matches-

UCIC

PAN and other IDs

Web report

as html/pdf

Name & any

configurable

criteria

14

© Nelito Systems Ltd. 2013


Nelito systems limited data quality

Case Study

Clients – Bank of Maharashtra ,1825 branches

UCO Bank – 2500 branches

UBI bank – 1800 branches

Bank’s

requirements

Implementation

Highlights

Benefits to the

bank

Allocating unique customer

ID (UCIC)

Identify High risk

customers & verify with

international lists.k

Grouping for TDS , rating

requirements and

delinquency analysis.

Marketing/upsell/cross

sell/retention/analytics/

alerts.

Cleansing of key fields

leads to better operations

and customer satisfaction.

Reduces frauds

Improve branding, image,

marketing efforts.

Savings in postal costs.

Correct internal/external

MIS and other reports.

Better gender

classification,

segmentation, cross sell

Pre account opening

verification.

Implementation for

Bank of Maharashtra :-

10 branches in 1 months

UCO Bank :- 15

branches(in process)

UBI Bank :- 5 Branches

in 15 days

Implementation of De-

Duplication engine

15

© Nelito Systems Ltd. 2013


Nelito systems limited data quality

Differentiators for Nelito’s Data Quality

Solution

Enhanced Data Dictionaries for

70 million Indian names

20 million Mobile nos.

70 million Addresses ,Postal codes

20 million Email IDs

Data Cleansing done on various database of CBS VIZ

Finnacle

TCS BaNCS

Customized Data Profiling

20 Customer Sectors covered

Customer Categorization (Age,Gender,Caste,Religion)

Capability to match records for House holding

16

© Nelito Systems Ltd. 2013

(contd.)


Nelito systems limited data quality

Differentiators for Nelito’s Data Quality

Solution

Prebuilt Data Warehouse Design for Retail Banking and MIS– Data Marts

Easily configurable for any source database structure

End to end solutions

BPO Services for data collection and data punching of missing data like

Postal addresses

Mobile no's,

Integration of external statutory sources like

PAN no. integration

AADHAR to UADAI seeding.

17

© Nelito Systems Ltd. 2013


Nelito systems limited data quality

Product Road Map

BPO services for

manual data

updating with

decision

workflow system

Building of

Various Data

Marts

End to End

integration with

Core and

ancillary systems

Real Time Data

De Duplication

Check

Visual Reports

for presentation

of Data Health

18

© Nelito Systems Ltd. 2013


Nelito systems limited data quality

THANK YOU

Get in touch

205-208 Bldg 2, Sector 1

Millennium Business Park

Navi Mumbai 400 710

Tele: (+91-22) 6713 5555, 6713

5600

Fax: (+91-22) 6713 5503

© Nelito Systems Ltd. 2013


  • Login