Lucy Pham

I'm Data Analyst

About

Experience: A Data Analyst with a solid foundation in data analysis, database, statistics, and machine learning, complemented by hands-on projects with tools such as Excel, SQL, Power BI, Tableau and Python.
Skills: Be skilful in extracting, cleaning, and visualising data to support data-driven decision-making. Eager to contribute to an energetic team, leverage analytical skills, and continue growing within the field of data analysis.
Open for: Junior data analyst role to apply technical skills in real-world scenarios and support business objectives.
Immigration Status: Canadian Permanent Resident.

Data Analyst

If you think I am a good fit for your role, please feel free to contact me via these channels:

Website: https://lucypham-data.com/
Phone: +1 604 722 9865
City: Vancouver, Canada

Degree: Diploma in Data Analytics
Email: lucyphamnt@gmail.com
Freelance: Available

Skills

SQL 100%

Excel 90%

Power BI 90%

Tableau 80%

Python 60%

C# 50%

Resume

Please refer to my LinkedIn Profile for my complete professional and educational background.

Sumary

Lucy Pham

A Data Analyst with a solid foundation in data analysis, database, statistics, and machine learning, complemented by hands-on projects with tools such as Excel, SQL, Power BI, Tableau and Python. Be skilful in extracting, cleaning, and visualising data to support data-driven decision-making. Eager to contribute to an energetic team, leverage analytical skills, and continue growing within the field of data analysis

Vancouver, Canada
(604) 722 9865
lucyphamnt@gmail.com

Education

Post-Degree Diploma in Data Analytics

2023 - 2024

Douglas College, New Westminster, BC, Canada

Bachelor of Commercial English

2010 - 2014

Ho Chi Minh University of Technology, Ho Chi Minh City, Vietnam

Projects

World happiness 2015-2024

2024

Collected, validated, and cleaned 1,500+ data points, achieving 98% data accuracy; summarized key metrics by Excel Pivot Tables. Analyzed happiness data from 173 countries across 10 regions.
Built and maintained 5 Power BI dashboards to highlight levels of happiness, and identify regional trends and correlations.

American baby name trends analysis

2024

Analyzed baby name trends in the US from 1920, identifying over 500 popular names and uncovering key patterns, trends, and correlations utilizing 10+ advanced SQL (PostgreSQL) queries.
Designed 10+ interactive dashboards employing Power BI tool, leveraging regression and time series analysis to visualize predictive insights.

AIDS treatments analysis

2024

Performed data analysis on the AIDS treatments dataset with 2000+ data points, leveraging Machine Learning to predict patient survival based on medical history and demographic data.
Applied 3 models: Logistic Regression, Random Forest and Naïve Bayes, to uncover key factors influencing outcomes.

Professional Experience

Test Administrator

2022 - Present

Pearson, Vancouver, Canada

Managed candidate data for the admission process by verifying information and collecting biometric records (palm prints) for 30+ candidates using a structured system, enhancing data accuracy and record maintenance by 80%.
Processed and cleaned 200+ raw test registration records daily in Microsoft Excel, ensuring data accuracy and consistency for generating the daily roster with zero errors.
Prepared necessary equipment for candidates and submitted detailed reports on any issues arising during exam sessions.

Sales Associate / Lead Cashier

2021 - 2024

Bath and body works, Burnaby, Canada

Provided excellent customer service by assisting with inquiries, processing 100+ transactions daily via POS, and promoting sales and loyalty programs, increasing customer engagement by 10%.

ESL Teacher

2021 - 2024

VUS English Center, Ho Chi Minh, Vietnam

Managed classrooms of 20 students, designed and delivered customized lesson plans based on course’s proficiency levels, utilizing diverse teaching strategies and resources.
Analysed and interpreted student grading data applying Excel, and leveraging Pivot Tables to calculate class averages, skill-specific performance, and rank students based on total scores.
Developed and maintained interactive reports and dashboards implementing Excel visualization to showcase students’ performance across 3 recent levels, supporting internal decision-making and marketing strategies.
Presented data-driven reports to students, parents, and Training Quality Manager after every course, improving student retention by 70%, enhancing parent engagement, and fostering a better learning experience.

Portfolio

I have done multiple projects using SQL, PowerBI, Python and written blog post explaining concepts in Statistics to demonstrate my Data Analytics skills.

All
Power BI
SQL
Statistics
Python

Power BI #1: Baby names in the US

Analyzed over 500 names that remained popular alongside current top choices, using SQL and power BI.

Power BI #2: World Happiness Analysis

Analyzed data from 173 countries across 10 regions to identify factors contributing to happiness and global rank, highlighting regional patterns and shifts in trends.

Python #1: AIDS Treatments

Examined the effectiveness of different treatment options for AIDS patients, aiming to evaluate their impact on patient survival and health outcomes.

Statistic #1: Basic Statistics

What is the difference between population and sample? Mean, median and mode? Range and standard deviation? Probability?

Statistic #2: Exploring Possibility in Statistics

Have you ever wondered about the chances of winning the lottery, the likelihood of rain tomorrow, or the probability of flipping a coin and getting heads?