Spearheaded the clean room development, utilizing Google Ad Data Hubs and Meta Advanced Analytics to elevate campaign and audience insights, resulting in a more comprehensive case study approach for informed decision-making.Developed a comprehensive digital media competitive intelligence tool, integrating website traffic, search analytics, YouTube engagement, KOL impact, and e-commerce data etc. Consolidated information from diverse sources, including various data providers and a custom-built scraper, to provide a holistic view of our clients digital landscape compared to competitors.Project Lead for an e-commerce intelligence project, managing data pipelines for sales and ad data from Shopee and Lazada. Designed and implemented a holistic e-commerce competitive tool to effectively compare and analyze client’s e-commerce performance with their competitors. Built a data pipeline from Facebook Ad Manager to the Google Cloud via Meta Graph API and BigQuery API, significantly reducing dashboard data loading time and cost for subscribing third-party connectors. Ensured real-time insights for informed business decisions, enhancing overall operational efficiency.Demonstrated expertise in data cleaning and visualization techniques, extensively working with SQL, Python, and JavaScript. Specialized in API integration for efficient data retrieval and analysis.

Campaign Management: Managed end-to-end programmatic campaigns for clients, including campaign set-up, creative upload, and strategy implementation, while adhering to trading desk processes. Successfully delivered campaigns within allocated budgets and timelines, resulting in increased client satisfaction and retention.Optimization: Monitored campaign metrics and made data-driven decisions to optimize campaigns towards client goals and KPIs. Developed custom optimization scripts to streamline optimization processes, resulting in a 15% increase in campaign performance.Reporting and Analytics: Produced campaign performance reports and analyzed data to provide insights and recommendations for continuous improvement. Developed platform reporting templates to automate reporting processes, reducing report generation time by 50%.Technical Expertise: Troubleshot technical issues and provided solutions to ensure campaign delivery. Mastered trading-related technologies, including DSPs, 3rd party ad servers, and PMP/PG related tasks.Project Management: Conducted correlation analysis for multi-channel conversion to provide insights and recommendations for cross-channel optimization. Successfully managed project timelines, budgets, and deliverables.

Root Cause Analysis: Assigned to investigate an event in the manufacturing process and to find the root cause of the issue. Utilized data analysis and problem-solving skills to facilitate effective corrective actions and prevent recurrence of the issue.Productivity Improvement: Monitored daily productivity and performance data to identify opportunities for improvement. Used statistical knowledge to analyze data and develop recommendations to improve manufacturing processes, resulting in a 10% increase in productivity.Vendor Upgrade Performance Evaluation: Conducted data analysis to evaluate the performance of machines after a vendor upgrade. Analyzed machine data and compared it with pre-upgrade data to determine the effectiveness of the upgrade. Provided recommendations to improve the performance of the upgraded machines.