Completed on: 15th Dec 2025
Skills utilized: Software Development, Database Management
Libraries/Languages: Xlwings, Python, SQL
Project code available soon.
Developed a programme for Lady Bea's English Tea House in Edmonton, Canada to automate their payroll information's addition to Excel. The main purpose was to create a spreadsheet with accurate information, and in an easily comprehensible manner.
It reads payroll information from an Excel workbook and creates a payroll sheet on Excel, containing bi-weekly hours worked by each employee. It filters the date, employee, role, and hours worked and the information is easily discernible. This same information is then stored in a PostgreSQL database.
Increased accuracy of the information added to Excel and decreased the time by 95% compared to creating the same Excel sheet manually.
Skills utilized: Software Development
Libraries/Languages: Xlwings, Python
Project code available soon.
Created the project to generate volcano plots of data from heart sample's of patients that suffered different types of cardiomyopathy. Programme used in the research of "Glycan Profiling in Cardiomyopathy Using Lectin Microarrays".
Used by the Faculty of Science graduate students of the Mahal Lab at the University of Alberta.
This programme saves over 90% of the time students would take to filter through data and generate plots; it also increased the accuracy of the filtered data and the plots.
Skills utilized: Software Development, Web Design
Libraries/Languages: Xlwings, Dash, Yfinance ,Python
Project code available here.
I undertook this project for a friend who maintained his financial portfolio on Excel. The two main goals were to automate the addition of his portfolio data with the most recent data from Yahoo Finance and to display information regarding his portfolio on a dashboard.
This program saved him over 85% of the time he would take daily to add information to Excel, and it increased the accuracy of the information added.
This program also:
Skills utilized: EDA, Dataset cleaning, Documentation
Software/Languages: Jupyter Notebook, Python
Project code available here.
Explored, cleaned, and prepared a dataset (over 289,000 entries) for analysis containing my listening records on Spotify from 2018 to 2025.
Some of the tasks accomplished were:
Skills utilized: Data analysis, Dataset cleaning, Documentation
Software/Languages: Jupyter Notebook, Python
Project code available here.
The following analyses were conducted:
Skills utilized: Data Acquisition, Data Visualization, Hypothesis Testing, Summarizing Quantitative Data, Data Wrangling and Tidying, Data Manipulation with Pandas
Software/Languages: Jupyter Notebook, Python
Project code available here.
The potential relationship of the Gross Domestic Product (GDP) and the life expectancy at birth (LEB) for six nations was investigated.
The data present in the dataset was for the period 2000 to 2015. The following countries were analyzed: Chile, China, Germany, Mexico, United States of America, and Zimbabwe.
The following points were analyzed:
Conclusion: In the given time frame, all
six countries experienced a growth in their GDPs, albeit to various degrees. The life expectancy at
birth also increased for all six nations, with Zimbabwe experiencing the largest LEB increase
despite a relatively modest increase in their GDP.
The life expectancy at birth for all six countries increased as the GDP of the respective nations
improved.
Skills utilized: Web Design, Web Development
Software/Languages: Visual Studio Code, HTML, CSS
A portfolio website (this website) designed from scratch to showcase various computer science and engineering projects that I have undertaken.
Skills utilized: Mechanical Design, Failure Analysis, Manufacturing
Software/Machines Utilized: Drilling CNC (Computer Numeric Control), FDM 3D Printer, Fusion 360
Designed and manufactured a prototype of a wooden floor tile that would generate electricity when stepped on.
Converted energy from footsteps to current via movement of fluid. Uses the concept of hydropower to generate 1.5 W.
Skills utilized: Mechanical Design, Failure Analysis, Simulation, Documentation
Software: ANSYS, Microsoft Word
Conducted an FEA of a jet engine bracket under various loading conditions.
Documented and presented the results of the simulations and analysis.
Skills utilized: Mechanical Design, Circuit Design, Failure Analysis, Business Plan Development, Group Work, Leadership
Software: SOLIDWORKS, Microsoft Word
CAD files available here.
Designed sprinkler & housing, provided technical drawings, circuit layouts, and design failure mode and effects analysis (D-FMEA).
Skills utilized: Mechanical Design
Software: SOLIDWORKS
CAD files available here.
Designed and created an assembly for a hydraulic scissor lift on SOLIDWORKS.
Utilized design automation to accommodate customizable sizes. Provided model drawings.
Skills utilized: Mechanical Design, Failure Analysis, Advanced Mathematics, Group Work
Software: SOLIDWORKS, Microsoft Word
CAD files available here.
Designed and conducted a failure analysis of gearbox that housed two bevel gears.
