Tabuk, Saudi Arabia · open to co-op training and junior analyst roles

Roaa Alghamdi

Data & BI Analyst · Odoo ERP · Decision Support

I study Management Information Systems at the University of Tabuk. I come from the business side, so I start with the decision a manager has to make, then build the data model, KPIs and Power BI dashboard that answer it.

See my projects Open live dashboard ↗ LinkedIn ↗
4.32 / 5GPA, BSc MIS
6applied projects
250survey responses analysed for STC study
221Ksales rows modelled in Power BI
01 / About

Business first, then the data

My degree sits inside the Faculty of Business Administration, so most of my coursework starts with a business problem: a telecom company losing complaint context between departments, a retailer deciding whether AI forecasting is worth the cost, an oil major whose margins shrank in a year.

That is how I like to work. I talk to the people involved, define the KPIs, clean and model the data, and build a dashboard that makes the next decision obvious. I use SWOT, PESTEL, Porter's Five Forces and VRIO when the question is strategic, and Excel Solver or decision trees when it is quantitative.

I also hold a professional diploma in cybersecurity, which taught me to think about who should see which data, and how to design access to it properly.

ANALYSE

Data analysis & BI

Power BI (Power Query, DAX, star-schema modelling), advanced Excel, SQL and Python basics.

OPERATE

ERP & business processes

Odoo ERP, process mapping and requirements gathering: where operational data comes from and how it flows.

DECIDE

Decision support

KPI design, financial ratio analysis, SWOT and strategy frameworks, linear programming and decision analysis.

02 / Work

Selected projects

University and personal projects. Team projects say what my part was.

Power BI sales overview page with KPI cards, monthly trend, region and channel charts
Personal project · Power BI · 2026

Nakheel Market: Retail Sales Dashboard

A three-page Power BI report for a fictional Saudi supermarket chain with 12 branches in 9 cities. I designed the dataset myself so I could practise on realistic, shareable data.

  • Star schema: 221K sales lines, 6 tables, 37 DAX measures (YoY, YTD, target achievement, repeat rate, delivery KPIs)
  • Ramadan lifts average daily sales by about 45%; online orders grew from 18% to 26% in a year
  • Electronics: 17% of sales but a 12% margin and the highest return rate
Power BIDAXPower QueryData modellingKPIs
Interactive version ↗Files on GitHub ↗
STC complaint 360 view prototype built in Power BI
Graduation project · STC case study · 2026–27 · team of 4

Customer Context Continuity in Complaint Handling

Why do STC customers repeat their complaint every time it changes hands? We ran a survey of 250 people and 5 stakeholder interviews, defined 6 continuity KPIs, and built three Power BI dashboards: complaint journey, KPI view and an AI decision-support screen.

73.8% of complainants lost context at least once; the worst point is the hand-off between departments (52.9%). I led the problem definition, research questions and theoretical framework.

Power BISurvey analysisInterviewsKPI designDecision support
−17.6%revenue, 2023 vs 2022
−24.7%net income, 2023 vs 2022
SAR 1.65T2023 revenue
27.5%net margin 2023 (30.1% in 2022)
Financial Management (FIN 1202) · team of 6

Saudi Aramco: Financial Performance & Ratio Analysis

Common-size statements and ratio analysis of Aramco's 2022 and 2023 consolidated results: liquidity, solvency, asset efficiency and profitability, with the figures modelled in Excel and summarised in Power BI.

Profitability fell with oil prices (net margin 30.1% to 27.5%), while liquidity stayed strong and reliance on debt kept falling.

ExcelPower BIFinancial ratiosVariance analysis
12,000AI cases/year to break even
SAR 7,250optimal daily contribution (LP)
SAR 3 / minshadow price of stocking labour
SAR 60Kbest expected value (decision tree)
MIS 1404 · case-based team project

ASTRA Markets: Should We Automate Replenishment?

A case-based study for a grocery chain weighing AI forecasting. I worked through break-even analysis, a linear program for the daily restocking mix, sensitivity analysis, a nonlinear profit model and a decision tree with imperfect information, all in Excel Solver.

Recommendation: buy the SAR 3,000 data study first; roll out AI only if the result is favourable, otherwise pilot at two stores.

Excel SolverLinear programmingSensitivity analysisDecision trees
Defense-in-depth network architecture diagram for the redesigned retailer
Applied Security Project · team of 5

Target 2013 Breach: Analysis and Data-Security Redesign

How one phished HVAC vendor led to 40 million stolen cards. We mapped the kill chain, then redesigned access, data and network controls: RBAC with ABAC conditions, least-privilege SQL roles with row-level security, tokenisation and a segmented cardholder-data zone.

Tested on PostgreSQL 16, with a Python demo of SQL injection and the parameterised-query fix.

SQL / PostgreSQLPythonAccess controlRisk assessment
PESTELexternal factors, 2025
5 Forcesindustry structure
SWOTposition summary
VRIOlasting advantages
Strategic Management · 2024

Ferrari: Strategic Position Analysis

Ferrari sells fewer cars than the market wants on purpose. I analysed how that choice holds up against EU emission rules, electrification and supplier risk, using PESTEL, Porter's Five Forces and VRIO.

Keep production limited, build electric drivetrains in-house, and lock in long-term supplier contracts.

StrategySWOTPESTELVRIO
03 / Skills

Toolkit

Levels are my honest self-assessment.

Data & BI

Microsoft Exceladvanced
Power BI · DAX · Power Queryintermediate
Data modelling (star schema)intermediate
SQLfoundational
Pythonfoundational

Business & ERP

Odoo ERPintermediate
Business process analysisstrong
Requirements gatheringstrong
Workflow mappingstrong
Technical documentationstrong

Decision support

KPI design & dashboardsstrong
SWOT · PESTEL · VRIO · 5 Forcesstrong
Financial ratio & variance analysisstrong
LP, sensitivity & decision treesintermediate
Cybersecurity & riskdiploma

Languages: Arabic (native), English (professional). Also: Word and PowerPoint (advanced).

04 / Certifications

Certifications & training

AI

AI Data Analytics Certification

TVTC & authorised training centre · Sep 2026

IBM

Data Fundamentals

IBM SkillsBuild · Sep 2026

Verify ↗
IBM

Getting Started with Data

IBM SkillsBuild

BI

Data Analysis Using Power BI

Professional development course

XL

Excel Skills & Data Processing

Intishar Al-Ilm Training Institute · TVTC-accredited · 20 hours · 2026

stc

AI & Data Analysis in the Future Labour Market

HRDF (Doroob) & stc · Aug 2026

SEC

Professional Diploma in Cybersecurity

Gulf Colleges · May 2025

VOL

Volunteer: Next-Generation Data Management in Engineering

University of Tabuk · National Volunteering Platform · Nov 2025

05 / Education

Education

Expected 2027

BSc Management Information Systems

University of Tabuk, Faculty of Business Administration · GPA 4.32 / 5.00

2025

Professional Diploma in Cybersecurity

Gulf Colleges

06 / Contact

Let's talk data

I'm looking for co-op training and junior roles in data analysis, BI or ERP. Happy to walk you through any of these projects.

Roaa-Alghamdi1@outlook.com Email linkedin.com/in/roaa-alghamdi-814068328 LinkedIn github.com/roaa-alghamdi GitHub