Professional Projects

Below are projects that demonstrate my abilities with VBA, Python, SQL, and Tableau. I categorize these as professional projects since they utilize commonly used technical skills in analytics. In addition, I believe that they also teach universal and transferrable skills, such as the ability to learn in an unguided and independent setting and the ability to leverage available resources to complete a task.

View my certifications at https://www.credly.com/users/binaryxxsune

TIP: Fullscreen/download files for easier readability if necessary. Usually found at the bottom of the media

VBA

To use and inspect the macros, please download the worksheet.

Question Auto Fill Macro

Designed a user form to populate and format a sheet with a character’s info and stats, based on the inputted parameters.

Character Creation User Form

Create a macro to automatically answer common questions, such as name and current date, regardless of its location in the selection.

Python

Street Fighter 6 Rank Distribution Explorer

Visualized the distribution of 750k players’ ranks based on web-scraped data to provide an accurate benchmark
Leveraged multiprocessing for an 80% runtime reduction to allow for the implementation of a player inactivity check

Valorant Meta Analysis Series

Built an interactive dashboard to reveal the most popular and successful characters based on the map and skill level
Evaluated whether performance statistics from past matches, such as accuracy, can be used to predict a player’s rank
Gathered, stored, and wrangled data requested from a REST API to overcome the limited match data provided

IBM Data Science Professional Capstone Project: Winning the Space Race through Data Science

Employed classification algorithms, such as KNN and SVM, to predict if rocket engines will be successfully retrieved and reused after their launch, determining the company’s ability to offer competitive contracts through cost savings
Performed all the tasks found in a data science project’s life cycle, from data collection to communication of findings

SQL

HackerRank: The Report
Completed the following HackerRank challenge: “The Report - write a query to generate a report containing three columns: Name, Grade and Mark.”
https://www.hackerrank.com/challenges/the-report/problem

  
SELECT  
    CASE   
    WHEN g.grade > 7 THEN s.name   
        ELSE NULL   
    END AS student_identifier,   
    CASE   
        WHEN s.marks BETWEEN g.min_mark and g.max_mark THEN g.grade   
    END AS student_grade,   
    s.marks   
FROM students AS s   
INNER JOIN grades AS g   
ON s.marks BETWEEN g.min_mark AND g.max_mark   
ORDER BY student_grade DESC,   
    CASE   
        WHEN student_identifier IS NULL THEN s.marks   
        ELSE s.name   
    END   
;