Skip to content

TelRich/TelRich

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

33 Commits
 
 
 
 

Repository files navigation

Hey there, I'm Goodrich Okoro

Data & Analytics Engineer | Fintech data platforms | Credit risk


About Me

I'm a Senior Data & Analytics Engineer who builds production-grade data platforms for fintech and lending teams. I design resilient pipelines, data models, and automation that move data from core systems into analytics-ready layers without compromising reliability or compliance.

  • Bridge core banking data to modern stacks with Python, SQL, Prefect, dbt, and PostgreSQL.
  • Architect migration and remediation frameworks that keep large user and loan portfolios consistent during platform changes.
  • Ship analytics assets (dashboards, documentation, and data apps) that support credit, fraud, and finance teams.

Highlights from recent work

  • Prefect orchestration for 40+ flows: ETL across Instafin, Odoo, Zendesk, segmentation, and dbt runs with GitHub Actions deployments, secrets management, and a domain-driven restructuring plan with shared configs and utilities.
  • Dual-mode Instafin NG migration runner: chunk-based parallel pipeline for 125k+ users (strategic and remaining KYC-approved) with test/summary modes, VAN updates, and rollback-friendly design that cut runtimes from days to hours and eliminated duplicate processing.
  • Post-migration automations: Prefect flows to reprocess failed loans, migrate unmigrated accounts, backfill missing repayments, and update client records after core banking cutovers.
  • Analytics warehouse with dbt: staging/intermediate/mart models for Instafin loans, clients, and corporates; seed-driven product mappings; relationship tests; and a rollout plan for documentation, exposures, and CI quality checks.
  • Core banking ETL and cleanup: Python/Prefect jobs for clients, corporates, and loan schedules plus API-driven scripts to close dormant accounts, fix balances, and refresh profile images for better data hygiene.
  • Vintage analysis app: Streamlit + Postgres + Plotly dashboard for loan repayment and vintage KPIs with cached SQL queries, cohort filters, and performance metrics for risk teams.

Toolbox

Data Engineering & Orchestration

Python Prefect dbt Airbyte Airflow

Databases & Warehousing

PostgreSQL Azure PostgreSQL MySQL SQLite Databricks

Analytics & Visualization

Superset Power BI Streamlit Looker Tableau

Core Technologies

SQL Pandas NumPy SQLAlchemy FastAPI

DevOps & Version Control

Git GitHub Actions Docker CI/CD


Selected Projects

  1. spark-dbt-postgres — Spark + dbt + PostgreSQL data stack with incremental models, quality checks, and automated docs.
  2. Credit-Risk-Model — Credit risk analytics pipeline with portfolio KPIs, PAR analysis, and ML-based scoring.
  3. Prefect — Prefect-based orchestration patterns for ETL, segmentation, and reporting jobs.
  4. gcp-ingestion-project — Cloud ingestion pipelines to land batch data into a warehouse using a lightweight orchestration stack.
  5. mongodb-eduhub-project — MongoDB-backed learning hub with CRUD and aggregation flows for course content.
  6. csv-to-db-project — Automated CSV loader that normalizes files and writes them to a relational database.
  7. Data-Entry-App-with-Streamlit — Streamlit data-entry app that validates inputs and persists them to a database.
  8. Power-BI-Dashboards — Collection of finance and operations dashboards packaged for easy review.
  9. National-University-Ranking-App — Streamlit search application with advanced filtering and ranking.
  10. Currency-Foreign-Exchange-Rates-Forecasting — Time-series forecasting using ARIMA/Prophet with explainability-ready visuals.

GitHub Analytics

GitHub Stats Top Languages
GitHub Streak Stats
GitHub Trophies

Certifications & Continuous Learning

Click to expand certifications
  • Diploma in Data Engineering — AltSchool Africa
  • Certified Associate Data Analyst — DataCamp
  • ALX-T Data Analyst Nanodegree — Udacity
  • SQL for Database Administrators — DataCamp
  • Data Analyst with Python — DataCamp
  • Fundamentals of Credit — CFI
  • Professional Ethics — CFI

Let's Connect!

I'm always interested in collaborating on projects that involve:

  • Building scalable data infrastructure
  • Creating impactful analytics solutions
  • Fintech and financial data challenges
  • Automating complex data workflows

Reach out to me:


"Turning data chaos into business clarity, one pipeline at a time"

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published