top of page

Resume

Work
Experience

Feb. 2023 - Current

Sep. 2022 - Dec. 2022

Jun. 2022 -

Aug. 2022

Aug. 2020 -May 2021

​

  • Enhanced Electronic Payment Registration by 4% and increased $1.04M by creating three Qlik Sense Data Visualization Dashboards for five departments, enabling real-time data-driven business strategies.

  • Accelerated Credit Card Application rates by 5% through leading the Global Retail Application and NA Credit Card

    Power BI Projects across four regions and 3 departments.

  • Optimized 4 manual data update procedures, reducing average update time from 180 minutes to 10 minutes by

    transitioning network folders to SharePoint sites and automating file compilation using Power Query.

  • Selected out of 300 analysts to participate in the CNH Data League Market Share Analysis program, using Python for sanity checks, and leveraging IBM Cognos and Azure SQL to merge 12 tables and construct a Power BI visualization

    dashboard.

  • Revamped 31 monthly financial data updates by creating Excel VBA scripts to automatically update PowerPoint

    presentations and enhanced Excel spreadsheets with Macros.

  • Utilized Azure SQL and Qlik Sense SQL to perform ETL and data transformation from IBM Cognos, designing Star

    Schema and Snowflake data models to support dashboard development.

  • Managed cross-functional communications across Sales, Underwriting, Contact Management departments, Credit Card

    department and Finance, aligning data team efforts and director-level requirements with project objectives.

CNH Industrial

Business Intelligence Analyst

Racine, WI, US

​

FedEx Corporation

Business Analyst Consulting Project

Pittsburgh, PA, US

​

​​

  • Led a team of 15 students, managing both technical and non-technical workstreams to conduct qualitative research.

  • Conducted Tableau visualization competitors analysis dashboard and performed data cleaning using Python to

  • formulate actionable recommendations.

  • Achieved first place in the KPMG Consultant Cup and received an award from FedEx.

MoonShot Museum, Astrobotic

Business Analyst Intern

Pittsburgh, PA, US

​

​

  • Increased attendance by 8% through the Visitor Analysis Tableau dashboard, which focused on identifying major customer segments and the most popular exhibits, leading to targeted and effective marketing campaigns.

  • Executed Community Engagement Analysis by utilizing SQL for data extraction and building comprehensive visualizations with Python, resulting in actionable insights to enhance community outreach and engagement strategies.

Auchan Retail International S.A.

Business Analyst

Taipei, Taiwan

​

  • Drove interdepartmental collaboration among IT, BI, and marketing teams to optimize the IKEA co-branding strategy, resulting in a 5% increase in profitability.

  • Evaluated Sales Performance Analysis across 556 shops by developing a KPI Power BI dashboard and leveraging SAP ERP and EI Consumer Profile data.

Education

2021 - 2022

2016 - 2019

University of Pittsburgh
Joseph M. Katz Graduate School of Business

Yuan Ze University
College of Management

Pittsburgh, PA, US

Master of Science in Marketing Science & Business Analytics (STEM)

Taoyuan, Taiwan

Bachelor of Business Administration, Certificate in Marketing

Skill &
Certification

Analytics, Programming & Database:

SQL, Tableau, Adobe Analytics, SPSS, SAS, Python, R

Marketing:

Google Analytics & Ads, Google Optimize 360,

SEO, Spectra, HubSpot, SAP ERM,

Eastern Integrated Consumer Database

, NetBase, Photoshop


Microsoft Office:

Excel, Solver, Project, Access


Language:

Chinese – Native, English – Fluent, Japanese – Basic

 

Certification:

Advanced SQL Kaggle, Inro to SQL Kaggle, 

Pandas & Data Visualization Kaggle, Google Ads Search, Hootsuite Platform

bottom of page