OLUWAKOYA OLUWAFEMI

Data Analyst | Business Intelligence Developer

LinkedIn | GitHub

About

Highly analytical and results-driven professional with a strong foundation in data analysis, business intelligence, and operations management. Adept at leveraging Python, SQL, Excel, and Power BI to transform complex data into actionable insights, optimize processes, and drive strategic decision-making. Seeking to apply robust analytical skills and a proven track record of improving data accuracy and reporting efficiency to a challenging Data Analyst or Business Intelligence Developer role.

Work Experience

Operations Manager

SILKTAG

May 2023 - Apr 2025

Lagos, Lagos State, NG

Managed operational workflows and business performance reporting, leveraging data analytics to optimize inventory and support strategic decision-making.

  • Developed and implemented monthly Excel-based reporting systems, utilizing pivot tables and advanced formulas to accurately track and visualize key business performance metrics.
  • Conducted in-depth research on inventory and supply chain trends, enhancing stock assessment accuracy by 15% through data-driven analysis and forecasting.
  • Collaborated with senior management to identify and design critical process improvements, presenting actionable data insights through comprehensive reports and dashboards to inform strategic decisions.

Education

Data Analysis

AltSchool Africa

Oct 2024 - May 2025

Lagos, Lagos State, NG

Courses

  • Smart Waste Management System (Urban Green)

Chemistry

University of Lagos, Nigeria

Sep 2019 - Oct 2023

Lagos, Lagos State, NG

Courses

  • Portable Water Quality Assessment in Female and Postgraduate Hostels

Projects

Smart Waste Management System (AltSchool Project)

Oct 2024 - May 2025

A collaborative project focused on developing an innovative smart waste management solution through comprehensive research and data analysis.

Adidas Sales Dashboard (Deep Dive Project)

Apr 2025 - Apr 2025

Developed an interactive Power BI dashboard to analyze Adidas US sales data and provide actionable business insights.

Nigerian Exchange Rate Analysis (Deep Dive Project)

Mar 2025 - Mar 2025

A data analytics project focused on fetching, processing, and visualizing live exchange rate data from the Central Bank of Nigeria.

Bike Sales Report (Personal Project)

Nov 2023 - Mar 2024

A personal project focused on analyzing bike sales data through an interactive Excel dashboard to derive customer demographic insights.

Skills

Programming Languages

  • Python
  • SQL
  • VBA

Python Libraries

  • pandas
  • matplotlib
  • Beautiful Soup
  • re
  • os
  • requests

SQL Software

  • SQLite
  • MySQL
  • PostgreSQL

Excel Tools

  • Pivot Table
  • Pivot Chart
  • VLOOKUP
  • HLOOKUP
  • XLOOKUP
  • Formulas

Business Intelligence Tools

  • Power BI
  • DAX
  • Power Query
  • API Integration

Data Analysis & Visualization

  • Data Cleaning
  • Data Extraction
  • Report Generation
  • Interactive Dashboards
  • Time-based Analysis
  • Comparative Analysis
  • Trend Analysis

Project Management

  • Cross-functional Collaboration
  • Research
  • Process Improvement
  • Documentation