Hi, welcome to my data portfolio. I'm a UNSW Sydney student undertaking a double degree in Economics (Econometrics and Data Analytics) and Arts (Politics and International Relations). You can find some of the projects I've enjoyed working on here. Below are some of the highlights.
| Type | Project/Certification | Skills/Technologies |
|---|---|---|
| Internships | Logistics Dashboard - Amazon Internship '22-'23 | SQL (PostgreSQL, SQLite)Python (Pandas, Matplotlib, sqlite3) Microsoft Excel (Power Query, Pivot Tables/Charts) |
| Personal Projects |
UFC/MMA Sports Analytics - EDA & Web Scraping '23 | Python (Pandas, Matplotlib, Seaborn, Scrapy) |
| Online Courses |
Data Analyst with Python - DataCamp |
Any information that could violate my NDA has been redacted
🚨 Find a closer look at how I utilised SQL in my project here SQL Highlights 🚨
During my internship at Amazon Logistics over the summer of 2022/23, I owned a project that produced an Excel dashboard for operations managers across the Last Mile (the final, and often most expensive, part of the supply chain where the parcel is delivered to the customer) Logistics Network.
My overall project involved:
- A scheduled SQL statement to extract relevant data from Amazon databases.
- A Python script that read the extracted data and utilised the SQLite3 module for feature engineering and creating tables.
- An Excel spreadsheet that utilises Power Query to take the outputs from the previous steps and visualise the data using pivot tables.
My dashboard provided new and granular insights into the root of logistical defects, guiding decision-making and formulation of effective response plans. Nearing the end of my internship, I worked with the business intelligence team to implement the categorisation logic from my SQL statement into the broader internal Amazon Logistics web dashboard.
🚨 Find more details here 🚨