Data Architect

Toby Reisner, Data Architect

Greenwood, Minnesota, 55331, United States, 612-***-****, ****@***********.***

http://www.linkedin.com/in/TobyReisner

SUMMARY

Dynamic Data Architect with over 14 years of experience in data architecture and cloud data solutions. Expertise in designing and implementing data models, creating semantic layers, and executing complex migrations to cloud platforms like Azure. Successfully developed source to target data mappings and data quality checks, significantly enhancing data governance. Proven ability to collaborate with cross-functional teams and deliver innovative data solutions that meet business needs. Ready to leverage these skills to drive impactful data architecture initiatives.

WORK EXPERIENCE

August 2022 – December 2024 Data Architect, Blue Cross Blue Shield Illinois

Supported corporate services and finance lines of business.

Engineered source-to-target data maps from multiple finance Medicaid/Medicare claims platforms and systems to Azure ADLS storage platform.

Conceptualized source-to-target data maps from Azure ADLS and AWS storage platforms to Snowflake Data Warehouse platform.

Developed new Erwin data models and Snowflake data warehouse tables (facts & dimensions) to enhance the semantic layer.

Formulated new Snowflake semantic layer views to bolster Power BI interactive dashboards and reports.

Instituted Snowflake stored procedures to conduct data quality checks, monitoring and rectifying data irregularities.

Contributed to the migration project of Hadoop/Teradata to the Azure Databricks cloud-based analytics platform.

Crafted new data architecture diagrams (Visio & Sparx eCSA Current State Architectures) and data flows for review by leadership and stakeholders.

Collaborated with the Portfolio Enterprise Architect and Solution Architects in the Enterprise Architecture Services department (EAS).

Engaged with Delivery Teams and Engineers in IT and Data Analytics Services (DAS).

Provided consultative and support services to all stakeholders.

Created and maintained a comprehensive data dictionary.

November 2021 – July 2022 Solution Architect, Medica Minnesota

Oversaw the Common Administrative Technology Ecosystem (CATE) Project to build, migrate, and manage Medica & Wisconsin-based Dean Health Plan (DHP) administrative systems onto a unified technology ecosystem and platform.

Provided architectural guidance for project initiatives.

Facilitated the legacy systems migration to an Azure cloud-based platform.

Authored current and future state architectures, diagrams, models, process flows, and data flow documents.

Ensured all deliverables underwent rigorous peer review by the architecture review board (ARB).

May 2018 – October 2021 Data Warehouse Architect, UCare Minnesota

Supported the Data Ecosystem Construction Project to replace the existing Amisys Claim Payer System with the HealthEdge HealthRules claim payer system.

Designed and implemented a new operational data store (ODS) and staged data warehouse using the Erwin data modeling tool.

Created semantic layer views for all Medicaid, Medicare claims, membership, enrollment, and provider data.

Delivered architectural support to the Health Informatics Team.

Developed stored procedures to implement data quality checks, ensuring monitoring and rectification of data irregularities.

Crafted source-to-target data mapping documents for enrollment, product, benefit, and provider data.

Produced translation and mapping documents from UCare Health data models to Fast Healthcare Interoperability Resources (FIHR) based data model for data exchange.

Developed translation and mapping documents from UCare Health data models to the Common Payer Consumer Data Set (CPCDS) for data exchange.

Created and maintained a comprehensive data dictionary.

January 2014 – April 2018 Data Warehouse Architect, Medica Minnesota

Led multiple large data warehouse projects to integrate & build out their existing data warehouses, Integrated Data Mart (IDM) and Aggregated Data Mart (ADM).

Championed multiple large data warehouse projects to enhance and build out existing data warehouses, including the Integrated Data Mart (IDM) and Aggregated Data Mart (ADM).

Executed migration and integration of data from the United Healthcare Platform, incorporating member, provider, and claim data attributes into a new integrated data mart (IDM).

Established a new operational data store (ODS) with a canonical model based on EDI 837 and 834 formats.

Integrated data from three grouper software packages into the new integrated data mart (IDM).

Architected and established semantic layer views for all Medicaid, Medicare claims, membership, enrollment, and provider data.

Developed stored procedures to conduct data quality checks, enabling monitoring and correction of data warehouse irregularities.

Authored ETL specifications and source-to-target mapping documents.

Conducted query optimization and performance tuning.

Performed data profiling and quality assessments.

Created and maintained a comprehensive data dictionary.

May 2012 – January 2014 Data Warehouse Architect, Blue Cross Blue Shield Minnesota

Tasked with the CBM project, responsible for migrating Oracle legacy data warehouse to a new Teradata platform.

Migrated legacy Oracle databases and data to the Teradata platform.

Designed Erwin data models to architect semantic layer views for all Medicaid, Medicare claims, membership, enrollment, and provider data.

Contributed to project planning and estimation.

Crafted ETL specifications and source-to-target mappings.

Optimized queries and tuned performance.

Performed data profiling and quality assessments.

Created and maintained a comprehensive data dictionary.

April 2011 – July 2012 Data Architect, National Marrow Donor Program Minnesota

Facilitated the agile enterprise data warehouse team responsible for managing metrics associated with cord blood donations.

Contributed to data architecture, physical data modeling, and model management using Power Designer.

Managed database deployments, along with query optimization and performance enhancement.

EDUCATION

Bachelor of Computer Science, Eastern Michigan University, 1986 – 1991

Certified Scrum-Master (CSM), 2014 - 2015

SKILLS

Dimensional Star Schema Modeling

Relational Modeling

Data Warehousing

ETL

Data Architecture

Analysis & Design

Database Performance & Tuning

SQL Performance & Tuning

Version One

ER/Studio

Erwin

Power Designer

Embarcadero SQL

PL/SQL

Transact SQL

Sparx Enterprise Architect v15.2

Oracle

Teradata

SQL Server

Sybase

Snowflake

SnowSQL

Snowsight

Hadoop

MS Azure Cloud

Data Lake

Power BI

Tableau

Agile-Scrum

SAFe

SDLC

Consultative Services

Collaboration

Continuous Learning

Project Planning

Stakeholder Management

Amazon Web Services (AWS)

Contact this candidate