Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Dave Pan

Anaheim,CA

Summary

Results-driven Data Analyst with experience at Deloitte, skilled in data visualization and analysis. Proven ability to enhance decision-making through advanced Excel functions and Python programming. Demonstrated strong collaboration and communication skills while optimizing SQL queries and ensuring data accuracy, leading to improved productivity and reliable insights.

Positive and analytical with knack for turning data into actionable insights. Comprehensive understanding of statistical analysis and data visualization tools such as SQL and Tableau. Dedicated to leveraging data-driven strategies to drive success and innovation.

Overview

2
2
years of professional experience
1
1
Certification

Work History

Entry Level Data Analyst

Deloitte
10.2024 - 12.2025
  • Produced monthly reports using advanced Excel spreadsheet functions.
  • Utilized data visualization tools to effectively communicate business insights.
  • Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.
  • Improved decision-making processes with accurate data analysis and visualization techniques.

Data Analyst Intern

Presidio
02.2024 - 10.2024
  • Conducted thorough data validation and cleanup, ensuring accuracy and reliability of datasets used for analysis.
  • Optimized SQL queries for faster processing times, increasing overall productivity within the team.
  • Completed data cleaning and data validation of existing spreadsheets to promote robust data management platform, resulting in accurate data analysis and entry.
  • Enhanced data visualization capabilities for better decision-making with the use of advanced BI tools.

Teacher's Assistant

Woodbury University
07.2024 - 09.2024
  • Supported classroom maintenance and upkeep, organizing books, and materials.
  • Supported classroom activities, tutoring, and reviewing work.
  • Helped with grading assignments and tests, providing constructive feedback to students based on results.
  • Maintained safety and security by overseeing students in recess environments.

Research Assistant

04.2024 - 08.2024
  • Participated actively in regular meetings with fellow researchers to discuss project updates, challenges faced, and lessons learned during ongoing activities.
  • Organized research materials, maintaining a well-ordered workspace conducive to productivity.
  • Maintained open lines of communication with project leads and team members for effective collaboration on common goals.
  • Conducted literature reviews to support hypothesis development and identify gaps in existing knowledge.

Education

MBA - Automated Management Information Systems

International American University
Los Angeles, CA
05-2016

Skills

  • Data visualization and presentations
  • Data analysis
  • Python programming
  • Excel functions

Certification

  • Certified TensorFlow Developer
  • Microsoft Azure AI Engineer Associate – Microsoft
  • Ethics in AI for Legal Applications
  • Advanced C# Programming & Modular Architecture

Timeline

Entry Level Data Analyst

Deloitte
10.2024 - 12.2025

Teacher's Assistant

Woodbury University
07.2024 - 09.2024

Research Assistant

04.2024 - 08.2024

Data Analyst Intern

Presidio
02.2024 - 10.2024

MBA - Automated Management Information Systems

International American University
Dave Pan