Data Analyst
Current• Manage and integrate data from multiple systems and applications (TPASC App, EZ Facility, GoHighLevel, Moodle, Power BI, Connect), providing timely and accurate insights to directors and managers, enabling data-driven decision-making• Troubleshoot SQL turnstile database issues to resolve member access problems at turnstiles, fitness center, and walking track• Develop a parking detection program that reduces parking-related complaints by 60%• Analyze and report on previous marketing campaigns, providing the marketing team with actionable insights that improve the efficiency of the "12 Days of Fitness," "Fall Membership," and "Boxing Week 2023" campaigns. This leads to a 70% reduction in advertising costs and a 65% increase in membership revenue compared to 2022 • Conduct customer churn analysis and develop a scoring system to rank the likelihood of customer churn. Implement targeted communication strategies based on these insights, resulting in an increase in retention rate from 52% in January-April 2023 to 85% in the same period in 2024 Collaborate with developers to launch the new TPASC App and integrate app data from CustomerIO to AWS S3. Develop interactive dashboards to analyze user behavior and engagement. Implement a Smart Watch Giveaway campaign, including a Python program for eligibility verification and a dashboard to track distribution, achieving 48% new app onboarding among active members within 2 months