Zachary Flynn
Ogden,UT
Summary
Data-driven quality engineer with expertise in software testing and a focus on data science and analytics. Proven experience in automation and SQL optimization at Focused Support LLC. Skilled in extracting actionable insights from complex datasets to enhance project outcomes. Strong ability to integrate quality assurance practices with advanced data modeling techniques.
Overview
3
3
years of professional experience
Work History
Software Test Engineer
Focused Support LLC
Logan, Utah
11.2024 - Current
- Led testing initiatives for inventory management product, ensuring comprehensive coverage and quality assurance.
- Designed and executed comprehensive test plans and cases for software applications.
- Conducted manual and automated tests across various projects to ensure quality.
- Collaborated with developers to identify, document, and resolve defects efficiently.
- Mentored junior testers on best practices and effective testing methodologies.
- Directed user integration efforts for inventory management system, improving overall data handling. Utilized Python with Pandas and NumPy to prepare data for seamless system ingestion. Executed SQL scripts to modify existing records within the integrated system efficiently.
- Developed SQL queries to assess data integrity across multiple databases.
- Participated in product design reviews to offer insights on functional requirements.
- Supported internal research and development through provision of mathematical principles and execution of Kalman filter machine learning model for aircraft targeting.
- Redesigned and upgraded organizer of testing environments, transitioning from Python and Django to Angular implementation.
Census Tree Team
BYU Record Linking Lab
Provo, UT
11.2022 - 08.2024
- Oversaw census databases containing 132 million observations, ensuring data integrity and accessibility for econometric analysis.
- Engineered and sustained machine learning models aligning sparse historical data with census records, enhancing data accuracy for analysis.
- Executed thorough data cleaning, reshaping, and manipulation to enhance data for machine learning and econometric analysis.
- Utilized diverse econometric models including ordinary least squares, instrumental variables, and quantile regression to extract insights from historical data.
- Directed small team in associating land patent records with census, promoting teamwork and fulfilling project deadlines.
- Synchronized efforts across multiple universities to facilitate smooth project execution.
- Developed visually compelling graphs and tables through Python and Stata to support conclusions in academic papers from the Linking Lab.
- Supported writing and editing efforts for academic papers ensuring clarity, accuracy, and alignment with scholarly standards.
- Designed and implemented innovative research projects focused on data analysis.
Econometrics TA: Teaching Assistant
BYU
Provo, UT
01.2024 - 04.2024
- Mentored and instructed over 50 diverse students in mathematical principles of econometric modeling, enhancing their analytical skills.
- Provided hands-on training in Python and Stata programming, empowering students to effectively clean, visualize, and analyze data within an econometric framework.
- Instructed students individually or in groups to reinforce learning concepts.
- Fostered inclusive learning environment through personalized guidance and support, improving student engagement and comprehension.
- Graded assignments and provided constructive feedback to promote learning.
- Supported students during office hours, addressing questions and concerns promptly.
- Developed instructional materials using educational software and tools effectively.
- Encouraged students to take an active role in their own learning process.
Education
Bachelor of Science - Economics
Brigham Young University
Provo, UT04-2024
Skills
- Python programming
- Stata analysis
- TypeScript Programming
- Data visualization and Tableau
- Statistical modeling
- Automated testing and quality assurance
- Security and performance testing
- API and database testing
- Automated testing
- Software development lifecycle
- Data analysis
- Problem solving strategies
- Project management
- Team collaboration
- Mentoring juniors
- Time management
- Project management skills
- SQL query optimization
Volunteer Experience
Church Of Jesus Christ of Latter-day Saints, Missionary, Orchestrated and led 35 training sessions for groups of up to 20 individuals, fostering skill development and cohesion. Implemented regular team performance evaluations on a weekly basis, providing constructive feedback and facilitating continuous improvement. Dedicated 10 hours per week to community service initiatives, including support for food banks and engagement with local community members, embodying the mission of service and compassion. 08/01/20 to 07/31/22
Timeline
Software Test Engineer
Focused Support LLC
11.2024 - Current
Econometrics TA: Teaching Assistant
BYU
01.2024 - 04.2024
Census Tree Team
BYU Record Linking Lab
11.2022 - 08.2024
Bachelor of Science - Economics
Brigham Young University