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




