Zach Fry
Tucson,AZ
Summary
A self-motivated data and business analyst with strong analytical skills, attention to detail, excellent communication, and the ability to learn and work in a collaborative environment.
Experienced with database design and management, ensuring optimal functionality and performance. Utilizes SQL and data warehousing techniques to support business operations. Track record of maintaining data integrity and security, fostering reliable database environment.
Overview
10
10
years of professional experience
1
1
Certification
Work History
Database Specialist
University of Arizona, Transfer Credit and Articulation
04.2019 - Current
- Create various queries using PS Query for quality control and data analysis.
- Conduct independent research into institutions for organization maintenance.
- Developed a data structure to pull annual work numbers for the department.
- Analyze student and external institution data for quarterly reports used to determine departmental needs.
- Collaborate with campus users to modify or create new transfer credit policies.
- Create business process guides to ensure consistent business practices.
- Provide customer support to staff regarding transfer credit policies.
- Update student transfer credit records to align with policies.
Business Analyst
University of Arizona, Human Resources
06.2018 - 04.2019
- Work with cross-functional teams to address and solve systems issues.
- Provide customer support to newly hired employees, campus end-users and business offices.
- Participate in planning and implementation of system upgrades.
- Prepare fit-gap analysis, functional specifications, design prototypes, test plans and scripts.
- Create and maintain internal procedures and operational guides to document business practices.
- Troubleshoot UAccess Employee issues to assist campus end users.
- Make recommendations for solutions to reported problems.
Database Specialist
University of Arizona, Office of the Registrar
11.2016 - 06.2018
- Created reports using PS Query for various tasks in the Registrar’s Office.
- Maintained and modified queries to ensure accuracy and function.
- Performed testing and documentation of modifications to Registrar PeopleSoft pages.
- Communicated with users to troubleshoot problems and identify database needs.
- Created technical and non-technical database documentation.
Residency Classification Specialist
University of Arizona, Office of the Registrar
10.2015 - 11.2016
- Ran daily reports in PeopleSoft to identify and reconcile student record errors.
- Responded promptly to various student record inquiries from students and staff.
- Advised students, parents, and staff on ABOR and university policies.
Education
Graduate Certificate - Foundations of Data Science
University of Arizona
Bachelor of Applied Arts and Sciences - Business Administration, Minor in Aviation Management
Eastern New Mexico University
Skills
- Expert user of PeopleSoft/UAccess environments
- Comprehensive knowledge of MS Office, MS Excel and MS Word
- Understanding of sensitive data and FERPA
- Pilot license in rotorcraft
- Data analysis
- Reporting tools
- Reporting and analytics
- Fit-gap analysis
Certification
- Commercial Pilot License - Rotorcraft/Helicopter
Timeline
Database Specialist
University of Arizona, Transfer Credit and Articulation
04.2019 - Current
Business Analyst
University of Arizona, Human Resources
06.2018 - 04.2019
Database Specialist
University of Arizona, Office of the Registrar
11.2016 - 06.2018
Residency Classification Specialist
University of Arizona, Office of the Registrar
10.2015 - 11.2016
Bachelor of Applied Arts and Sciences - Business Administration, Minor in Aviation Management
Eastern New Mexico University
Graduate Certificate - Foundations of Data Science
University of Arizona