Kai Cheng (Kevin) Lo Email & Phone Number

Lincoln, Nebraska, United States

Lincoln, Nebraska, United States

• Optimized dynamic, scalable pricing models for both slow- and fast-selling SKUs using SQL. These models adjust in real-time based on various inventory metrics and market conditions, including competitor pricing, days.
• Conducted comprehensive analysis to identify assortment growth trends. Evaluated procurement status, out-of-stock%, category performance. Delivered strategic insights to leadership by identifying SKUs slated for.
• Implemented meticulous validation checks that resulted in a 20% decrease in discrepancies. Developed and maintained protocols to identify and rectify data inconsistencies promptly, ensuring reliable and consistent data.

Addison, TX

• Designed and implemented interactive Tableau dashboards to provide clear insights into monthly electricity usage, empowering management with data-driven decision-making capabilities.
• Executed a comprehensive cleanup of the company’s client database using MySQL Workbench, successfully eliminating data duplication and inconsistencies. This initiative streamlined data retrieval processes, resulting in.
• Leveraged advanced Excel functions to meticulously analyze over 20 renewable energy open-data sources. Insights gathered were translated into detailed energy trend reports on both Tableau and PowerBI, positioning them.
• Spearheaded the development of a robust internet marketing strategy in collaboration with an external consulting firm. The strategy was crafted to drive engagement and growth, with a projected increase of 300% in.

Master'S Degree, Business Analytics, 3.44 Gpa

Project : Cricket wireless customer segmentation with Python ▪ Subdivided Cricket customers into 4 different groups by cluster analysis.

Bachelor'S Degree, Statistics

Data Mining Project • Utilized Excel (Chart,Pivot table, Filter, Formula…) for cleaning and analyzing transaction data of a fashion store..