Data Transformation and Data Modeling
Efficient transformation of data to building data models that enable business intelligence.
Chisom Nnamani
Software (Data) Engineer, with a specialty in organizing and optimizing information for businesses. From creating efficient databases to ensuring seamless data flow, I transform raw data into valuable insights to drive informed decision-making. Let's turn your data into a strategic asset.
About Me.
Dedicated to crafting Data Solutions with an emphasis on scalable data architectures. I specialize in implementing robust data pipelines, designing efficient databases, and creating analytics solutions to meet the unique needs of businesses.
- My Skills are: Golang, Python, SQL, dbt, NoSQL databases, Unix, Database Management Sytems (SQLServer, MySQL, PostgreSQL), Data Warehouses (Amazon Redshift, Google BigQuery, Azure SQL Database, Snowflake), Cloud Storage (Amazon S3, Google Cloud Storage, Azure Blob Storage, Azure Data Lake), Spark, Docker, Apache Airflow, Terraform, Git & GitHub.
Services.
Database Design
Robust databases to ensure seamless data flow and accessibility.
Data Engineering
Efficient organization and optimization of data from different sources and building scalable data pipelines, ensuring data quality for actionable insights.
Projects.
Software Engineering
Ascii Art Web Generator
Built a fun, interactive website that turns whatever you type into instant ASCII art; a text-based artwork rendered entirely from letters and symbols. Users can type a message, choose from three artistic styles (Standard, Shadow, Thinkertoy), and instantly see their words transformed into bold, retro-style block art. The site is fast, responsive, and deployed online so anyone can use it. Built with Go, an HTTP server, template rendering, and deployed on Render.
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.
Contact Me.
I will read all emails. Send me any message you want and I'll get back to you.
I need your Name and Email Address, but you won't receive anything other than your reply.
Send Me A Message