William Lo

Project - Investment Cloud - IFRS 9 ECL Revamp - Lead the design and development of an end-to-end serverless data solution for the Investment Cloud platform, focusing on the revamp of the IFRS 9 ECL (Expected Credit Loss) project - Take the development lead role, effectively leading and managing a team of developers to successfully deliver the solution within the specified timeline. - Collaborate closely with the investment team to gather and consolidate their requirements for the project. - Collaborate with cross-functional teams to integrate the investment cloud solution with existing systems and processes, ensuring seamless functionality and data flow.

Engineering Design & Implementation - Data Ingestion - design & build the pipelines to ingest different data sources - Data Governance – design & build the anonymization solution to fulfill data management regulation - Data Deduplication - design & enhance the solution to stitch different user identities from various data sources trying to identify the same person by fuzzy match (e.g. name, gender) for analytical usage. - Data Transformation – design & build the transformation logic to cater the business need - System Enhancement – support the system maintenance to fulfill Data team and IT team requirement Project Planning - Leading a team in the planning, execution, monitoring, and delivery of projects. Business Support - Responsible for identifying and analyzing business problems and needs, and designing solutions to help client improve productivity and efficiency.

- Take lead in data architectural designs & end user visualization - Design & build end-to-end data severless solutions - Collaborate with project/ content/ community/ HR team for different data use cases - Modeling different tokenomic strategies with the use of EVM on-chain data

Design and implement the most appropriate data pipelines with Python & PrefectIO Prepare the ETL process to facilitate the data analysis with Presto Work closely with the Data Scientist to figure out the data needed Prepare the Amplitude tracking requirement for engineer teams Prepare the “Weekly User Metrics” dataset & Assist in building QuickSight Dashboard

Participate in Data Lake projects and BAU implementation Assist in system design and prepare program specification Assist in ETL(Talend, Spark), BI platform (Tableau), Data Management, SQL Assist in the Hadoop (Hortonworks) Management Asist in GAD Architecture

Digital Field • Develop the ML model for energy prediction & optimization, people counting, emotion sensing • Manage and develop the API for IoT and Building Management System gateway • Manage the programming team for the development of FM/BIM digital dashboard • Manage the development of the POC for Mix Reality project with Microsoft HoloLens • Digital team representative for database management and application development (Project Highlights: FM/BIM (Beijing), Digital Hub Platform(HK) , AI Building Management System (HK), Arup Neuron) Engineering Field • Network Design & IT/ELV Infrastructure Design (SCS, CCTV, ACS, BMS, PA, BGM etc) • Technical Specifications Preparation/ Tender Evaluation / Solution Recommendation • Project Management & Client’s Representative • Assist the design of smart city and smart building (Project Highlights: Kai Tak Sport Park, Universal Studio Beijing, Inspire Integrated Resort Korea, Hyatt Hotel Project, Investment Bank Building (QianHai))

Courses highlighted • Big Data Analytic & Mining • Big Data Integration & Modeling and Big Data • Infrastructure & Computing System

Courses highlighted • Telecommunications, Networking, Information Processing and Cyber Security Final Year Project • Hacking Of Android System