- Improved data ETL pipeline and Data Warehouse with four key stakeholders using Python, SQLite, and Excel, achieving a 90% increase in efficiency - Develop 5 reporting dashboards using Power BI to monitor operational performance and reduce report creation time from 4 hours to 20 minutes per report - Analyzed data from 90000 donors (22000 monthly active donors) and used output to guide marketing and donor engagement strategies

- Organized the venue and meticulously processed orders, packaging over 100 bottles of wine for customer purchases - Serviced over 40 customers with engaging hospitality, achieving a 2% conversion rate through effective communication and product knowledge

- Conducted comprehensive analysis of 15 million customer shopping records, utilizing RFM and LTV models for customer segmentation. Developed tailored marketing strategies for different customer groups, enhancing targeted marketing efforts - Developed predictive models using Python, achieving an approximate 20% accuracy rate in predicting customer purchases - Designed and analyzed online user surveys for the Carrefour e-commerce platform, focusing on website experience, advertising marketing, and recommendation systems. Proposed 3 distinct solutions to optimize the online user journey and enhance customer engagement

- Managed the warehouse of firefighter Tools and Equipment to maintain the safety and availability of over 50 types of equipment - Led a team of 10 assistants and collaborated with 3 instructors to streamline the equipment management process for over 100 students daily, enhancing efficiency by 30% - Analyzed, collected, and documented over 5 types of class information to build the database for instructors to efficiently make plans for the course, which improved efficiency by 90%

Data Analyst Intern October 2020 - November 2021 / Taiwan, New Taipei City - Collaborated with 5 colleges from the operation and marketing team to figure out the needs of indicators and make the plan for the ETL pipeline of digital Ads data and the data dashboard building - Received, cleaned, and prepped data (10K records per month) from Ads platforms API using Python, and SQL Server to help the marketing and operation team have automated real-time supervision - Built extensible and maintainable data dashboard for supervising digital Ads KPIs and manual reporting led to reducing 90% of the processing time