Cassie Lam - BI Analytics Engineering Consultant

Cassie Lam

Select me!

Cassie is available for hire

Hire Now

Cassie Lam

Gender

Male

Address

Île-de-France, France

Language

English - Advanced

Main expertise

Analytics Business Intelligence Data Scientists SQL AWS Python JavaScript Linux WebAssembly C++JSON XML

Introduction

Cassie Lam is open to embracing new challenges in the fields of data, business, and management. With her versatility, organization, and autonomy, she can quickly adapt to new situations and environments.

Project list

Kering Project

2023 - 2024

The project involves creating optimal BI datasets by exploring raw data from various sources such as Zeppelin and Jupyter.

Manage physical and logical models of data warehouse, data marts, and staging areas. Problem-solve data models according to business needs and objectives to prepare optimal BI datasets by exploring raw data from various sources, including Zeppelin and Jupyter. Migrate database from AWS Athena S3 to Google Cloud Platform using DBT.

Technologies: Trino SQL, DBT, AWS, GCP, Tableau, Excel, Github, PySpark, Airflow

Luxury Car Brand CRM Project - Accenture France

2022 - 2023

Responsible for ensuring the CRM data quality for a luxury car brand in France.

Consolidate lead data quality from multiple integrated sources. Merge automated processes, including data GDPR compliance, deduplication, normalization, and cleansing. Translate business strategies into technical processes to ensure accurate list extraction performance on a case-by-case basis. Document processes and descriptions.

Technologies: SAP S/4HANA, Salesforce SFMC, MySQL, Incident management, Tableau

Veepee Data Governance Initiative

2022 - 2022

Contributed to the development of a Business Intelligence (BI) strategy ensuring that the company's data needs were fulfilled with high-quality and easily understandable data.

Translate business requirements and processes into comprehensive data models and KPIs to make information accessible and meaningful for business users. Help shape the BI strategy to ensure the company's data needs are met with high-quality data that is easy to use and understand.

Technologies: SQL Server, BigQuery, GCP, DBT, Gitlab, Jira, Docker, Airflow, Python

Dassault Systèmes Project

2021 - 2024

This project involved significant responsibilities in managing data lakes, adapting C++ code, and migrating clients to modern web technologies.

Manage data modeling and metadata of data lakes in the PLM products. Adapt existing native C++ code via Makefiles to the Emscripten compiler for CATIA. Implement projects that have successfully migrated clients to WebAssembly code.

Technologies: SQL, XML, JSON, C++, WebAssembly, Emscripten, Javascript, Linux

Project list

Education

Expertise

Certifications