Chisom Nnamani

Data Engineering

Reddit ETL Data Pipeline

Designed and deployed a fully orchestrated ETL pipeline to extract Reddit posts, transform them using AWS Glue, and make the data queryable via Athena and Redshift Spectrum. Utilized Apache Airflow, Docker, Terraform, and AWS (S3, Glue, Athena Workgroup, IAM, VPC, Redshift). This pipeline enabled scalable ingestion and transformation of social media data for downstream analytics.

Data Engineering

Travel Agency Data Platform

Developed a robust data platform to streamline data ingestion, transformation, and storage for predictive analytics. This enabled a travel agency’s data science team to forecast travel demand and identify high-potential markets. Utilized Docker, Apache Airflow, Terraform, AWS (VPC, S3, ECR, SSM, Redshift), and dbt.

Data Engineering

ELT Pipeline with GCP and Apache Airflow

Built a secure ELT pipeline to process over 1 million global health records on Google Cloud Platform, enabling country-specific data access and analysis of diseases lacking treatment or vaccination. Automated data ingestion from GCS to BigQuery using Apache Airflow, and transformed data into clean, analysis-ready tables

Data Engineering

Rocket Enthusiast Case Study

Built an ETL data pipeline that automated the retrieval of upcoming rocket launch images for a space enthusiast, using the Launch Library 2 API. This streamlined access to up-to-date rocket visuals is achieved by storing image URLs in a structured format. Leveraged Apache Airflow for orchestration, Docker for containerization, and the launch API library for data retrieval.

Data Engineering

Building OLAP Dimensional Model in BigQuery, using dbt as a Data Transformation Tool.

This project is about building a dimensional data warehouse in BigQuery by transforming an OLTP system in MySQL into an OLAP system in BigQuery, using dbt as a data transformation tool.

Data Engineering

Designing a Bank Marketing Database

This project involved creating a comprehensive database using PostgreSQL to manage customer information for a bank's marketing campaigns. I used Python to import, clean, and load data, ensuring its quality and reliability, and authored scripts to set up database tables.

Data Analysis

The Look E-commerce Data Analysis

In this project, I utilized SQL to analyze The Look's data; an e-commerce clothing store and answered some business questions regarding the performance of the e-commerce marketplace, gain insights, and provided some recommendations to increase revenue.

Data Analysis

Transaction Data Analysis using SQL

This case study is all about calculating metrics, growth and helping Data Bank; a FinTech startup analyse their data in a smart way to better forecast and plan for their future developments.

Data Analysis

Cryptocurrency Data Analysis

In this project, using Python and its libraries, I built a web scrapper, scrapped and analyzed top 10 Cryptocurencies live data from Cryptowatch.

Data Analysis

Business Performance Analysis using SQL

This case study centers on leveraging Foodie-Fi’s digital data, which follows a subscription-based model, to analyze critical business metrics relating to the customer journey, payment transactions, and overall business performance.

Data Analysis

Sales Performance Analysis using SQL

I analyzed data from Adventure Works database and conducted a Sales Performance Analysis, answering some pertinent business questions.

Data Analysis

Querying the Database of a Paper-Selling Company using SQL

Parch and Posey is an e-commerce paper selling company that sold 3 diffetrent types of papers to companies(accounts) via different channels at diferent point in time in different regions.

Data Analysis

Amazon Best Selling Books Analysis

In this project, I web-scrapped Amazon best-selling books using Selenium and Beautiful Soup. I wrangled and analyzed the best selling books beginning from 2009 to 2019.

Data Analysis

We Rate Dogs Twitter Analysis

"In God we trust, all others must bring data" - W. Edwards Deming

In this project, I queried Twitter API using Tweepy, wrangled and analyzed the tweet archive of Twitter user @dog_rates, also known as WeRateDogs.

Data Analysis

Medical Appointment Data Analysis

In this project, using Python and its libraries, I wrangled and analyzed more than 100k Medical Appointments in Brazil to derive insights on the reasons why patients showed up or not for their appointments.

Data Analysis

Africa Food Production and Supply

Who Grows and who Eats the food we grow in Africa? The project focuses on finding insights, patterns and trends through visualizations on food Production and Supply data in Africa using Seaborn and Matplotlib.

Data Analysis

Tackling the Health Crisis in Africa

I participated in a hackathon and worked on the case study; Tackling the Health Crisis in Africa and provided recommendations on how to curb this crisis using Power BI.

Data Analysis

Sales and Market share Analysis using Excel

The CMO of VarnArsdel, a fictitious manufacturing company wanted to keep an eye on the company's performance both internally and externally.

As the Business Intelligence Analyst, I analyzed the sales and market share data of the company and its competitors and built an interactive Excel dashboard answering the relevant business questions.