Skip to content
View Ayoleyi-dev's full-sized avatar

Block or report Ayoleyi-dev

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Content in all repositories owned by your account will be closed.
Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
Ayoleyi-dev/README.md

Hi, I'm Ayoleyi 👋

Data Analyst | Business Intelligence | Reporting Automation
Biochemistry undergraduate at the University of Lagos · Lagos, Nigeria

I build reporting systems, data pipelines and automations that make messy information easier to trust and use. My work spans operational reporting, SQL analytics, Power BI, Python and Google Sheets automation. I'm also interested in applying these skills to healthcare, product analytics and computational biology.

Portfolio · LinkedIn · Email me

What I work on

  • Business intelligence: SQL data models, KPI definitions, Power BI reports and clear findings for decision-makers.
  • Data quality: Cleaning, reconciliation, validation rules and repeatable checks before numbers reach a dashboard.
  • Reporting automation: Excel, Google Sheets, Google Apps Script and Python workflows that reduce repetitive handling.
  • Applied analytics: Market pricing, operational performance and product/engagement analysis.

Selected projects

Project What I built Tools
Public Health Data Warehouse & Analytics Pipeline A SQL Server reporting model for synthetic healthcare records, with constraints, validation checks, Power BI reporting and CI tests. SQL Server, T-SQL, Power BI
Jumia Smartphone Market Analysis Collected and cleaned marketplace listings, fixed parsing issues and analysed listed prices and seller patterns. The data is listings, not actual sales. Python, Pandas, SQL
Hytale Player & Server Analytics Built a Java telemetry collector, Python/SQLite analytics pipeline and Streamlit dashboard. Simulated player metrics are kept separate from observations on my own local server. Java, Python, SQLite, Streamlit
PII Privacy & Data Quality Pipeline Validated and de-identified synthetic customer records, with privacy-aware issue logs and automated tests. Python, Pytest, GitHub Actions
AI Document Extraction QA Validator Checked structured invoice extraction outputs against JSON Schema, duplicate rules and financial reconciliation logic. Python, JSON Schema
Excel Chocolate Sales Analysis Built an interactive Excel reporting workbook with KPI views, data auditing and scenario planning for a historical sales dataset. Excel, formulas, PivotTables

Applied experience

  • DIAMS — Data & Analytics Officer: I maintain operational trackers, validate recurring records, prepare KPI reports and improve reporting workflows with Google Sheets and Apps Script.
  • Silver Lue — Analytics work: I analysed audience and content-performance data and translated patterns into practical reporting and recommendations.
  • Son of I Am — Client market research: I structured artwork-pricing comparisons and source tracking in an Excel workbook to support commercial discussions.

I describe the scope of my project data plainly: synthetic demonstrations are labelled as such, and I don't present example results as measured client outcomes.

Tools I use

Analysis and BI: SQL / T-SQL, SQL Server, Excel, Power BI, Power Query, DAX, Python, Pandas
Automation and engineering: Google Sheets, Google Apps Script, SQLite, data modelling, ETL, Git, GitHub Actions, Pytest
Visualisation and apps: Power BI, Streamlit, Plotly, Matplotlib

Computational biology and scientific work

I'm studying Biochemistry at the University of Lagos and developing a parallel interest in bioinformatics and computational drug discovery. My homology-modelling and molecular-docking project documents an exploratory in-silico workflow; its predictions are not experimental evidence of drug efficacy.

Connect

I'm interested in junior Data Analyst, BI, reporting and analytics automation opportunities, including work where healthcare or scientific domain knowledge is useful.

Pinned Loading

  1. Excel-Chocolate-Sales-Analysis Excel-Chocolate-Sales-Analysis Public

    An analysis of chocolate sales data using Excel Pivot Tables and Dashboards.

  2. Public-Health-Data-Warehouse-Analytics-Pipeline Public-Health-Data-Warehouse-Analytics-Pipeline Public

    End-to-end healthcare data warehouse project using SQL ETL pipeline, dimensional modeling, and Power BI dashboards built on a synthetic hospital dataset.

    HTML

  3. AI-Document-Extraction-QA-Validator AI-Document-Extraction-QA-Validator Public

    Python pipeline for validating document annotation/extraction accuracy using automated QA checks against ground truth labels to catch extraction errors before downstream use.

    Python

  4. Hytale-Data-Analysis-Project Hytale-Data-Analysis-Project Public

    Hytale player & server analytics — synthetic modelling, real local telemetry, Python/SQL, Java, and Streamlit.

    Python

  5. Jumia-Phone-Market-Webscraping-EDA Jumia-Phone-Market-Webscraping-EDA Public

    Python web scraper for Jumia product listings which collects pricing and category data with BeautifulSoup/pandas for e-commerce market analysis.

    Jupyter Notebook

  6. PII-Data-Privacy-QA-Pipeline PII-Data-Privacy-QA-Pipeline Public

    Python