Xu Ran: Marketing Analyst in Irvine

Remote • Analyze the company's e-commerce sales data from various platforms including T-Mall, JD, Red Book, Tik Tok, & etc. Provide recommendations on upcoming sales strategies for the management team, with a special focus on under- performed products • Leverage Power Survey tools to create reports and monitor daily, weekly, and monthly client volume, product reviews and sales from each platform. Provide budgeting, projected sales and inventory adjusting recommendation • Conduct analysis on historical sales, marketing performance, online survey data, provide recommendation on social media influencers collaboration, drove over $1 million sales during major e-commercial sales events

Manage the restaurant's online ordering system with 2500 members, process 200+ daily orders, adjusting the cooking based on online orders, and create weekly reports for leadership reviews • Conduct analysis on customer schedules, historical sales, and meal popularity. Forecast future sales to guide inventory and upcoming meal preparation. Provide recommendations on cost efficiency optimization and general day to day operations. • Lead Voice of the Customer program, professionally communicate with new and existing customers and leverage findings to improve operational efficiency and customer satisfaction

Xuanhan, China • Advanced functional strategic plans and goals to support company mission and vision to enhance company's business and revenue performance • Developed management decisions including recruitment strategy, revenue analysis, and customer relations to ensure the attainment and meeting of company goals • Assisted with design of commercial and government advertising products utilized in local market • Engaged with external stakeholders to ensure timely product delivery and solicitation of customer feedback • Identified and resolved technical and customer issues by providing appropriate alternative solutions

China • Oversaw four approval processes designed to verify applicants' visa paperwork, employment, and assets certification • Input applicants' confidential information to Schengen visa system and fulfilled requisite background check • Processed individual and group visa applications totaling over one thousand applications per week • Partnered with local governments to coordinate and execute cross-cultural events and festivals • Collaborated with Chinese and Italian commercial companies for business visitors' visa applications