- Advanced Microsoft Excel Skills
- SQL
- R programming
Nathan Pryer
Data Analyst
Summary
Experienced data analyst with a proven track record in driving process improvement, managing business operations, and reporting key performance indicators (KPIs). Proficient in utilizing Excel, SQL, Power BI, and Tableau to extract valuable insights from complex datasets. Highly motivated to integrate technical skills with analytical expertise to foster innovation and enhance operational efficiency across all aspects of the business.
Overview
4
4
years of professional experience
5
5
years of post-secondary education
1
1
Certification
Work History
Junior Data Analyst
Total Vision
08.2023 - Current
- Transformed complex sales data into visually impactful reports in Excel and Tableau utilizing tools such as Power Query, array formulas, pivot tables, and dynamic data visualizations to provide clear insights
- Generated and distributed daily, weekly, and monthly reports, including WIP reports, Accounts Receivable Aging reports, and Vendor Sales Reports to facilitate data-driven decision-making
- Utilized SQL to query databases, extract insights, and produce customized reports tailored to stakeholder needs
- Created and presented interactive dashboards in Tableau, enabling real-time tracking of key performance indicators and improving the visibility of sales trends and team performance
- Automated repetitive data analysis tasks through the creation and implementation of Excel macros and SQL scripts, enhancing operational efficiency and accuracy
Accounts Payable Specialist
Total Vision
07.2022 - 08.2023
- Verified the accuracy and completeness of invoices and investigated invoice discrepancies using Sage Intacct
- Addressed payment issues and responded to vendor inquiries, ensuring efficient resolution
- Maintained petty cash, fielded calls, and negotiated with vendors regarding services and available discounts
- Accurately recorded financial transactions in Sage Intacct, consistently maintain a 100% accuracy rate in strict adherence to internal policies
Financial Representative Internship
Northwestern Mutual
01.2021 - 04.2021
- Successfully acquired my insurance license for Life, Accident, and Health coverage
- Expanded my clientele by engaging in effective prospecting and networking strategies
- Assist in developing financial plans and strategies for clients based on their individual goals and risk tolerance
Education
Bachelor of Arts - Finance
San Diego State University
San Diego, CA 08.2017 - 07.2022
Skills
Certification
Google Data Analytics Professional Certificate
08-2024
Timeline
Google Data Analytics Professional Certificate
08-2024
Junior Data Analyst
Total Vision
08.2023 - Current
Accounts Payable Specialist
Total Vision
07.2022 - 08.2023
Financial Representative Internship
Northwestern Mutual
01.2021 - 04.2021
Bachelor of Arts - Finance
San Diego State University
08.2017 - 07.2022
Similar Profiles
Marlina SalazarMarlina Salazar
Optician at Total VisionOptician at Total Vision
Joanne GonzalesJoanne Gonzales
Optometry Practice Manager at Total VisionOptometry Practice Manager at Total Vision
Cesar BustosCesar Bustos
Assistant Manager at Total VisionAssistant Manager at Total Vision