• Contributed to monthly order growth of 15% by investigating invoices by SQL, providing insights about seasonal purchasing patterns with discounts and popular telecom packages, and edited market development according to the target market• Promoted the virtual card, and the usage of Telecom’s cellular services on customer data across live chat, telephone, direct mails, and social networks to qualify the value of CRM initiatives and identify attrition risks, applied statistical methods, and built reports to suggest cohort marketing plans; Tracked down user behaviors and provided a recommendation on social media posts• Created dashboards and visualizations of user engagement, conversion rate, and retention rate over time to validate the solution with managers and present the user trend, increasing the target customer order by 12%• Mapped and analyzed customer profile and transaction activity from owned channels and produced insights for automatic payment, reducing complaints of the payment process; Helped CRM team to optimize the special customer use cases

• Recorded the popular dish of beef and vegetables through previous orders by SAP Customer Checkout; Contributed to a new package by SQL and modified the product mix to optimize profitability, effectively increasing the sale by 10%• Developed “First in, First out” inventory valuation to track perishable inventory and avoid large amounts of obsolete inventory, boosting net income and asset size in periods of rising inventory prices; Reduced theoretical recipe costs by incorporating inventory portioning and theoretical yields into each menu item in 8%• Modified customer profile on customers’ preference, frequency of visit, allergies,and reviews from SAP Customer Checkout and CRM data, accelerating table turnover rate by 19%

• Optimized shift work scheduling by What-If Analysis to consider the duration per shift, the weekends, and normal salary as predictors of the number of staff, and the number of customers during the busy time, maximizing employee productivity by 12%• Selected top 6 supply chains by Logistic Regress Model based on Key variables of the consolidation of logistics and warehouses, the year of opening, and the source of food, sustaining over 98% customer satisfaction among suppliers