• Performed end-to-end management of data using Waters Empower3 and NuGenesis SDMS platforms, including ETL process development, data cleaning, aggregation, and optimization of data pipelines; Collaborated with laboratory scientists to translate data requirements into actionable insights and visualizations, ensuring data integrity and regulatory compliance while providing technical support for system-related issues• Conducted thorough data cleaning, transformation, and validation procedures to guarantee the precision, coherence, and reliability of data within the Rotronic Environment Monitoring System and Blue Mountain Regulatory Asset Manager System• Established and enforced standard operating procedure (SOP) to ensure compliance with data governance policies and industry regulations• Utilized Microsoft Azure to manage email systems, leveraging Azure Active Directory for identity and access management, Azure Exchange Online for email hosting, and Azure Information Protection for email encryption and compliance. Implemented and maintained email policies and configurations to ensure security, reliability, and compliance with organizational standards and regulatory requirements

• Evaluated TV/digital media campaign performance and delivered observed findings and insights to both internal and external stakeholders• Calculated monthly LTV, average per order value, purchase frequency over last 6 years and extracted MoM/YoY LTV trend fluctuations and made assumptions around potential driver; Projected future matured monthly LTV between sub vs. non-sub customer groups; Explored significant variation on customer LTV among multiple online/offline channels; Identified the top LTV-generating TV media list based on purchase frequency, customer size and ROAS• Assisted in the maintenance/upgrade of cooperation internal BI tool for fast data query, transmission, and reporting via imbedded SQL server connection• Used R/Python to conduct web scraping and sentiment analysis on online customer reviews to identify client’s product/service pain and selling points and provided recommendations to client• Collaborated with internal cross-functional team on data ETL and EDA

• Created an interactive dashboard with Tableau to present the KPIs and visualizations that support basic statistics analysis needs based on OTT platforms’ advertisement performance data from Google Analytics and investment records of client. • Built machine learning models to explain the ads response with multi-stimulus and applied the most proper model to different clients.

• Predicted and optimized the purchase portfolio based on the inventory of resources to produce standard product and non-standard product and the customers’ demand. • Designed a production plan with manufacture department and quality testing department to guarantee period and quality. • Created a dashboard with Tableau to visualize the production plan and shorten about 7% of original production time.