Wilson Yip Email & Phone Number

London, England, United Kingdom

- Build and maintain data extraction pipeline on Aifrlow. Data sources come from Salesforce, Jira, Stripe, Aircall, Front, etc. - Data transform in DBT with BigQuery. Maintaining three layers of tables: source tables, proxy tables, and entity tables. - Build and maintain reverse ETL pipeline, pushing data back to source platforms such as Salesforce after transformation in BigQuery. - Build and maintain webhooks on Google Cloud Functions and push data to BigQuery. Streaming data into BigQuery using Storage Write API. - Automate reports on Google Sheets from BigQuery using Google Apps Script.- Review PRs from data analyst on GitHub.

London, England, United Kingdom

- EDA and feature engineering with PySpark, ElasticSearch and other databases to provide quality analyses and input for models. - Design and implement machine learning models to predict YouTube channels' audiences demographics. Design and implement FastAPI for the model.- Apply mathematical knowledge to real world problems: introducing soft-cosine similarity to optimise the existing cosine similarity model, matching 5-10% more top performers. - Writing async functions to follow tens of millions urls (include link shorteners e.g. bit.ly) to identify the real domains, reducing 90% of execution time compare to non-async functions. - Rapid application development: Automating client requests to generate documents, logging and notification on completion. Utilizing Google APIs, Slack API, ElasticSearch, PostgreSQL.

London, England, United Kingdom

- Monitor the system performances by querying Grafana Loki and perform log analysis. Visualise the results on Grafana and Looker Studio. - Design database architecture, collaborate with multiple stakeholders to understand requirements. Build and maintain a PostgreSQL database.- ETL the agency performance and operational data into the database above.

Hong Kong Sar

- Scraped thousands of research papers from library system via Selenium, study the relationships and correlations from the n-gram networks, and summaries them through topic modeling algorithms.- Carry out network analysis on the ecosystem of social enterprises, identify the centralities of nodes and conduct community clustering on ecosystem.- Identify characteristics of different test groups in experiments via AB-testing, regression, PCA etc.

Hong Kong Sar

- Collaborate with external agencies to establish the first online counselling platform in Hong Kong, Open Up. Code infrastructure with Packer, Chef Infra, Kitchen CI, Vagrant and hosting VMs on Azure. Setting up MongoDB and various applications on Linex servers. - Design API specifications for vendors. ETL service data into in-house database for research purposes. - Host, design, and implement Shiny Dashboard on a VM to share service data with NGO partners. - Apply Poisson regression and Negative Binomial regression on count data to identify the users' characteristics.