Olamilekan Razak Elegbede | Data Analyst

Olamilekan Razak Elegbede

Data Analyst

Based in Ottawa, Canada

About

Communications engineering graduate with a passion for working with numbers, problem-solving, data analysis and finding insights into data!

Skills

Projects

Database Design Project

The Players Database Design project is a database design and manipulation project focusing on the collection and storage of players' statistical data. Data extraction is carried out by running simple-to-advanced queries to compare data and visualize them.

Analysis of Canadian Gas Prices

A research analysis of gas prices in Canada over the past 10 years was conducted using data collected by the Government of Canada and provided by Statistics Canada. The analysis focused on key metrics to provide insights into regional Price Variations, Average Cost, and year-over-year Change.

Canadian Premier League: 2023 Season Review

This project uses data provided by FBref to visualize how the Canadian Premier League shaped out during the 2023 regular season. It shows the league table, comparing it to the 2022 season; golden boot winners; assist leaders; and the average attendance for each club.

Data-Driven Bike-Sharing Customer Conversion Project

Provided data-driven business insights and recommendations to stakeholders for a bike-sharing company by developing dashboards highlighting key performance indicators (KPIs) in Tableau such as user concentration and weekly usage trends.

End-To-End ETL Design Pipeline

Created an ETL design project for a sports team, to extract and store historical data from various websites and store it in a database to perform visualizations and analysis. This involved data collection via Python web scraping, data storage in SQL database and data visualization in Tableau.

Clustering Stations using K-Means Algorithm

Applied K-Means clustering to group 846 distinct bike-sharing stations based on customer usage patterns, identifying four distinct clusters using Python Scikit Learn and visualized results with Folium map.

Analyzing a Soccer Team's Season - 2023/24 Bayer Leverkusen

An analysis of over 130,000 event data on Bayer Leverkusen's invincible season using Statsbomb API in Python and Tableau.

HR Year-Year Product Sales Performance

An interactive sales dashboard in Tableau for a bike company to evaluate sales performance on monthly sales across different product categories, highlighting key sales performance metrics including the number of orders, profit generated, month-month % difference in revenue, and product return rates,

Experience

2022-2023

Customer Service Representative at Best Buy

Handled and led the operational team of 5-10 members, assigning individual responsibilities accordingly, to achieve daily sales budget. Provided effective solutions to over 80 customers daily in a fast-paced environment by effectively listening and understanding customers' needs, analyzing the problem, and using the standard order of operations to offer a clear solution.

2021-2023

League Organizer at Carleton University

Coordinated staff training, and scheduling and improved customer satisfaction by conducting weekly surveys to gather valuable feedback on customer issues and complaints.

2021

Data Analyst Intern at Synapse Technologies

Worked closely with senior engineers and analysts on the Package Beverage Analyzer team to run multiple tests on carbonation levels, identifying and reporting abnormalities to improve the efficiency of the product. Performed daily data gathering, cleaning, and validating of data in Microsoft Excel from laboratory paper documents and electronic records, while ensuring data accuracy and reliability for analysis. Communicated product insights, highlighting improvements, and provided recommendations to senior data analysts in weekly team meetings, using interactive dashboards and visualization tools in Tableau and Microsoft Excel

Education

2017-2022

Communication Engineering at Carleton University

Related Courses - Data Management, Data Processing, Web Development, Statistics and Random Process, Probability

2021

Google Data Analytics Certificate at Coursera

An extensive six-month job-ready Google-certified training involving data cleaning, data visualization and communicating data analytics findings which involves the use of SQL, Microsoft Excel, Tableau and R.