
Fatuma Ahmed Mohamed
Sr.sales analyst at Mido food & Beverage supplier
Hadayek Alkobba, Cairo, EgyptWork 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 schoolJan 2003
Languages
Arabic
FluentEnglish
Intermediate
Training & Certifications
ICDL
2008