Professional Experience & Background
Experience, Education & Languages
A comprehensive overview of professional data analytics, automation engineering, operational leadership, and financial background.
Freelance Data Analyst & Automation Engineer
Self-Employed (2025 – Present)
Designed and deployed Python automation scripts, web scrapers, ETL pipelines with n8n, and custom reporting solutions for clients.
Shift Leader
Tech-Me (2024 – Present)
Directing operational workflows, team coordination, and technical systems monitoring.
Accountant
Dream Pharma (2017 – 2020)
Managed financial reporting, transaction tracking, and accounting reconciliation.
Pharmacy Manager
Ghada El Zanaty Pharmacy (2014 – 2017)
Oversaw inventory control, staff supervision, daily operations, and customer service standards.
Full-Stack Data Analysis Diploma
Arabian Academy (2026)
Intensive training covering Python, SQL, ETL pipelines, and Power BI visualization.
Bachelor of Accounting
Alexandria University (2023)
Core foundation in corporate finance, auditing, and accounting principles.
McKinsey Forward Program
McKinsey & Company (2026)
Professional learning program focused on problem-solving, leadership, and adaptability skills.
Arabic (Native)
English (Fluent)
French (Good)
Russian (Good)
Machine Learning & Financial Analysis
EGX Stock Market Forecasting & Macroeconomic Analysis
Predictive financial machine learning model built with Python and XGBoost to forecast Egyptian Exchange (EGX) trends by incorporating macroeconomic metrics like USD/EGP exchange rates and pushing recommendations to Google Sheets.
Primary Algorithm
XGBoost & LSTM
Market Target
EGX (COMI.CA)
Sync Integration
Google Sheets API
- Feature Engineering: Merged historical ticker prices with volatile foreign exchange trends to compute 5-day horizon directional signals.
- Automated Pipeline: Deployed scripts via Google Colab and gspread to automatically refresh daily stock signals.
View on GitHub
Python Media Automation & AI
Automated Shorts Scraping & Whisper Transcription Engine
End-to-end Python automation pipeline using yt-dlp, OpenAI Whisper, MoviePy, and PyDrive2 to scrape viral YouTube Shorts by hashtag, transcribe audio, detect engagement peaks, and auto-sync videos to Google Drive.
Speech Recognition
Whisper Local AI
- Data Extraction: Filtered videos based on view thresholds and automatically generated vertical aspect ratios (9:16) for short-form video creation.
- Metadata Logging: Parsed video engagement metrics directly into structured Excel sheets using openpyxl.
View on GitHub
ETL & Workflow Automation
Automated n8n Data Ingestion & Power BI Dashboard Pipeline
Automated ETL workflow utilizing n8n cloud to ingest, clean, and consolidate dynamic multi-table Excel datasets directly into a centralized Power BI dashboard environment.
Orchestration
n8n Workflows
BI Visualization
Power BI Desktop
- Zero-Touch Refresh: Automatically triggers file consolidation upon receipt of raw data files, eliminating manual reporting tasks.
- Interactive Reporting: Implemented DAX dynamic measures to track operational key metrics and revenue trends.
View on GitHub
DevOps & Cloud Automation
24/7 Cloud VPS & Docker Python Automation Servers
Configured and maintained remote Linux virtual private servers (Rooyai Cloud VPS) and Render.com web services to run continuous 24/7 background Python automation workflows and Docker containers.
Deployment
Docker Containers
- Continuous Execution: Containerized data pipelines to ensure zero-downtime background execution and automated error recovery.
- Cloud Web Services: Deployed scalable endpoints for webhook processing and automated file synchronization.
View on GitHub
Mobile Development & Gaming
3D Mobile Action Shooter & Google AdMob Monetization
Developed a 3D third-person mobile shooter game for Android inspired by Max Payne, integrating Unity engine architecture, Google Firebase user authentication, and rewarded ad monetization via Google AdMob.
Monetization
Google AdMob
- Backend Integration: Configured Google Firebase for secure user profile management and cloud data storage.
- Ad Monetization: Integrated rewarded interstitial ads to drive mobile in-app revenue generation.
View on GitHub
SQL & Relational Databases
SQL Cohort Analysis & Customer Retention Optimization
Relational SQL data project implementing CTEs, window functions, and aggregations to calculate user retention rates and revenue degradation.
WITH MonthlyCohorts AS (
SELECT
customer_id,
DATE_TRUNC('month', MIN(order_date)) OVER(PARTITION BY customer_id) AS cohort_month,
order_date,
total_amount
FROM sales_orders
)
SELECT
cohort_month,
COUNT(DISTINCT customer_id) AS active_users,
SUM(total_amount) AS cohort_revenue
FROM MonthlyCohorts
GROUP BY cohort_month
ORDER BY cohort_month ASC;
View SQL Scripts