Learn Data Skills
Beta
Mohamed El Tanbedawy

Mohamed El Tanbedawy

senior business analyst

Careem

Technologies

My Portfolio Highlights

My New Course

Introduction to Python

Data conductor, orchestrating the symphony of insights with precision.

My Work

Take a look at my latest work.

DataLab

Project: Analyzing Unicorn Companies

course

Introduction to Python

course

Intermediate Python

DataLab

Project: Exploring Airbnb Market Trends

DataLab

Competition - Supply Chain Analytics

DataLab

Project: Time Series Analysis for Transportation

DataLab

Project: Investigating Netflix Movies

DataLab

Project: Analyzing Motorcycle Part Sales

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

My Work Experience

Where I've interned and worked during my career.

Careem | Jan 2023 - Present

Senior Business Analyst

As a Senior Business Analyst, and part of The Strategy & Planning Team my main focus is on driving business growth through data-driven insights and analysis. I design and implement automated systems to streamline processes, increase efficiency, and generate regular performance updates, including tailored reports and metrics analysis. I also monitor and evaluate key performance indicators, budget, and targets to optimize performance and develop and maintain dashboards to visually track progress towards business goals. In addition, I conduct in-depth data analysis to identify trends and patterns, using this information to make informed recommendations for performance optimization and improvement. I collaborate with cross-functional teams to gather and analyze data from various sources, including SQL queries and Tableau dashboards. Supporting the creation of a self-serve styled platform that empowers the Ride Hailing division to create amazing insights. Create new data platforms where needed to unlock new types of insights, Design and structure data from source tables to rollup into data warehouses that can be consumed easily to answer key business questions and problem statements.
Show More

Careem | Jan 2021 - Jan 2023

Business Analyst

Design and implement automated systems to streamline processes, increase efficiency, and generate regular performance updates including tailored reports and metrics analysis using SQL , google sheets , Excel and Tableau and monitor and evaluate key performance indicators, budget, and targets to optimize performance, and develop and maintain dashboards to visually track progress towards business goals Created over 5K SQL Query and 50 tableau dashboards and Conducted in- depth data analysis to identify trends and patterns, and use this information to make informed recommendations to the Country Leadership and teams for performance optimization and improvement. Created Growth hacks Profit vs net contripution analysis that succeded to inccrease the average profit per customer and helped the growth team to target the user in amore efficient way Performed underpaid credit card trips analysis that saved above 10K dollars monthly and created customer behavior per zone and peak multiplier analysis that increased platform service reliability by 7 % and service gross revenue by 5 %.

Careem | Jan 2020 - Jan 2021

Supply Lead - Growth

Led a team of high talented colleagues managing Driver acquisition and Support and succeded to acquire over 60K drivers and manage 300+ suppliers and Resolved over 100K Zendesk tickets, providing timely and efficient support to drivers and suppliers while achieving monthly SLA targets. across 19 cities in Delta, Canal, and Upper Egypt. Developed a Driver's City Change Policy and Early Life Program that significantly decreased supplier fraud, increased driver activation rates, and improved the onboarding experience for new drivers. Created an Escalations Manual and implemented automation through Google Sheets SQL queries that reduced the average number of support tickets per driver and saved 3 hours of manual work per week. Developed a Supplier's Performance Development Program and launched the Ambassador Acquisition Program to increase the number of drivers acquired per supplier, reduce differences in suppliers' share of total city acquired drivers, Created partnerships with local businesses to offer discount promo codes to their users, resulting in over 100K secured trips across all 19 cities.

Careem | Jan 2019 - Jan 2020

Supply Growth Senior Associate

Led the on-ground market launch activities and established effective communication channels with third-party partners, building the company's presence in Shebin elKom city from scratch. Secured a suitable office location for the company in Shebin elKom city, managing all communications with the owner and overseeing monthly costs for electricity, water, and gas to ensure operational efficiency. Successfully acquired 9K drivers and 13 suppliers and managed the entire driver and supplier lifecycle at Shebin elKom and Banha cities, from recruitment and training to ongoing support, improving driver satisfaction and retention rates. Resolved over 20K Zendesk and Jira tickets, providing timely and efficient support to drivers and suppliers across both cities while achieving monthly SLA targets.

Careem | Nov 2017 - Jan 2019

Supply Growth Associate

Secured a suitable office location for the company in Banha city, managing all communications with the owner and overseeing monthly costs for electricity, water, and gas. Successfully acquired 3K captains by acquiring 5 suppliers and managed the entire driver and supplier lifecycle in Banha city, from recruitment and training to ongoing support, to improve driver satisfaction and retention. Supported over 3K Drivers in person at Banha Office and Resolved over 7K Zendesk and Jira tickets, ensuring timely and effective support for city drivers and suppliers and achieving monthly SLA targets. Established plus 20 strategic partnerships with local businesses to provide drivers with exclusive services and discounts, enhancing their work environment and boosting overall driver satisfaction,

Nestlé | Sep 2015 - Nov 2017

HR Admin Officer

Oversaw the entire recruitment process for seasonal employees, including responding to applicant calls, scheduling interviews, and onboarding new hires. Maintained accurate and up-to-date records for both seasonal and permanent employees, including contracts, military status, medical certificates, and insurance forms. Provided guidance and support for the termination process and assisted with the preparation of insurance Form 6 for seasonal employees. Managed the renewal process for contracts, military status, and medical certificates, as well as employee absences, penalties, and leaves, ensuring compliance with company policies and regulations.

Oberoi Hotels & Resorts | Nov 2014 - Sep 2015

Receptionist

Provided exceptional customer service and support to guests during their vacation on board the cruise ship. Managed all necessary communications, certifications, and licenses for the cruise ship and ensured compliance with government regulations in Aswan, Luxor, and Esna. Coordinated and facilitated communication between different departments on the cruise ship to ensure smooth and efficient operations. Handled all guest transportation needs, including transportation to and from the cruise ship, airport, temples, and museums, providing a seamless and hassle-free experience for guests.

My Education

Take a look at my formal education

bachelor of commerce, Accountingfaculty of commerce menofiya university | 2012

About Me

Mohamed El Tanbedawy

Experienced and skilled in data analysis, project management, and process improvement. Proficient in SQL and Tableau. Experienced in using Excel, Google Sheets, and Zoho Sheets. Adept in marketing tools like Google Tag Manager, Google Analytics, and

Powered by

  • Work
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free