📷 Information

• Name: Mai Huy Khang
• Github: https://github.com/maihuykhang2000
• Email: maihuykhang2000@gmail.com
• Location: District 5, Ho Chi Minh

🏃 Experience

PULLM AN SAIGON CENTRE HOTEL (May 2022 – Nov 2022)

Sale Coordinator

• Updating and storing customers’ data in CRM system
• Making paper works, annual reports, occupation report, banquet forecast report at Sale department
• Accumulating information from sale's data for insight analyzing and reports about events and reservation

🖥 Skills

• Languages: Python, SQL
• Frameworks: None
• Libraries: Numpy, Pandas, Matplotlib, Scikit-learn
• Databases: MySQL
• Tools: Power BI

🗨️ English

• IELTS 6.5

📑 Project

Customer Segmentation with RFM Analysis

• Classified customer's groups based on RFM factors and analyzed their behaviors for further usages.
• Used data cleaning skills, implemented group by, qcut through using Numpy and Pandas libraries for RFM scores calculations.
• Used Dax functions to create dimension tables and created a dashboard with Power Bi to help segment analysis.
• Divided into 11 customer segmentations, labeled their main features and provided solution for each group.

Customer Churn Analysis with Classification Models

• Explained factors lead to customer churn, built model to predict with accuracy above 8,0 and gave meaningful solutions.
• Used Python to preprocess, removed outliers by IQR method, fix bias target and performed feature engineering.
• Utilized Gridsearch CV to find out best parameter for each model and made model performance evaluation.
• Defined 3 main factors to the issue, random forest model with f1-score and accuracy up to 99%