
Associate Database Manager (Data Analytics & BI)
WOOP.WORLD · Jan 2025 – Present
- Own end-to-end data operations for a 9-brand, 5-country FMCG lead-generation program (Nestlé, Abbott, Unilever, Reckitt, Fonterra) across Malaysia, Philippines, Vietnam, India, and Indonesia.
- Designed and implemented SQL deduplication logic (Opt-in Code + MIN(Opt-in Date)) to identify each user's first valid interaction, eliminating duplicate leads across manual files and API-fallback processes, and generated % validity metrics to assess lead quality per brand.
- Built a Python automation script to fetch client data from the database, apply deduplication logic, and generate client-ready files replacing a fully manual Excel process and cutting file-creation time from 3-4 hours to ~10 minutes.
- Diagnosed and fixed a critical bug in a live Quickwork API journey where a flawed monthly-target query compared month numbers only (not month + year), which was silently blocking lead delivery on an active campaign.
- Built and maintained Metabase dashboards (daily performance tracking, opt-in monitoring, brand-code reconciliation) and a country-wise funnel analysis dashboard to surface campaign drop-off.
- Automated a WhatsApp lead-intake flow (Interakt + n8n) with built-in validation checks, and led the migration of client data-download infrastructure from PointerPro to Metabase.
- Maintained compliance readiness by uploading audit evidence to SCRUT and completing Business Continuity & Disaster Recovery (BCDR) testing.


