Experience

El Attal Holding

• Egypt
• Real Estate
• 100 - 200 Employee

• Data Analysis Manager

  • Nov 2019 - Present

  • Managing and maintaining sales data in (CRM) and other software programs• Preparing Quarterly Business Review presentations• Preparing Exhibitions & Events preview presentations• Developing and maintaining daily, weekly, monthly, and quarterly reports and Key Performance Indicators(KPIs) • Evaluating Marketing channels and lead Sources. • Measuring the qualified leads and Effectiveness of Indirect sales and active brokers. • Preparing reports for the top management to make a good business decisions and solve critical issues. • Managing reports for Call center ,sales, marketing to make recommendations for the future. • Recommend different types of direct marketing campaigns for specific market sectors based on the analysis of previous campaign results. • Market research studies of the competitors (general projects informations ,POS materials, offers,campaigns & prices).



Real-Estate

• Real Estate
• 1 - 100 Employee

• Freelance Real Estate sales advisor

  • Aug 2019 - Nov 2019



LIVING YARDS Developments

• Senior CRM & Sales Analyst

  • Jun 2018 - Aug 2019

  Sales & Brokers Analyst : • Tracking the sales request and identify the right channels. • Handling the sales conflict • Managing the Client and the brokers Data base. • Managing the broker contract and reviewing the legal document • Prepare the broker commission calculation. • Updating and managing the clients database. • Reporting sales KPIs. • Evaluating Marketing channels and lead Sources. • Measuring the qualified leads and Effectiveness of Indirect sales and active brokers. • Preparing reports for the top management to make a good business decisions and solve critical issues.CRM:Managing Call Center team ,create reports for Call center and in sales, marketing and customer service, helping them to make more effective decisions,make recommendations on relationship strategies for different categories of customer or for individual customers, recommend different types of direct marketing campaigns for specific market sectors based on the analysis of previous campaign results.Recommend upselling or cross-selling programs.



4Link Enterprise Solutions

• Senior Admin Sales & Operations

  • Apr 2017 - Apr 2018

  - Duties and responsibilities:• Prepares sales forecasts and collects and analyzes data to evaluate current sales goals.• Researches and evaluates current economic conditions that may affect the organization's ability to sell its products or services in the marketplace.• Assists in the development of sales quotas and forecasts for the sales team.• Recommends changes to current sales techniques, procedures or promotional efforts based on market research and new trends.• Analyzes sales and performance records, interprets results of overall sales• Collects, analyzes, evaluates and reports data to increase sales productivity.• Performs special projects as assigned by the Executive stakeholders.• Demonstrates the ability to handle multiple tasks with minimal supervision.• Creates reports that directly impact the running or servicing of the business.• Performs regular maintenance and updates to the reports.• Manipulates spreadsheets, such as formatting and formulas for productivity reports and sales graphs.• Audits data and reports for accuracy.• Any other miscellaneous duties as assigned.



Chalhoub Group

• United Arab Emirates
• Retail Luxury Goods and Jewelry
• 700 & Above Employee

• Fashion Brands Analyst (MK-Lacoste-Longchamp-ToryBurch)

  • Sep 2014 - Feb 2017

  The Role :The Brand Analyst is responsible for gathering, organizing and analyzing brand related statistical data, in addition to handling the buying process for the handled brands. Forecasting and Purchasing:Develop the framework of analysis and recommend inventory levels based on environmental parameters, seasonal forecasts and turnover of buying estimates Prepare purchase forecasts, purchase orders and track inventory levels Coordinate closely with the regional buying team to ensure fulfillment of the budget in term of purchase of all forecasted lines .Planning and Analysing: Prepare detailed sales performance reports for the designed brands: breakdown per outlet, per line, per reference. Develop a consolidated annual purchase plan for all handled brands. Generate advanced reports with cross analytical data based on market trends and marketing activities. Coordination: Generate or help develop tools to train shop floor teams on market trends of new collections. Willingly accept responsibility for work while keeping other people informed of progress and possible. Stock Management: Manage stock at hand to optimise the sell through of the collection to reach the agreed upon target. Responsible for re-orders if needed. Follow up on the margins of all products and report any discrepancy to Division Manager/Accounts. Manage old stock and study the amortization of the one year old stock and older stock and act upon it. Is responsible for positioning of the stock according to the flow and trends of each shop and accordingly advise on products’ transfer. Estimate the Points of Sales (POS) material needs (shopping bags / gift wrapping papers) in quantity and value. Validate the cost with the division manager and present it to Marketing Coordinator



Kane for import and distribution

• Janod Assistant brand manager & Retail analyst.

  • Oct 2013 - Aug 2014

  Kane is a sole distributor for educational toys as we have around 108 different items The range includes wooden puzzle, board games, musical instruments and educational magnetic boards, all of which are of the highest quality in the market.www.janod.comMain Functions:1-Supporting different clients during projects.In either case, typical tasks are likely to include:researching consumer markets, monitoring market trends and identifying potential areas in which to invest, based upon consumer needs and the pricing of products.2-Analysing the potential profitability and generating names for new and existing products and services, coming up with ideas for new packaging designs, including shape, size, colours and fonts.3-Ensuring the designs and messages meet the company brand and regulatory guidelines4-Monitoring product distribution and consumer reactions.5-Sales & stock analysis.



Rasport

• United States
• Retail Apparel and Fashion
• 1 - 100 Employee

• Quiksilver-Roxy & DC Merchandising manager

  • Mar 2012 - Aug 2013

  1-Planning the product range with the brand team;2- Forecasting sales using computer programs, in particular Excel; 3-Planning Delivery dates for ordered products.4- Controlling stock levels based on forecasts for the season to ensure the business has the optimum amount of stock; 5- Ensuring that best sellers are fully potentialised;6- Managing the distribution of stock; 7-Daily monitoring of stock in stores and warehouse. 8-Seasonal order planning. 9-Planning Delivery dates for ordered products.10- Responsible for all shops product requisitions. 11-Responsible for all stock transfer movements between all shops. 12-Weekly sales and stock reporting to the management



Toys R Us

• United States
• Retail
• 700 & Above Employee

• Buyer assistant

  • Jul 2010 - Mar 2012

  Controlling the replenishment activities regarding to category target inventory and sales level• Generating the new products in the system according to the buyers assortment planning• Generating import purchase orders• Following up with vendors on theآ purchase orders receipt• Ensuring category sales and inventory levels are matching with the category targets• Updating the system information with regards to pricing, barcodes, item numbers, descriptions, purchase orders prices and ETA dates• Providing overall merchandising support to the Buyer.



Omar Effendi

• Egypt
• Retail

• Sales analyst-product file supervisor

  • Jul 2007 - Feb 2010

  Purchasing Job purpose: Responsible for all product file maintenance, inventory and administration. Main functions: 1. Check all product file updates (new prices, new items, new deals, deletion of items, etc.). 2. Generate daily reports to check for errors and make necessary corrections. 3. Preparation and analysis of sales reports. 4. Support in updating plans monthly to reflect retail performance, including opportunities and risks, managing sales, inventory levels, and profitability. 5.problem analysis and problem-solving attention to detail and accuracyJob description:Am working as a product file supervisor & sales analyst in the purchasing department, my work including supervise and audit the data entering process for the product and the supplier (name, address, tax calculated, payment terms, change prices according to the promotion strategies), go through the product cycle starting from creating the items, ordering, picking to stores, delivery to the stores till stock rotation (reordering the product or transfer it among the stores or return it to the supplier), sales & coverage analysis through generating and exporting reports from the (RMS)&by using advanced excel functions(F-V.LOOKUP-PIVOT TABLE)on daily, monthly, yearly basis, problem analysis and problem-solving attention to detail and accuracy in order to know whether the product is slow moving item or fast moving depend on its point of sale which will be the very important factor in company decision making process for accelerating sales for the company welfare.



Spinneys Middle East-EGYPT

• Product file coordinator

  • Oct 2005 - Jun 2007

  1. Entering data related to the product and the supplier (name, address, tax calculated, and payment term 2. Checks all product file updates (new prices, new items, new deals, deletion of items, etc.). 3. Generates daily reports to check for errors and make necessary corrections 1. Entering data related to the product and the supplier (name, address, tax calculated, and payment term 2. Checks all product file updates (new prices, new items, new deals, deletion of items, etc.). 3. Generates daily reports to check for errors and make necessary corrections



OMS

• Egypt
• IT Services and IT Consulting
• 500 - 600 Employee

• Admin assistant

  • Jul 2005 - Aug 2005

  Its a temp. job,i was worked as an admin.assistant for only 1 month Its a temp. job,i was worked as an admin.assistant for only 1 month