• Implemented historical point in time reporting within the Data Mart utilizing the Data Vault’s Type 2 SCD, cementing the warehouse as an accurate, trusted source leading to more confident hiring decisions for the business and teaching techniques and strategies for the classroom • Managed data acquisition project increasing funding by 115% resulting in total funding of $86M• Played an integral part in the formation of the Project Management Office, laying the groundwork for the… Show more • Implemented historical point in time reporting within the Data Mart utilizing the Data Vault’s Type 2 SCD, cementing the warehouse as an accurate, trusted source leading to more confident hiring decisions for the business and teaching techniques and strategies for the classroom • Managed data acquisition project increasing funding by 115% resulting in total funding of $86M• Played an integral part in the formation of the Project Management Office, laying the groundwork for the utilization of Team Pulse, and championing PMO’s integration into the enterprise• Delivered nearly 300 reports and analyses utilizing SQL Server Reporting Services (SSRS) supporting key processes in Finance, Logistics, Student Information, Marketing, external customers, and Operations• Oversaw the development of approximately 400 ETL packages and released to production using a self-managed Change Control process Show less

• Introduced incremental data loading which decreased nightly SSIS run time of 12 + hours down to under one hour• Designed and implemented a complete rewrite of the existing Data Warehouse using Data Vault methodology, ETL (SSIS), and dashboards (SSRS) saving the organization over $1.7M in contractor fees