DO NOT PAY BEST PRACTICES FORUM

HOW ANALYTICS CAN TELL THE STORY OF

YOUR PAYMENT INTEGRITY JOURNEY

July 2020
2 L EAD ∙ T RANSFORM ∙ D ELIVER

What is Data Analytics 

So that you can

Focus on your mission

Data Analytics is examining raw data to draw conclusions. It 

involves the assessment, evaluation, interpretation, and 

communication of meaningful information and utilizing that 

information for effective decision making. 
3 L EAD ∙ T RANSFORM ∙ D ELIVER

Why Data Analytics

Your Business 

Problem Here

Eligibility risks and

payment/payee integrity 

issues related to:

• Beneficiaries

• Vendors

• Travel Pay

• Payroll

• Service Providers

• Loans

• Grants

• Disaster Funds

• Loss 

Guarantee/Insurance

Common challenge our partners face:

Business Problem:

Your organization disburses a high volume of payments, 

which makes it difficult to devote enough staff time to 

scrutinize every payment before issuance.

Solution:

Consult with DNP Analytic Solutions Team to utilize 

analytic techniques that identify hard-to-detect payment 

errors and fraud risk so that you can focus resources 

based on risk.

Benefits:

Supplement your resources with our staff and 

expertise, independently establish point-in-time 

check of current controls, and identify a targeted 

approach to reviewing payments based on risk.

Leverage your data to address business problems
4 L EAD ∙ T RANSFORM ∙ D ELIVER

Who We Are

So that you can

Focus on your mission

The DNP Analytic Solutions Team is dedicated to delivering

analytical insights and innovative data solutions that help 

you improve your payment integrity and meet your mission. 
5 L EAD ∙ T RANSFORM ∙ D ELIVER

Our Techniques

We employ advanced data analysis techniques

Data

Matching

Data

Modeling

Risk 

Assessment

Advanced 

Algorithms
6 L EAD ∙ T RANSFORM ∙ D ELIVER

Our Services

Analytic Solutions Team services range from consultation to 

fully-integrated data solutions that can be customized to your business
7 L EAD ∙ T RANSFORM ∙ D ELIVER

Our Capabilities

Eligibility 

Verification:

Confirm payee 

eligibility by 

matching to data 

sources

Integrity 

Checks:

Identify hard-todetect errors, 

anomalies, and 

fraud risk in 

payees, 

payments, or 

invoices

Preventative 

Controls 

Assessment:

Demonstrate if 

internal controls are 

effectively 

preventing 

improper payments

Establish point-in-time verification of current processes & risk level of improper payments

Maximize resources via a prioritized recommendations to implement changes

Payee 

Consolidation:

Identify duplicate, 

high-risk, or ineligible 

payees

Custom 

Analysis:

Provide insight 

into specific 

research 

questions

(e.g., existence 

of cross-state 

overlap)

Develop additional process controls & strengthen existing controls to reduce risk of errors

Identify high-risk records to further evaluate based on risk and/or impact

Results allow partners to:
8 L EAD ∙ T RANSFORM ∙ D ELIVER

Business problem: Partner knew there were integrity issues 

within its travel payment systems which have caused improper 

payments. The partner needed a way to identify system errors 

or vulnerabilities that lead to improper payments that should 

result in recovery activities.

Solution:

Travel Payment Example

Integrity 

Checks:

Identify hard-todetect errors, 

anomalies, and 

fraud risk in payees, 

payments, or 

invoices

• Duplicate payments

• High risk overlapping trips

• Shifted decimal analysis 

• Outlier detection

– Same invoice amount

– Invoices exceeding thresholds

– Excessive trips per fiscal year

• Vendor segment analysis

• Unliquidated advances
9 L EAD ∙ T RANSFORM ∙ D ELIVER

Example Output: Duplicate Payments

Risk Level Vendor Attributes in 

Common: Vendor ID +

Invoice Attributes in 

Common

Duplicated 

Invoices (#)

Duplicated 

Invoices ($)

High

Invoice Total, Doc Type, 

Doc ID, Line Amount, 

Invoice ID, Invoice Total, 

Invoice Number Part 1, 

Check Date

Begin Travel, End 

Travel, Doc Number 244 $221K

Results: 

• Partner confirmed 42 duplicate payments totaling $44K

• 29 were not previously identified through existing processes 

resulting in $23K in cash loss avoided through partnership with 

DNP
10 L EAD ∙ T RANSFORM ∙ D ELIVER

Example Output: Overlapping trips

Partially Overlapping Trips
11 L EAD ∙ T RANSFORM ∙ D ELIVER

Business problem: Partner needed to retrain lenders on due- diligence 

processes, but faced resource constraints and therefore needed to 

prioritize lenders to train based on risk

Solution:

Delegated Lender Example

Preventative 

Controls 

Assessment:

Demonstrate if 

internal controls 

are effectively 

preventing 

improper payments

Test due-diligence processes

• TIN quality & risk assessment

• Eligibility verification

Synthesize results to prioritize lenders 

based on portfolio risk level

• Borrower- & principal-level view
12 L EAD ∙ T RANSFORM ∙ D ELIVER

Business problem: Partner needed to proactively identify which of its 

payees who are concurrently dually enrolled in other similar programs to 

prevent improper payments stemming from dual-collection

Solution:

Dual-Benefits Example

Custom 

Analysis:

Provide insight 

into specific 

research 

questions (e.g., 

identification of 

cross-program 

overlap)

DNP identified & returned 

overlapping payees

DNP will continually identify and return 

overlapping payees with relevant detail 

for agency to conduct case 

development

Payee TIN Payee Name

Benefit 

Month

# of 

Ovalapping 

Payments

Total 

Payment 

Amount - 

Partner

Total 

Payment 

Amount - 

Agency A

Net 

Payment 

Overlap

######## John Smith Jan-20 5 $100 $1,000 $100

######## Jane Doe Jan-20 3 $500 $500 $500

... ... ... ... ... ... ...

Agency A Partner 

Agency

Overlap

9,511 

Payees

Totalling 

$193M

S M T W T F S

1 2 3 4

5 6 7 8 9 10 11

12 13 14 15 16 17 18

19 20 21 22 23 24 25

26 27 28 29 30 31

July
13 L EAD ∙ T RANSFORM ∙ D ELIVER

Business problem: Partner uses a third-party obituary death source 

that does not provide TINs as part of its death data checks. Can DNP 

death data sources do a better job? For free?

Solution:

Beneficiary Eligibility Example

Eligibility 

Verification:

Confirm payee 

eligibility by matching 

to data sources

Description of Match 3rd Party 

Matches

Matches to 

Both DNP 

& 3rd Party

Death previously confirmed 28 99

Partner determined match 

was inconclusive 149 18

Partner determined match is 

possible, but not conclusive 

enough to stop payments

73 9

Partner determined match 

was conclusive 40 133

Total 290 259

More Value

More Value

Less 

Junk! Custom 

Analysis:

Provide insight into 

specific research 

questions

(e.g., identification 

of cross-program 

overlap)
14 L EAD ∙ T RANSFORM ∙ D ELIVER

Feedback from Partners

“DNP’s findings helped 

to strengthen FINCEN’s 

[U.S. Coast Guard 

Finance Center] internal 

policies and procedures 

and provided a better 

understanding of data 

integrity controls.”

– United States Coast Guard, 

2019 Winter edition of the 

Quarterly Armed Forces 

Comptroller Journal

“Or experience with the 

DNP Analytics Team has 

been awesome. We all 

want to do more analytics, 

but we don’t have the 

time or resources to do 

that. Using DNP analytics 

was like augmenting our 

staff. We got the very best

analytics possible for free.”

– Jim Bates, Director of Program 

Accounting, U.S. Small Business 

Administration

Here’s what our partners are saying about us...

• “Our experience with the DNP Analytics Team has been awesome. We all 

want to do more analytics, but we don’t have the time or resources to do 

that. Using DNP analytics was like augmenting our staff. We got the very

best analytics possible for free.” – Jim Bates, Director of Program 

Accounting, U.S. Small Business Administration

• “DNP’s findings helped to strengthen FINCEN’s [U.S. Coast Guard Finance 

Center] internal policies and procedures and provided a better 

understanding of data integrity controls.” – United States Coast Guard, 

2019 Winter edition of the Quarterly Armed Forces Comptroller Journal
HOW TO GET STARTED

July 2020
L EAD ∙ T RANSFORM ∙ D ELIVER 16

1. Initial project discussion with DNP Agency Lead 

2. Scoping call with Analytics Team

3. Sign and return Customer Acknowledgment form

4. Set up secure HTTPS connection with DNP Analytics 

(if applicable)

5. Send project data to DNP Analytics (if applicable)

6. Project is assigned to Analytics team 

Steps to Partner With Analytics 
L EAD ∙ T RANSFORM ∙ D ELIVER 17

1. Share your goals for partnering with DNP Analytics

2. Include team members who are knowledgeable on:

a. The Program’s business process

b. The Program’s data 

How to Maximize Your Analytics Scoping Call
18 L EAD ∙ T RANSFORM ∙ D ELIVER

DNP Success Stories - Department of Labor

• Proof of Concept – Identifying Overlap Between DOL, SSA and OPM

— Do Not Pay analyzed data from FY 2017, 2018 and 8 months of 2019 in Payment 

Automation Manager to identify potential overlap between DOL FECA and SSA 

OASDI, and DOL FECA and OPM FERS

• Results

— 9,511 payees received concurrent DOL FECA and SSA OASDI payments. The 

overlapping payment amounts are estimated at $193 million.

— 2,188 payees that received concurrent DOL FECA and OPM FERS payments. The 

overlapping payment amounts are estimated at $30 million. 

• Feedback

— DNP analytics team is flexible and customer service based

— Identifying and reducing improper payments with key data points 

— Central to DOL’s efforts to automate paper based processes 
19 L EAD ∙ T RANSFORM ∙ D ELIVER

DNP Success Stories – HUD OIG

• Audit Support - FHA Insured Home Loans

— Do Not Pay conducted matches against more than 1 million FHA insured 

home loans

• Results

— Identified an estimated 9,507 loans worth $1.9 billion which were not eligible 

for insurance because they were made to borrowers with delinquent Federal 

debt or who were subject to Federal administrative offset for delinquent child 

support

• Feedback

— Provided clear, convincing evidence to compel change in a cost effective 

manner
20 L EAD ∙ T RANSFORM ∙ D ELIVER

DNP Success Stories – State Agency

• Audit Support – Federal Funded State Program

— Do Not Pay conducted matches against more than 1 million Medicaid 

recipients both inside and outside Oregon. 

• Results

— Identified more than $790,000 in improper payments, generating an ROI of 

approximately $286 in savings for each $1 spent in researching data 

matches. Additionally, DNP analytics helped prevent over $6 million in future 

improper payments. 

• Feedback

— “I am encouraged to see the Department of Human Services and Oregon 

Health Authority working to gain access to these important tools that will help 

our state save money and resources. In programs like Medicaid, every penny 

counts, and I am glad that Do Not Pay has helped identify these savings.”
21 L EAD ∙ T RANSFORM ∙ D ELIVER

Contact Information

Interested? Here’s how to get started:

Contact your 

DNP Agency Lead

or

DNP Agency Specialist 

or send an email to:

donotpay@fiscal.treasury.gov

Website: fiscal.treasury.gov/dnp