Business Analyst- Liquor Division
Spinneys Abu Dhabi LLC
Total years of experience :14 years, 6 Months
Spinneys Abu Dhabi LLC, Abu Dhabi, UAE
Business Analyst- Liquor Division (Jul 2008 till date)
Job Profile:
Reporting to the General Manager and Finance Controller responsible for preparation of Monthly Management Reports and Presentation docket to the Senior Management
KPI for the company on quarterly basis
Various business measuring Reports on Depletion, Margin, Agency, Top X Reports, Forecast accuracy reports & Brand Analysis
Supporting the total business on daily basis to measure the performance and suggest the management for pro-active steps by providing gap analysis, flag pole chart etc.
Making strategies on key areas to increase revenue and profit
Finalizing promotion mechanism with Inventory Controller, Brand & Retail Manager
Price & Cost Analysis, Stock Ageing Analysis including Reviews
Monthly Product Forecast Review for the stores and finalizing with Inventory controller
Depletion reports to the Major Agencies with Comments
Volume, Revenue and GP Budget - Working till Finalization with the Senior Management
Forecast workings with Key Account Managers
Achievements:
• Setting up tableau in the business environment and making dashboards with the Key Information by company level and for different departments and categories
• Introduced Monthly Product Forecast Format for the Division and successfully implemented
• Strategy made and successfully implemented to push people for applying liquor license with incentive scheme with customer retention plan
• Introduced daily liquor license tracker
• Implemented successfully new budget format since 7 years (2009 till now) and improved the budget formats from Value & GP to Volume, Value & GP by product level
• Maintaining the required database for the company and provided access to the team in their relevant area
• Knowledge sharing on MS-Excel and presentation skills with the team
• Initiated Group, Sub-Group level data clean up and leading the team on distribution audit data base first time in the company
• Core team member in business data conversion from Sage to Oracle and Oracle to AX
• Leading the team at present in data cubes for our new business tool setup
Kamal Osman Jamjoom Est, Dubai, UAE
MIS Coordinator (Dec 2006 Jun 2008)
Job Profile: * Reported to the Group IT Manager & Retail Managers, responsible for preparation of KPI and various fortnightly MIS Reports on Sales, Margin & Customer Analysis
* Configuring the promotion mechanism in the system in the Head Office, Price Management, Mark Up and Mark Down analysis and Stock Ageing Analysis including Reviews
* Monitoring the promotional issues with the store and coordinating with the Merchandising Team for streamlining various functions and Operations
* Recognized for restructuring the entire MIS Reporting with generating more Business and effective KPI Systems.
* Core member in handling Inventory Control Management providing suggestions for improvizations of Stock accuracy and ensuring Variance Reduction by 2% from 15%.
* Successfully defined Processes and Policies for 50% of the IT Activities in the Group.
Tata Tele Services, Chennai, India
Assistant Manager MIS - TamilNadu, Kerala, Karnataka & AP Circles (Jan 2006 to Sep 2006)
Job Profile: * Led a team of 4, reported to the General Manager / Regional Director, responsible for finalization of Sales Budgets with Regional Head of TamilNadu & Kerala.
* Analysis & Review of Daily Activations for Corporate & SME Segments, preparation of fortnightly reports on MIS & KPI - Key Performance Indicators.
* Review of the Monthly Meet & Corporate Meet Presentations on EBG performance, analyzing account wise revenue details for EBG and Number Management & Control for EBG segment.
* Instrumental in introducing a new format for MIS - Management Information System and a Revenue Analysis for the Region.
Landmark Central Market Co., Kuwait
(BABY SHOP, SHOE MART, SPLASH, HOME CENTRE & LIFESTYLE CONCEPTS)
MIS Coordinator (Jul 2000 to Jan 2006) and Accountant (Jul 2000 to Jun 2002)
Job Profile: * Led a team of one Executive, reported to the CEO / Senior Finance Manager, responsible for preparation of Purchase, Sales Budgets for the Territory for all Concepts.
* Finalizing Sales, Stock & Purchase related numbers in the financial budget in co-ordination with finance manager and COO of the territory.
* Monitoring the stock levels and providing suggestions for business decisions.
* Preparation of MIS & KPI Reports, Monthly Review of Margin Analysis for the Territory during Sales & Discounts and Preparation of Break Even Analysis for new Project Proposal.
* Handled Reconciliation of accounts with Corporate Office Books, Payroll, Overtime, and Leave Salary & Final Settlements for the Employees.
* Monitoring Bank Reconciliation Statement, checking Daily Sales Report, Sales Accounting, Monthly closing with Reconciliation, Reconciliation of Debtors.
* Successfully finalized Sales, Purchase & Budgets for the Territory with the Concept Directors in the Corporate Office.
* Recognized and appreciated as a Star Performer by the Management.
Integrated Stock Broking Services Pvt. Ltd. (MRF Group), Chennai, India
Accounts Executive (Dec 1999 to Jun 2000)
Job Profile: * Monthly Reconciliations of Branch Accounts, MIS, Liaisoning with Auditors, Coordination with Branch Offices and Review of Reconciliation of Branch Accounts.
Sanjay Sales Corporation, Chennai, India
Accountant (May 1998 to Nov 1999)
Job Profile: * Monthly Reconciliations of Branch Accounts, Payroll, Accounts Closure, MIS, Liaisoning with Auditors, Coordination with Branch Offices and Review of Reconciliation of Branch Accounts.
Bachelor of Commerce (Accounts / Tax) from RKM Vivekananda College, Chennai, India (1998) . Affiliated to University of Madras Trainings Project Management Time Management ~ Stress Management ~ Conflict Management ~ Team Simulation & Management Individual Role in a Team ~ Effective Communication Personal Particulars Languges Known: English, Hindi, Tamil, Malayalam and Telegu Passport No.: G2654180 Holder of Clean UAE Driving License Transferable Residence Visa