Sr. Data Architect/Modeler Resume

SUMMARY

I have extensive experience with end to end development of Telecommunications, Marketing, Banking, Manufacturing, LTL Freight, Healthcare solutions (both BI/Decision Support and OLTP) using Erwin, ER Studio and Power Designer for deployment in Oracle, SQLServer, TeraData, and other RDBMS platforms.
My most recent experience has been as a Sr. Data Modeler/Architect designing ODS data structures for Healthcare payer data hubs.
I was also responsible for Data Profiling support using Trillium’s TS Discovery for both Confidential and CenturyLink.

TECHNICAL SKILLS

Data Modeling: ER Studio, Erwin, PowerDesigner, ADRM Healthcare Data Model

Database: Oracle/Exadata, SQLServer, Azure, TeraData, DB2, Informix, FoxPro

Data Quality/Profiling/MDM: Trillium TS Discovery, Informatica, Mellisa Data, Profisee

ETL: SSIS, WhereScape, Informatica - PowerCenter, Kafka

Programming Languages: C, C#, Pascal, PL/SQL, TSQL, VisualBasic, SAL(structured assembly language)

Agile: Jira, GIT, CVS, Pivotal Tacker

PROFESSIONAL EXPERIENCE

Confidential

Sr. Data Architect/Modeler

Responsibilities:

Provide data support in an Agile environment for healthcare data hubs: provider, member, claim data using the ADRM Industry standard data model.
This includes data structures for staging and ODS, along with mapping documents for the full data lifecycle.
These mappings are being implemented in Azure with Wherescape.
Assisted with defining the data modeling standards and processes for consistent/extensible deliverables including logical/physical data models, data dictionaries, data mappings and DDL generation.

Confidential

Sr. Data Modeler

Responsibilities:

Provide data support in an Agile environment for LTL (less than truck load) freight data warehouse (OLAP) and legacy modernization team (OLTP).
This includes data structures for staging and star schemas, along with mapping documents for the full data lifecycle.
Lead the effort to define data warehouse standards and processes for consistent/extensible deliverables including physical data models, data dictionaries, data mappings and DDL generation.
These mappings are being implemented in Kafka and SSIS.