Zachary Berard Email & Phone Number

Kansas City, Kansas, United States

- Designed and developed interactive PowerBI dashboards, enhancing data visualization and business intelligence reporting for key stakeholders.- Utilized Azure Data Factory to orchestrate and automate data workflows, ensuring efficient ETL processes for seamless data integration.- Leveraged Azure Synapse Analytics for large-scale data processing and analytics, enabling high-performance data querying and transformation.- Implemented robust data models in PowerBI, incorporating DAX calculations to provide in-depth insights and advanced analytics.- Collaborated with cross-functional teams to gather requirements and translate business needs into technical specifications for dashboard development.- Managed and optimized Azure SQL Database and Azure Data Lake storage solutions, ensuring high availability and scalability of data resources.- Developed custom PowerBI visuals and extensions using R and Python scripts, enhancing the analytical capabilities of dashboards.

The Archonate is the governing body of Phi Gamma Delta that ensures Phi Gamma Delta is following the strategic plan set by the board. I actively represent the interests of over 9000 undergraduate fraternity members as a full voting member on the international fraternity's Board of Directors. I also collaborate with fellow board members to make strategic decisions regarding the fraternity's policies, initiatives, and long-term goals. In this role, I demonstrate leadership and advocacy skills by effectively communicating the perspectives and concerns of undergraduate members to the board, contributing to informed decision-making processes.

Manhattan, Kansas, United States

- Responsible for all chapter operations. - Lead the chapter to receive the IFC Gold standard for 8/9 categories. - Lead the Chi Deuteron chapter to achieve the best GPA of all 22 Fraternities on campus for the first time in chapter history.- In K-States IFC's annual Fraternal Excellence awards in 2023, Chi Deuteron took home an award for the best philanthropy and service among all chapters at Kansas State- Nominated as a finalist for Chapter President of the Year in 2023 FEAs.- Oversaw a GPA improvement from 3.24 to 3.48 over 3 semesters as chapter president

Manhattan, Kansas, United States

I was responsible for collecting, organizing, and reporting grade data for all members of the chapter. I was also tasked with creating new incentives to improve scholarship.

Manhattan, Kansas, United States

• Manage weekly lab sections for the course, guiding students with difficulty understanding the material. • Hold office hours to assist students on homework assignments.

Kansas, United States

-Responsible for developing applications to streamline how financial reports are generated-Utilize SQL Server Management Studio, Python, and PowerBI to develop a database dashboard to display relevant information about database and backup health in an easy-to-digest manner. -Assist DBAs in ensuring that databases are healthy and accessible to all users.-Collaborate with other interns on a meaningful HR project focusing on community outreach and brand recognition among college campuses.

Kansas, United States

Managed all documentation, storage, and shipment of over 2500 case files to an offsite facility. Acted as an urgent document runner in the Kansas City Area.