• Utilized Tableau Prep Builder to develop data flows that clean, standardize, join, blend, and perform custom calculations on large raw flat datasets, transforming them into actionable data for advanced analytics.• Designed interactive dashboards to present COVID-19 vaccination data insights for the State of Hawaii, computing KPIs and discerning trends of doses administered for bivalent, monovalent, and 2023-2024 updated booster doses across demographic categories such as race, geography, age, and sex.• Merged three databases containing over two million observations and restructured datasets in DBeaver using SQL to eliminate duplications, missing values, and mismatching observations.• Constructed over 30 dashboards using Salesforce CRM products including Tableau Desktop and CRM Analytics tool, incorporating data modeling and computing KPI data metrics to facilitate comprehensive data analysis and derive actionable insights.

• Provided clients with highly detailed, personalized service to guide them to meet their beauty and health goals with fitting products.• Memorized product details and applied knowledge to articulately converse with customers and sell products. • Sold Factory 5 exclusive limited-edition collection products by consistently conversing and engaging with customers.

• Provided excellent customer service by helping with sales, customer inquiries, merchandising, and store maintenance.• Collaborated with a team to reach high individual and group sale goal.

• Manipulated data from MyGRC, TDA, and SIRIS using VBA, pivot tables, and charts through Microsoft Excel to conduct risk analysis and performance tests on oversight groups and enterprises.• Analyzed issues and writing business intelligence reports utilizing Tableau and identify risks to provide risk mitigation insights. • Presented risk analysis reports to manager twice a week and corporate risk team biweekly.• Collaborated with Schwab interns and full-time employees to produce data reports on capital stress tests, issue trends, and issue management.

• Created 20+ graphics for AXO’s social medias (Instagram, official website, and Facebook), sorority apparels, and presentations.

• Facilitate booth and building plans in CMU Spring Annual Carnival as Booth Design Chair.

• Design visualizations and markets for CPDC events, workshops, and daily operational tasks.• Review 5+ freshman and sophomore resumes and cover letters weekly, arrange freshman dorm workshops bi-weekly, and administer 3+ CPM appointments weekly.

• Produced business intelligence reports and dashboards weekly on costs and trends of 60,000 ~ 80,000 ticket incidents using Microsoft Power BI. • Analyzed data and generated pivot tables of ticket incidents weekly using Microsoft Excel. • Presented reports and dashboards, updated pages for MediaKind Projects, and evaluated TapMyBack data to select performance winners monthly.

• Utilized Python to transcribe interview transcripts into a standard csv format and analyzed data results. • Collected and reformatted data over 100 recorded video interviews, audio interviews, and emails

• Utilized python to transcribe interviews from transcript or chat format into a standard csv format and conduct analysis on data results. ¬¬• Completed research ethics training, corrected audio transcripts, combined and re-formatted emails and chat interviews, and tagged start and end of each interview question. (100 interviews)• Collected and managed data from recorded interviews through videos, audio, and emails.

• Organized biweekly meetings and led a team of freshmen students in a large-scale service project by running a succulent sale event raising $230.• Supervised leadership activities and conducted administrative roles at overnight Emerging Leader Retreat.• Researched service topics, designed awareness posters, and promoted fundraisers and mentor events.

Coordinate and run general events of the annual Spring Carnival hosted by the students of Carnegie Mellon University, including planning out events, organizing the event location/layout, and running events.

Operated cash register, managed customers’ orders and monitored bakery

Provided young children private swimming lessons, including freestyle, breaststroke, butterfly, backstroke, diving and flip-turn.