Principal Software Engineer on the Data Office Team. Delivery Lead/ Co-Technical Lead on a large scale data warehouse migration from Oracle Exadata to Snowflake. Planned, organized and led the successful migration and validation of 400+ tables and ETL processes from Informatica Cloud/Exadata to dbt/SnowflakeCreated and managed a high performing team of 6+ developers by implementing Agile and Kanban practicesLed a team that was awarded the NI Impact Award during the 2023 IT AwardsMentored 4 younger developers on data warehouse concepts and troubleshooting techniquesDiscovered and designed technical solutions for numerous roadblocks encountered during the migration processArchitected solutions that reduced monthly Snowflake credit consumption by over 40%

Established standards & best practices for teams within the IT Org to enable tracking and visualization of metrics for deliverable commitmentsManaged the delivery of team cycle commitments using Agile methodologiesConsulted internal business groups on the proper use of NI’s product data

Designed AWS and Qubole Datalake environments for Business Units using AWS S3, AWS IAM, and Qubole Data Services APIsAutomated the creation of business unit environments using AWS Cloudformation Designed and implemented data marts for use in Oracle BI and Tableau dashboards and reports using Oracle Warehouse builder and Informatica PowercenterDesigned a data warehouse training curriculum used to introduce data warehouse and standards to programmers from other teamsTrained 30+ programmers on data warehouse basics and internal NI standards

Performed data warehouse data validation for multiple ERP system migrationsDesigned and implemented a configurable data cleansing engine that used dynamic sql to filter, deduplicate and transform dataDesigned and implemented a robust logging engine that enabled monitoring, reporting and troubleshooting of ETL jobs