SENIOR DATA MODELER

SUMMARYOF EXPERIENCE

Accomplished Data Modeler 20 Years with extensive System Development Life Cycle experience, and a proven record of delivering quality Operational and Data Warehouse applications for financial institutions.

TECHNICAL SKILLS

• Methodology: Agile, Rational Unified Process, SSADM, Kimball
• CASE Tools: Erwin 9.5, Rational Rose, Select SE
• Business Areas: Banking Securities, Insurance, Mortgages, Public Utilities
• Applications: Oracle Tools Utilities,
• Software: FINEOS Claims Solution
• Databases: Oracle, DB2, Teradata, SQL Server, Informix
• Office Tools: Excel, Word, Project, PowerPoint, Visio

EXPERIENCE

Confidential

• Created fully attributed normalized Logical and Physical data models to support mutual fund and securities transactions, including client reporting, SEC reporting. fund indexing
• Gathered complex business data requirements from internal business clients and development teams.
• Validated data models with IT team members and internal clients.
• Reviewed data models with lead to assess the impact of the new model on the enterprise model.
• Transformed logical database models into physical database designs. Created and wrote documentation, including collecting and maintaining metadata.
• Created XML schemas to manage document content.

Confidential

• Participated in business requirements gathering workshops.
• Created fully attributed normalized Logical and Physical data models to support mortgage insurance applications.
• Created dimensional model and identified the dimensions, facts, and measures for monitoring system access and availability.
• Developed mapping spreadsheets for ETL team with source to target data mapping
• Defined data naming and metadata standards for all new data models.
• Researched and responded to Data Modeling Team assigned IT Service Requests within the required time-frame.
• Wrote SQL scripts to analyze OLTP data for eventual movement into the data warehouse.
• Wrote SQL scripts to load code data into production tables.

Confidential

• Wrote SQL scripts to pull Accident Intake data and create views.
• Enhanced Enterprise Data Modeling Standards.
• Created DDL scripts and built Oracle tables and indexes
• Participated in peer data model walk-thru sessions and design reviews
• Created data mapping documents for the movement of data from legacy production databases to the new Fineos database. Defined logic for Extraction, Transformation and Loading of claim data into Warehouse and Marts.
• Participated in data migration workshops and translated data requirements into data models to facilitate the migration of legacy data into the new Fineos Claims processing system.

Confidential

• Wrote SQL scripts to analyze data as part of database problem solving.
• Researched and responded to IT Service Requests within the required time-frame.
• Worked with the Data Warehouse Development ETL team to define source to target mapping and develop mapping spreadsheets.
• Generated and managed Oracle DDL.
• Translated data requirements into project data models and enhance the underlying IBM Financial Services Logical Data Model to support the following applications: consumer lending remote data capture customer authentication, and workstreams.
• Performed data modeling role within a Scrum agile project methodology, using ERwin.

Confidential

• Wrote SQL scripts to load test data using SQL Navigator and proprietary ETL tools into an Oracle database.
• Developed data mapping, transformation rules, and domain values. Created the Logical Data Model and Dimensional Models in ERwin to support a data warehouse and data marts for an integrated social services application.
• Conducted interviews with end users and stakeholders to gather business requirements documents.
• Responsible for data modeling and master data management for a large and highly metadata-driven Oracle data warehouse that integrates information for the Department of Social Services by bringing together data from a host of social services and related family information sources.

Confidential

• As a member of the corporate data management group, provided governance for all data-related strategies, architectures, and data models.
• Established and enforced data modeling standards including table structures, naming conventions, and key definition generation.
• Managed master data MDM defined data types, domains, sizes, and defaults. Reverse-engineered data models from legacy databases and SQL scripts. Maintained a subject-area based enterprise data model through rigorous change control procedures.
• Worked with business users to capture business requirements for operational and BI initiatives.
• Using ERwin and Rational Rose, translated requirements and business rules into Data Models to support new data in Teradata and Oracle for the following applications: account processing mortgage strategies customer authentication internet banking telephone applications telephone solicitation suppression non-sufficient funds processing, compliance and customer privacy. Identified entities, attributes, metrics, and relationships, and assigned keys.
• Conducted model reviews with business and technical team members.
• Developed source to target data mappings, performed gap analysis, and designed a Data Warehouse model to support pricing data sourced from a 3000 attribute operational database.
• Provided source to target ETL mapping and worked with enterprise ETL developers to ensure proper business rules and validation checks were applied to transformation and loading.