Essam Abdelkhalek

Essam Abdelkhalek

Medical Sales Representative

Followers of Essam Abdelkhalek980 followers
location of Essam AbdelkhalekEl Obour, Al Qalyubiyah, Egypt

Connect with Essam Abdelkhalek to Send Message

Connect

Connect with Essam Abdelkhalek to Send Message

Connect
  • Timeline

  • About me

    Microsoft Power BI - Microsoft Excel Power PIVOT - Oracle SQL and PL/SQL - more than 9 years in Data Analysis on commercial excellence department.

  • Education

    • Faculty of science, Ain Shams university

      2001 - 2005
      Bachelor's degree

      MathematicsStatisticsChemistryDos

  • Experience

    • Amman Pharmaceutical Industries

      Jun 2006 - Feb 2009
      Medical Sales Representative

      MR on Ophthalmology drugs

    • GSK

      Mar 2009 - Mar 2010
      Medical Sales Representative

      1 year of work with GSK (one the top 10 pharmaceutical co. in the world)

    • Rameda Pharmaceuticals

      Apr 2010 - Jan 2020

      "Target" setting and calculation "Sales" preparation, reporting, analysis, and Dashboards IMS and Company bricks Mapping Products Mapping (co-promoted products included) Customers Mapping Sales Transactions if existing "Excel and PIVOT training" "Customers unified code project" "Incentive" scheme and calculation "FF Structure" regular head count calculation per (line, cost center, Area Manager) turn over % calculation "TO_Market, Export, TOLLتصنيع للغير, Bonus, Donation, Vet, and (Point System for Pharmacies)" Show less

      • Senior SFE & Sales Analyst

        Oct 2014 - Jan 2020
      • District Sales Manager

        Jan 2014 - Sept 2014
      • Product Specialist Representative

        Apr 2010 - Dec 2013
    • Orchidia Pharmaceutical Industries

      Feb 2020 - Jan 2021
      Senior Data Analyst

      "Doctors database" Potentiality sheet by products where each doctor has accurate no. of our Rx in each product and accurate no. of Rx from competitors. raise Classification from Potentiality sheet which is updated each 6 months.regular development of doctors' lists by Potentiality Sheet."Marketing Activities" Analysis for activities vs sales.analysis per each product manager's activities and events vs Sales.analysis per each product's expenses vs its achievement.follow up on plan of actions put on these above analysis reports."Excel and PIVOT training" for all FF and product managers. "IMS" analysis for monthly total report from IQVIA. (Companies and Brands)analysis for IMS per 70 bricks per all levels of our structure of FF. "Export CRM Project" Jordan, Sudan and Emirates."Export Achievement Analysis" monthly presentation for export Ach%. Show less

    • COPADPHARMA

      Feb 2021 - now
      Commercial Excellence Supervisor

      "Sales" preparation, reporting, analysis, and Dashboards (Solutions-Max Sales software):sales calculations per rep and per customersSales vs (Expenses + COGs)Sales vs Target AchievementSales Transactions (like: bulks distribution and chains distribution)"Daily sales calculations" calculations for daily sales come from distributors and finalize it per line."Target" setting and calculations."IMS" analysis for monthly total report from IQVIA. (Per items, bricks and companies)."CRM_Management" Doctors databases, visits reporting, KPIs Analysis."Excel and PIVOT training" for Commercial Excellence Team. Show less

  • Licenses & Certifications

    • Oracle Developer

      Eng. Helal Ahmed
      Jan 2016
    • English

      American International University
      Jan 2014
    • Presentation Skills

      Rameda Pharmaceuticals
      Jan 2012
    • Business Writting

      AmCham Egypt
      Jan 2020
    • HR Diploma

      Ain Shams University
      Jan 2015
    • Power BI Essential Training

      LinkedIn
      Jan 2021
      View certificate certificate
    • Public Speaking Skills

      Orchidia Pharmaceutical Industries
      Jan 2020
    • Business Planning

      LEADS Group; Leadership Effectiveness And Development Solutions
      Jan 2013
    • Key Account Management

      LEADS Group; Leadership Effectiveness And Development Solutions
      Jan 2013
    • Communication and Selling Skills

      GSK
      Jan 2009