Data Insurance

SUMMARY

Data Governance - Technical Business Analyst

Data Governance - Technical Business Analyst specializing in Data

Architecture Metadata. Expertise is in discovering connections between the

data and requirements to ensure quality content across Enterprise. Drive to

provide solutions with quality products through innovative, insightful

application of methods and technology. Effectively perform data analysis to

recognize the impact of data movement activities. Organize the data to

maximize use, reduce redundancy, foster corporate knowledge. Influence

communication with Business and Technical Communities to ensure integration

of requirements. Raise awareness that metadata improves Knowledge Transfer

and Project Development Cycle.

Strengths:

. Metadata Analysis - Business-Technical / Data Dictionary-Reference-

Data Mapping Data

. Communication - Act as liaison among Business - Technical Communities

. Technical Platform Knowledge - Mainframe, Microsoft SQL Server,

Windows XP, 7

. Software Tool Knowledge - Microsoft Office Suite(Access, EXCEL),

Microsoft SQL

. Vendor Software Knowledge - Informatica, Cognos, CA ERWIN, IIW Data

Model

. Subject Matter Expert - Insurance Policy and Claim Data

EXPERIENCE:

Harleysville Insurance Company, Harleysville, PA

2000 - 2010

Property Casualty Insurance Company provides Personal and Commercial

Insurance Policies.

Data Architect - Technical Business Analyst

Organized and captured metadata on 11 Personal and Commercial Insurance

Policy Administration Lines of Business. Created and implemented processes

and structures used to develop and support data infrastructure.

Communicated results to Data Modelers, Developers, and End Users in

Business Areas. Metadata Activities resulted in opportunities to reduce

data redundancy, rapid identification of data elements, improve response

time to project requirements.

Metadata Analysis

. Performed detailed data structures analysis of Copybooks, Databases,

Text, XML.

. De-constructed data structures to expose and discover all data

relationships.

. Evaluated Business Processes to gain proper insight into meaning of

data.

. Translated and rationalized disparate application data into cohesive

data structure supported by dictionary and reference data.

Communication

. Interacted directly with Business to investigate requirements. Led to

quality data being delivered with proper tools and instructions to

navigate the content.

. Collaborated on In-House Data Mapping Software resulting in a Tool to

consistently document ETL rules.

Software Tool Knowledge / Vendor Software Knowledge

. Created In-House Enterprise Dictionary and Reference Databases that

captured over 180,000 dictionary elements and over 750,000 reference

elements.

. Analyzed and populated proper structures into vendor tools using their

software.

. Reused tools and methods to assist other groups with conversion

processes.

. Used Microsoft Access and SQL Database Query Languages extensively to

create and navigate content.

Subject Matter Expert

. Data Subject Matter included Data Warehouse, Insurance Policy

Administration Applications, STAT, Predictive Modeling, ISO Reporting,

Data Marts and other Reporting.

. Captured and organized Insurance Metadata data structures and content

of policy and claim systems detailing covered risk, selected coverage,

claim activities and data relationships.

Colonial Penn Insurance, GE Capital Assurance, Norristown, PA

1998 - 2000

Property Casualty Insurance Company provides Personal and Commercial

Insurance Policies.

Data Administrator

Responsibilities included analysis of data structures, process flows, and

documentation. Analyzed data processes for Business Online Transaction

Processing, Operational Data Store and Decision Support Systems for

Property Casualty Personal Lines.

. Developed position Data Administrator.

. Participated directly in evaluation and selection of Data

Administration tool.

. Constructed logical model for application developers.

. Developed project plans for the processes from Concept through

Implementation.

. Analyzed data for Property Casualty Personal Lines mailing campaigns

solicitations.

Glatfelter Insurance Group, York, PA

1998 - 1998

Property Casualty Insurance Company provides Personal and Commercial

Insurance Policies.

Data Administrator

As Data Administrator established roles and responsibilities for data

warehouse with Director of Data Management. Created functions for Data

Administration Role and responsibilities.

. Identified and implemented solutions to document enterprise data

repository.

. Solutions were used in online and data warehouse processes.

. Created logical design of enterprise data models.

Colonial Penn Insurance Group, Norristown, PA

1979 - 1998

Property Casualty Insurance Company provides Personal and Commercial

Insurance Policies.

Data Analyst

Wrote and implemented data analysis scope documents. Developed project task

plans. Responsibility included management of enterprise metadata

repository.

. Repository supported Online Transaction Processing, Operational Data

Store and Data Warehouse processes.

. Analyzed projects to determine system and staffing requirements.

. Provided support services for Business and Technical projects.

Projects involved data entry and reporting system Human Resources.

. Coordinated Payroll internal and external interfaces.

EDUCATION:

Bachelor of Elementary Education, Penn State University

Contact this candidate