- Collaborated with marketing to design SMS campaigns, applying HiveQL for targeted user selection and boosting user engagement and retention rate.- Partnered with the OA data team to transform real-time API data into interactive reports using Python and HiveQL, resulting in improved fee payment monitoring and reduced overdue rate.- Led the validation of 44 user persona tags, achieving over 90% coverage rate for primary tags, and utilized BI tools for performance visualization.- Implemented data-driven strategies across 3 projects, enhancing user engagement, ensuring timely payments, and optimizing resource allocation for maximum returns.