• Acting Product Owner for Quicken Loan’s data warehouse, identifying opportunities to construct scalable Business Intelligence platform enhancements and cloud migration strategy. • Design and implement a proof of concept for a cloud data warehouse architecture for Quicken Loans on Amazon Web Services using AWS Glue, S3, Lambda, Athena, and Redshift. • Work closely with DBAs to monitor server performance to reduce I/O and CPU utilization, implementing strategies such as table partitioning and ColumnStore indexing. • Responsible for designing and migrating legacy on-prem SSIS ETL processes to AWS using Glue and Managed Apache Airflow. • Wrote custom python libraries to perform data quality error handling in our Apache Airflow DAGs. • Actively monitor query performance of SQL Server data warehouse using DMVs, Query Store, and customized alerting to proactively mitigate resource contention and delayed analytics. • Proudly serve as one of our SQL performance tuning experts in the data warehouse environment and actively mentoring developers regarding OLAP best practices. • Assisted in migrating our ETL code base from TFS to GitHub Enterprise in order to build towards a CI/CD practice for a Business Intelligence environment. • Responsible for mentoring and coaching newer engineers.

• Built countless ETLs using SSIS to ingest data into our SQL Server data warehouse, including in the form of flat files, APIs, other SQL Servers and our HIVE data lake. • Assisted in the initial migration from SSIS to Apache Airflow for data warehouse ETL orchestration. • Design and develop dimensional models in accord with Kimball Group standards for the Semantic reporting layer. • Coordinate with source system engineers and build ETLs to ingest various forms of new data into the data warehouse, via the sources listed above. • Actively emphasized the need to gain business context to the data, in order to deliver the most impactful data product to our business users. • Created a Power BI dashboard to actively monitor query performance for the data warehouse, enabling developers to implement targeted query optimization strategies. • Create and modify both Tableau and Power BI dashboards to meet reporting requirements, including writing DAX queries and custom formulas for KPI calculations.

• Performed reporting and analysis for a number of significant company initiatives• Designed multiple reports using Power BI for business stakeholders to actively monitor the health and state of high-priority projects• Created views, stored procedures and functions to help automate ad hoc data pulls and create consistent data sources for reporting• Worked closely with fellow analysts to troubleshoot underperforming T-SQL queries and offer feedback on reporting methodologies