Data Modeler / Lead ETL Developer Resume Cincinnati, Ohio. - Hire IT People

Background Summary

Expertise in designing logical data models and physical structures associated with transactional, data warehouse, and dimensional databases with conformed dimensions. Proven proficiency in translating complex business processes into defined data transformations integrating multiple data sources. Concept - to-implementation responsibility for:
SQL with advanced features such as analytical functions and query parallelization high volume, large data warehouses with table partitioning, table data compression, indexing schemes, summarizations and aggregations.
Oracle-certified SQL Expert. Hands on developer of complex SQL queries for ETL, PL/SQL packages, external tables, DML error logging, Heterogeneous Services. Data design using ERwin primarily for Oracle (7.3.4 - 12c) including compression, partitioning, and bitmap indexes. Database tools include SQL*Developer, SQL*Navigator, TOAD; PL/SQL Developer. Limited experience with DB2 v8, SQL Server, korn shell.

PROFESSIONAL EXPERIENCE

Confidential, Cincinnati, Ohio.

Data Modeler / Lead ETL Developer

Responsibilities:

Transformed and traced business requirements into logical data model (LDM) of new Agency Management System, aligned with Enterprise Data Model (EDM). Extended Inmon-style data warehouse and integrated additional ERP source. Built Kimball-style dimensional data marts.
Designed and implemented physical model changes including re-partitioning, bitmap indexing, data compression, referential integrity and other constraints. Tuned critical SQL, improved through-put via concurrent sessions and bulk processing. Extracted non-Oracle OLTP sources (SQL Server, DB2 v8 on z/OS, Informix) via ODBC connections.

Confidential

Data Architect

Responsibilities:

Designed Kimball-style star schema for corporate sales reporting; extended ETL to pull from second ERP (JDE on Oracle 8i, PRMS on AS400/DB2). Designed initial Cognos Impromptu catalog, then supported BI analysts. Provided technical guidance and reviewed work products for ETL PL/SQL 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 per J2EE Roadmap. Developed Unicode 9iR2 database for multi-lingual design and printing of product labels. Implemented hub-and-spoke, low-latency integrations using OAGIS standards; linked four European and US ERP systems (1 SAP on Oracle, 2 JDE on Oracle, PRMS on AS400/DB2). Developed transactional replication for Oracle 7 & 8i databases. Provided specs, reviewed deliverables & US Food and Drug Administration verification documentation.

Confidential . Dayton, Ohio

Responsibilities:

Senior Data Modeler (1998-2000) Modernized Air Force wholesale inventory system consolidating 5-site legacy databases into single Oracle database. Data model conformed to DoD Data Model and standards.
Data Warehouse Analyst (1997) on 3-person team planning data mart for Defense Logistics Agency (DLA). Recommended RDBMS based on TPC-D benchmarks.
Business-Reporting Manager (1994-1997) Designed project tracking/reporting database using Microsoft FoxPro/ Access populated from corporate systems of record. Briefed client monthly on Cost/Schedule and Earned Value of project; improved project profitability.