Data Stewardship at Federated Insurance July 2011

1. Data Stewardship at Federated InsuranceJuly 2011

2. Agenda • History/Background • Structure • Progress • Tools • Challenges

3. Data Stewardship Defined Data Stewardship has as its main objective the management of Federated’s enterprise data assets in order to improve their reusability, accessibility and quality. The Data Stewardrepresents Federated in making decisions for the definition, use and security of the data at Federated.

4. Data Stewardship 2008 • Initiated for Data Warehouse Project • Data Quality was and remains the Driver • Business Ownership • Definitions • Quality criteria • Standard domains

5. Data Stewardship Structure 2008

6. Data Stewardship 2010 • Expansion Beyond Data Warehouse • Data Profiling • Additional Data Steward

7. Data Steward Roles • Data Stewardship Steering Committee

8. Data Steward Roles • Business Data Steward

9. Data Steward Roles • IS Technical Data Steward

10. Data Steward Roles • Business Subject Area Manager

11. Data Steward Roles • IS Data Administrator

12. Data Steward Roles • Data Stewardship Steering Committee • Business Data Steward • IS Technical Data Steward • Business Subject Area Manager • IS Data Administrator

13. Data Stewardship Progress • Include Data Steward in Projects • Data Profiling • Business Terms Glossary • Processes

14. Draft Proposed Structure 2011

15. Tools • SharePoint site • Meta Data Repository/Application • ASG metaGlossary • Rochade WebAccess • DataFlux dfPower Profile & Monitor • SQL Server Suite for reporting

16. Challenges • Data Steward Availability • Data Steward Visibility • Access to Meta Data • Data Stewardship Program Responsibilities

17. Contact Information Tracy Bauer Data Administrator Federated Insurance Company 507-455-8954 tmbauer@fedins.com