Experience

Al Wefag Trading & Manufacturing Co. Ltd

• Saudi Arabia
• Food & Beverages
• 100 - 200 Employee

• Sales Support & Performance Analyst

  • Oct 2019 - Present

  · Sales KPI dashboard including including all sales and incentive parameter (Sales & Achievement, Distribution, Sales Priority, Zero Sales Analysis, Invoice Productivity). · Sales target for salesman and their target contribution in the branch as per SKU distibution. · Demand target as per SKU wise and channel wise target & branch wise. · SKU & brand wise sales contribution as per branch wise and entire KSA. · DS, MT & WS customer contract as per their criteria (space for visibility & sales and achievement). · Base calculation for contract monthly incentive percentage, space rental, payment percent as per sales, core sku distribution achievement monthly percentage. · Customer route plan versus customer in oracle and update journey plan for the salesman, marchandiser and their supervisor. · New salesman praparation for their creating salesbuzz code, KML for route & journey plan. · Weekly & monthly review salesman detail in salesbuzz. (Category of Salesman, out of visit, out of visit order, & visit with GPS). · Workplan for the sales team (Van Salesman, WS Salesman, MT Salesman, Mechandiser & their superviser & unit manager as per their KPI & distribution of the KPI points). · TT sales meeting review monthly. (All review calculated branch wise growth, KPI achievement, Gap Vs Par, performance of the contracts. · Dashboard with all salesman perfomance. · Issue credit limit for salesman and customer as per their limit. (Grocery A & Grocery B) Show less



Kimberly-Clark

• United States
• Manufacturing
• 700 & Above Employee

• Sr. MIS Officer

  • Apr 2018 - Jul 2019

  · Primary sales, secondary sales & promotional trackers sales report on daily basis. · Weekly Report - Fundamental Report, Infrastructure Report, Huddle Call Template, WS & Sub Distributor Tracker Report. · General trade monthly review presentation for MD & trade managers meeting. · All master file for the sales team by MOC & months – PSR Master, Primary Master, Sales Fundamental Report, GPS Varience, Order Vs Invoice, Export Master, Rout coverage master & throuput sales master. · Purchase requisition in SAP for the vendor and creating SE & GR for sales team. · All master for KCL sales file & HUL sales report on monthly basis. · Performance report for the entire sales team from salesman to state sales manager as per their criteria for incentive. · Working on callage (No of Calls), productive calls, attendance, GPS varience, Eco, DRCP master for DSR/SE & SSM level. · Addhoc report required by trade manager & customer develeopment manager as per their requirement. · Extracting data from multiple sources from HUL Bex, KCL Bex, SAP, DMS for making reports. · MSS report for the Chemist Stores for specific SKU have highest contribution as per state. · Calendar for TTS report SKU category wise contribution as per state after rollout & before rollout comparision (Sellience) & growth. · Channel wise display plan and scheme and their spent. · Town wise Sub Distributor sales report with city wise population to take decision to start direct distributor. · Chemist display and TOT & NMT display & TOT with their margin and performance. Show less



Al Wefag Trading & Manufacturing Co. Ltd

• Saudi Arabia
• Food & Beverages
• 100 - 200 Employee

• Sales Development Officer

  • Oct 2016 - Oct 2017

  · Forcaste SKU report by channel and by branch, creating report for estimation of achievement as per commited by the supervisor and unit managers. · Daily sales report for sales team and top management to track their target vs achievement (Priority, Performance and Promotion). · Monthly one pager scorecard for the modern trade customer which is contain all progress of MTD and YTD by brand and category. · Wholesale contract and direct trade contract report and their progress and criteria as per mentioned in the contract like target vs achievement, visibility and space. · Standard target, channel target & split target for wholesale, modern trade and direct trade for sales man and creating daily wise standard product order for them, uploading all target into SQL server and making changes as per requirement. · Route plan for sales man and suprerviser, visit frequency, new customer creation, changing customer channel as per required and creating KML file if required. · Reporting data as per tranfer made by the management and update route plan according to salesbuzz software and oracle. · Performance of the promotion run by the company and make as changes as per customer class working on competitor promotion and activity. · Unit manager & supervisor time plan as required by the country manager. · Report for supervisor visit and salesman visit to track the supervisor and saleman to make sure they should visit the key account customer as per plan and take order as target. · Factory PVP report contain KPI, line effieciency, breakdown time, machine speed. Show less



Colgate-Palmolive

• United States
• Manufacturing
• 700 & Above Employee

• Management Information System Analyst

  • Nov 2014 - Nov 2016

  · DPR Branch, DPR-CDO, CDO booklet, monthly progress report & RM-BM meet report which contain all performance of the CDO’s and stockist. · Activity tracker report weekly or monthly, ERC, KPI, activation scheme and allocation for the branch & scheme performance as segment wise. · All payouts and addition scheme and its payout of the according to scheme wise. · RDST, PSR, HN1, Phasing data and step earning reports monthly wise. · Branch dashboard, SKU level data, OCC, RSS, & other sales data & MTD, YTD, L3M, & L6M data as per requirement. · Van subsidy in every quarter which is the payout of Stockiest man power & van expenses & special merchandiser subsidy. · RE change data & addition of store and Stockiest to be added in the list updating of stores & van subsidy route. · Non Purchase store list, Billing data and repetition of Stockiest billing for focus brand. · Brand wise, RE Channel, Segment progressive report for the monthly and weekly. · Budgeting forecast report for every month Brand & SKU wise. · All budget for the branch (scheme spent, visibility budget, subsidy budget, activity budget, additional scheme budget and institutional order budget). Show less



Bharat Petroleum Corporation Limited

• India
• Oil and Gas
• 700 & Above Employee

• MIS Analyst

  • Sep 2012 - Aug 2014

  • All India outlet inspection report based on varience of petrol & deasel through the analysis of consumption by sales. • Retail automation data with analysis of outlet performance NANO with manual sales done by the dealer or operator. • SMS data which is sent to the bulk customer for their knowledge for how much petrol and diesel purchased by him, and we are remove the duplicate through the formulas and we kept all duplicate entry for the management. • All India credit card transaction report, this report indicate the entire country sale through the credit cards with we are specified all sale according to bank like how much sale done through the HDFC or ICICI etc. • BROMA award report for the management, this report belong to the operator and territory manager and engineer performance Show less



Future Group India

• India
• Manufacturing
• 700 & Above Employee

• MIS Analyst

  • Sep 2010 - Aug 2011

  · Supervising project of future group's private brand named Sach by Sachin Tendulkar. · Handling 50 sales promoters on 50 different locations in all over India at Big Bazaar or Food Bazaar and to meet personally to every promoter to check their efficiency and product knowledge and motivate them for achieving their target. · MIS report on target based achievement on daily basis or weekly and monthly and send it to management so that management can take effective decision on time. · Large data received from private brand & making analysis of individual performance of promoter as per SKU wise and other analysis. Show less