DANIEL OLUWASEGUN OGUNFADEWO

Strategic and Results-Driven Business Development Analyst
Lagos, NG.

About

Strategic and results-driven Business Development Analyst with proven expertise in leveraging data-driven insights to identify market opportunities and optimize revenue streams. Proficient in financial modeling, demand forecasting, and competitive analysis using Excel, SQL, Python, and Power BI. Successfully contributed to a 45% improvement in cargo tonnage across monitored airline routes by supporting cargo operations analysis and identifying growth opportunities.

Work

Skyway Aviation Handling Company PLC.
|

Cargo Data Analyst Internship

Lagos, Lagos, Nigeria

Summary

Led data analysis and visualization initiatives for cargo operations, identifying high-performing routes and optimizing cargo planning.

Highlights

Analyzed airline cargo handling data with precision to identify high-performing routes, airlines, and peak operational days, optimizing cargo planning strategies.

Developed interactive performance dashboards using Microsoft Power BI, tracking key cargo metrics such as total tonnage, airline share, and flight frequency.

Conducted comprehensive Year-on-Year (YoY) and month-to-month cargo performance analysis, highlighting operational changes that contributed to an estimated 40-45% increase in handled cargo tonnage across key routes.

Implemented trend analysis and KPI monitoring systems, enabling management to quickly identify growth opportunities and performance gaps.

Created clear visual reports and storytelling dashboards, supporting data-driven decision-making within complex cargo operations.

Volunteer

Independent
|

Excel Analyst Tutor

Lagos, Lagos, Nigeria

Summary

Provided comprehensive data analysis training and mentorship to students, enhancing their understanding and application of analytical tools.

Highlights

Taught students how to effectively utilize various data analysis tools including Excel, Power BI, and SQL, enhancing their practical application skills.

Delivered engaging online lectures and practical demonstrations, effectively conveying complex data concepts to improve student comprehension and application.

Designed and implemented core data engineering ETL (Extraction, Transformation, and Loading) techniques using PostgreSQL, MySQL, and Python, ensuring efficient data processing and integration.

Provided advanced data analysis training covering data cleaning, financial modeling, database design, querying, and data visualization using MS Excel, Python, PostgreSQL, and MySQL.

Maintained clear and concise documentation of training materials and resources, facilitating easy access and understanding for students and fellow tutors.

Education

Olabisi Onabanjo University
Ogun State, Ogun State, Nigeria

BSc.

Economics

Ijebu Ode Grammar School
Ogun State, Ogun State, Nigeria

High School Diploma

Senior Secondary Certificate Examination

First School Leaving Certificate
Ogun State, Ogun State, Nigeria

Certificate

Primary Education

Skills

Data Analysis & Visualization

MS Excel, Power BI, SQL, Python, Visual Studio Code, ETL Process, Data Storytelling, Data Cleaning, Interactive Dashboards, Market Research, Competitive Benchmarking, Route Performance Analysis, Pandas, Numpy, Matplotlib.

Financial & Business Intelligence

Financial Modelling, Revenue Forecasting, Demand Forecasting, Pricing, Tariff Modelling, KPI Tracking, Strategic Initiatives, Regulatory Compliance, Capital Expenditures, Business Intelligence.

Programming & Scripting

Core Python, VBA, Visual Basics, Data Structures, OOP, PostgreSQL, MySQL.

Software & Systems

Hardware Installation, Software Installation, Computer Systems Setup, Data Validation, Chart Creation, Pivot Tables.

Projects

Technical Analysis of Stock data using Python

Summary

Advanced Python analysis of time-series stock data to estimate covariance matrix, correlation matrix, Value at Risk, Return on Investment (ROI), Option Pricing and Portfolio variance for major U.S stock portfolios.