• Visualized sales differences among games with Tableau to analyze ROIs for tickets with different features• Integrated data from different databases such as Qlik Sense, US Census, and Lottery Player’s Club• Analogized the sales of $50 tickets in Arizona from the data of other states based on regression model built with Microsoft Azure Machine Learning Studio• Presented the application of Data Support Decision Making Process in the Lottery industry in North American Association of State and Provincial Lotteries conference held in Phoenix, July 2019

• Created KPIs to evaluate the striping efficiency based on references from the Missouri Department of Transportation• Guided the team to switch the focus from striping machines to the labor force, which was the key factor impacting the striping capacity• Differentiated the striping efficiency of the team size ranging from 3 to 5, using the data extracted with Pivot Table• Rearranged the working schedule and increased the ideal capacity by 25% with the employee staggering model built with Microsoft Excel Solver Add-In

• Mapped out Western Maricopa Education Center’s process of purchasing with Microsoft Visio• Built process tracking board and visualized the purchasing process by applying “Kanban” system• Reshaped the size of order by regulating purchase date• Reduced the utilization of the bottleneck of purchasing process by 10.63%

• Fetched and reorganized data from Web of Science by applying VLOOKUP function• Subdivided universities and accelerated the speed of sales team reaching out to potential customers• Ensured all schedules were fully compliant with internal policies and customers’ needs at Publons’ Marketing Campaign held in Beijing, May 2018• Collaborated with different teams to facilitate the SMARKET email marketing process that converted more than 150 followers into customers