Singapore, Singapore
• Designed and automated BI dashboards in Metabase for lead, usage, and revenue analytics • Developed SQL pipelines (PostgreSQL & BigQuery) to track KPIs and cohorts • Built and monitored core performance metrics for product and GTM teams • Optimised complex queries and improved reporting performance Tools: SQL, BigQuery, PostgreSQL, Metabase, Python
• Diagnosed and resolved data discrepancies across claim, order, and parcel-level datasets, ensuring consistency across multiple sources. • Translated complex business logic into robust SQL queries to support compensation validation and reporting accuracy for regional operations. Tools: Data Studio, Python, Excel, PrestoSQL, SparkSQL
• Built full-stack web applications using FastAPI, React, Tailwind CSS, and SQLite, integrating IoT sensor data for real-time monitoring. • Developed interactive dashboards with Streamlit, Shiny, and Metabase for operational insights. • Conducted automated testing with Pytest, security testing using OWASP ZAP, and code quality checks with SonarQube.
• Intern at National Biodiversity Centre • Worked on Community in Nature Playtime Series book, lesson plan, and video. • Conducted field surveys and NParks watches • Involved in the Festival of Biodiversity 2022