SQL Fundamentals Walkthrough
Wrote a comprehensive review of SQL fundamentals. Topics covered include basic syntax, joins, and aggregations. Many examples are provided.
Utilized: SQL (SQLite, MySQL), R
Hi, I'm Chira 👋🏾
I am a developer and data professional inspired by tough problems and helping others make their best decisions.
In this portfolio, I share my latest projects, blog posts, and tutorials in the space of data and technology.
Reoccurring topics include algorithmic decision systems and human-centered design in technology and social infrastructure.
You can
find the code for each technical project on GitHub
accompanied with a clear and comprehensive
description.
If you would like to collaborate on a project, please reach out to me by e-mail or
LinkedIn.
Recent Work
COVID-19 Media Fact Checker
A research project on the development and performance of two neural networks trained to
differentiate between accurate
and inaccurate COVID-19 media.
Utilized: Python, TensorFlow, Pandas, NumPy, Scikit-learn, NLTK, Seaborn, GloVe, Kaggle
Real-time ETL Pipeline for IoT System
Developed an ETL pipeline that extracts and loads multimodal IoT sensor data into PostgreSQL.
Utilized: SQL (PostgreSQL), PHP, Bash, HTML/CSS, JavaScript
Deep Learning with Biologically Plausible Neural Networks
A performance comparison between spiking neural networks and conventional neural networks on the
MNIST, CIFAR-10, and Google Speech
Commands Tasks.
Utilized: Python, PyTorch, ssnTorch, Deep Learning
Market and Natural Forces on H1B Visa Adjudication
A data analysis project investigating the influence of COVID-19 and the tech labor market on
H1B Visa acceptance rates and wait times.
Utilized: R, Tidyverse, ggplot
Prisoner's Dilemma Game
A command line game simulating creative instances of the prisoner's dilemma.
Utilized: Python