leowu

Increased data-driven decision-making efficiency about FORWARD Lupus Registry by 27% through comprehensive data analysis. Led the team in task coordination, ensuring the timely delivery of project milestones, fostering collaboration within the group, and providing regular weekly updates to stakeholders. Documented data from multiple sources using SQL and Excel, creating a comprehensive data dictionary and generating derived variables from raw data to facilitate advanced analysis.

Achieved an 11% increase in customer retention by implementing the RFM model (analyzing Recency, Frequency, and Monetary value) to create more effective customer segments. Developed an interactive dashboard of sales performance tracking, e.g., line charts of daily sales for each customer segment, leading to better analytically informed decisions efficiency with stakeholders. Conducted data extraction processes using SQL and Python, processing over 100,000 customer records to support data warehouse development.