Consultant

• Nov 2022 - Present

Data Engineer and Analyst

• Oct 2018 - Nov 2022

# Ingested Google Ads customer insights using Apache Airflow, Python, AWS Glue into S3 data lake and Redshift data warehouse to accommodate fast and consistent access to critical data# Designed, implemented and maintained batch ELT pipeline using Apache Airflow, Python and MySQL# Developed web crawlers using Apache Airflow and Python to extract operational data# Streamlined the workflow to process and analyse terabytes of video data using a combination of MS Azure Video Indexer and Python# Distilled insights from Azure Video Indexer into actionable observations by using data mining toolkit Orange, Google Colab, Jupyter# Prepared dataset for Generative Pre-trained Transformer NLP model fine tuning and implemented the evaluation using Label Studio, Streamlit# Worked with analysts to create data views to be used in BI tools like Google Data Studio# Worked with operational teams to translate data into actionable dashboard using Statsbot powered by Cube.js# Converted video campaign performance data into insights to support teams make data-informed decisions.# Prepared data for management report# Managed data under data lifecycle management guideline, and data ethics and privacy

Product Support

• Jun 2016 - Mar 2020

# Assisted operational team with difficult technical issues requiring a deep level of knowledge of the product# Coordinated with internal Level 3 technical support specialists and external development team to maximise the product operations’ efficiency# Advised country manager on operational and technical matters of the product# Onboarded and trained new team members

Product Owner

• Jun 2016 - Jun 2017

# Liaised between external software development team and country team to understand business problems and prioritize product roadmap# Collaborated with teams to identify unique product constraints and gaps in overseas market# Articulated product vision and user stories# Proactively identified and mitigated engineering roadblocks# Led the development of web and mobile applications that were tailored to overseas user’s habits and technical constraints# Fostered open communication between stakeholders, engineering and marketing

Content Producer

• Jun 2011 - Jun 2016

# Produced well-received video content in various styles and genre in line with the organisation’s mission statement and objectives using Adobe creative suits# Created high-impact messaging for marketing content# Collaborated in discussion and brainstorming sessions with creative team members and contractors# Organised and coordinated creative activities throughout the entire video production process