# bassant ajacad

bassant ajacad is a remote worker on Himalayas, Data Analyst Intern at ICEALEX, based in Egypt.

Source: https://himalayas.app/@bassantajacad

```text
Data auditor and operations coordinator turning validated datasets into Power BI KPIs and reliable reporting.
```

| Detail | Value |
| --- | --- |
| Availability | Open to opportunities |
| Location | Egypt |
| Authorized to work in | Egypt |
| Job categories | Data Auditor, Data Analyst, Data Scientist, Operations Coordinator, Database Analyst, Data Audit Analyst Jobs |
| Skills | Google Sheets, Index Match, COUNTIF, Sumifs, Pivot Tables, Filters, Power BI, Power Pivot, DAX, Data Validation, Data Cleaning, Data Reconciliation, Statistical Analysis, KPI Analysis, Data Visualization, ANOVA, Hypothesis Testing, Machine Learning, Python, SQL, ERD, Database Design, Dashboard Development, Process Optimization, Podio, Temporal, Excel |

## What I'm looking for

```text
I’m looking for a role where I can audit and clean data, build Power BI dashboards and KPIs, and partner with stakeholders to turn trusted data into fast decisions—while continuously improving processes with accuracy and clear reporting.
```

## About

```text
I’m a Data Auditor and Operations Coordinator based in Alexandria, Egypt, and I build dependable reporting by validating data at the source and connecting it into decision-ready datasets.

In my current role (Alexandria University), I collect, validate, and maintain high-quality student data across multiple Google Sheets and systems, ensuring consistency and accuracy. I link and integrate records across sheets to consolidate student details, exam results, subscriptions, and attendance data—then clean, standardize, and reconcile datasets to remove duplicates, missing values, and inconsistencies. I audit Google Forms exam and assessment data, implement validation rules and quality checks, and produce structured analytical reports that support academic and operational decision-making.

I also collaborate with stakeholders to keep workflows moving smoothly, providing first-line technical and operational support to students for exam/form/subscription and data-related issues. Alongside academic and accounting teams, I coordinate timely issue resolution and smooth execution, while using Power BI to support data interpretation, statistical analysis, Excel analytics, KPI analysis, and dashboard development.

Previously, as a Data Analyst (Egypt Scholar Inc) and as a Data Analyst/Intern and Data Scientist (Intern) on project work, I’ve defined KPIs and reporting frameworks, extracted and structured data from Podio to reduce manual preparation time by 25%, and designed interactive Power BI dashboards for engagement, satisfaction, and outcome analytics. I’ve also worked hands-on with Python for data cleaning, built SQL schemas and ERD diagrams for relational databases, and applied statistical methods (including ANOVA, correlation, and hypothesis testing) and machine learning techniques to uncover patterns and improve operational decisions.
```

## Experience

### Data Analyst Intern

ICEALEX. May 2024 - Sep 2024

```text
Led a project team to design and deploy a relational database for the ICEALEX training program, improving data accessibility and operational efficiency. Executed Python-based data cleaning and transformation and built Power BI and Excel dashboards to visualize startup growth, funding, and sector metrics.
```

Skills: SQL, Relational-Databases, Python, Data-Cleaning, data-transformation, Power-BI, Excel, Dashboard-Development, KPI-Reporting

## Education

### Ajal Academy

Master's Degree in Engineering, Chemical Engineering. 2025 - Present

```text
Pursuing a Master's Degree in Engineering in the Chemical Engineering department at Ajal Academy since October 2025.
```

### Alexandria University

Bachelor of Science in Engineering, Chemical Engineering. 2013 - Present

Activities and societies: Partnered to link and consolidate engineering student records (exam results, subscriptions, attendance) across sheets; used VLOOKUP/INDEX-MATCH, IF, COUNTIF/SUMIF, Pivot Tables and filters; performed data cleaning and validation checks and audited Google Forms assessment data.

```text
Earned a B.Sc. in Engineering (Chemical Engineering) from Alexandria University, supporting student data management and audits across Google Sheets and Google Forms.
```

## Tech stack

- Gmail
- Google Sheets
- Root Cause
- SQL
- Temporal
- Transform
- Enhance
- Dynamic

To contact bassant, message them from this profile with a Himalayas employer account: [Hire on Himalayas](https://himalayas.app/hire).

## People also viewed

- [dareen talal](https://himalayas.app/@dareentalal): Data Analyst Intern, Cleopatra Hospitals Group
- [Ereny Naem](https://himalayas.app/@erenynaem): Data Analyst, Information Technology Institute
- [Esraa Gamal](https://himalayas.app/@esraagamal2): Aspiring Data Analyst, Self Employed
- [Shahd Emam](https://himalayas.app/@shahdemam): Data Analysis Instructor, Pixels.eg
- [Mohamed Ahmed](https://himalayas.app/@mohamedahmed22): Data Analysis Intern, ATEC – Obour Institute
- [Doaa ALKHATIB](https://himalayas.app/@doaaalkhatib): Data Analyst, Al Jazeera Media Network
- [Rofida Aboshosha](https://himalayas.app/@rofidaaboshosha): Freelance Data Analyst, NTI Data Analysis Scholarship – Projects & Training
- [Aya Yousry](https://himalayas.app/@ayayousry): Social Media Analyst & Specialist, Maharat Net Company UAE
- [Radwan Hefny](https://himalayas.app/@radwanhefny): Data Analyst, IntellDetect
- [Yara Sameh](https://himalayas.app/@yarasameh): Data Analysis Intern, VOLTIX EG
