Alexandria, Egypt — analytics with heart

Hi,
I'm Shahd
.

Data storyteller — Power BI · Tableau · SLA
ML enthusiast — Python · Forecasting · Churn
System builder — .NET · Angular · MongoDB · DevOps
shahd@portfolio ~ bash
$ cat profile.json
{
  "name": "Shahd Sherif Mohamed",
  "role": "BI Analyst + Data Scientist",
  "location": "Alexandria, EG",
  "experience": "data & analytics",
  "domains": [
    "call_center_analytics",
    "business_intelligence",
    "machine_learning",
    "backend_infrastructure"
  ],
  "open_to_work": true
}
$ # 3 domains. 1 engineer. let's talk.
01

ABOUT

I'm a Computer Science graduate (Alexandria University, 2025) who sits at the intersection of three disciplines — business intelligence, data science, and backend engineering.

My sharpest edge is call center analytics: I've worked with live ACD feeds, built Power BI dashboards that supervisors use every day, and written SQL to compute Adherence, Occupancy, and SLA in real time.

On the data science side I apply machine learning — churn prediction, time-series forecasting, and agent segmentation — and embed the outputs back into dashboards that non-technical teams can actually use.

My backend exposure covers .NET, Angular, MongoDB, and Hadoop, which means I understand how data systems are built, not just queried.

Power BI
Interactive dashboards
Python
ML & automation
Real-time
Operational analytics
.NET + Angular
Systems & interfaces
02

DOMAINS

Three pillars
⚙️

BACKEND &
INFRA

Systems · APIs · DevOps

Building the plumbing that data flows through. REST APIs with .NET, scalable data pipelines with Hadoop, infrastructure automation, release pipelines, and frontend clients with Angular.

.NET / C# Angular MongoDB Hadoop REST APIs SQL Server Git / GitHub
🧠

DATA
SCIENCE

ML · Forecasting · EDA

Turning raw numbers into predictive models. Churn classification, time-series forecasting with LSTM & ARIMA, customer segmentation, and regression for engagement optimization.

Python Scikit-learn TensorFlow Pandas Random Forest XGBoost Statsmodels
📊

BUSINESS
INTELLIGENCE

Dashboards · KPIs · Analytics

Real-time call center monitoring, SLA tracking, and executive dashboards. Specialized in contact center KPIs — AHT, Adherence, Occupancy, CSAT — with Power BI and Tableau.

Power BI DAX Tableau AHT · SLA Power Query Excel VBA
03

PROJECTS

7 selected works
01
BUSINESS INTELLIGENCE

Live Monitoring Dashboard — Call Center

Worked with real call center ACD data to build a 15-minute-refresh Power BI dashboard displaying live agent states (Available, ACW, Break, Aux), queue SLA status, and intraday AHT. Replaced a manual Excel tracker used by floor supervisors. SLA breach escalation time dropped 18%.

Power BISQLDAX AHT · SLAReal Data
02
BUSINESS INTELLIGENCE

Agent Performance & Workforce Analytics

Analyzed 6 months of real agent-level call data (50k records) profiling AHT, CSAT, and schedule adherence. K-Means clustering segmented agents into performance tiers. Delivered Power BI report and Excel summary for team leads.

Power BIPythonK-Means ExcelPandas
03
DATA SCIENCE

Customer Churn Prediction — Telecom

Random Forest classifier on 70k telecom records. 91% accuracy, 0.89 AUC-ROC. Engineered 15 features including support call frequency and usage ratios. Model outputs embedded in a Power BI retention dashboard for business teams.

PythonScikit-learnRandom Forest Power BIFeature Engineering
04
DATA SCIENCE

Stock Price Forecasting — LSTM & ARIMA

Time-series forecasting on 5 years of daily stock data for 10 companies. LSTM achieved 3.2% MAPE, outperforming ARIMA baseline by 22%. Visualized prediction intervals with Plotly for non-technical stakeholders.

TensorFlowLSTMARIMA StatsmodelsPlotly
05
BUSINESS INTELLIGENCE

Sales & Revenue Analytics — BikeStores

Cleaned 50k+ rows of multi-table sales data via SQL CTEs and Power Query. 5-page Power BI report with DAX for YoY comparisons, revenue by region, product, and rep. Identified top 3 revenue-driving categories.

SQLPower BIDAX Power QueryStar Schema
06
BACKEND & INFRA

Responsive Web Application — ITI Internship

Designed and developed responsive web applications using HTML, CSS, JavaScript, and Angular during a formal internship at ITI. Applied UX/UI principles and full Agile SDLC workflow within a supervised engineering team.

AngularHTML / CSSJavaScript Agile / ScrumUX/UI
07
DATA SCIENCE

Social Media Engagement Optimizer

Collected 6 months of platform data via APIs. Built a regression model predicting engagement rate (R² = 0.78). Recommendations implemented by client, growing average post reach by 25% in the first month.

PythonRegressionAPI Integration PandasMatplotlib
04

EXPERIENCE

3 roles
DEC 2024 — MAR 2025
NTI
Business Intelligence Analyst Intern
  • Designed real-time Power BI dashboards monitoring AHT, SLA adherence, and agent occupancy across multiple call center queues.
  • Built real-time reports used by team leaders to manage intraday staffing; SLA breaches reduced by 18%.
  • Analyzed large telecom and contact center datasets; reports were adopted by operational teams.
  • Automated weekly Power BI and Excel pipelines using Power Query and DAX — reporting time cut by 40%.
  • Completed an intensive BI + data analysis program with top results.
MAY 2024 — PRESENT
Freelance / Remote
Freelance BI & Data Analyst
  • Delivered end-to-end BI systems for retail, e-commerce, and contact center clients.
  • Built contact center operations dashboards tracking call volume, agent performance, and SLA status in real time.
  • Designed Power BI reports with RLS and drill-through pages; manual reporting effort was cut in half.
  • Applied ML models (Random Forest, XGBoost) for sales forecasting with strong accuracy on holdout data.
JUL 2024 — AUG 2024
ITI
Frontend Web Developer Intern
  • Built responsive web applications using HTML, CSS, JavaScript, and Angular.
  • Applied UX/UI best practices and worked within an Agile SDLC team environment.
05

SKILLS

Full stack
BI Tools
Power BI
DAX
Tableau
Excel / VBA
Call Center
Real-time analytics
AHT · SLA
Adherence
CSAT · FCR
Data Science
Python
Scikit-learn
TensorFlow
Pandas / NumPy
SQL & Databases
SQL
PostgreSQL
MongoDB
Hadoop
Backend / Infra
.NET / C#
Angular
REST APIs
Git / GitHub
Methods
Agile / Scrum
EDA
Hypothesis Testing
Star Schema
Education & Languages
B.Sc. Computer Science
Alexandria University, 2021 – 2025
Arabic
Native
English
Fluent
French
Beginner
06

CERTS

6 credentials
NTI
Data Analysis — Skills for the Freelance Professional
Dec 2024
Stanford / Coursera
Supervised Machine Learning: Regression & Classification
Mar 2024
365DataScience
Data Analysis in Power BI with ChatGPT
Completed
MaharaTech ITI Mooca
Database Fundamentals
Sep 2024
365DataScience
Intro to ChatGPT & Generative AI
Completed
NTI — In Progress
Machine Learning — G6 D.E
Enrolled Apr 2025

LET'S
BUILD
TOGETHER.

I'm actively looking for full-time roles in BI analytics, data science, or backend engineering. If you're building a data team or a contact center analytics platform — I want to talk.