PROFILE

Senior Data Modeler

25 years designing and implementing multi-tier databases and enterprise data services for finance, securities, property/casualty/health care insurance and pharmaceutical industries.

• Logical Physical Data Modeling.
• Development of data domain standards.
• End to end support of development lifecycle including requirements, logical/physical data modeling, data mappings, specification and validation of test scenarios.
• Database design Sql Server, Oracle, DB2, Sybase , generation of completed ddl scripts, load scripts in support of reference data, source to target mappings, Agile methodology.
• Enterprise data service design XSD , transformation rules for auto policy administration retrieval/update , address validation, auto territory assignment, check processing/eob details.
• Coordination of modeling team, synchronizing across systems for key projects.
• Strong analytical ability, broad and diverse experience designing and implementing customer account, product, order, securities, auto policy application and administration, reference, enterprise data warehouse and dimensional databases.
• Experience in use of case tools 15 plus years Erwin and database/data service tools Microsoft SQL Server Management Studio, Toad, Altova XML Spy .

Experience

Senior Data Administrator

Confidential

Data Architect

• Designed transactional auto policy administration database SQL Server 2008 , utilized ERWin for data modeling and ddl generation, SQL Server Management Studio to maintain ddl and reference data load scripts.
• Participated in initial setup of Data Governance policies and implementation.
• Designed auto insurance policy retrieve and update enterprise data services data model xml schema , and source mappings integrated with Acord industry model for use in new customer self service website, along with rating territory assignment and VIN details/discount services.
• Designed address validation service data model xml schema utilizing Business Objects Data Quality, for integration with policy and claims applications, including database for additional independent progressive search and validation application.
• Designed reinsurance database SQL Server for reinsurance claim identification and management.
• Designed highly generalized check processing data service data model xml schema for payments to vendors and claimants healthcare and lost wages claims , with associated explanation of payment/benefit details.

Confidential

Senior Data Administrator

• Facilitated evolution of DA group from logical to logical/physical database design.
• Supported Oracle databases replicating data needed from mainframe DB2 securities clearing applications, as well as independent data bases for trading interface applications and dimensional marts.
• Enhanced domain standards for international trades, negotiating agreement across development groups.
• Supported implementation of database for asset movement systems checks, account transfers etc on DB2.
• Redesigned Subscription contract database for new industry standards and external OLTP needs.
• Designed enhancements to existing equity and mutual fund trade databases, and security inventory database.
• Identified tactical solution for addition of international reference data e.g. ISO country codes, additional compliance requirements to existing applications.
• Coordinated data administration team to enhance subscriber/customer account and order databases to comply with Patriot Act requirements designed reporting database normalizing equity, mutual fund and bond orders.

Confidential

Senior Data Architect

Organization Standards

• Participated in depiction of existing system architecture, relationships and flows.
• Defined and published Data Administration mission and goals.
• Defined and maintained Data Administration standards, including ISO for geographic reference data.

Subscriber/Account/Decision Support

• Maintained 178 table database migrating legacy subscriber, contract, billing, pricing, revenue recognition and sales force management data/functions, utilizing ERWin for data modeling and ddl generation. Managed relationship with consulting firm, ensuring adherance to database design standards and documentation.
• Implemented enhancements for sales, marketing and finance functions.

Product

• designed generalized 50 table relational database for event detection. Coordinator, lead analyst and designer of modular processes, including interfaces to in house developed middleware and legacy product systems received Leadership Conference Award for initiative and risk-taking.
• key analyst in logical and physical design of 2000 entity/200 table global business data model defined legacy data transformations for 55 million businesses in 230 countries.

Data Analyst

• Business data expert, participating in creation of enterprise wide global conceptual business data model.
• Defined transformations migrating business data from existing tag delimited keyed text file legacy system , to highly encoded generalized relational database approx. 3000 elements .
• Participated in logical design of public records database.

Divisional Operations Manager

• Managed Business Analysts responsible for Business Information Reports, basis of all data products.

Business Analyst

• Evaluated background, financial statements and management experience to assign D B rating. Received Presidential Citation national and Regional Citations for highest quality and content. Consistently ranked one of top 3 analysts in U.S considered data/subject matter expert.
• Managed task force developing new standards/procedures for improvement of trade and bank references.