Omar Ahmed Sediek

SFE & Business Intelligence Senior Data Analyst at Elixir Pharma

New Cairo, Cairo, Egypt

Elixir Pharma

Jun 2023 - Present -2 yrs

Job Details:• Responsible for company data analysis & and modeling for data from each department (sales, marketing, finance, regulatory, HR, …etc.) • Creating dashboards, forecasting models, data templates, and mapping through different used data (daily, monthly, & and management dashboards) to get better insights for better decisions. • CRM system monitoring and data updates for the dynamic structure of the sales teams and other departments. • Analyzing system requirements for the new models or system updates to match company needs and new launch updates. • IMS data monitoring and analysis nationally and by territory and monitoring product performance through different periods.

Sales Force Effectiveness (Commercial Operations analyst)Full Time
Oct 2022 - May 2023 -7 months
Egypt , Giza
- Job Details:• Focusing on commercial data analysis, planning, targeting & forecasting for each business unit (Radiology, Laboratory, Catheter, & polyclinics). • Creating dynamic dashboards to present the commercial team’s progress daily and connect the daily revenue data with the CRM visits per sales representative. • Monthly reviewing sales teams’ achievements and identifying the areas that need to be improved to focus on for the next month as short-term actions, and for the quarter for the big changes (focusing on new specialty, increasing our PM list of doctors, or adding new corporate deals and repricing).
Senior business data analystFull Time
Aug 2021 - Oct 2022 -1 yr, 2 months
Egypt , Giza
- Job Details:• Analyzing, planning, targeting & forecasting for corporate data, ongoing & new projects. • Budget analysis, modality & branches revenue & volume forecasting, and risk analysis & presenting. • Forecast the HR budget for annual increases, training activities, and other compensation & benefits activities. • Analyzing the payroll data for the payroll team. • Feasibility studies for new acquisitions and branches. • Prepares reports of the results, presenting and explaining findings for the management

Dar Al-Teb

Dec 2020 - Aug 2021 -8 months

Egypt , Cairo

Job Details:Responsible for planning and analyzing sales, marketing, and operation results. Collaborating with board management, supply chain, finance, and medical departments. Key accomplishments: • Project lead for new management system implementation for Ebtesama Hospital that was responsible for increasing revenue from an average of 250,000 EGP monthly in 2020 to more than 800,000 EGP in June 2021. • New system implementation for stores that saves more than 20% of OpEx.

Dar Al-Teb

May 2019 - Nov 2020 -1 yr, 6 months

Egypt , Giza

Job Details:Strategy management, sales & marketing data analysis, and financial analysis & planning. Project manager for a new ERP system to increase the quality and smooth transformation from the old ERP to the new one. Data analyst for the corporate and the proposed plans for the next year, analyzing our current situation vs. the previous periods, financial statements & savings.

Nanodegree, Advanced Data Analysis
Udacity·2022
Udacity Nanodegree, Data Analysis Professional
Udacity·2022
Data Challenger Track (Data Analysis)
Udacity·2021
Good Clinical Practice (GCP)
Good Clinical Practice (GCP) The National Institute on Drug Abuse (NIDA)·2021
Microsoft Project
Next Academy·2020
English speaking
AUC·2019
Communication skills
Eli Lilly & Co.·2017
Presentation skills
Eli Lilly & Co.·2017
HR diploma
MBA·2016
Pharmacovigilance total-guidelines
Common Arab Pharmacovigilance·2016
Leadership Development
Yakazet Fekr·2012