📊 Data Analyst | Business Intelligence | Sales, Operations & Marketing Analytics
I build end-to-end analytics solutions that transform raw data into actionable business insights.
- Design interactive dashboards in Power BI
- Build data models using star schema
- Analyze data using SQL & Python
- Translate data into business decisions and insights
- Data Analysis: SQL, Excel (Advanced, Power Query), Google Sheets
- Visualization: Tableau, Power BI
- Programming: Python
- Core Skills: Data Cleaning, Data Visualization, KPI Reporting, Business Analysis, Problem Solving
I built an end-to-end data quality and validation solution for property tax and assessment datasets. Using Power Query, Excel, and interactive dashboards, the solution automates the detection of data inconsistencies, enhances governance, and supports evidence-based decision-making.
- Designed an automated ETL and reporting framework validating 500+ records, reducing manual data processing by 80%.
- Built interactive dashboards providing executive visibility into KPIs and data quality metrics.
- Implemented statistical outlier detection and comprehensive validation checks to ensure reliable analytics.
🔗 https://github.com/Richie-Rokka/Property-Tax-Data-Quality-Dashboard-
I developed an automated data analytics solution using Excel to streamline reporting, improve data accuracy, and deliver actionable business insights. By using Power Query, structured data modeling, and interactive dashboards, the solution transforms raw operational data into a scalable reporting system that supports decision-making across sales and inventory functions.
- Developed scalable data pipelines integrating sales and inventory datasets, enabling self-service analytics for stakeholders.
- Delivered executive dashboards tracking revenue, profit, and operational performance.
- Reduced reporting time by 80%+ by automating data workflows and eliminating repetitive manual tasks
🔗 https://github.com/Richie-Rokka/Automated-Inventory-and-Sales-Reporting-Dashboard
Analyzed inventory data to identify stockout risks, overstock conditions, and lost sales opportunities using Tableau.
- Built KPIs: Stockout Rate, Overstock Rate, Estimated Lost Sales
- Identified inefficiencies in inventory allocation and warehouse distribution
- Provided recommendations for demand-driven inventory planning
🔗 https://github.com/Richie-Rokka/Inventory-Risk-Demand-Optimization
Conducted a full case study analyzing rider behavior to support marketing strategy decisions.
- Cleaned and analyzed large datasets using SQL and Excel
- Identified behavioral differences between casual riders and members
- Delivered insights to support customer conversion strategy
🔗 https://github.com/Richie-Rokka/Data-Analytics-Capstone-Project-Cyclistic-Bike-Share
- Building end-to-end data analytics projects
- Strengthening SQL and Python skills
- Preparing for data analyst roles
- 🔗 LinkedIn: https://www.linkedin.com/in/abodunrin-oketade-579aa331
- 💻 GitHub: https://github.com/Richie-Rokka
I am actively seeking opportunities as a Data Analyst, where I can apply data-driven insights to solve business problems and support decision-making.
⭐ Thank you for visiting my profile!