Business Intelligence Analyst | Bi & Planning
Current● Acted as the main PIC for 5+ projects focused on seller segmentation & productivity assessment, analyzing business needs & delivering actionable recommendations. Demonstrated strong communication & collaboration with cross-functional teams while developing automated dashboards using in-house tools.● Selected project exp: o Key Account Managers (KAMs) KPI ▪ Supervised and evaluated 30+ KPIs for 800+ KAMs across various business development sectors (C2C, Mall, Social, Brand Partnership, etc.) to ensure alignment with high-level and regional strategic directions. ▪ Successfully implemented a systematic approach to measure & calibrate KPI evaluation scores for all KAMs on a quarterly basis. This meticulous process maintained compliance with Regional & Local HR standards for 10 consecutive quarters, reinforcing the alignment of performance metrics with strategic goals. o Competitor Sellers ▪ Managed a project analyzing the competitive landscape of Shopee sellers against competitors, focusing on market share & commercial performance. Executed ETL processes and interpreted key data from competitor sellers, providing actionable insights for nearly 10 internal stakeholder teams. This facilitated the implementation of targeted strategies to identify competitor sellers, enhance seller retention rates, and offer exceptional treatment for multi-platform seller groups o Streamer Live ▪ Measured pfm based on the Streamer Live program's reward policy, ensured accurate data alignment with the Finance team, proposed investigations into potentially fraudulent livestream sessions, and implemented timely adjustments to the reward schema.● Served as a mentor to junior team members, providing guidance and practical support to foster their growth---Team Collaboration: Seller Performance, HRBP, Business Development, Marketing, and Regional BD/Business Intelligence.Techstack: PrestoSQL, SparkSQL, Python, Excel, Power BI, Google Sheets, Google Apps Script