YUNJEONG KIM

Burger King CRM & Coupon Analytics Project
• Collected, cleaned, and validated large-scale customer transaction data (user ID, purchase history, order details, payment data), ensuring accuracy before database entry and reporting
• Performed data cleansing using SQL, Python, and Excel (duplicate removal, missing value checks, format standardization) and maintained reliable datasets for analysis
• Supported reporting and stakeholder communication by extracting data, preparing Excel reports, and delivering bi-weekly PPT presentations and dashboards

Meiji Retail Location & Consumer Segmentation Project
• Collected and organized multi-source data (demographic data and survey responses), ensuring consistency and usability for analysis
• Conducted data validation and segmentation analysis (Factor Analysis, K-means) to classify customer groups and support data-driven retail decisions
• Prepared and delivered data insights and analysis in PPT presentations, clearly communicating findings to client stakeholders

• Performed accurate data entry and validation of high-volume international invoices, ensuring compliance with internal policies and accounting standards (GAAP)

• Organized and digitized financial documents by converting paper records into structured electronic files, improving accessibility and record tracking

• Responded to high-volume email inquiries from global teams, resolving invoice discrepancies and providing clear, timely communication using Outlook and Teams