Skip to content
View Richie-Rokka's full-sized avatar
🎯
Focusing
🎯
Focusing
  • Ontario, Canada
  • 17:11 (UTC -04:00)

Block or report Richie-Rokka

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Content in all repositories owned by your account will be closed.
Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. Markdown is supported. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
Richie-Rokka/README.md

Hi, I'm Abodunrin Oketade 👋

Business Intelligence Analyst | Commercial, Revenue & Operational Analytics

I build analytics solutions that transform commercial, operational, and workforce data into clear KPIs, decision-ready insights, and executive reporting.

My background combines commercial and business experience with hands-on analytics across SQL, Python, Power BI, DAX, PostgreSQL, Data Modeling, ETL, Performance Analysis, Power Automate.


🚀 Featured Portfolio Projects

🥇 Automated Commercial Performance Reporting System

End-to-end commercial reporting workflow connecting actual sales performance and CRM pipeline visibility with management decision support.

Combines AdventureWorks sales data and Maven CRM opportunity data through Python extraction, transformation, validation, reporting-ready datasets, generated Excel outputs, and a Power BI report. A local Power Automate Desktop workflow supports report refresh/save and export distribution.

Focus: Python · SQL Server · AdventureWorks · Maven CRM · Excel · Power BI · Commercial Analytics · CRM Pipeline · Reporting Automation · Management Recommendations

➡️ View Project


🥉 Revenue Operations Intelligence Platform

Business intelligence platform for analyzing the commercial funnel, sales performance, customer value, and revenue operations.

The project transforms simulated commercial data into decision-support analytics across lead generation, opportunity performance, sales effectiveness, customer value, and revenue intelligence.

Focus: Python · SQL · Power BI · Revenue Operations · Commercial Analytics · Funnel Analytics · KPI Development · Business Intelligence

➡️ View Project


🥈 Commercial Analytics Pipeline

Reproducible end-to-end analytics workflow for transforming raw commercial data into trusted business insights.

The project demonstrates a structured analytics pipeline covering data preparation, validation, SQL analysis, and reusable outputs across revenue, customers, products, regions, segmentation, and cohort retention.

Focus: Python · Pandas · SQL · Data Validation · Revenue Analytics · Customer Analytics · Cohort Analysis · Data Visualization

➡️ View Project


👥 Enterprise Workforce Planning & Talent Intelligence

Power BI workforce intelligence solution integrating workforce planning, attrition risk, and talent acquisition analytics.

The project combines workforce capacity, projected demand, staffing gaps, retention risk, and recruitment performance into a unified decision-support framework.

Note: This portfolio project uses synthetically generated workforce data and does not represent results from an actual organization.

Focus: Power BI · DAX · Workforce Analytics · Workforce Planning · People Analytics · Forecasting · Talent Intelligence · Data Modeling

➡️ View Project


🏗️ Enterprise Revenue Intelligence Platform

Enterprise data platform architecture for ingesting, validating, warehousing, modeling, building semantic analytics and KPIs, and exposing revenue data for analytics.

The completed and published platform baseline demonstrates modular ETL orchestration, PostgreSQL warehousing, data quality controls, runtime monitoring, semantic analytics, and KPI development.

The project is paused beyond its completed v4.5.0 baseline, which remains the documented architectural reference.

Focus: Python · PostgreSQL · SQL · ETL · Data Warehousing · Data Quality · Semantic Layer · Analytics Engineering · Revenue Analytics

➡️ View Project


📈 Marketing Mix Modeling & Budget Optimization

Marketing analytics project focused on channel effectiveness, return on investment, forecasting, and budget allocation.

Focus: Python · SQL · Power BI · Marketing Analytics · Marketing Mix Modeling · ROI · Forecasting · Budget Optimization

➡️ View Project


📊 Additional Analytics Projects

Project Focus Tech
Customer Acquisition & Funnel Analytics Conversion, cohort analysis, funnel leakage, and acquisition performance Python · SQL · Power BI
Enterprise Data Quality Monitoring Data validation, reporting integrity, and governance Power Query · Excel

🛠️ Analytics & Technology

Business Intelligence

Power BI · SQL · DAX · Power Query · Tableau · Excel

Data & Analytics Engineering

Python · Pandas · NumPy · PostgreSQL · SQL Server · ETL · Data Modeling · Data Validation

Analytics & Business Performance

Commercial Analytics · Revenue Analytics · Revenue Operations · Customer Analytics · Workforce Analytics · Operational Analytics · Forecasting


🎯 What I Build

  • 📊 Executive and operational intelligence solutions
  • 💰 Revenue and commercial performance analytics
  • 👥 Customer, cohort, funnel, and workforce analytics
  • 📈 KPI frameworks and performance reporting
  • 🗄️ SQL-based analytical solutions and data models
  • ⚙️ Automated analytics and ETL workflows
  • 🔍 Data quality and validation frameworks
  • 🏗️ End-to-end analytics pipelines

🌐 Business Domains

Business Intelligence · Commercial Performance · Revenue Analytics · Revenue Operations · Customer Analytics · Operational Analytics · Workforce Planning · People Analytics · Performance Analytics · Executive Reporting


🤝 Let's Connect

I'm interested in opportunities and conversations around Business Intelligence, Data Analytics, Commercial Analytics, Revenue Analytics, and Operational Performance.

📍 Ontario, Canada


Turning business data into actionable decisions.

Pinned Loading

  1. Automated-Commercial-Performance-Reporting-System Automated-Commercial-Performance-Reporting-System Public

    End-to-end commercial analytics and reporting automation for sales performance, profitability, CRM pipeline, and management decision support using Python, SQL Server, Excel, and Power BI.

    Jupyter Notebook

  2. Revenue-Operations-Intelligence-Platform Revenue-Operations-Intelligence-Platform Public

    Built a Revenue Operations Intelligence Platform that transforms 100K leads and 25K opportunities into executive insights across funnel performance, sales effectiveness, customer value, and revenue…

    Python

  3. Commercial-Analytics-Pipeline Commercial-Analytics-Pipeline Public

    Reproducible end-to-end commercial analytics pipeline using Python and SQL for revenue, customer, regional, movement, and cohort analysis.

    Python

  4. Enterprise-Workforce-Planning-and-Talent-Intelligence Enterprise-Workforce-Planning-and-Talent-Intelligence Public

    Enterprise workforce planning and talent intelligence solution built in Power BI, integrating workforce forecasting, staffing gaps, attrition risk, and recruitment analytics.

    Jupyter Notebook

  5. Enterprise-Revenue-Intelligence-Platform Enterprise-Revenue-Intelligence-Platform Public

    An enterprise analytics platform for revenue and operational intelligence, featuring ETL orchestration, data quality, monitoring, warehouse modeling, semantic analytics, and KPI development using P…

    Python 2

  6. Marketing-Mix-Modeling-Budget-Optimization Marketing-Mix-Modeling-Budget-Optimization Public

    Marketing Mix Modeling (MMM) and revenue optimization system analyzing CAC, ROI, channel efficiency, revenue forecasting, and scenario-based budget allocation using Power BI and advanced business a…

    Jupyter Notebook