Resume

Professional Experience

Quality Business Systems Analyst

CooperVision

Victor, New York

Built Oracle-based data warehouses using ETL pipelines and analyzed 1M+ records with SQL to deliver actionable insights via Tableau dashboards on product status, customer feedback, and process efficiency, supporting leadership decision-making.
Automated real-time global quality dashboards in Tableau with live Oracle connections, saving 160+ person-hours per month and improving reporting efficiency 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.
Developed data-driven Lot Trace workflows to improve traceability across manufacturing, packaging, and distribution systems, reducing investigation time and strengthening supply chain control.

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.

Research & Data Analysis 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)