💡 I'm currently a Financial Technology and Data analytics major studying at the University of Hong Kong.
🎓 I enjoy learning about new technologies and creating software solutions and quick hacks.
🌱 My background has exposed me to AI and Systems Design which I will deepen my understanding of.
✍️ Apart from this, reading history books and chinese novels are hobbies/side hustles I pursue in my free time.
💬 If you're in need of pro bono consulting services or just want an interesting conversation, feel free to reach out via email at FrankiePang2010@gmail.com! I'll do my best to respond as soon as possible. All feedback and suggestions are welcome!
dApp for NFT Ticketing (https://github.com/hlpangaa/nft-ticketing-main)
- Deployed smart contracts in the Ethereum network using hardhat framework, utilized a Next JS frontend to allow users to use Metamask to interact with the smart contract in a Web3 fashion
- Hosted the frontend in Fleek(decentralized nodes) and connected with the graph(indexing protocol) to listen to the event emitted under the contracts, stored metadata in InterPlanetary File System(IPFS)
Used Car Price Prediction (https://github.com/hlpangaa/python-ml-linear-regression)
- Gathered and analyzed data related to used car prices and divided the data into training and testing datasets
- Built a linear regression model, evaluated the model using Mean Squared Error(MSE) and predicted the used car price
Classification for Loan Evaluation (https://github.com/hlpangaa/python-ml-decision-tree-and-random-forest-loan-data)
- Gathered and analyzed data related to automobile loans and divided the data into training and testing datasets
- Constructed a decision tree via computing the information gain recursively, improved the model performance using Random Forest Algorithms(RFA), and predicted the loan status (Approved/Declined)
Clustering to group Loan Applications (https://github.com/hlpangaa/python-ml-kmean-and-clustering-loan-data)
- Gathered and analyzed data related to automobile loan applications and divided the data into training and testing datasets
- Applied K-means and Hierarchical Clustering, evaluated the model and generated the clustering results.
Robot Cleaning (https://github.com/hlpangaa/python-ml-reinforement-learning-robot-cleaner)
- Created a learning environment, a robot agent and a reward function and applied a reinforcement learning algorithm to enable the robot to learn
- Visualized the Robot Behavior and evaluated the result via a plotted graph for rewards against the number of testing episode
F1(Car Racing) Data Pipeline (https://github.com/hlpangaa/databrick-formula1-data)
- Constructed a data pipeline for F1 data in Azure environment with components of Azure data lake storage, Azure data factory and Databrick
- Transformed and Load the data using Python and SQL to convert a single csv to multiple tables with defined schema and partition
Flight Price Alert (https://github.com/hlpangaa/python-web-scraping)
- Programmed to harvest flight price data from Expedia and Skyscanner using Beautiful soup and Selenium, scheduled to run daily with Macbook's built-in job automater.
- Cleaned, normalized, and transformed the raw data into usable information in Pandas and Numpy, and designed an alert trigger when the expected price is hit.
Foodie Portal (https://github.com/hlpangaa/react-foodie-data-fetching)
- Built a React-based portal to allow users to view random food recipes or search specific types of food and feedback
- Setup API integration with theMealDB to the responsive single-page application
Trader's Watchlist (https://github.com/hlpangaa/react-trading-data-fetching)
- Built a React-based portal to allow users to view trading data in their own's watchlist via FinnHub API
- Visualized the candle chart for the stock and introduced the Auto-complete function in the stock list
- Azure Data Engineer Associate - Microsoft
- Azure Data Fundamental - Microsoft
- Azure Fundamentals - Microsoft
- Azure Databricks & Spark Core For Data Engineers(Python/SQL) - Udemy
- SQL (Advanced) Certificate - Hackerank
- Tableau training - SkilUp
- Certified Scrum Product Owner (CSPO) - Scrum Alliance, Inc.
- Professional Scrum Master I - Scrum.org