Adejoro Raymond Olaotan

Hi, I am Adejoro Raymond Olaotan

I am a detail oriented Business Data Analyst with over 6 years of experience in data analysis, product analysis and process improvement within the utility sector. Proven ability to analyze technical and commercial operations, ensuring accurate data tracking, and facilitating cross-functional collaboration to enhance operational efficiency and product readiness.
I specialize in leveraging analytics, automation, and process optimization with engineering mindset to transform complex data into actionable insights that drive innovation and operational excellence.

About

Business Data Analyst

Phone: +(234) 803 325 2725
City: Lagos State, Nigeria

Email: raydey04@gmail.com
Role: Business Data Analyst | Ikeja Electric

Skills

Programming Language: Python (Pandas, NumPy, SciPy, Matplotlib) 100%

Databases ( SQL Server, MySQL) 100%

Data Analysis & Visualization: Tableau, Power BI, Excel (VLOOKUP, Pivot Tables), Data Cleansing & Preprocessing 100%

Statistical Methods: Time Series Analysis, Regression, Clustering, Predictive Modeling 100%

Data Modeling & Reporting: Power BI, Tableau, DAX 100%

Problem-Solving: Critical thinking, Analytical reasoning, Creative data solutions 100%

Resume

Summary

Adejoro Raymond Olaotan

I am a detail oriented Business Data Analyst with over 5 years of experience in data analysis and process improvement within the utility sector. Proven ability to analyze technical and commercial operations, ensuring accurate data tracking, and facilitating cross-functional collaboration to enhance operational efficiency and product readiness.

Education

Bachelor of Engineering in Electrical & Electronic Engineering

2016

Federal University of Agriculture, Abeokuta, Ogun State, Nigeria

Certification

Microsoft Certified: Power BI Data Analyst Associate

Microsoft

2023

Professional Experience

Business Data Analyst

Ikeja Electric Plc – Ikeja, Lagos, Nigeria.

January 2022 – Present

Measure and analyze technical and commercial performance data to support management decision-making.
Drive non-operations performance by tracking strategic technical metrics weekly, monthly, quarterly and annually while I also prepare and coordinate daily and monthly performance review sessions for the technical group.
Generate periodic reports and departmental performance statistics across all touchpoints to inform management decisions and I also partner with cross-functional teams to deliver stable and reliable reporting platforms, ensuring data and statistical models are readily available on request.
Develop broader monthly and quaterly performance reviews for the technical department and assist in creating and analyzing performance models for various technical units.

Data Analyst

Ikeja Electric Plc – Ikeja, Lagos State, Nigeria

November 2019 – December 2022

Analyzed customer data trends to forecast operational gaps, reducing revenue leakages through improved compliance checks and reporting.
Provide insight for team operations through statistical analysis of customer data to drive field activities at identifying revenue and energy leakages. Periodic Energy and Commercial loss Audit.
Enforce action on consumer resorting to theft or illegal use of electricity. Weekly performance reporting.

Data Analyst Intern

Quantum Analytics NG – Lagos, Nigeria

January 2022 – June 2022

Developed and deployed over 30 interactive dashboards using Tableau, Power BI, and Excel, significantly improving stakeholder data access and understanding.
Implemented advanced data analysis methodologies that increased report accuracy by 25%, leading to more reliable insights and informed strategic decisions.
Executed end-to-end data extraction, cleaning and analysis on large datasets using SQL and Python, reducing processing time by 40% and streamlining reporting workflows.
Constructed predictive models to forecast sales and revenue, achieving an 85% accuracy to support future business planning and resource allocation.

Robotics Instructor

Baun Robotics Educational Solution – Prince and Pricess Estate, Abuja, Nigeria

January 2018 – August 2019

Taught students the fundamentals of robotics development and hardware programming using Arduino.
Guided hands-on projects involving sensor integration, actuator control, and embedded coding.
Simplified complex robotics concepts to foster practical problem-solving and technical confidence.
Project development, Business proposal and Development of Robotic Design with code.

Download Resume

Portfolio

Welcome to My Portfolio! Hello and thank you for visiting my portfolio website. Here, you’ll find a showcase of my work, skills, and passions. Whether you’re here to explore my latest projects, learn more about my professional journey, or simply get inspired, I hope you enjoy your visit. Feel free to navigate through the different sections to see examples of my work, read about my experiences, and discover what drives me. If you have any questions or would like to collaborate, don’t hesitate to reach out through the contact page. Happy browsing!

All
Power BI
Tableau
Python
SQL
Excel

Real Estate Property Management Dashboard - Overview

An interactive Power BI dashboard providing a high-level overview of property conditions, renovation status, and key portfolio metrics.

Nysc Taxi Trips

explore the patterns and trends in taxi usage among New Yorkers.

Student Mental Health

This project investigates the impact of student mental health on CGPA using data from a Google Forms survey. It aims to uncover insights into how well-being influences academic performance.

Supermarket Stores Analysis

A project on a supermarket chain sales data aimed to improve performance by examining store area and customer count.

SQL Project: AdventureWorks Business Analysis

In this project, I explore the Adventure Works database, by leveraging SQL, I demonstrate my skills in database design, complex querying, and data manipulation, providing insights into sales trends, customer behavior, and inventory management to support informed decision-making.

United States Census Data

In this project I analyzed U.S. population data from 2010 to 2015 using Python to gain insights into the country's demographic dynamics.

Maternal Health Risk

A look into the health conditions that most strongly indicate health risks during pregnancy.

Airline FLight Delay and Cancellations

This project analyzes over 5 million airline flight records from 2015, sourced from the U.S. DOT. The goal is to uncover insights on delays, cancellations, and airline reliability to enhance air travel experiences.

NCDC covid-19 Dashboard

This project utilizes the NCDC COVID-19 dataset to analyze the pandemic's impact on public health in Nigeria. By examining case trends and response measures, we aim to provide actionable insights for future health initiatives.

Customer Shopping Mall Analysis

I analyzed 10 Istanbul shopping malls from 2021 to 2023, revealing insights into consumer behaviors and trends across different age groups and genders.

Supply Chain Optimization for an FMCG Company

This project focuses on optimizing the supply chain for an FMCG company's instant noodles business by analyzing demand and supply dynamics across warehouses. The goal is to provide insights that improve inventory strategies and reduce costs.

Microsoft Stock Market Analysis

This project examines Microsoft Corporation's (MSFT) stock performance from 1986 to 2022, focusing on daily price movements and trading volume. The dataset highlights key market trends in Microsoft's growth as a technology leader.

Shark Attacks Analysis

This project examines shark attack data from the past 100 years, focusing on location, victim details, and shark species. The analysis aims to uncover trends in annual attacks, geographic hotspots, and injury patterns.

Food App Business

This project focuses on enhancing customer engagement in the online food business through data analysis. By performing exploratory analysis, I provide actionable insights and data-driven proposals to drive growth and improve customer experiences.

Health Insurance Coverage

This project examines health insurance coverage rates before and after the Affordable Care Act (ACA), focusing on uninsured rates and Medicaid enrollment. It evaluates the ACA's impact on healthcare access across states and nationally.

World Trade & finance Finance

This project analyzes trade and finance data for over 190 countries from the UN Development Program. It highlights key 2019 indicators such as exports, foreign direct investment, and remittances to reveal global economic trends.

United States Birth Analysis

This project analyzes US birth rates from 2016 to 2021, focusing on data categorized by state and maternal education level from the CDC. It explores trends in birth rates, including gender, average maternal age, and birth weight across various educational groups and locations.

Analysis of Unicorn Companies

This project explores the rise of unicorn companies—startups valued at over $1 billion—focusing on their growth trajectories, funding rounds, and market impact. By analyzing key data, we uncover trends and insights that highlight what drives success in today’s competitive landscape.

Internet Movie Database Analysis

This project analyzes IMDb data from 2006 to 2016, highlighting trends in movie ratings, genres, and box office performance. It provides insights into the changing landscape of film and audience preferences during that period.

Pizza Business Analysis

This project analyzes pizza sales data to identify trends in customer preferences and sales performance, offering insights to boost sales and enhance engagement.

2012 Mexico restaurant Analysis

This project analyzes restaurant ratings in Mexico from 2012, using consumer feedback to explore restaurant characteristics and preferences. The goal is to uncover insights on top-rated establishments, assess consumer demographics, and identify market opportunities for investment.

Bitcoin Historical Data

This project analysis historical Bitcoin market data at 1-minute intervals from select exchanges, covering January 2012 to March 2021. It offers insights into trading patterns, including open, high, low, and close prices, along with volume data, facilitating deeper analysis of market trends.

Shipping Ports Around The world

This project examines a dataset of over 450 global ports, showcasing their vital roles in modern supply chains. Seaports are evaluated on factors like automation and market access, underscoring their importance in the global economy.

Kolera-Katrina,1983

This is part of research work on the history of Stockholm in the 19th century Since Sweden has well-preserved church archives this permits getting detailed information about pandemic events.

Historical Stock Price of 10 popular Companies

This project analyzes daily stock prices of ten major companies, including Apple and Tesla, from 2015 to 2021. The dataset includes essential metrics such as opening, high, low, and closing prices for insightful comparisons of stock growth.

World Energy Consumption

This project analyzes global energy consumption data from Our World in Data, focusing on primary energy use, energy mix, and electricity consumption. It provides insights into consumption patterns and growth rates across various countries.

WHO Covid-19 Dashboard

This project leverages the WHO COVID-19 dataset to explore global trends and patterns in the pandemic's progression. By analyzing case numbers, vaccination rates, and response strategies, we aim to generate insights that inform public health decisions.

COVID-19's Impact on Airport Traffic

This project analyzes airport traffic as a percentage of pre-pandemic levels, using February to March 2020 as a baseline. The monthly updated dataset offers insights into COVID-19's ongoing effects on air travel.

Brazillian e-Commeerce

This project examines the Olist dataset of 100,000 orders from 2016 to 2018, offering insights into order status, pricing, and customer reviews. The analysis aims to reveal key trends and consumer behavior in Brazilian eCommerce.

E-Commerce Sales Dashboard

This dataset examines e-commerce sales profitability across channels like Shiprocket and INCREFF. It includes key financial metrics and SKU data, enabling retailers to analyze trends and optimize inventory for improved profitability.

Revenue Analysis Dashboard

This is comprehensive Excel dashboard for revenue analysis dashboard, offering insights into sales performance, product categories, and regional trends.

Contact

Location

Lagos, Nigeria

Call Me

+(234) 803 325 2725

Email Me

raydey04@gmail.com