8/2/2019 Aijay Ann T. Lamela

1/12

Creation of Data Quality StandardsUsing Failure Mode and Effect

Analysis Approach in Master Data

Aijay Ann T. Lamela

Finance OperationsData - Technical Assets

8/2/2019 Aijay Ann T. Lamela

2/12

Shell Worldwide

8/2/2019 Aijay Ann T. Lamela

3/12

Agenda

Data Quality Standards

Failure Mode and Effect Analysis (FMEA)

Data Quality Check Q & A

8/2/2019 Aijay Ann T. Lamela

4/12

Data Quality

8/2/2019 Aijay Ann T. Lamela

5/12

Data Quality

Standards

?Process Failure Cost

?Information Scrap and Rework

?Cost of Lost and Missed

8/2/2019 Aijay Ann T. Lamela

6/12

Assigned Search Term 1 is

incorrect and does notfollow the format

- Difficulty in searching location

- Extra time to search for the records

- Affects planning and distribution

- Delay of updates for the location

- Incorrect information

provided by the customer

- Incorrect entry by the

analyst

- Standard assignment of Search Terms

- In process check

8/2/2019 Aijay Ann T. Lamela

7/12

Object

Propertie

s

Failure

Mode

Effects? SEVerity (1-10)

Causes? OCCurence (1-10)

Controls? DETectability (1-10)

RPN =

SEV*OCC*DET

(1-1000)

Data Quality

Standards

8/2/2019 Aijay Ann T. Lamela

8/12

8/2/2019 Aijay Ann T. Lamela

9/12

To clean the lake, eliminatethe source of pollutants Thomas C. Redmon

FMEA

Data QualityStandards

Data QualityCheck Data

Quality

8/2/2019 Aijay Ann T. Lamela

10/12

8/2/2019 Aijay Ann T. Lamela

11/12

Q & A

8/2/2019 Aijay Ann T. Lamela

12/12

References

Experience with FMEA by Sikke van der Zee and David McFarland

Supply Chain Assets Process Pamela Hughes, John Hyde

Data Quality and You Course - Shell Learning and Development

Information Management Course - Shell Open University

Images and Locations - Shell Worldwide Site (www.shell.com)

Other Graphics www.wikipedia.com; www.google.com