Data Analyst Intern

W O R K E X P E R I E N C E

E D U C A T I O N

E X P E R T I S E

C O N T A C T

90%

S K I L L S S U M M A R Y

85% 80%

L A N G U A G E

DATA ANALYST INTERN

*************@*****.***

+84-777-***-***

baotran310702

Python (pandas, numpy, matplotlib,

selenium...)

SQL (Sql Sever, MySql, Oracle)

MS Excel - MS Power BI (basic level)

Github

Another programming language (C++, C#,

Java, Javascript )

Analyzing the behavior of tenants in New York 2019 using KMean - a clustering algorithm.

1.

Data preprocessing with Python (Drop empty, delete duplicate...) Apply Kmeans algorithms for dataset and running process. Visualization their correclation with box-plot chart and show the clusters in map using python.

Bachelor of Information System 2020-2024; GPA: 7.5/10 University of Information and Technology

In process of learning Data Analyst provided by Google Coursera. Python

Data

Visualization

Structured

Query Language

Vietnamese (native)

English (Upper Intermediate)

TRAN

QUOC BAO

baotran310702

80%

Analytical

mindset

2. Building a data warehouse for dataset AB_NYC_2019 (Airbnb at New York City in 2019) using Visual Studio and SQL Server Building a snowflake schema for data warehouse.

Prepare Server Intergration Services and build data warehouse. Run and deploy data and its relationship to database. Using Analyst Services to make reports and data query by MDX. 3. Analysis of the habits shopping customers by using retails data from 10 different shopping malls between 2021 and 2023 in Istanbul

(Turkey)

Preprocessing data using Python(information about data, find empty cells, change datatype of columns, format columns name)

Using excel to create a overal dashboard about this dataset. 4. Using ARIMA and Hybrid ARIMA & Random Walk Models (ARIMAR) to predict price of cryptocurrency (ADAUSDT) in Binance Exchange. Preprocessing dataset, drop unuse columns and keep usable columns like OLHC, timeseries

Dataset is fetched by using API provided by Binance and save to an excel files. Visualize the predict values and train data with matplotlib. Link github: https://github.com/baotran310702/Analyze_Airbnb_KMeans Link github: https://github.com/baotran310702/SSIS_OLAP Link github: https://github.com/baotran310702/Customer_shopping_analysis Link github: https://github.com/baotran310702/Crypto_Price_Forecasting

Contact this candidate