Ryan Murphy
American Fork,UT
Summary
Current college student working toward a degree in Information Systems with and emphasis in Business Intelligence.
Overview
3
3
years of professional experience
Work History
Data Analyst Apprentice
WCF Insurance
Sandy, UT
08.2023 - Current
- Received, cleaned, and prepped data to build reports using PowerBI to help aid decision making processes and identify accounts that should be prioritized
- Created data visualizations using KPI's to point out trends and potential problems to address using data testing strategies
- Built macros in report templates to save ~90 minutes per week in manual data entry
- Collaborated with underwriters to gain insight in what KPI's insurance agents put the most emphasis on and what to consider including in reports
Data Analyst Intern
WCF Insurance
Sandy, UT
05.2023 - 08.2023
- Performed testing using macros to ensure quality, integrity, and usability
- Analyzed workbooks to ensure accurateness and completeness.
- Completed a variety of different projects along side senior data analysts to help aid them in their work
- Improved Excel workbooks that were messy and cluttered to make sure they are neat, tidy, easy to read and follow
- Assisted with resolution of customer issues by troubleshooting software errors and then performed corrective actions
Warehouse Associate
Fence Specialist
Lindon, UT
03.2021 - 05.2023
- Go to guy for application issues and general data questions
- Calculated inventory and measurements for common orders to prep for future orders, saving 30 minutes per order
- Pulled orders for customers, operated forklifts & pallet jacks
- Maintained a safe working environment by adhering to safety protocols and guidelines.
Education
Bachelor of Science - Information Systems
Utah Valley University
Orem, UT04.2025
Associate of Science - Business Management
Utah Valley University
Orem, UT12.2023
Skills
- Python - 1 year
- Data Visualization
- Microsoft Excel - 2 years
- Detail Oriented
- Good Communication
- Analytical mindset
Timeline
Data Analyst Apprentice
WCF Insurance
08.2023 - Current
Data Analyst Intern
WCF Insurance
05.2023 - 08.2023
Warehouse Associate
Fence Specialist
03.2021 - 05.2023
Bachelor of Science - Information Systems
Utah Valley University
Associate of Science - Business Management
Utah Valley University