Ayodeji Oso
Lagos, Nigeria www.linkedin.com/in/ayodeji-oso-
www.dejisportfolio.wordpress.com
DATA ANALYST
Power BI Development | SQL | Data Modelling
Data analyst with 1+ years of experience designing and developing interactive dashboards and
reports in Power BI and SQL. Holds a bachelor’s degree in computer science and PwC Power BI job
simulation training. Excels at translating business requirements into end-to-end ETL solutions,
ensuring data quality and delivering actionable insights that inform strategic decision-making.
Skilled in writing and optimizing SQL queries and DAX measures. Partners seamlessly with crossfunctional stakeholders, technical and non-technical, to identify process-improvement
opportunities and drive measurable impact.
PROJECTS
Grocery Store Sales Performance Dashboard (view dashboard)
02/2025
Extracted, cleaned and removed duplicates sales transactions with SQL to establish a highintegrity data source.
Designed a star-schema model in Power BI, optimizing relationships for accurate analysis.
Developed DAX measures (e.g. Total Sales, MoM Growth, Month-To-Date, Previous MonthTo-Date) and calculated columns for category-level KPIs.
Built an interactive dashboard showing daily sales trends, top-selling products and regional
performance helping the business identify its top performers.
Brazilian E-Commerce Customer & Sales Analysis (view dashboard)
Joined eight normalized tables using SQL to create a unified dataset.
09/2024
Implemented DAX calculations to derive key insights into revenue and payment and
average delivery day trends.
Developed advanced visuals (slicers, drill-down line charts, gauge chart) to explore
customer segments and sales seasonality.
Titanic Passenger Survival Analysis Dashboard (view dashboard)
Transformed and cleansed passenger records in SQL (removed duplicates).
03/2024
Created DAX formulas to calculate survival rates by gender, age bracket and passenger
class.
Designed an interactive dashboard with drill-down filters for subgroup analysis.
Ensured model and data accuracy through cross-validation of DAX outputs against SQL
aggregates.
Ayodeji Oso
Discovered that women and children had higher survival rates which is in line with
prioritization of women and children during emergencies.
WORK EXPERIENCE
FMDQ Group Plc - Lagos, Nigeria
10/23 - Present
Frontend Developer/Reporting Analyst
Translated Figma designs into responsive web interfaces using HTML, CSS and JavaScript,
ensuring pixel-perfect implementation and accessibility standards
Partnered with UI/UX designers to build a reusable React component library, reducing
development time and enforcing design consistency
Wrote SQL queries to extract, aggregate and transform data for ad-hoc reports, empowering
stakeholders with timely insights
Page Financials – Lagos, Nigeria
06/21 – 06/22
IT Support Intern
Installed and configured desktops for 50+ new employees, reducing onboarding time by
30%
Provided technical support for hardware, software, and network issues, achieving an 80%
first-contact resolution rate
Maintained IT asset inventory and access-control logs, ensuring data integrity and
compliance with security policies
PROFESSIONAL SKILLS
Data Analysis & Visualization: Power BI (including DAX, calculated columns, KPIs, custom
visuals), interactive dashboard development, storytelling with data
SQL & Relational Databases: Writing and optimizing complex SQL queries, data extraction,
transformation, and aggregation using SQL.
Data Modeling: Designing star/snowflake schema models in Power BI, managing
relationships between tables, and optimizing for performance
ETL & Data Preparation: Data cleaning, transformation, and integration from multiple
sources for accurate reporting and analysis
Reporting & Insights: Translating business requirements into actionable reports, ensuring
data quality and relevance for decision-making
Stakeholder Communication: Presenting insights to technical and non-technical
audiences; cross-functional collaboration for report refinement
CERTIFICATION AND TRAINING
PwC Switzerland Power BI Job Simulation — Forage
03/25
Completed a job simulation where I strengthened my Power BI skills to better understand
clients and their data visualization needs.
Ayodeji Oso
Demonstrated expertise in data visualization through the creation of Power BI dashboards
that effectively conveyed KPIs, showcasing the ability to respond to client requests with
well-designed solutions.
Strong communication skills reflected in the concise and informative email communication
with engagement stakeholders, delivering valuable insights and actionable suggestions
based on data analysis.
Leveraged analytical problem-solving skills to examine HR data, particularly focusing on
gender-related KPIs, and identified root causes for gender balance issues at the executive
management level, highlighting a commitment to data-driven decision-making.
Applied DAX to create calculated measures and optimize data models, enhancing insight
accuracy and report clarity.
Demonstrated end-to-end analytics workflow: data extraction, cleaning, visualization, and
business-oriented storytelling.
EDUCATION
Babcock University - Ogun, Nigeria
Bachelor of Science – Computer Science, June 2023
Relevant Coursework: Database systems and management, Statistics, Data Structure and
Algorithms
LANGUAGE COMPETENCIES
English: Native Language
