Microsoft Azure platform including Azure SQL, Azure Data Factory, and cloud data pipeline development. AWS experience includes Redshift data warehouse architecture and Airflow orchestration.
Architect and developer of an AWS Data Warehouse migrating Lifetouch's SQL Server warehouse to Redshift.
Development of ETL to move 14 data sources to AWS S3 Buckets through Python and AirFlow.
Development of ETL building fact and dimension tables in Redshift again using Python and AirFlow.
Legence, Inc.2023–2024
De-engineering of IFS data model to build a dimensional data model. Oracle Cloud views and packages analyzed to drive a 120 dimension, 35 fact table data warehouse. Warehouse hosted in Microsoft Azure Fabric with Data Factory as the tool to provide ETL.
Temporary Data Warehouse built on Azure SQL Instance. IFS tables replicated from Oracle Cloud to SQL Server through SSIS, Transact SQL and SQL Agent. More than 100 tables replicated to Azure allowing for the development and delivery to production of Service, Finance and Executive Power BI Reports.
Marketing Architects, Inc.2025–Present
Migration of on-premises servers to Azure cloud servers. Data Architect supporting the next generation of the flagship linear advertising platform. Adding AI Model metrics to buy lines, developing an AI driven development process used within the data team.