OLAJUMOKE IBIWUMI AJANI

Data Analyst | Business Intelligence Specialist

Oyo State, NG.

About

Detail-oriented Data Analyst and Economics graduate with hands-on experience in data entry, data cleaning, visualization, and business intelligence. Skilled in Excel, Power BI, and DAX, with a strong ability to analyze datasets and generate actionable insights. Experienced in building dashboards, performing financial analysis, and supporting data-driven decision-making.

Work

Havilah Grace Foundation

|

Data Analysis Facilitator (Volunteer)

→

Summary

Facilitated foundational data analysis training, guiding students through practical sessions on data cleaning, visualization, and dashboard creation to enhance their analytical skills.

Highlights

Trained students in foundational data analysis, equipping them with essential skills in Excel and Power BI for data manipulation and visualization.

Delivered hands-on sessions focused on practical data cleaning, visualization, and dashboard creation techniques, fostering immediate application of learned concepts.

SDG CDS Group (NYSC)

|

Financial Secretary

Ogun State, Ogun, Nigeria

→

Summary

Managed financial records and bookkeeping practices, ensuring transparency and supporting community programs impacting over 100 residents.

Highlights

Managed all financial records and ensured transparent bookkeeping practices, upholding fiscal integrity for the group.

Supported community programs that positively impacted over 100 residents, contributing to the organization's social mission.

Initiative for Digital Transformation (I4DT)

|

Data Analysis Facilitator

→

Summary

Led Excel and data analytics training for over 50 learners, designing practical projects and providing support to improve engagement and completion rates.

Highlights

Delivered comprehensive Excel and data analytics training to over 50 learners, significantly enhancing their data proficiency.

Designed practical, real-world data analysis projects, enabling learners to apply theoretical concepts to solve practical business challenges.

Provided consistent learner support, resulting in improved engagement and higher completion rates across all training modules.

Balogun Consulting Firm

|

Accounting Assistant (Remote)

Texas, Texas, US

→

Summary

Reconciled financial transactions with 100% accuracy, resolved discrepancies, and organized records to enhance reporting efficiency for a consulting firm.

Highlights

Reconciled over 50 financial transactions using QuickBooks with 100% accuracy, ensuring precise financial reporting.

Identified and resolved all discrepancies during monthly account reviews, maintaining data integrity and compliance.

Organized financial records to significantly improve reporting efficiency, streamlining month-end closing processes.

Education

Kwara State University, Malete

Malete, Kwara State, Nigeria
→
B.Sc. Economics Grade: Second Class Upper Division

Languages

English

Certificates

Business Data Analytics

Simplilearn

Data Analytics Job Simulation

Deloitte (Forage)

Accounting & Bookkeeping

DBN

Data Analysis & Visualization

3MTT/Darey.io

Data Analytics Essentials

Cisco

Microsoft Excel (Beginner to Advanced)

Udemy

Skills

Technical Tools

Microsoft Excel (Advanced), Power BI (DAX and Data Modeling), QuickBooks, SQL, Python (Beginner).

Core Competencies

Data Cleaning and Transformation, Data Analysis and Interpretation, Data Visualization and Dashboard Creation, KPI Tracking and Reporting, Financial Analysis, Financial Reconciliation, Reporting Documentation.

Professional Skills

Communication, Problem-solving, Attention to Detail, Teamwork, Adaptability.

Projects

Student Mental Health using SQL

→

Summary

Analyzed international student data using SQL techniques to evaluate the impact of length of stay on mental health outcomes, identifying patterns in acculturative stress.

Sales Performance Dashboard (Power BI)

→

Summary

Developed an interactive Sales Performance Dashboard using Power BI, DAX, and Power Query to analyze sales data, evaluate revenue, and support strategic decision-making.

Video Game Sales & Ratings Analysis using SQL

→

Summary

Conducted a comprehensive analysis of video game sales and review datasets using MySQL and SQL to identify top-selling games and highly rated release years.

Customer Churn Analysis Dashboard (Excel)

→

Summary

Developed an interactive Excel dashboard to analyze customer churn data, identifying key drivers of attrition and providing actionable retention strategies.

Logistics Optimization Using Excel Solver (Transportation Model)

→

Summary

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