Data Analyst Intern - SQL, Excel, Power BI Expert

Lê Nguyên Khoa

Data Analyst Intern

Ho Chi Minh 70000 +84-096****** ***************@*****.*** Linkedin-Le Nguyen Khoa

Summary

I graduated from RMIT University with two years of experience in tourism and hospitality management. Demonstrated expertise in analytical consumer behaviour and diverse business domains. Proficient in Excel, SQL, Python, and Power BI, utilized for data cleaning, reporting, and analysis. Committed to applying analytical skills to real-world financial and business datasets to enhance and optimal a company performance.

Education

MindX Technology School Feb 2025 - Dec 2025

Python, SQL, and Power BI for data processing,data cleaning,analysis, querying, and visualisation for reporting

Bachelor Tourism & Hospitality Management - RMIT Nov 2020 - April 2025 University

Personal project

MULTICHANNEL SALES DOMAIN ANALYSIS — INSIGHTS & POST-PANDEMIC STRATEGY REPORT

Goal: Discovered new trends throughout the epidemic and advised prospective sales tactics.

Role details:

-Used Power BI to preprocess 220,488 sales records from 1 dataset, apply DAX calculation, and create a time-series sales performance dashboard using Power BI.

-Used SQL Server tools to analyze customer behavior in each region for comparison,

-Conducted a more in-depth analysis and visualised the data. Achievement: Gain insights and solutions for businesses following pandemics. CUSTOMER SEGMENTATION WITH RFM ANALYSIS

Goal: Classified consumer groups based on RFM characteristics and analysed their behaviours for future applications.

Role details:

-Used data cleaning skills and implemented via the use of Numpy and Pandas libraries for RFM score computations.

-Used Dax functions to construct dimension tables and develop a dashboard with Power BI to facilitate segment analysis.

-Conducted insight analysis on trends, deviations, performance, and specific information for each consumer segmentation group.

Achievement: Delivered clear consumer segmentation insights that enabled targeted

marketing strategies and improved customer retention planning. FORECASTING CANCELLATION RATES IN THE HOTEL INDUSTRY Goal: Explained the variables that cause customer churn, constructed a model to forecast with an accuracy of over 70%, and provided useful remedies. Role details:

-Preprocessed data with Python, used IQR to eliminate outliers, corrected biased targets, and did feature engineering.

-Used Gridsearch CV to optimise model parameters and evaluate performance.

-Used feature significance to determine the most important criteria for customer cancelled booking status.

Achievement: Defined three primary aspects of the issue, a Support Vector Machine model with an F1-score and accuracy up to 74%.

Work experience

Grilled Stocker & Bar Restaurant (Captain)April 2023 - Sep 2023

-Collected customer data to support operational decision-making to enhance service quality, increase profit, and customer satisfaction.

-Trained employees to upsell, meet service standards, and solve customer problems to enhance employee performance.

-Managed shifts to ensure smooth operations and compiled end-of-day reports to evaluate service and customer feedback.

Park Hyatt Saigon (Senior waiter) May 2022 - March 2023

-Captured customer feedback and behavioral patterns, contributing insights

-Improved communication, teamwork, and workflow coordination across the professional workplace

Skils

Technical Skills:

Python & SQL: pandas, numpy, scikit-learn; data cleaning, transformation, statistical analysis

Data & ML: Supervised & unsupervised learning; SQL Server, Azure DB Visualization & Tools: Power BI, Excel, matplotlib; Google Colab

Contact this candidate