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