Mohamed Rashidi

Data Analyst & Automation Engineer | Specializing in Python ETL, Machine Learning, Automated n8n Pipelines, and Interactive BI Dashboards.

Python (Pandas, XGBoost) SQL n8n Automation Power BI OpenAI Whisper Docker & VPS
Professional Experience & Background

Experience, Education & Languages

A comprehensive overview of professional data analytics, automation engineering, operational leadership, and financial background.

Work Experience

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.

Education & Certifications

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.

Language Proficiencies
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
Key Highlights 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
Cloud Sync
PyDrive2 API
Technical Highlights 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
Workflow & BI Features 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
Environment
Linux VPS
Infrastructure Features 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.

Engine
Unity 3D
Monetization
Google AdMob
Development Highlights 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.

Core SQL Cohort Query
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