RÉSUMÉ / EXPERIENCE & SKILLS

The work behind
the portfolio.

A concise view of my professional experience, technical skills, selected projects, and relevant training.

LinkedIn PROFILE UPDATED · 2026-11-08

Sohila Khaled Abbas

BI Developer | Data Analyst | Analytics Engineer · Damietta, Egypt

sohila.k.data@gmail.com · linkedin.com/in/sohilakabbas · github.com/Sohila-Khaled-Abbas

Profile

BI Developer | Data Analyst | Analytics Engineer

BI Developer with nearly two years of freelance experience building Power BI dashboards and decision-ready reporting. My work spans sales and retail, churn, supply chain, e-commerce, customer satisfaction, marketing, HR, and healthcare, with a focus on data preparation, validation, SQL and Power Query, dimensional modeling, and KPI design. I also hold a BSc and build analytics projects, explore Python-based model evaluation, streamline reporting with Excel and VBA, and share practical learning through The Data Tea.

Professional experience

Nov 4, 2026Virtual · Completed simulation

Excel Skills Job Simulation

Forage Academy
  • Reviewed and organized account sales data, using conditional formatting to surface data-quality issues and meaningful patterns.
  • Applied SUM, AVERAGE, IF, COUNTIF, SUMIF, and IFERROR to calculate, summarize, and classify sales information.
  • Built PivotTables and charts to examine account performance and annual sales trends, then brought key metrics together in an Excel dashboard.
  • Recorded and tested VBA sorting macros, assigning them to Form Control buttons to make repeatable workbook operations easier to run.
Nov 3, 2026Virtual · Completed simulation

Data Labeling Analyst — Job Simulation

Forage Academy
  • Reviewed simulated customer-support messages and classified intent, sentiment, and personally identifiable information (PII) using a consistent labeling schema.
  • Evaluated ambiguous edge cases and documented concise rationales for final labeling decisions.
  • Reviewed peer labeling, identified inconsistencies, and proposed an improvement to the team's labeling guidelines.
  • Applied clear definitions and privacy-aware practices to support consistent, reliable labeled data.
  • Practiced human–AI collaboration concepts relevant to AI operations, trust and safety, and machine-learning data support.
Jul 2026 – Sep 2026Remote

Machine Learning Engineer Intern

FlyRank AI
  • Queried an approximately 79-million-row search-performance warehouse with DuckDB and SQL, aggregating Parquet data for analysis.
  • Developed Python-based feature-preparation workflows and machine-learning experiments using anonymized search-performance data.
  • Explored temporal and client-grouped validation approaches to assess model generalization and identify potential data-leakage risks.
  • Completed a capstone project that was independently reviewed and approved.
Dec 2024 – PresentRemote

Freelance BI Developer

Freelance
  • Deliver confidential BI engagements, translating business questions into Power BI reports, KPI definitions, semantic models, and DAX measures.
  • Shape source data with Power Query and SQL, and document metric definitions, transformation logic, and reporting handover.
Sep 2025 – Jun 2026Part-time · Remote

Freelancing Coach

Digital Egypt Pioneers Initiative (DEPI)
  • Coached aspiring freelancers on professional positioning, portfolio and CV development, freelance-platform profiles, proposal writing, and client communication.
  • Reviewed learner portfolios, CVs, and freelance profiles, providing practical feedback and structured weekly development challenges.
  • Analyzed freelance project listings to identify recurring skill requirements and help learners position practical services.
Jul 2025 – Apr 2026Part-time · Remote

Data Analysis Mentor

Data Pill
  • Mentored learners in Excel formulas and functions, data cleaning, PivotTables, charts, dashboards, Power Query, Power Pivot, and DAX.
  • Taught data transformation with Power Query and data modeling with Power Pivot, including DAX calculations in Excel’s Data Model.
  • Designed practical exercises and reviewed learner work to strengthen analytical reporting and dashboard skills.

Technical skills

Data & analytics engineering

PythonSQLETL / ELTData warehousingDimensional modelingSQL ServerPostgreSQLData validationKimball dimensional modelingMySQLSSISInformatica

Platforms & orchestration

AirflowdbtDatabricksPySparkDockerGit & GitHubApache SparkApache KafkaSnowflakeBigQuery

Machine learning & modeling

Predictive modelingMachine learningFeature engineeringModel evaluationPandasscikit-learnNumPy

Business intelligence & automation

Power BIDAXPower Query MExcelPower Pivotn8nREST APIsTechnical documentationObsidianMacros / VBANotionData storytelling

Analytics applications & visualization

StreamlitPlotlyMetabaseExcel charts

Statistical analysis & experimentation

A/B testingHypothesis testingStatistical modelingOLS regressionRSelenium

Selected projects

Egyptian Cosmetics Analytics

An Egypt-focused retail portfolio project connecting operational data to a dimensional warehouse and Power BI reporting.

Python · SQL Server 2022 · Power Query M · Power BI · DAX

PixelFed, from raw to ready

A reproducible social-content analytics project built around a relational schema, mixed-format landing files, and a galaxy semantic model.

Python · Power Query M · Power BI · TMDL · SQL · GitHub Actions

Kickstarter Analytics Engineering Platform

A Power BI analytics-engineering project designed to reconcile campaign history across public Kickstarter data sources.

Power Query M · Power BI · DAX · PBIP · TMDL · Python

Automation with a backbone

A documented Docker Compose stack for queue-mode n8n workflows, with Redis, PostgreSQL, and worker-oriented execution.

n8n · Docker Compose · Python · Redis · PostgreSQL · Qdrant

PwC Switzerland virtual case

An Excel and Power BI modeling portfolio based on the PwC Switzerland virtual case experience hosted on Forage.

Excel · Power Query · Power Pivot · DAX · VBA

Customer 360 banking ETL

A banking integration capstone combining relational customer data with ATM and credit-card files using Informatica Cloud Data Integration.

Informatica IICS · Oracle · CSV · ETL · Data quality

Training & certificates

Nov 6, 2026

Introduction to Excel

365 Data Science

Revisited Excel fundamentals and passed the course exam on a second attempt. First taken during the 2025 free-access period; retaken in 2026 as structured revision.

View course certificate ↗

2026

n8n Foundations Professional Certificate

n8n Academy

Essentials, Integrations, and In Practice: AI, Testing & Best Practices.

Oct 2026

Fundamentals of Networking for Effective Backend Design

Udemy

Completed course with practical networking labs.

Mar – May 2026

Data Analytics Diploma

Ahmed Ali · Friendly Analysis

28 sessions covering data analytics.

May 2026

Build with AI: Masr Edition

Information Technology Institute (ITI)

AI-focused training.

Nov 2025

Python, APIs & data-platform foundations

365 Data Science

Web Scraping and API Fundamentals in Python; Introduction to Jupyter, Data Warehousing, and Databricks.

Oct 2025

Power BI Desktop & Power BI Service

Maven Analytics

Business intelligence training.

Oct 2025

SQL, Python, Excel & data foundations

IBM · edX

SQL for Data Science; Relational Database Basics; Python Basics for Data Science; Analyzing Data with Excel; Data Engineering Basics for Everyone; Data Analytics Basics for Everyone.

Enrolled coursework

Continuing study in dbt, Airflow, Excel VBA, cloud data engineering, Docker, operating systems, and database engineering. Enrollment is separate from completion and certification.

View all seven enrolled courses
Explore the full learning & credential collection

Languages

Arabic · Native · English · Excellent, written and spoken

A QUESTION WORTH EXPLORING?

Let’s make something useful.

Start a conversation

Project preview

Find a project

↑ ↓ to navigate · Enter to open · Esc to closeBrowse all work ↗