Data Architect, Great American Insurance Group, Cincinnati, OH, Jan 2018-present

·   Modeled enterprise catastrophe claims data mart, explored and modeled multi-source data for ETL specifications.

Data Architect, Matchpoint Solutions, Erlanger, KY, Oct 2015-Nov 2017

·   Modeled the vehicle assembly-line tracking database from flat files to target (SQL Server 2012), including source-to-stage-to-target mapping, complex database constraints (computed columns), and PMERR error capture tables for Informatica team. Recommended Hadoop for history reporting.

·   Modeled vehicle assembly-line part-inventory multiple-source data-integration database (SQL Server 2012).

·   Data modeled parts-supplier data mart, integrating multiple data sources into star schema (Oracle 12g Exadata) with source-to-target mapping and testing-comparison views for the Informatica ETL team and PowerBI reporting views.

Data Modeler / ETL Lead, American Modern Insurance Group, Amelia, OH, 2005-Oct 2015

·   Supported Accounting, Actuary, Claims, Regulatory, Business Intelligence (Cognos) and Catastrophe modeling teams.

·   Transformed and traced business requirements Inmon-style Enterprise Data Warehouse (EDW), integrated multiple sources. Built Kimball-style dimensional data marts.

·   Designed and implemented physical model changes including re-partitioning, bitmap indexing, data compression, referential integrity and other constraints. Extracted non-Oracle OLTP sources via ODBC connections. Built ETL using PL/SQL; supported DataStage ETL developers, and Cognos Framework administrator.

Data Architect, Depuy Orthopaedics, Warsaw, IN, 2000–2005

●  Designed Kimball-style star schema for corporate sales reporting; wrote PL/SQL ETL integrating two ERP (JDE on Oracle 8i, PRMS on AS400/DB2). Designed initial Cognos Impromptu catalog, then supported BI analysts. Provided technical guidance for and reviewed work products of PL/SQL maintenance programmer.

●  Transformed business requirements into enterprise-wide conceptual, logical and physical data models. Aligned ERwin models with corporate models stored in ModelMart. Collaborated with users, analysts, and business managers to establish “to be” processes, Use Cases and GUI for international, multi-lingual application and database. Developed DIY transactional replication for Oracle 7 & 8i databases. Provided specs, reviewed deliverables, and documented US Food and Drug Administration compliance verification.

Senior Data Modeler / Data Warehouse Analyst, Computer Sciences Corporation, Dayton, OH, 1997-2000

●  Modernized Air Force wholesale inventory system consolidating 5-site legacy databases into single Oracle database. Erwin data model conformed to DoD Data Model.

●  Planned data mart for Defense Logistics Agency (DLA). Recommended RDBMS based on TPC-D benchmarks.

Graduate Certificate, Database Design & Management, Wright State University, Dayton, OH

Master’s in Engineering, Operations Research/Human Factors, Ohio State University, Columbus, OH

Bachelor of Science, Industrial Engineering, University of Cincinnati, Cincinnati, OH