OLAJUMOKE IBIWUMI AJANI

Data Analyst | Economics Graduate
Oyo State, NG.

About

Highly analytical Data Analyst and Economics graduate with a proven track record in transforming raw data into actionable business intelligence. Expertly leverages Excel, Power BI, and DAX to perform comprehensive data cleaning, visualization, and financial analysis, driving data-driven decision-making. Adept at designing interactive dashboards and extracting key insights that enhance operational efficiency and strategic planning.

Work

Balogun Consulting Firm
|

Accounting Assistant (Remote)

Texas, Texas, US

Summary

Supported financial operations by accurately reconciling transactions and resolving discrepancies to improve reporting efficiency for a remote consulting firm.

Highlights

Reconciled over 50 financial transactions using QuickBooks with 100% accuracy, ensuring precise financial record-keeping and compliance.

Identified and resolved discrepancies during monthly account reviews, maintaining data integrity and supporting accurate financial statements.

Organized financial records to significantly improve reporting efficiency, facilitating timely and informed decision-making.

Volunteer

Havilah Grace Foundation
|

Data Analysis Facilitator (Volunteer)

Summary

Empowered students with foundational data analysis skills through hands-on training in Excel and Power BI for effective data utilization.

Highlights

Trained students in foundational data analysis using Excel and Power BI, enhancing their analytical capabilities for future career paths.

Delivered hands-on sessions on data cleaning, visualization, and dashboard creation, fostering practical skill development and application.

SDG CDS Group (NYSC)
|

Financial Secretary

Ogun State, Ogun State, Nigeria

Summary

Managed financial records and ensured transparent bookkeeping practices, supporting community programs for over 100 residents.

Highlights

Managed financial records and ensured transparent bookkeeping practices, upholding fiscal integrity and accountability.

Supported community programs, positively impacting over 100 residents through efficient financial administration and resource allocation.

Initiative for Digital Transformation (I4DT)
|

Data Analysis Facilitator

Summary

Provided comprehensive data analytics training and project support to over 50 learners, significantly boosting engagement and completion rates.

Highlights

Delivered Excel and data analytics training to over 50+ learners, equipping them with essential analytical tools and techniques.

Designed practical projects to teach real-world data analysis concepts, improving skill application and retention among participants.

Provided dedicated learner support, which significantly improved engagement and project completion rates within the program.

Education

Kwara State University, Malete
Malete, Kwara State, Nigeria

B.Sc.

Economics

Grade: Second Class Upper Division

Certificates

Business Data Analytics

Issued By

Simplilearn

Data Analytics Job Simulation

Issued By

Deloitte (Forage)

Accounting & Bookkeeping

Issued By

DBN

Data Analysis & Visualization

Issued By

3MTT/Darey.io

Data Analytics Essentials

Issued By

Cisco

Microsoft Excel (Beginner to Advanced)

Issued By

Udemy

Skills

Excel

Advanced, Data Entry, Data Cleaning, Data Visualization, Financial Analysis, Solver, Pivot Tables, Charts, Conditional Formatting.

Power BI

DAX, Data Modeling, Data Visualization, Business Intelligence, Dashboard Creation, Power Query.

SQL

Data Analysis, Data Aggregation, Data Filtering, Data Preparation.

Python

Beginner.

QuickBooks

Financial Transactions, Bookkeeping.

Data Cleaning

Data Preparation, Data Quality.

Data Visualization

Dashboard Design, Reporting.

Data Analysis & Interpretation

Actionable Insights, Dataset Analysis, Statistical Analysis.

KPI Tracking

Performance Monitoring, Metrics.

Financial Analysis

Reporting, Decision Making.

Reporting & Documentation

Report Generation, Documentation.

Communication

Presentation, Stakeholder Engagement.

Problem-Solving

Critical Thinking, Issue Resolution.

Attention to Detail

Accuracy, Precision.

Teamwork

Collaboration, Cross-functional Teams.

Adaptability

Flexibility, Learning Agility.

Projects

Customer Churn Analysis Dashboard (Excel)

Summary

Analyzed customer churn data for 6,687 customers using Excel, identifying a 26.9% churn rate and key drivers of customer attrition.

Student Mental Health using SQL (DataCamp DataLab)

Summary

Analyzed international student data using SQL to evaluate the impact of length of stay on mental health outcomes and identified acculturative stress patterns.

Logistics Optimization Using Excel Solver (Transportation Model)

Summary

Developed a transportation optimization model using Excel Solver to minimize total shipping distance from multiple warehouses to retail stores.

Sales Performance Dashboard (Power BI)

Summary

Developed an interactive Power BI dashboard to analyze over $2.3M in sales data, evaluating revenue, profit, and regional performance.