Mohamed E.

  • محلل بيانات وأعمال
  • مصر

نبذة

محلل بيانات وأعمال. أكثر من 11 سنة خبرة مهنية، منها 6 سنوات في شركة نقل ذكي رائدة في الشرق الأوسط: كتبت أكثر من 2,000 استعلام SQL وبنيت أكثر من 50 داشبورد Tableau عبر تسعة أسواق، من بينها السكوركارد التنفيذي الذي يقرأه الرئيس التنفيذي يوميًا. وأسست أول إدارة تحليل بيانات في كريم مصر.

 

أعمل على: داشبوردات Power BI و Tableau و Looker Studio بنمذجة star schema ومقاييس محكومة · SQL ونمذجة بيانات على PostgreSQL و BigQuery · تحليل يشخّص (كوهورتات وأقماع وأشجار محركات وتقسيم شرائح ومحاكاة تسعير) · قياس وتتبع GA4 و Google Tag Manager و Meta CAPI · أتمتة بنحو 50 workflow إنتاجي على n8n مدعومة بـ Node.js و PostgreSQL.

 

طريقة عملي: أطابق كل رقم مع مصدره قبل التسليم، وأنشر قيود البيانات مع النتائج. الرقم الذي لا يمكن الدفاع عنه لا يدخل التقرير.


الخبرات

Independent Consultant, Data & Automation - Self-employed (Jun 2024 - Present)

Design and build BI and analytics systems for eCommerce and operations clients: Power BI and Tableau dashboards on governed star-schema models, SQL and BigQuery data models, and GA4, Google Tag Manager and server-side Meta CAPI measurement architectures. Engineered an AI Commerce Operating System running 50+ production n8n workflows end to end for two retailers, and delivered a scheduled Apps Script to BigQuery pipeline that values a multi-owner stock portfolio daily. Teach the SQL, Tableau and Excel modules of a data career-readiness diploma.

Senior Business Analyst - Careem (Jan 2023 - Jun 2024)

Architected the Master Scorecard: 15+ interconnected views blending 8 Google Sheets and SQL sources into a single executive command center with city and product drill-downs, read daily by the CEO across nine markets, cutting ad-hoc deep-dive requests by 30% and meeting preparation time by 50%. Built the Marketplace Bid-Ask suite, decomposing the booking funnel and acceptance rate across 14 peak-multiplier brackets and separating timed-out from self-cancelled rides.

Business Analyst - Careem (Jan 2021 - Dec 2022)

Wrote 2,000+ production SQL queries and built 50+ Tableau dashboards. Delivered the eight-tab supply retention and early-churn platform with 13-month cohort triangles and churn decomposition by block category, a six-level GMV driver tree, near-real-time Egypt and Pakistan monitoring at 15-minute granularity, and pricing and GMV simulators with explicit elasticity assumptions.

Supply Growth Lead - Careem (Jan 2020 - Dec 2020)

Founding member of the analytics function created for Egypt: taught myself SQL and built the region's first pipelines and dashboards on personal initiative. Led driver acquisition across 19 cities with 60,000+ drivers and 300+ suppliers, a city-change policy that lifted retention by 13%, and an early-life program that lifted activation by 25%.

Supply Growth Associate - Careem (Nov 2017 - Dec 2019)

Grew city trips 5x and tripled the supplier fleet while improving trip completion by 40%. Handled 100,000+ Zendesk tickets and built the reporting that replaced manual supply tracking.

HR Administrator - Froneri Egypt (Oct 2016 - Oct 2017)

Managed recruitment processes and employee records for seasonal and permanent staff, and optimised HR operations through data management and compliance tracking.

HR Administrator - Nestle Egypt (Sep 2015 - Sep 2016)

Administered employee records and payroll inputs and supported recruitment cycles across seasonal and permanent hiring.


التعليم

Bachelor’s Degree in Commerce - Menoufia University (2008 - 2012)

Major in Accounting. Gained a strong foundation in business, financial management, and data analysis.


أعمالي


هل تبحث عن فرصة للعمل عن بعد؟

حدد التخصصات التي ترغب في العمل بها لنرسل نشرة الوظائف الدورية إلى بريدك الإلكتروني

برمجة وتطوير
تسويق ومبيعات
كتابة وترجمة
تصميم
إدارة وأعمال
دعم فني
المجالات الأخرى