Summary
Overview
Work History
Education
Area Of Expertise
Coreskillset
Work Availability
Timeline
Generic
Chak Hung KONG

Chak Hung KONG

Data Consultant
Hong Kong

Summary

Dedicated data professional with 8+ years' experience, excelling in ETL processes and programming across banking, property, and insurance sectors. Proven expertise in data analysis,data engineering, and data governance. Seeking to apply this diverse expertise and enthusiasm for data programming to a challenging role that drives data strategy and innovation.

Overview

6
6
years of professional experience
4
4
years of post-secondary education

Work History

Assistant manager

AXA
1 2023 - 12.2023
  • Build up meta data platform(purview) from stretch & deploy 100% of customer related meta data into production environment
  • Purview development of data lineage and data classification
  • Enhanced data quality by implementing stringent data validation processes and error-checking procedures.
  • Contribute to strategic planning and decision-making to align data management goals with company objectives.

Data Analyst

SINO PROPERTY
10.2020 - 09.2022

Transited from Contract role to Perm role since 21 Aug 2021

  • Data ingestion from other BUs, Data modeling and build up Common data model on Azure
  • Produce monthly reports using advanced Excel spreadsheet functions.
  • Used statistical methods to analyze data and generate useful business reports.
  • Extract-Transform-Load (ETL) in DataFactory/DataBricks/Stored Proc and data visualization tool by Power BI
  • Support end users in all areas on data analysis including but not limited to ad-hoc reporting, building automated dashboard in PowerBI
  • Develop and maintain crm platform Dynamic 365
  • Major achievement: Increase customer conversion rate from 20% to 35% through mail promotion by performing address cleansing.

Analyst Programmer

BANK OF EAST ASIA
05.2018 - 10.2020
  • Secondment in Finance Division IT Department(IFRS9 team) in Bank of East Asia
  • Support and Enhance ETL Process using PL/SQL
  • Design and enhance workflow for IFRS9 production run
  • Handle over 10 million deals level record per day in production
  • Gather business requirement from Risk Strategy user and perform simulation run for different economic situation
  • Major achievement: Perform SQL performance tuning from 24 Hours to 18 Hours on daily batch run.

BI Programmer

BANK OF CHINA
05.2016 - 05.2018
  • Secondment in MIS Division IT Department(Basel team)
  • ETL Process: IBM InfoSphere DataStage & Sybase
  • Provide timely production support and ad hoc problem-solving solutions
  • Regular deployment support.

Education

Bachelor of Science - Internet Technology

The Open University Of Hong Kong
Ho Man Tin
08.2012 - 08.2016

Area Of Expertise

  • Data Migration
  • ETL Process
  • Data Management
  • Data Analytics
  • Data Modelling
  • Data Visualization
  • Vendor Management

Coreskillset

  • MS SQL/Oracle
  • Azure Data Factory
  • Google Analytics
  • Dynamic 365
  • Python/Pyspark
  • Power BI
  • Microsoft Purview

Work Availability

monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse

Timeline

Data Analyst

SINO PROPERTY
10.2020 - 09.2022

Analyst Programmer

BANK OF EAST ASIA
05.2018 - 10.2020

BI Programmer

BANK OF CHINA
05.2016 - 05.2018

Bachelor of Science - Internet Technology

The Open University Of Hong Kong
08.2012 - 08.2016

Assistant manager

AXA
1 2023 - 12.2023
Chak Hung KONGData Consultant