Modern Trade Analyst UAE
Fine Hygienic Holding
Total years of experience :11 years, 10 Months
Role Summary: Reporting to the UAE Modern Trade Head, this position requires me to use
my analysis and reporting skills to the full extend with consistence and quality, publishing
various daily, weekly and monthly sales reports, working together with the key account
executives and on a daily basis for the various marketing activations and follow ups and
collaborating with the various internal departments, viz. the Category team, Finance, Digital
Transformation, IT, MS&P & Production etc.Fine follows the APAP (Availability, Presence,
Activation& Pricing) principle across all customers
• Creating a detailed business analysis, outlining problems, opportunities, and solutions for
the modern trade business
• Developed the MSL score tracking system for the modern trade team
• Enhanced the templates used for daily sales reporting
• Preparation of all kinds of Ad-Hoc reports as asked by the management
• Analysis and reporting on the Carrefour sell-out data and Lulu sell-out data
• Handling the promo price dashboard analysing the competition pricing in the market
• Developed scorecard to measure the Bricks & Clicks performance (Retailer’s ecommerce platform)
• Successfully replaced the pack shots and contents of all products across retailer’s online
platform (Carrefour, Lulu, Union Coop, Nesto etc)
• Coordinating with the e-commerce department of retailers for the monthly promotion
participations
• Coordinating with the sales team for the promotional stock forecast weekly and monthly
basis and subsequent planning with the production planning team
• Consistent follow-up with the sales team on the listing updates and data requirements
from retailers
• Identifying the root causes and facilitating to resolve the problems in cases of logistic
issues, out of stock issues, permit issues etc
• Working together with the Trade Marketing and Sales team for the implementation of
various marketing campaigns and reporting on the ROI
• Handling the Journey plan of the merchandisers and monitoring the call compliance score
• Working together with the central IT team on various projects: Digital Merchandising
tool (Vispera), Salesforce implementation, APAP BI dashboard implementation and MSL
score automation
Handles all modes of communication with the company suppliers across the globe Responsible for finalizing the order forecast with the management, approval of the budget with the finance team, placing the orders, negotiations, finalizing the order and ensuring close monitoring of the shipping phase until the stock arrives at the office. Being the first point of contact for all matters related to the suppliers(Technical, financial, marketing related and non-technical) and diligently allocating the matters to the respective departments in the company Negotiating for the optimization of shipping cost percentage by planning the order quantities efficiently Documentation of all the activities related to Purchase, payment transfer, order confirmation, shipping, clearance and delivery Handles stock replenishment and maintenance process communication to the retail stores(Virgin Mega stores, IMG, Dubai duty free, ELC, Mumz world etc) Monitors the availability and flow of the various products in each POS and generate forecasted reports as per the parameters devised by the Management Setting the reorder levels for the various products in each stores based on the space availability, sales forecasts, competition and market demand. Ensures the proposals for replenishments will optimize turnover and profitability. Follows-up with retailers for the purchase orders based on the replenishment request Preparation of cost calculation sheet for the products from the purchase price to arrive at the RRP factoring the company margin, shipment cost and retailer margin Liaises with the Logistics Department for system entries and shipment handling steps i.e. tally the invoice with physical goods received. Coordinates with the Merchandising Department regarding stock delivery dates in order to arrange merchandising visit and ensure the correct/ timely display of new arrivals with the support of P.O.S team.
Responsible for the data analysis and MIS reporting activities of the Billing complaints team in the Enterprise& SMB department Designed and implemented the dashboards for the MIS reporting of the daily complaints inflow, daily closure and pending status Tracking the various KPIs to measure the team performance and efficiency and the data reporting to senior management Actively participated in the backend investigation of billing complaints reported from the various front end channels of Etisalat ensuring high level of customer experience at all stages Taking the ownership of a complaint from the creation until the complete resolution of the issue Identifying the root cause of the overbilling complaints in coordination with the various stakeholders (Engineering, IT, Processing and Delivery, Product development, Sales and Marketing) and the further follow-up for the issue fix and alignment with Finance team for the eligible refund calculation Daily reports for complaints monitoring, weekly management presentations and monthly reports Weekly analysis of the “Customer Effort survey” results identifying the gap areas and recommendations for further improvement Monthly study of the overall complaints to identify the top issues and the presentation of the results to senior management
2: Coordinator-Credit Risk &Operations: Etisalat \[December2016-July2018\]: Working in the Consumer-Credit Risk&Operations department and responsible for implementing various strategies to monitor the credit exposure of post-paid consumer customers and to take necessary dunning actions (disconnection of service) wherever breaches from the business rules are identified
Job Responsibilities: Planning, implementation and tracking of the various credit control activities of consumer post paid products: invoice non-payment dunning, credit limit dunning, high usages during roaming, fraud usages, promise to pay dunning, registration expiry dunning etc. Jimson John Data Analyst-Complaints Management 6 years experience Indian, Male +971-528990438 jimsonjohn55@gmail.com LinkedIn ID: www.linkedin.com/in/jimsonjohn55
Page 2 of 4
Responsible for the movement of post paid accounts to their subsequent stages of lifecycle until cessation if eligible for dunning action based on non-payment of monthly bills. Coordination with IT for the identification of invoice defaulted accounts and planning the dunning actions across the month based on the business rules and management requirement. Tracking the hourly alarms generated for the Credit limit breaches and high usages while roaming. Identification of registration expired customers on a daily basis and coordination with various teams for exclusions, notifications and taking actions as per the TRA mandate. Coordination with fraud management teams for the alarms generated with fraud usages in UAE or outside. Working together with the front office teams: 101, BPO partners etc to forecast and finalize the dunning counts for each day since the dunning actions will result in customer escalations. Responsible for the MIS reporting of all dunning activities through various daily weekly and monthly dashboards. Follow up with multiple departments: Sales and marketing, BPO partners, Service recovery team, Business intelligence team, VIP, SMB, enterprise teams as per the business requirements. Performing RCA of the rejections and failures from the dunning activities and presenting the results to management. Analysis and reporting of payment trends after the invoice dunning actions. Preparation of various summaries and dashboards from the dunning files, payment files, complaints log etc. Daily Dunning activity tracker (Rejection, processed & unprocessed cases). Daily Non Payment Cessation report Category and Action wise tracker. Maintenance of Exclusion database for HC & dunning activities. Weekly Presentation preparation for high consumption and dunning trends. Preparation of various ad hoc reports as per the management requirement
I have done coordination and operations management activities in IT industry.Have experience in timesheets data, SAP timesheets module, Projects billing, estimation, forecasting, budgetting, EVM management methodology, scrum methodology, project audits, project reviews and project updates.
Weekly and monthly MIS reporting, Microsoft office tools, Excel functions and formulas, administrational activities, SAP timesheets module leader
I have done installation and commissioning of telecom equipments.