WHO AM I ?

Learn more about me

Ewe Li Wei's Profile Picture

Data Engineer @ PayNet

As a data enthusiast with a passion for visualizations, I am proficient in multiple programming languages and tools. I am committed to continuous learning and development, dedicated to leveraging data for uncovering valuable insights in strategic decision-making. With a diverse range of hobbies, I bring creativity to problem-solving, viewing every bug as an opportunity to enhance my skills and move closer to success.

Languages

Languages I Speak
English Native Speaker
Mandarin Native Speaker
Bahasa Melayu Native Speaker
Cantonese
Currently Learning
German (from Duolingo)
Japanese (from Duolingo)

What I Enjoy

My Hobbies

Hackathons

Code challenges

New programming languages

Reading

Sports

Piano

Music

Travel

Photography

Arts

Cooking

Education & Professional Experiences

Personal Background In A Glance

Professional Experience

Data Engineer

Nov 2023 - Present

Payments Network Malaysia Sdn Bhd (PayNet)

  • Designed, developed, and maintained data pipelines and ETL processes handling millions of records daily using Python and Apache Airflow
  • Deployed and managed data pipelines using AWS cloud-based technologies
  • Enhanced and optimized dashboards, and improved query efficiency using AWS QuickSight
  • Refactored existing workflows and created a versatile script for processing all dimension tables
  • Conducted data quality checks to maintain integrity throughout the data lifecycle
  • Developed and maintained comprehensive documentation for data processes and workflows
  • Volunteered for PayNet Akar: X2 (eXperimentation eXchange) 24-Hour Hackathon with APU

AWS Apache Airflow AWS QuickSight

Process Automation Analyst Intern

Aug 2022 - Nov 2022

Shell Business Operation Center Kuala Lumpur, Cyberjaya

  • Digitized existing processes through the implementation of Microsoft Power Platform solutions
  • Developed and customized team's homepage on Microsoft SharePoint to enhance collaboration
  • Developed a user manual to streamline team operations based on explored Microsoft Azure DevOps functionalities
  • Utilized Azure ML to convert complex data sets into actionable insights
  • Produced detailed Solution Design Documents (SDD) to clarify project scope and provide implementation guidelines
  • Coordinated and actively participated in social events
  • Demonstrated adaptability and a rapid ability to learn new concepts, contributing to efficient project execution

MS Power Platforms Azure DevOps Azure ML MS Sharepoint

Technical Team Intern

March 2021- July 2021

MC Crenergy | Datanory | IT Solution Provider, Puchong

  • Developed features for diverse web and console applications
  • Contributed as a productive and positive team member in designing, coding, testing, reporting, and debugging operations
  • Implemented software changes and enhancements adhering to system design specifications
  • Programmed dynamic SQL statements and stored procedures to optimize database operations
  • Generated comprehensive reports using SQL and SSRS
  • Enhanced communication abilities through regular engagement with team members and stakeholders

SQL SSRS MVC Framework VB.NET

Education

BSc(Hons) in Computer Science - Specialism in Data Analytics

Sept 2021 - Sept 2023
CGPA 3.8 (First Class Honors)

Asia Pacific University of Technology and Innovation (APU / APIIT)
APU-DMU Dual Degree Programme - De Montfort University

Activities and societies:

  • Member of Asia Pacific Analytics Club (APAC) (2022 - 2023)
  • Member of Chinese Langauge and Culture Society - Media Team

Achievements:

  • Awarded 2nd runner-up in ADA Business Messaging Hackathon 2023
  • Participated in ImpactHack 2023
  • Awarded 1st runner-up in AppSheet Hackathon Competition 2023
  • Participated in FutureLab x APAC Discovering Image Processing in Data Science Event 2022
  • Participated in Shopee x APAC Analytics Career Talk 2022
  • Participated in AIA Hackathon 2022
  • Participated in Shopee Code League 2022

Diploma in Information Technology - Specialism in Data Analytics

Apr 2019 - Apr 2021
CGPA 3.8 (Distinction)

Asia Pacific University of Technology and Innovation (APU / APIIT)

Activities & Societies:

  • Member of Chinese Langauge and Culture Society - Media Team

Achievements:

  • Participated in Hult Prize Asia Pacific University 2020
  • Head of Department in Merdeka Fiesta 2019
  • Volunteered in International Cultural Night 2019
  • Camper of Dragon Boat Festival Celebration 2019

Sijil Pelajaran Malaysia (SPM), Pure Science Stream

Jan 2014 - Dec 2018

SMK Seri Kembangan

Activities & Societies:

  • Member of Prefectorial Board (2014 - 2018)
  • Student Ethics Award 2018
  • Secretary of Arts and Crafts Club 2018

Achievements:

  • Member of Prefectorial Board (2014 - 2018)
  • Treasurer of Prefectorial Board (2015)
  • Prefect Team Building Camp (2017)
  • Head of Activity Department in Prefectorial Board (2017-2018)
  • Secretary of Art and Craft Club (2018)
  • Participated in Essay Writing Competition With ELS Language Centers (2018)
  • Malaysian National Chemistry Quiz 2018 (Merit)
  • Student Ethics Award (2018)

Skill Sets

My Skill Sets

Data Analytics

Python logo

Python

R Programming logo

R Programming

SAS Softwares logo

SAS Softwares

Azure ML logo

Azure ML

Reporting & Dashboarding

Power BI logo

Power BI

Tableau logo

Tableau

Streamlit logo

Streamlit

SSRS logo

SSRS Report Builder

Programming Languages

SQL logo

SQL

JAVA logo

JAVA

C++ logo

C++

VB.NET logo

VB.NET

Low-Code Platforms

Microsoft Power Apps logo

Microsoft Power Apps

Microsoft Power Automate logo

Microsoft Power Automate

AppSheet logo

AppSheet

Extra

Microsoft 365 logo

Microsoft 365

Azure DevOps logo

Azure DevOps

Figma logo

Figma

Wix.com logo

Wix.com

Professional Skills

Analytical Thinking Skills icon

Analytical Thinking Skills

Time Management Skills icon

Time Management Skills

Teamwork and Leadership Skills icon

Teamwork and Leadership Skills

Report Writing and Presentation Skills icon

Report Writing and Presentation Skills

Research Skills icon

Research Skills

Self-Learning Courses

More Skills
HTML logo

HTML

CSS logo

CSS

JavaScript logo

JavaScript

Bootstrap logo

Bootstrap Framework

JavaScript logo

Google Analytics

Python logo

Python

Android Studio logo

Android (Java)

Flutter logo

Flutter

Portfolio

My Recent Projects

Final Year Project

A sentiment analysis tool designed to assist Malaysian SMEs in analyzing customer feedbacks and gaining valuable insights. The tools comprises simple data cleaning feature, interactive dashboards, direct review prediction that benefits business owners. Click here to view the project.

Python Streamlit Data Mining Machine Learning

ApPA (AP Personal Assistance)

A low-code application developed during the 30-hour AppSheet Hackathon with the theme of "Improving University Life". ApPA is a one-stop solution that APU students and staffs to view the most recent events, check the status of car parks, manage their to-do lists, and even receive instant responses to all campus-related queries.

AppSheet Google Slides Google Sheets

Tuition Centre Management System in C++

The aim of this project is to develop a console application written in C++ to address the limitations of eXcel Tuition Center's manual filing system. Two different data structures, Array and Doubly Linked List, and two sorting algorithms, Bubble Sort and Insertion Sort. These will improve sorting based on attributes such as overall performance and Tutor ID, providing improved performance and management of tutor records.

Console Application C++ Sorting & Sort Algo

Analyzing Crime Patterns: Insights From Los Angeles Dataset

This project aims to analyze a crime dataset from Los Angeles since 2020, and develop an analytical solution using SAS Enterprise Miner. The objectives include identifying criminal hotspots, potential victim profiles, and analyzing common weapons used in crimes. Clustering is implemented to analyse and cluster sectors such as crime categories, weapon usages and victim profiles. Moreover, each cluster is being analyzed with different supervised models to determine the model with the highest accuracy.

SAS Enterprise Miner Data Mining

Covid-19 Vaccine Registration System

A vaccine registration system for Malaysian citizens and non-citizens was developed improving the effectiveness of the Covid-19 vaccine registration process. Features including scheduling vaccination appointments, people management, reports generation, managing committee members, and managing vaccines and centres. The system was developed with NetBeans IDE in Java, which includes Object-Oriented concepts and data were stored in text files (.txt)

Java NetBeans IDE Java Swing UI OOP Concept

Employee Attrition Analytics In R Programming

An attrition dataset is provided for analysis in order to identify potential root causes of employee attrition. Recommendations are also made to assist businesses in increasing employee productivity.

R Programming Data Cleaning Data Visualization

Alpine Works Cycles Analytics with Power BI

This project aims to revitalize sales and customer satisfaction of Alpine Works Cycles by implementing a business intelligence solution. The objectives encompass understanding historical sales performance, extracting customer purchasing patterns, identifying performance-degrading factors and offering recommendations based on patterns to enhance both sales and customer satisfaction.

Microsoft Power BI Microsoft Visual Studio SSAS - DW

Additional Highlights

More Projects

Power BI Project (Personal)

This project aims to develop 2 dashboards: revenue tracking and salesperson performance analysis dashboards. These dashboards offer a comprehensive view of revenue generation and order counts across various channels and product categories. Additionally, the salesperson dashboard serves the purpose of identifying the top three performing salespersons, enabling management to recognize their outstanding contributions.
Power BI DAX Queries

IMDB Movie Dashboard with Streamlit

The IMDB Movie Dashboard is a dynamic and user-friendly web application that provides comprehensive insights into the IMDB movie dataset. Besides, the dashboard's interactive features enable users to filter and sort movies based on various criteria, enhancing their ability to discover new films and gain valueable insights. Click here to view the project.
Data Visualization Streamlit

E-learning Mobile Application (Study Gang)

Study Gang, a mobile app designed for SPM students seeking self-paced learning. Figma is utilized for the app's user interface design and Android Studio in Java is used to develop its features.
Android Studio (Java) Mobile Application Prototype

Grocery Chatbot

A chatbot project was developed with SnatchBot to provide customers with a seamless grocery shopping experience while also facilitating the grocery business operation. The chatbotalso recommends grocery lists for customers based on their meal types and preferences, tracks product promotions or discounts, and displays membership benefits.
Introduction to AI SnatchBot

Hotel Management System

A Java project developed with the NetBeans IDE that simulates hotel room reservations. The main features include room reservation, billing and receipt generation, employee management, and customer details management.
Java NetBeans IDE

E-commerce Data Analysis

A data analysis project in which data was collected, cleaned, and analysed in multidimensional views using SAS Visual Analytics in order to increase e-commerce sales and address e-commerce limitations. The scope was narrowed down to product category in order to analyse the purchase rate by product category. OLAP approaches were used to determine the highest and lowest purchase frequency of a product category, as well as the possible reasons.
SAS Visual Analytics Data Cleaning Data Visualization

Database System For E-bookstore

This project aimed to design and develop a relational database system for an online bookstore. SQL queries were utilized for table creation and data manipulation in the database.
SQL Server Management Studio SQL