E-Commerce Web & Mobile Data Platform- Rebuilt GA4 Tracking: Enhanced web and mobile analytics by rebuilding GA4 tracking systems.- Data Pipelines & Dashboards: Established data pipelines using orchestration tools to streamline dashboard data creation and cleansing processes.- Team Leadership: Led a team of Data Analysts to develop 15 self-service dashboards, supporting various departments.- Customer Persona Development: Integrated GA4 and user-generated data to create detailed customer personas, enhancing marketing and campaign strategy planning.Food & Beverage United Data Platform- All-in-One Data Platform: Developed a comprehensive data platform for the food and beverage industry, improving operational efficiency with a centralized system for managing kitchen inspections, orders, customer interactions, and employee information.- Advanced Dashboards: Created sophisticated dashboards for user management, membership tracking, and HR functionalities, enabling businesses to optimize performance and deliver superior service.- Team Leadership: Led a team of Data Analysts to develop dashboards and Data Engineers to build robust data pipelines.Construction & Property Development Dashboard- Financial & Project Monitoring: Designed a dashboard for monitoring project clients and subcontractors, tracking certified amounts, received amounts, and outstanding balances based on project contracts.- Comprehensive Insights: Enabled users to view contract validity periods, current project progress, and remaining balances, providing essential insights for managing financials and project timelines effectively.- Team Leadership: Led a team of Data Analysts to develop dashboards and Data Engineers to establish efficient data pipelines.

Content Recommendation Engine- User Behavior Analysis: Utilized user impressions and trace data to learn and analyze user behavior and preferences in news reading.- Correlation and Suggestion: Developed a News Content Recommendation Engine that draws correlations from user data to suggest articles aligned with their reading habits and interests.- Personalized Recommendations: Created personalized content recommendations to enhance the user experience by pushing content that matches individual preferences.- Enhanced Engagement: Increased the stickiness of mobile news apps by providing engaging and relevant article suggestions.- Boosted Engagement Rates: Encouraged users to spend more time within the app, leading to higher engagement rates and increased return visits.Green Tech Company- Comprehensive Carbon Analysis Dashboard: Created a dashboard to analyze carbon footprint and carbon waste for a green tech company.- Robust Data Pipelines: Developed data pipelines using Airflow and Airbyte to ingest data from MongoDB, Mixpanel Tracking Data, and MySQL into a centralized Data Lake.- Efficient Environmental Monitoring: Enabled efficient monitoring and management of the company's environmental impact.- Informed Decision-Making: Empowered the company to make informed decisions to promote sustainability.- Promoting Sustainability: Supported the company's efforts in driving sustainability through detailed and actionable insights.Game Recommendation Engine- Personalized Suggestions: Developed a Game Recommendation Engine that personalizes game suggestions based on user ratings, gameplay frequency, and current market trends.- Mobile App Performance Dashboard : Leverage user tracking data from GA4 to identify the Key Performance Index. Provide trends analysis and flow funnel to understand user behaviour in depth.

Firebase Analytics for Mobile Users (Data Studio) - Measure the number of total return users and total mobile applications (Android & iOS) install with different dimensions - Insights generated holds 80% or more accuracy where the remaining % is due to unique circumstances. Data Wrangling - Prepared two level of datasets from the raw data, a granular dataset which could be reused for other analysis purpose and aggregated dataset to reduce the query cost from BigQuery. Recommendation of Cities Search- Built RESTful API to serve recommended cities based on user search ( Web )Push Notification Tool- Built a push notification tool to allow different team to push notification based on targetted device. Improved push notification flow from existing tools. Reduces the cost for development for mobile and web department. The tool is built with Python and Flask and hosted in Google App Engine with PubSub, Memcache, Cloud Storage and Data Store services.RESTful API Authentication- Built an internal API Authentication Level to secure API served by Data Science Team. This tool will check on user's access token with SSO Engine before allow the end user to consume the API(s)Near Real Time Dashboard & Products Dashboard- Built dashboards in Data Studio backed by BigQuery.- Create data pipeline with DataFlow & PubSub and ingest data into BigQuery.- Built granular level dataset to ease further usage in the future.- Work closely with Google Analytics Data to build different dashboard for different stakeholders.

• Built a Django project for F&B receipt barcode generator internal testing tool and simple ETL engine to extract data from production. Deployed in AWS ECS with DOCKER and NGINX.• Built Snowplow Analytics, with AWS Kinesis Steams. Customized storage loader from Snowplow Github in order to store user customized data model into Postgresql. • Built Apache Spark along with Snowplow to read on near real time data stream from AWS Kinesis Stream.• Built Loyalty Apps & F&B POS data ETL engine worker in Python and Django with Celery Beat. • Built Business Analysis Dashboard to visualize crunched data with Chartjs in Python and Django.• Delivered User’s behavior, Store Sales Performance, Loyalty apps adoptions, Frequent usage for loyalty apps, Performance of Marketing Campaign, User spending behavior and etc. demographics in Business Analysis Dashboard.• Built email report worker to generate daily feedback report from users. • Used shortest path algorithm to increase search performance for Business Analyst Dashboard in Python.

Backend DeveloperDeveloped the crime analysis engine (SaferStreets) used by Walky to analyse and determine unsafe areas in selected cities in the US - Initially developed in Java, responsible for migrating monolithic Java structure into a few smaller Ruby/Rails based microservices that intercommunicate with each other services with RabbitMQ - Migrated cache from Java Objects stored in EHCache to JSON objects in Redis - Experienced in geographical and geometrical calculations Developed our internal data analysis platform - Created a platform for analysing and visualizing crime data trends - Created a platform for managing crime data classification and weightage assignment - Created a platform for analysing and detecting spikes in crime reports and automatically creating alerts for users if a spike in crime is detected in a particular area over a 2-week trendCrime Data AnalystPerformed exploratory analysis on US cities open crime data for Walky that uncovered important details in knowledge and understanding of crime.Developed an anomaly detection mechanism to detect and flag places with potentially anomalous data that may not reflect the place’s actual safety level, and create an exclusion zone around such areas to mitigate false negatives in our crime grid analysisETL (Extract/Transform/Load) engineResponsible for creating the initial version of our automated ETL engine - Wrote a fuzzy matcher based on Jaro Winkler algorithm to match the description of the crime from various open data sets to our existing weighted crime types in our database - Wrote Latent Dirichlet Allocation matcher to determine the crime type based on the news articles - Created a system to analyse and detect the following information from any crime-related news - System is also able to determine whether an article is a crime report news vs opinion piece/court proceeding news, and ignore the irrelevant news articles