Resume

Professional Experience

Quality Business Systems Analyst

CooperVision

Victor, New York

Designed data warehouses using Extract, Transform, Load (ETL) processes in Oracle databases, enabling the development of 25+ high-performance Tableau dashboards, which generate digestible reports for upper management, guiding data-driven decisions.
Analyzed over 1 million data records using Oracle SQL, uncovering 5–8 actionable insights per dashboard on product status, consumer feedback, quality metrics, and workflow efficiency to enhance compliance and process outcomes.

Automated real-time global quality dashboards in Tableau by connecting to an Oracle database for seamless data updates, saving 160 person-hours per month and boosting reporting efficiencies by 96%.

Streamlined project collaboration by developing project management tools in Excel for 14+ stakeholders using dynamic charts, simplifying tracking and facilitating regular meetings.
Led Tableau training sessions for 70+ users across five global sites and the leadership team, developing documentation and user guides that improved dashboard adoption and data literacy.

Social Media Ambassador

University of Rochester -

Warner School of Education

Rochester, New York

Created engaging content using AI-powered tools and editor apps across Instagram, Facebook, and X, increasing reach by 630% within the first two months of launch.
Conducted market and keyword research on Gen Z behavior to guide and optimize social media content strategy.
Improved performance by analyzing metrics (reach, engagement, and conversion rates) using social media built-in analytics, and adjusted marketing plans for the target audience, achieving a 21.84% conversion rate for the Northeast Noyce members over two months.

Consultant

Simon Vision Consulting

Rochester, New York

Analyzed unstructured complex demographic data reports over 30 years in Rochester by using multivariate regression in R, identifying key factors of education, income and crime rates influencing socioeconomic enhancement.
Proposed improvement strategies include subsidizing IT companies and developing a community-university partnership program, supported by market research for the 200K+ population across 36 districts.

University of Rochester

Master of Science in Marketing Analytics

Rochester, New York

Relevant Coursework:

Tamkang University

Bachelor of Arts in English Language and Literature

New Taipei, Taiwan

Relevant Coursework:

Data & quantitative analysis

Requirements gathering & stakeholder management

Communication & storytelling

Problem-solving & critical thinking

SQL

Advanced Excel

Python

Tableau & Power BI

English (proficient)

Mandarin (native)