Omar Eita, Developer in Cairo, Cairo Governorate, Egypt
Omar is available for hire
Hire Omar

Omar Eita

Verified Expert  in Engineering

Data Analyst and Developer

Cairo, Cairo Governorate, Egypt

Toptal member since January 10, 2024

Expertise
Microsoft DevelopmentData AnalysisBusiness Intelligence DevelopmentSQLData VisualizationTableau DevelopmentMySQLData ScienceWindows DevelopmentPythonC++
Bio

Omar is a data enthusiast who has worked on multiple data-related projects for big international corporations. He specializes in analyzing, organizing, and cleaning data, as well as building dashboards with Microsoft Power BI and Tableau by leveraging external data sources using SQL and Excel. Omar is always eager to learn new tools and techniques to carry out projects in an efficient and effective manner.

Portfolio

Coca-Cola HBC
SQL, Excel 365, Microsoft Power BI, Data Analysis, Data Analytics, QGIS...
Giga Systems
Excel 365

Experience

  • Microsoft Office - 10 years
  • Excel 365 - 10 years
  • Power Pivot - 3 years
  • Microsoft Power BI - 3 years
  • Data Visualization - 3 years
  • Microsoft Power Apps - 2 years
  • SQL - 2 years
  • MySQL - 1 year

Availability

Full-time

Preferred Environment

Windows, SQL, Microsoft Power BI, Tableau, Microsoft Power Apps, Power Pivot, Excel 365

The most amazing...

...project I've worked on is dividing a large country like Egypt into affluent and non-affluent areas, allowing the company to better serve its consumers.

Work Experience

Senior Data Insights and Analytics Analyst

2022 - PRESENT
Coca-Cola HBC
  • Applied the potential volume-per-outlet model and resegmented outlets based on monthly and potential sales into platinum, gold, silver, and other categories.
  • Led end-to-end activations for new product launches and emerging categories.
  • Employed a forest regression model to assess the affluence of Egyptian subdistricts and, in turn, the company's routes and outlets.
  • Identified and addressed abuse in coolers, optimizing product placement and visibility.
  • Recommended products to business developers based on outlet-specific requirements.
Technologies: SQL, Excel 365, Microsoft Power BI, Data Analysis, Data Analytics, QGIS, Azure Databricks, Data Visualization, Microsoft Office, MySQL, Microsoft Power Apps

Business Intelligence Specialist

2019 - 2022
Giga Systems
  • Signed contracts with our suppliers and customers.
  • Built a fully functional ERP system to track inventory, create quotations, sales orders, and purchase orders, and track tasks.
  • Changed the mail hosting server, built a new website for the company, and increased traffic by 75%.
Technologies: Excel 365

Experience

Segmenting Egypt into Affluent and Non-affluent Areas

The company needed to segment its outlets and customers into those located in affluent areas and those located in non-affluent areas with the aim of better serving its customers and consumers by providing them with the most suitable assortment.

I used publicly available shapefiles and modified them to suit our needs. I also connected multiple sources in Python, SQL, and Excel to work on segmentation logic and criteria to accurately segment customers using 140+ metrics available at the outlet level.

Tailored Recommended Activities

A model that I developed that carries out advanced analytics to come up with tailor-made recommended activities for the business developer to carry out for each visit to our outlets. The model generated €1.9 million in additional revenues after four months of launching the project.

Education

2016 - 2020

Bachelor's Degree in Management of Information and Communication Technology

The American University in Cairo - Cairo, Egypt

Skills

Tools

Microsoft Power BI, Tableau, Microsoft Power Apps, Power Pivot

Languages

SQL, Python, C++

Platforms

Windows

Storage

MySQL

Other

Microsoft Office, Data Analysis, Data Visualization, Excel 365, Data Analytics, QGIS, Azure Databricks

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring