Matiwos Desalegn
Portfolio

My Projects

A comprehensive showcase of data engineering and AI solutions that drive real business impact

Work

Featured Projects

Showcasing innovative data engineering and AI solutions that drive real business impact

Data Engineering
CDC replication lag monitored with cdc-monitor alertsFeatured

World Bank CDC Analytics Platform

End-to-end analytics engineering pipeline with PostgreSQL OLTP, Debezium CDC, Redpanda, ClickHouse OLAP, dbt marts, Airflow orchestration, and Grafana observability plus a live demo environment.

PostgreSQLDebeziumRedpanda+6 more
~3K rows ingested from paginated REST API
Performance
Live demo environment for portfolio review
Impact
View Details
Data Engineering
Unified RAW to Application to Cleansed S3 layer structureFeatured

Multi-Bank Digital Lending ETL Orchestration

Mage AI-orchestrated ETL system ingesting loan data from 5 Ethiopian partner bank Metabase instances every 6 hours into AWS S3, with PAR (Portfolio at Risk) transformation and Athena-queryable cleansed layers for digital lending analytics

Mage AIAWS S3AWS Athena+3 more
6-hour ingestion cadence across 5 partner banks
Performance
Serving PAR analytics and portfolio risk monitoring for the digital lending platform
Impact
View Details
Data Engineering
~70% storage reduction via Parquet + SnappyFeatured

Firebase Analytics Data Pipeline

Automated daily pipeline exporting 600K–800K Firebase Analytics events from Google BigQuery to AWS S3 in Parquet format with Snappy compression

PythonBigQueryAWS S3+5 more
600K–800K events exported daily
Performance
Zero BigQuery storage cost via table expiration lifecycle
Impact
View Details
Data Engineering
99.9% pipeline reliabilityFeatured

Credit Scoring Batch API

Production FastAPI microservice for batch ingestion of 18+ financial and behavioral data domains, powering credit scoring for 5 Ethiopian partner banks via Feast Feature Store and ML pipelines

FastAPIMongoDBFeast Feature Store+9 more
5–10 pod autoscaling under load
Performance
Serving 5 Ethiopian partner banks
Impact
View Details
Data Engineering
Zero-downtime atomic table swap for all partner banksFeatured

Multi-Source Digital Lending Data Platform

Production multi-source data platform ingesting core banking, sharia-compliant, operational, and portfolio risk data from 5+ partner banks into Aurora PostgreSQL and Amazon Redshift, powering credit risk, portfolio analytics, and Power BI dashboards for a digital lending business

Apache AirflowAmazon Aurora PostgreSQLAmazon Redshift+11 more
5 source systems, daily full-refresh ingestion
Performance
Serving 5 partner banks + 3 internal analytics teams
Impact
View Details
Data Engineering
CI/CD via GitHub Actions + GitLab CI/CD; GDPR-compliant anonymizationFeatured

Digital Lending Dimensional Data Modeling

End-to-end dimensional modeling project for a digital lending platform - from conceptual and logical design through physical Star Schema implementation (fact and dimension tables) in Amazon Redshift - covering Transient Staging, Core Canonical Data Model, and a Semantic Layer with Data Contracts for analytics, credit risk, and BI consumption

dbt CoreAmazon RedshiftPostgreSQL+7 more
99.9% uptime - Kubernetes (EKS) containerization
Performance
Serving Power BI, credit risk models, and portfolio analytics across 4 source systems
Impact
View Details

Need Similar Solutions for Your Project?

I can help you build scalable data infrastructure, AI-powered solutions, and fintech applications. Let's discuss your requirements.

View All Projects