Hi, I am

Nongnaphat Wongpiyachai

I'm a

Scroll Down

Skills

Data Manipulation

Python

Scala

SSMS

PostgreSQL

Tableau

Power BI

Looker Studio

Google BigQuery

Jupyter

Spyder

Excel

Machine Learning

Python

NumPy

Pandas

Matplotlib

Seaborn

Scikit-learn

OpenCV

PyTorch

Gensim

SciPy

TensorFlow

Google Colab

Jupyter

Kaggle

Web Development

React

HTML

CSS

Bootstrap

Tailwind CSS

JavaScript

PHP

Python

FastAPI

Flask

SSMS

MySQL

SQLAlchemy

Others

Anaconda

Azure

Figma

Postman

GitHub

Trello

Apache Kafka

Android Studio

Apache Airflow

Education & Experience

August 2020 - December 2023

Bachelor of Science Program in Computer Science, Minor in Data Science
Thammasat University, Thailand | GPA 3.40

Relevant Coursework

Object-Oriented Programming

Data Warehousing and Business Intelligence

Machine Learning and Data Mining

Database Systems

Data Visualization

Data Structures and Algorithms

Statistics

June 2023 - December 2023

Data Engineer Co-operative Education Intern
Siam Kubota Corporation Co., Thailand

Developed and maintained ETL scripts for integrating data utilization

Utilized Tableau tools to create meaningful visualizations for diverse stakeholders

Designed, implemented, and integrated APIs into a web application to manage role-based access control, ensuring robust system security

Tools Used:

June 2022 - August 2022

Helpdesk Assistance / IT Support Intern
The ICT department at Thammasat University (ICT-TU), Thailand

Provided essential support in troubleshooting technology-related issues

Managed comprehensive categorization of technical issues for streamlined troubleshooting and efficient problem resolution

Tools Used:

Certificate

Aug 2024

SQL Associate
DataCamp

Mar 2024

Certified in Negotiation Skills Workshop
Thammasat University

January 2024

Associate Data Scientist
DataCamp

May 2023

Certified in Business Ideas
Faculty of Science and Technology, Thammasat University

Project

UX/UI

EatU Application

…

Designed a mobile application to assist users in deciding what to eat including user experience, functionality, and aesthetics

Home Page

Random Page

Random Results Page

Ideas:
● A new feature to assist you in choosing a restaurant or menu
● Restaurants have expanded their outreach by incorporating a broader array of public relations channels
● Users can easily find the restaurant of their choice, resulting in increased restaurant's customer base

Features:
Explore random restaurants and varied food menus
Customize search with restaurant and menu filters
View restaurant reviews and recommended menus
Connect with friends through group creation
Voice commands
Calculate food prices

Tools Used:

Links:
Prototype

Spring Kafka

Create Sale Order Service

…

Built a microservice that handles the creation of sale orders and utilizes Kafka for messaging between different components

Tools Used:

Links:
GitHub

Telecom Churn Prediction

…

Built models to predict whether a customer is likely to switch to another telecom service provider (churn) based on historical data and various features associated with the customer

Customer churn influencing factors

Month-to-month contracts, a lack of online security, and technical support appear to be positively related to churn. While tenure and two-year contracts appear to be negatively correlated. It's interesting to note that churn appears to be adversely correlated with services like online backup, tech support, streaming TV, etc. that don't require an internet connection.

Grouping of customers who have ceased to use the service (Churned)

From the picture, it can be observed that there are five groups of customers who have already discontinued using the service:
● Group 1 (Blue): This comprises customers with a low service life and low monthly expenses. It is evident that these customers tend to come and go without forming a lasting attachment to any camp service.
● Group 2 (Green): This group consists of customers with a moderate to very long service life and low monthly costs. The density of this group is relatively sparse compared to others, suggesting it is a smaller group. These customers may include general individuals with modest income who might cease using the service for various reasons.
● Group 3 (Red): Here, we have customers with a low service life and relatively high monthly expenses. This group represents the largest number of customers, characterized by a higher density than any other group. The primary reason for discontinuing the service in this group may stem from the high monthly fees, as well as the availability of cheaper alternatives in other camps.
● Group 4 (Purple): This group encompasses customers with a moderate service life and relatively high monthly expenses. Similar to Group 3, the termination of service in this group may be attributed to the high monthly fees, with potential additional factors such as hesitations or preferences for other camps.
● Group 5 (Gold): This is an intriguing group with customers having a long service life and high monthly expenses. Considered as valuable customers who should be retained, they seem indifferent to the cost. The reason for discontinuation in this group may not be the cost itself but could be due to service-related issues or other factors that warrant further investigation. To prevent the loss of these valuable customers in the future, a more in-depth study is necessary.

Steps:
Data Preparation
Data Representation
Modeling
Evaluation

Tools Used:

Links:
Dataset Google Colab

Web Development