Zach Willand Email & Phone Number

Lexington, Kentucky

• Managed the entire data platform lifecycle, including development and maintenance of a comprehensive data warehouse, ensuring optimal performance and data integrity.
• Led the successful migration of the data warehouse from on-premises infrastructure to Microsoft Azure for enhanced scalability and reliability.
• Administered and maintained the Power BI service, creating new reports and dashboards while ensuring data accuracy and consistency.
• Redesigned existing reports for a modern look and feel, while also significantly improving performance by leveraging data flows to reduce the impact of scheduled refreshes on data sources.
• Collaborated with business units to gather requirements and develop tailored Power BI reports, enabling data-driven decision-making across the organization.

• Work within the Microsoft BI Stack to develop and deploy custom cloud data warehousing to clients globally at a ten-time Microsoft Partner of the Year firm utilizing technologies such as Azure Synapse and Azure SQL.
• Responsible for working with clients at every stage of a project from requirements gathering and technical design to launch.
• Leverage SQL and SSAS to create complex data models and stored procedures, enabling seamless integration into BI reporting.
• Collaborate closely with Microsoft Dynamics365 consultants to ensure data warehouse design and reporting are impactful and align with ERP needs.
• Develop concise and targeted reporting with SSRS, Power BI and Excel.

Lexington, Kentucky, United States

• Support operational decision making by creating informative, actionable and repeatable Power BI reporting that highlights relevant business trends and opportunities for improvement.
• Leverage languages such as SQL, PowerShell, DAX, and Power Query to efficiently query large databases, write stored procedures and to automate transformations.
• Create complex data models in order to enable reporting on business performance from many different departments and fields.
• Develop and maintain Azure SQL databases, ensuring best practice is followed on database design and data storage.
• Develop and maintain Azure Data Factory and associated pipelines, enabling ETL, storage and analytics on data outside of Azure.
• Administrate Power BI service, ensuring best practice and efficiency in report and dataset/dataflow deployment.

Lexington, Kentucky, United States

Lexington, Kentucky Area

Lexington, Kentucky Area

Lexington, Kentucky Area

• Cellular and Molecular Biology

Cincinatti, OH Area

• Drove profitable sales by decreasing external, internal and operational shortages.
• District and group level trainer for assets protection leaders.
• Fostered a shortage awareness culture among leaders and team members.
• Developed and maintained relationships with local law enforcement.
• Investigated internal and external theft, conducted internal interviews.
• Implemented and led a safety initiative to mitigate risk to team members and guests.

• Research focused on mutation rates of GAG gene in Equine Infectious Anemia Virus.
• Personal research selected for presentation at 6 research conferences and published in two journals.

Master Of Science - M.S., Applied Engineering And Technology Management

Network Security Management Concentration

Double Major In Biology (B.S.) And Homeland Security (B.S.)

Activities and Societies: Phi Sigma Biological Sciences Honor Society, Homeland Security and Assets Protection Leaders of Tomorrow (HALT).

Ag. Biotechnology

Activities and Societies: Chellgren Fellow, National Freshman Honor Society, USAF ROTC Cadet Selected to present research on Equine.