Assistant Data Manager

• Dec 2021 - Present

Department: Data Team, Hang Seng Index Company Limited- Led Business Database Project. Designed data operation flow to load figures of business products like ETP and F&O to GCP BigQuery.- Created unique identifiers in the database to map company identifiers from different market data vendors.- Created and shared common Python modules to make HTTP requests and connect to the database using the proxy required by the HSBC network, defined coding standards and rules across the team.- Led a team in designing Tableau ‘seed’ reports. Provided training to business teams to encourage colleagues to build reports with BI tools.

Analyst Programmer (Data Enginnering)

• Nov 2020 - Dec 2021

Department: Tech Team, Research Department- Automated 50 regular report ETL of economic and financial data and saved economists time from manual, repetitive tasks.- Built Python script for data extraction through web scraping and APIs, transformation, and analysis.- Designed dashboards to assist economists in economic and financial research, including the most viewed “Financial Market” dashboard.- Refactor some dashboards to improve performance, leading to a three-second faster load time.- Was nominated as a scrum master in an agile project team. Managed multiple project cycles from gathering business requirements and coordinating product backlog prioritisation with users and developers, effort estimation and planning, and monitoring project process.

Data Analyst

• Jan 2020 - Nov 2020

Department: Planning and Performance Management- Built a “Sales Pipeline” dashboard to visualise sales opportunity data interactively from the CRM system for forecast and sales management.- Developed and maintained a “Sales Forecast Vs Actual Variance” dashboard with the sales team to compare sales forecast to actual sales and to track sales performance. The dashboard was the 2nd most viewed report across the company.- Automated regular KPI reports by writing VBA macros. Department: Planning and Performance Management- Built a “Sales Pipeline” dashboard to visualise sales opportunity data interactively from the CRM system for forecast and sales management.- Developed and maintained a “Sales Forecast Vs Actual Variance” dashboard with the sales team to compare sales forecast to actual sales and to track sales performance. The dashboard was the 2nd most viewed report across the company.- Automated regular KPI reports by writing VBA macros.

Summer Intern

• Jun 2019 - Jul 2019

Intern

• May 2017 - Jan 2018

Department: Engineering & Sourcing- Optimised data operation flow from adidas Retail Sourcing Platform to quarterly KPI reports- Consolidated and analysed tenders’ quotation and demand forecast data in tender procurement projects Department: Engineering & Sourcing- Optimised data operation flow from adidas Retail Sourcing Platform to quarterly KPI reports- Consolidated and analysed tenders’ quotation and demand forecast data in tender procurement projects