Zach Madson

Guiding customers on optimization of post-production workloads in the Snowflake ecosystem - Building internal tools and applications to support these functions at scale.

Served as Data SME for the Emergency Response division, requiring deep knowledge and handling of sensitive personal data, building robust data models, and resolving urgent ad-hoc requests related to all aspects of Business Operations (clinician credentialing, residential placement, and expense management). End-to-end development of PowerBI applications for senior leadership in order to provide Business Operations & Revenue KPIs across the enterprise. Responsibilities include leading requirements gathering sessions, building out data-model and testing scripts for Dev/QA/Prod environments, front- end development, design, and A/B testing. Analysis and automation of a manual data extraction process with a Dynamic SQL script, eliminating over 10 hours of weekly manual work. Eliminated outdated manual data export relied upon for enterprise-critical KPIs (revenue tracking, recruitment conversion rates) into a secure, automated, and daily refreshed PowerBI application. Greatly improving data quality and security management, trend evaluation, and business decision making.

Investigated and resolved a critical data quality issue within the production environment, successfully migrating and updating over 150 SQL scripts, resulting in a significant drop (>30%) in associated ServiceNow tickets. Optimized and managed SQL Stored Procedures and Views responsible for providing data for 3 different critical internal applications leveraged across the global enterprise. Update resulted in a reduction of ServiceNow tickets related to application failure and data discrepancies by over 70%. Developed a comprehensive Revenue Forecasting reporting suite using SSRS to provide Partners and Senior Managers with actionable insights on fiscal year performance and areas for optimization in response to the impact of COVID-19. Creation of a PowerBI dashboard analyzing usage of legacy reporting systems and data structures identifying objects eligible for decommissioning based on usage over the past 2 fiscal years, reducing enterprise warehousing costs annually.

Machine Learning (CS 7641) Machine Learning for Trading (CS 7646) Game Artificial Intelligence (CS 7632) Video Game Design (CS 6457) Software Design Process (CS 6300)