Working as a Data Analyst in Trade Marketing Dept.(S&D Food Service) for GCC. Working for mentioned GCC countries KSA, KWT, UAE, Oman & other countries.  Preparing forecast Baselines on the basis of sales trend for GCC and other countries. Having discussion with sales team to update and confirm the forecast for MT. Preparing Forecast Accuracy % report on country, category, channel level. Preparing Forecast Accuracy % report on SKU level to analysis forecast accuracy. Preparing MGR (Monthly Gap Review) working file as well as presentation for MGR meeting which will show the gap for Actual vs AOP & CY vs LY, YTD as well as MTDfor all countries on product group, product subgroup, sub channel level with top performing SKU and top customers.  Writing MOM for the MGR meeting and circulating it to the teams to get an update on it. Preparing DRM (Demand Review Meeting) working file as well as presentation which will show the gap for AOP vs estimated closing sales for full year on channel, Product group,Product sub group level with LY, CY Actual vs AOP & CY Actual vs FC achievement %. Discuss with sales team for near expiry stock liquidation and follow up on it. Maintain the contract details in format of hard copy and soft copy. Send the reminder mail to the sales team for expiring contract to get it renew. Preparing sales report on country, Product group, Prod. Sub group, Channel, Sub channel level with Growth/De-growth for Actual vs AOP and Actual vs FC MTD. Preparing an exception reports as per the manger’s requirement to analyse it.▪ Preparing Flour tracker to increase or achieve Flour AOP MT sales number.▪ Preparing Business opportunity pipeline report to track the new opportunities & status for it to generate further business.▪ Conducting Weekly Leadership meeting with sales team to analyze sales gap numbers & prepare plan ahead accordingly to reach the AOP numbers .

Working as Data Administrator in Trade Marketing Dept.(S&D Retail)Handling Frozen, Pasta, IFFCO-Beauty, Beverage 1. Creating Trade Marketing Investment plan.2. Creating modifiers to update the price off & promotions.3. Doing Budget Re-allocation.4. Creating sales intervention plan5. Preparing TMI report monthly basis6. Preparing Sales budget vs actual report.7.Analysing the sales & TMI data8. Preparing Sales & Rebates report budget vs actual.9. Preparing the Daily sales report category wise.10. Preparing the weekly, monthly, MTD,YTD comparision reports category & customer wise.11. Additional reports as per manager's requirements.

Data Analyst:Job Description: Taking Sales and GP report daily, weekly and MTD,YTD and comparing with target sales and Shortfall and Growth / D-Growth and find the reason of D-growth. Sales and purchase report and analyzing the behaviour. Communicating above analysis report to related department. Weekend promotion sales, GP, contribution of items sales quantity and sales amount with stock and analyzing the behaviour of promotion for future budget & Sale on promo and non-promo lines Taking report on lost sales on items, non-moving items, slow moving items to highlight and forward to stores. Taking Ageing report, stock report weekly and monthly and communicating the issue to category heads. Bifurcating given sales budget in to category and MTD and fixing Target GP % for given Sales budget.  Creating purchase budget monthly vendor wise , category wise, as per holding current stock. Analyzing Negative Selling lines and forward to stores to take proper action after found the reason. Working on negative GP lines and correcting using right tools. Analyzing Inventory turnover , inventory in days , optimal level of inventory , calculating variance from optimal level of inventory on monthly basis with sales & GP category and division for senior management.  Comparing Daily, Weekly, MTD Waste for Butchery, F&V, Fishery against purchase for making right decision. Taking an exception reports and analyzing how and where sale & GP, inventory is loosed. Generating Top 50 selling lines and Top 50 categories to be provided to store management  Telephone card stock tracking to maintain on daily basis Analyzing Selling Price structure with inventory and provide to update the RSP to category heads  Making monthly Incentive report for store’s staff with budget and achieved sales and provide to HR to get the incentive for staff.