Transcript Error Tolerant Matching - ISACA China HK Chapter

Error Tolerant Matching
• Acoustic Errors
Mr Haseez Abbafi
99 Woodheyes Rd London NW10 9DE
Mr Hafeez Abbasi
99 Woodheyes Rd London NW10 9DE
RCP Consulting Limited
Suite B, 15th Floor, Casey Building,
38, Lok Ku Road, Sheung Wan,
Hong Kong
Tel: 2815 9911
Fax : 2815 0611
E : [email protected]
• Semantic and Transposition Errors
Mrs Deolinad Abao
1 Station Rd Barnet Hertfordshire EN5 1NP
Miss Deolinda Adao
Basil Court 1 Station Rd Hertfordshire EN5 1NG
Real World Applications
•
•
•
•
•
•
•
•
•
•
•
Data quality assessments
Single view of customer
Customer de-duplication
Data migration
Clean, match and merge
Vendor screening
Forensic accounting
Fuzzy search/retrieval
Address cleaning
Anti money laundering
Denied persons
RCP Consulting Limited
Suite B, 15th Floor, Casey Building,
38, Lok Ku Road, Sheung Wan,
Hong Kong
Tel: 2815 9911
Fax : 2815 0611
E : [email protected]
Real Time Fuzzy Search
• Objective
RCP Consulting Limited
Suite B, 15th Floor, Casey Building,
38, Lok Ku Road, Sheung Wan,
Hong Kong
Tel: 2815 9911
Fax : 2815 0611
E : [email protected]
Identification and validation of university students
making loan applications with third party lenders
• Challenge
Complex and sensitive search criteria to identify as
many applicants as possible without performance
deterioration. Rules are client configurable
Encompassing periods of extreme volume
processing volatility
• Deployment
Web Service front end plus scalable cluster
• Result
Guaranteed 7 sec response day in day out. 24 x 7.
Corporate Fraud
• Objective
Detect potential fraudulent vendors
• Challenge
RCP Consulting Limited
Suite B, 15th Floor, Casey Building,
38, Lok Ku Road, Sheung Wan,
Hong Kong
Tel: 2815 9911
Fax : 2815 0611
E : [email protected]
Companies that have a large number of vendors are
at risk of fraud. The impact of any one specific
fraud is unpredictable
• Deployment
The vendor lists were compared firstly to the
employee list and secondly to a mail box
drop/pornography shop list
• Result
Results suggests that 1.5% of all vendors are
fraudulent. On one account that led to the
successful investigation of 250 targeted vendors
Anti Terrorist Application
• Objective
Detect individuals on the OFAC list
• Challenge
RCP Consulting Limited
Suite B, 15th Floor, Casey Building,
38, Lok Ku Road, Sheung Wan,
Hong Kong
Tel: 2815 9911
Fax : 2815 0611
E : [email protected]
US companies may not deal with individuals,
companies and vessels on the OFAC list nor with
specific countries
• Deployment
Rules were configured to allow maximum visibility of
all possible matches
• Result
In one account 15 entities were uncovered.
The US Patriot act enforces a $10m fine per entity
Denied Persons List
• Objective
RCP Consulting Limited
Suite B, 15th Floor, Casey Building,
38, Lok Ku Road, Sheung Wan,
Hong Kong
Tel: 2815 9911
Fax : 2815 0611
E : [email protected]
Detect individuals on the US Denied Persons list
• Challenge
US companies funded by government may not deal
with individuals, companies that have defrauded
the government. The denied persons list also
includes barred nurses and doctors
• Deployment
Rules were configured to allow maximum visibility of
all possible matches
• Result
In every account examined entities were uncovered
Duplicate Invoices
• Objective
Detect duplicate invoice payments
RCP Consulting Limited
Suite B, 15th Floor, Casey Building,
38, Lok Ku Road, Sheung Wan,
Hong Kong
Tel: 2815 9911
Fax : 2815 0611
E : [email protected]
• Challenge
Companies with large purchase order ledgers are
vulnerable to paying an invoice more than once.
• Deployment
Rules were configured to allow maximum visibility of
all possible matches.
• Result
In one account GBP 1.8m was discovered to be
multiple paid. One vendor had triple billed their
client for an entire quarter. One invoice was paid
seven times. Their accountants had double billed
them as well…