Portfolio
IOI Properties Data Scraping
This project was done during my time at IOI Properties Group, a property development company based in Malaysia. The goal of this project was to gain insight into the company’s image by extracting information from relevant public forums.
The goal of this project was to extract data from a popular website in Malaysia called Lowyat Forum, which is similar to Reddit. The client wanted to know what their brand image was on the website, taking comments from threads about their recent property developments. I extracted the text from multiple threads and forums using Python, developing a Microsoft Excel report that gave insight into the company’s image.
The button below links to the Gitub repository.
Amazon Sentiment Analysis
This is an NLP project that uses Bag-of-Words and TFIDF to Perform Sentiment analysis on reviews left on multiple products. The model produced was able to correctly predict the sentiment a given comment 70% of the time.
The dataset for this project was taken from Kaggle.
The goal of this project was to be able to correctly predict whether a product review is positive or negative by identifying keywords. I used both SVC and Linear SVC for the classification of positive and negative reviews. The project features a model that is able to predict the sentiment of a given comment with a 70% accuracy.
Click the button below to link to the Kaggle notebook.
Health Inspection Data NY
This project was done in my Database Management Class, we ran SQL queries and made a data warehouse from Health Data NY data on health inspection with NY state.
The goal of this project was to clean, process and query the data using Microsoft SQL Server. In class, we converted string variables into numerical representations, reformatted columns and finally built a data warehouse to access this processed data.
The button below links to the Github repository.
Snapcart JSON Tabularization
This project was done during my time interning at Snapcart, a consumer analytics company based in Indonesia.
The project is a part of an OCR(Optical Character Recognition) program, specifically parsing items on physical receipts which came in as JSON files. The objective of the project was to correctly map item prices, quantity and discounts to the correct item on the receipt. 81 receipts, with 11 chains for testing, were processed with an accuracy of 94%.
Due to confidentiality reasons, the code cannot be shared and thus I made a detailed presentation explaining the project.
KPI Dashboard
This project was done for a client on Upwork. The dashboard tracks KPI’s such as dollar/lead and conversion rate. The dashboard can be filtered for multiple variables including date and employee.
The dashboard was created by connecting with a client on Upwork, a freelancing platform. The client wanted a dashboard to track their KPI’s such as dollar/lead, conversion rate, proportion of leads in progress etc. Besides this, the client requested individual progress reports for his respective employees. Additionally, date, recruiter and client filters were added to get specific measurements of the company progress.
Since this project was for a client, the source code is confidential.
