Data Scientist

Tech Solution Lead

Over 20 years of professional exploration in various aspects of data solutions especially in data warehousing, data engineering, business intelligence and data analysis.
Over 10 years of tech solution experience introducing advanced technologies, like data mining, machine learning, AI technics.
1 year experience of application solution of using LangChain LLM framework.

Experience: 11 years

Yearly salary: $100,000

Hourly rate: $75

Nationality: 🇨🇳 China

Residency: 🇨🇦 Canada

Experience

Data Solution

JINGdigital

2022 - 2023

Data integration between the marketing automation platform and CRM systems like Salesforce and Marketo. (Python & API). Development of data cleansing and processing code (Pandas); Design of the core marketing data model. Data analysis leveraging Power BI desktop, Excel and Python code.

Data Solution and Business Intelligence

Wisers Information / Pingan Urban Tech / Hengfeng Bank

2016 - 2022

Data platform performance tuning. (MySQL, ClickHouse). Data analysis model development (AHP, Frequent Itemset mining) in Python. Data processing development on various data platform (Hive, MongoDB, Elastic Search). BI dashboard development (SQL, Python, Tableau).

ETL Development

Merkle Inc.

2014 - 2016

Data file processing using shell script and ETL development using Informatica, T-SQL procedure. Marketing data model design and data warehousing (SQL Server).

Onsite Technical Consultant

HP Enterprise Service

2010 - 2014

Maintained a centralized enterprise data warehouse solution built upon Oracle (Enterprise Data Warehouse) and SQL Server (Data Marts). A significant improvement of data accuracy by overhauling Informatica (ETL), PL/SQL (ETL), OBIEE (reporting). Automated the offline reporting service (Excel files) by leveraging VBA, VB scripts which saved 1 hour time per day.