profile-img

Fatuma Ahmed Mohamed

Sr.sales analyst at Mido food & Beverage supplier

Hadayek Alkobba, Cairo, Egypt

Work Experience

  • Sr.sales analystFull Time

    Mido food & Beverage supplier

    Jul 2019 - Present -6 yrs

    Egypt , Cairo

    • Job Details:- Preparing detailed DSR reports by Customer / SKU for 4 different channels (300+ SKU) on daily bases. - Got firsthand digital analytic experience through creating E-Commerce Channel Data Base from scratch which led to it’s develops it in a short period of time. - Produced monthly sales forecasts, and prepared weekly reports. - Distribution of monthly target for the total company by Channel, Category, Sub Brand and item. - Collaborate with sales team to develop sales forecasts & Reports. - Examine new channel Budgets to identify that it will providing a return on investment (ROI) - Provide marketing teams with data to develop promotional materials and campaigns. - Creating reports for executive leadership that effectively communicate trend, patterns and predictions using relevant data. - Work closely with the Brand Mangers to provide them with any required data. - Reporting directly and communicate with the suppliers, Export Area Managers & Business development managers to provide them with insightful reports & Dashboards. - Provide sales manager with Monthly forecasting and that could change monthly plan. - Collaborate with team members and members of other departments to finsh any tasks related to sales, numbers , target changes & Forcasting. - Generating reports from single & multiple Sources to clear up the whole vision & Analyze sales performance. - Create dashboard to present & track channels performance. - Create new pricing strategies, plans for the E-Commerce Channel and collaborated with colleagues on the improvement of the whole sales process. - Track & Check Customers Data base & items Codes to figure out any duplication's & errors to fix it with the department responsible for that. - Review and track the E- Commerce channel customer behavior to make the responsible team working on the loyalty program to increase the retention %.
  • Sales AnalystFull Time

    Rashideen Egypt for trade

    Jan 2017 - Jul 2019 -2 yrs, 6 months

    Egypt , Cairo

    • Job Details:- Responsible for tracking and analysis the stock balance vs. Target and Act sales trend on a daily basis to make sure the stock level is sufficient to cover the target. - Prepare daily, monthly, quarterly & annual sales reports of achievement vs. target to all sales channels. - Cooperate with regional coordinators to distribute target on monthly basis, after split it by SR & SV which is uploaded to the SAP system. - Calculating and preparing KPIs tracking reports for whole company. (SDO, AMF, CD, MSL). - Create daily and monthly reports on demand from managers to follow up the sales trend by customer or tracking specific Brand or SKU. - Check the system, compare it with the sales report, Target and notify the IT department about any problem. - Responsible for following up with the incentive and bonuses programs and accounts handled by sales specialists. - Tracking the active and non-active customers on monthly bases according to the invoices.
  • Merchandise AnalystFull Time

    Rashideen Egypt for trade

    Mar 2016 - Dec 2016 -9 months

    Egypt , Cairo

    • Job Details:- Work on reviewing the contracts related to the sales team & responsible for handling any contracts issues with the Legal Affairs & finance. - Assessing market data, including competitor’s news like new products, prices, promotions, packing to identify areas where the company can increase its efforts. - Report and calculating customer incentive according to the contract & measured by the S.S report. - Follow up of customer’s commetment to the contracts spaces & Shelf Share. - Deep analysis on our shelf share and all extra touch points (contracted and rentals) across all Categories. - Work on the Merchandisers team incentive according to the monthly assessment & KPIS. ( 4 SV & 30 Merchandisers) - Track and reporting the near expiry & Out of stock items to the Sales team mangers to make a decision. - Preparing reports and presentations for executives and other company leaders which includes data on market performance, competitor research, and general sales trends. - Monitor office supply for the merchandisers team, and reorder it.
  • Call Center RepresentativeFull Time

    Americana Group

    Jan 2012 - Mar 2016 -4 yrs, 2 months

    • Job Details:- Work on reviewing the contracts related to the sales team & responsible for handling any contracts issues with the Legal Affairs & finance. - Assessing market data, including competitor’s news like new products, prices, promotions, packing to identify areas where the company can increase its efforts. - Report and calculating customer incentive according to the contract & measured by the S.S report. - Follow up of customer’s commetment to the contracts spaces & Shelf Share. - Deep analysis on our shelf share and all extra touch points (contracted and rentals) across all Categories. - Work on the Merchandisers team incentive according to the monthly assessment & KPIS. ( 4 SV & 30 Merchandisers) - Track and reporting the near expiry & Out of stock items to the Sales team mangers to make a decision. - Preparing reports and presentations for executives and other company leaders which includes data on market performance, competitor research, and general sales trends. - Monitor office supply for the merchandisers team, and reorder it.
  • Education

    • Bachelor's Degree in Psychology

      Ain Shams University (ASU)

      Jan 2007 

    • High School - Thanaweya Amma

      el salam school

      Jan 2003 

    Skills

    • Analysis
    • Excel expert
    • Markiting strategy

    Languages

    • Arabic

      Fluent
    • English

      Intermediate

    Training & Certifications

    • ICDL

      2008
    Share this Profile