Yue Pan
CIRRO Fulfillment
Jersey City,NJ
1
Certification
3
years of professional experience
Data Analyst with experience leveraging SQL, Google BigQuery, AWS Athena, and BI tools to analyze large datasets, improve data quality, and deliver actionable business insights. Experienced in gathering business requirements, performing data profiling, validating data accuracy, documenting KPI definitions, and developing dashboards that support business decision-making. Strong background collaborating with cross-functional stakeholders to investigate data issues, perform root cause analysis, and improve reporting processes. Proficient in SQL, Power BI, Tableau, Looker, Excel, and Python.
Work History
Operations Analyst – Customer Success
7 Months- Developed Power BI dashboards and operational reports to monitor fulfillment KPIs, shipping performance, inventory accuracy, and customer service metrics.
- Analyzed operational data using SQL Server (SSMS) to investigate shipment delays, inventory discrepancies, and customer-reported issues.
- Collaborated with warehouse operations, customer success, and business stakeholders to translate reporting requirements into automated dashboards and reports.
- Performed data validation, reconciliation, and root cause analysis to ensure reporting accuracy across operational systems.
- Documented KPI definitions and reporting logic while presenting analytical findings and operational insights to business stakeholders.
Marketing Analyst
2 Years- Designed and maintained interactive Looker and Tableau dashboards that provided clients and internal marketing teams with real-time visibility into email marketing campaign performance, customer engagement, and business KPIs.
- Developed complex SQL queries using Google BigQuery and AWS Athena to analyze campaign performance, customer segmentation, conversion trends, retention metrics, and marketing ROI across large datasets.
- Partnered with account managers, marketing strategists, and client success teams to gather reporting requirements and translate business questions into scalable dashboards and self-service reporting solutions.
- Performed end-to-end data validation and QA by reconciling dashboard metrics with source systems, identifying reporting discrepancies, and resolving data quality issues before client delivery.
- Automated recurring client reporting workflows using SQL, Looker, and Tableau, significantly reducing manual reporting effort while improving reporting consistency and accuracy.
- Conducted campaign performance analysis to identify trends, customer behavior patterns, and optimization opportunities, presenting actionable insights that supported marketing strategy and client decision-making.
- Documented KPI definitions, business logic, source tables, and reporting methodologies to establish standardized reporting processes across marketing analytics projects.
- Collaborated closely with engineering and data teams to validate ETL outputs, troubleshoot data pipeline issues, and ensure reliable reporting across multiple marketing platforms.
- Presented analytical findings through executive dashboards and client-ready reports, translating complex datasets into clear business recommendations for technical and non-technical stakeholders.
Marketing Analyst Intern
8 Months- Wrote SQL queries in Google BigQuery to analyze customer segmentation and campaign performance.
- Supported dashboard development in Looker and Tableau.
- Conducted data validation and quality checks.
- Performed exploratory data analysis to identify trends.
- Prepared recurring KPI reports.
Education
Master of Science - Quantitative Methods in Social Science
Bachelor of Arts - Psychology
Skills
Programming: SQL
Python
R
DAX
Databases: Google BigQuery
AWS Athena
SQL Server (Basic)
Relational Databases
BI: Power BI
Tableau
Looker
Google Analytics
Klaviyo
Analytics: Data Profiling
Data Validation
Data Quality Assessment
Root Cause Analysis
Business Requirements Gathering
Data Mapping
Metadata Documentation
ETL Concepts
Dashboard Development
KPI Reporting
Tools: Excel (Power Query
Pivot Tables
XLOOKUP
INDEX/MATCH)
PowerPoint
Word
Certification
- Microsoft Power BI Data Analyst (PL-300) – In Progress
- Google Analytics Certification
- PCAP - Python Certified Programmer
Languages
English
Professional Working
Chinese (Mandarin)
Native or Bilingual
Timeline
Operations Analyst – Customer Success
CIRRO Fulfillment
01.2026 - CurrentRead More
Marketing Analyst
Alchemy Worx
12.2023 - 12.2025Read More
Marketing Analyst Intern
Alchemy Worx
04.2023 - 12.2023Read More
Graduate Center – CUNY
Master of Science from Quantitative Methods in Social Science
Read More
Baruch College City University of New York
Bachelor of Arts from Psychology
Read More