Kwan Kiu Tsea

Kwan Kiu Tsea

Data Engineer
Canada
English, Chinese

نبذة عني

Data Engineer with experience in data warehouse development, ETL, cloud migration, and data pipeline implementation. Skilled in Python, C#, C++, NodeJS, SQL, AWS, Terraform, Airflow, Spark, PySpark, Power BI, and machine…

الخبرة

Data Engineer

eCloudvalley Digital Technology
Jul 2022 - حتى الآن · 3 سنوات 11 أشهر

• Led and participated in the development of the data warehouse project for mobile notifications pushing and emails, using
PostgresRDS, AWS Lambda, SalesForce Journey, and Braze Canvas. – HK Disneyland
• Designed and implemented a data ingestion pipeline for ingesting manifest and CSV files from on-premise to PostgresRDS, using AWS
API Gateways, AWS Lambda, AWS S3, and NodeJS as the programming language. – HK Disneyland
• Continuous Integration/Deployment Pipeline Integration, pull requests, code reviews, load/stress testing with the use of Jenkins, Git Hook
Alantis and Terraform. – HK Disneyland
• Conducted User Acceptance Testing (UAT) to validate the functionality and performance of the developed solutions. – HK Disneyland
• Designed and implemented part of ETL process in a large-scale cloud migration project (cloud migration from on-premises Oracle to AWS Redshift). AWS Glue with PySpark was used to transform and load data, which was spooled by SAS and originally loaded to Oracle by SQL Loader, from S3 to Redshifts. EventBridge and Lambda were also used for flow orchestration purposes. – PCCW
• Deployed necessary infrastructures with the use of AWS CloudFormation and Parameter store. Set up Postgres RDS on EC2 for batch transaction monitoring. – PCCW
• Implemented envelope encryption practice for data encryption key and database permission control for data security, using Redshift, AWS KMS, and SecretsManager. – PCCW
• Participated in the development of ETL process development using Apache Airflow (MWAA). – PCCW
• Continuous Integration/Deployment Pipeline Integration, pull requests, code reviews, with the use of AWS CodePipline, and CodeCommit. – PCCW

Data Engineer

eCloudvalley Digital Technology, Hong Kong

Led and participated in the development of the data warehouse project for mobile notifications pushing and emails, using PostgresRDS, AWS Lambda, SalesForce Journey, and Braze Canvas.
Designed and implemented a data ingestion pipeline for ingesting manifest and CSV files from on-premise to PostgresRDS, using AWS API Gateways, AWS Lambda, AWS S3, and NodeJS as the programming language.
Performed continuous integration/deployment pipeline integration, pull requests, code reviews, and load/stress testing with Jenkins, Git Hook Alantis, and Terraform.
Conducted User Acceptance Testing (UAT) to validate the functionality and performance of the developed solutions.
Designed and implemented part of ETL process in a large-scale cloud migration project from on-premises Oracle to AWS Redshift.
Used AWS Glue with PySpark to transform and load data from S3 to Redshift.
Used EventBridge and Lambda for flow orchestration purposes.
Deployed necessary infrastructures with AWS CloudFormation and Parameter store.
Set up Postgres RDS on EC2 for batch transaction monitoring.
Implemented envelope encryption practice for data encryption key and database permission control for data security using Redshift, AWS KMS, and SecretsManager.
Participated in the development of ETL process development using Apache Airflow (MWAA).
Performed continuous integration/deployment pipeline integration, pull requests, and code reviews with AWS CodePipeline and CodeCommit.

Assistant Data Analyst

AXA China Region Insurance Company Limited, Hong Kong

Maintained and optimized the data pipeline from various data sources to Power BI dashboards, ensuring the accuracy and integrity of data.
Created and edited Power BI dashboards reporting to the heads of underwriting teams.
Transformed manual Excel handling to Python scripting, resulting in increased efficiency and reduced human errors.
Responsible for data cleansing and data mining of the Employee Benefit data, which is used for machine learning purposes.
Participated in a machine learning project utilizing XGBoost and CATBoost algorithms to conduct a cross-selling campaign.

المهارات

البيانات الضخمة مستودع البيانات هادوب (Hadoop) سكالا سبارك أباتشي هايف أباتشي بيغ خدمات أمازون ويب (AWS) كافكا نوسكيو إل ردشفت (خدمة قاعدة بيانات) إس 3 (خدمة تخزين البيانات على الإنترنت) Python C# C++ NodeJS SQL PL/pgSQL MySQL Oracle Amazon Redshift Apache Airflow Cloud Computing CI/CD Terraform ETL Git AWS CloudFormation DVC AWS Lambda AWS Glue Amazon S3 Apache Spark PySpark Amazon RDS Confluence Jira Machine Learning Deep Learning Salesforce Braze Distributed Systems Backend Power BI Excel Data Cleansing Data Mining XGBoost CATBoost Jenkins Git Hooks AWS API Gateway AWS EventBridge AWS CodePipeline AWS CodeCommit AWS KMS AWS Secrets Manager AWS MWAA
الإبلاغ عن هذا الملف الشخصي؟