Miranda Yuen Email & Phone Number

• Aggregating data from CRM system and interpreting sales, product data using advanced Excel functions— power query, data validation, pivot table, formula, etc. — to provide insights at management level
• Establishing and revamping SOP for Purchasing and Warehouse Dept. to increase data quality by 90%

• Monitored closely over company daily transactions which generated approximately $9M annual revenue in total
• Configured Data Queries and transformed millions of data sets into comprehensible reports for the reference of internal and external stakeholders
• Trained and on-boarded new staff; provided supervision and guidance to ensure adherence to company policies

San Mateo, California

• Prepared 50+ invoices monthly with precision, achieving a 99% on-time collection rate
• Replied and followed up inquiries promptly to provide ongoing support
• Served as a liaison between departments, facilitating communication and circulating new company policies
• Screened phone calls, greeted visitors with courtesy and made correct referrals to provide exceptional customer service

Hsinchu, Taiwan

• Analyzed product breakdowns and offered professional solutions to international customers in English, solving 90% customer service issues independently
• Composed various documents creatively for executive and department, including forms, reports, agendas and presentations using Microsoft Office (Word, Excel, PowerPoint)
• Connected and maintain relationships with 200+ global business partners, customers and local vendors as a primary point of contact
• Sorted incoming/outgoing mails and distributed them to corresponding recipients
• Prepared 60+ sets of invoices/shipping slips for purchasing orders in English weekly

Taipei City, Taiwan

• Keyed more than 100+ points of data into database software and amended information upon customer request in high accuracy
• Responded daily to more than 50+ questions to resolve customer inquiries/problems via phone and e-mail
• Collaborated with colleagues and vendors to fulfill assignments and duties effectively in a fast-paced environment
• Filed and maintained confidential company and client contracts with discretion
• Coordinated with over 120+ customers per week to obtain detailed information before pressing deadlines

Taiwan

• Screened and routed phone calls, greeted visitors with courtesy and made correct referrals to sustain customer satisfaction
• Trained and led new staff in school policy adherence in order to maintain workflow
• Prioritized and organized tasks in the order of urgency and importance to enhance office efficiency
• Monitored and maintained office supplies, replenishing to meet minimum quantities
• Set up conference room before meetings, preparing AV equipment, and meeting materials