Reagan Aranjo, Asst Category Manager

Reagan Aranjo

Asst Category Manager

Trolley Convenience Store

Location
Kuwait - Hawali
Education
Bachelor's degree, Accounts
Experience
16 years, 1 Months

Share My Profile

Block User


Work Experience

Total years of experience :16 years, 1 Months

Asst Category Manager at Trolley Convenience Store
  • Kuwait - Al Kuwait
  • My current job since January 2021

DAILY ASSIGNMENT

• AVAILABILITY REPORT AT WAREHOUSE & STORES FOR BEST SELLERS, LOCATION WISE, CIGARETTES & VAPES

• DERIVE STOCK COVER FOR 1 DAY & 3 DAYS ACROSS ALL STORES BASED ON LAST 30 DAYS SALES

• MANAGE STOCKS FOR NEW STORE OPENING

• VENDOR NEGOTIATION / FOLLOWUP

WEEKLY ASSIGNMENT

• RESOLVE OOS / OVERSTOCK / NEAR EXPIRY SITUATION

• TOP 80-20 ITEMS BASED ON QTY SOLD, VALUE & MARGIN

• RECOMMEND TO ACTIVATE / DEACTIVATE ITEMS BASED ON SALES MOVEMENT

• OOS / PENDING ORDER QTY - TO FOLLOW UP ON DELIVERIES WITH SUPPLIER

MONTHLY ASSIGNMENT

• RANGE REVIEW BASED ON 80-20 & NON PERFORMING ITEMS

• VENDOR CREATION / VENDOR AMENDMENT - INTRODUCE OR UPDATE TERMS OF EXISTING VENDOR

• PLANOGRAM - DISPLAY BEST SELLERS BASED ON SELLOUT, CUSTOMER PROFILE, SUPPLIER AGREEMENT

• STORE VISITS

OTHER ADHOC TASKS BASED ON MANAGEMENT REQUIREMENTS

Buying Coordinator at X-cite Alghanim Electronics
  • Kuwait - Al Kuwait
  • April 2019 to January 2021

DAILY ASSIGNMENT

• KVI REPORT - COMPETITION TRACKING FOR TOP 80 SKU’S
• DAILY STOCK RECEIPTS - COMMUNICATE TO SHOWROOMS OF NEW ARRIVALS AT OUR WAREHOUSE
• ONLINE ENRICHMENT - RECTIFY / ENHANCE / ENRICH WEBSITE WITH ADVANCED FEATURES / SPECS
• MARKETING / SOCIAL MEDIA - HIGHLIGHT SPECIAL DEALS FOR MARKETING ON SOCIAL MEDIA
• SAFETY STOCKS, PR, PO, ARTICLE CREATION, VISTEX CREATION IN SAP, VENDOR NEGOTIATION / FOLLOWUP
• PRICING MEMO - UPDATE COST, STICKER, CASH, CASH SPECIAL PRICES
• MASTER DATA MANAGEMENT - ACTIVATE, DISCONTINUE, ARTICLE EXTENSION, VENDOR EXTENSION

WEEKLY ASSIGNMENT

• MARKETING ACTIVITY TRACKER - FLYER, DIGITAL OR SOCIAL MEDIA SELLOUT ANALYSIS
• DISCONTINUED SKU’S - TO PHASE OUT DISCONTINUED MODEL AND INTRODUCE SUCCESSOR MODEL
• ACTIVE SKU’S AVAILABILITY - ANALYZE BRAND & CATEGORY MIX
• OOS / PENDING ORDER QTY - TO FOLLOW UP ON DELIVERIES WITH SUPPLIER
• PSI & SKU STATUS - TOTAL RANGE (ACTIVE & DISCONTINUED WITH SUPPLIER SUPPORT)
• RANGE COMPARISON - RANGE COMPARISON WITH COMPETITOR
• MARKET VISIT - SHOWROOM AND COMPETITION VISITS

MONTHLY ASSIGNMENT

• COMPETITION PRICE BENCHMARK - APPLE TO APPLE COMPARISON WITH COMPETITOR
• OPEN ORDER QTY - TO CLOSE OPEN ORDER QTY IN THE SYSTEM
• FOREIGN PI TRACKER - MONITOR PLANNED ARRIVALS FROM THE DATE OF RFQ
• DENTED RETURNS / RPO - FOLLOW UP WITH SUPPLIERS TO COLLECT THEIR RETURNS
• VENDOR CREATION / VENDOR AMENDMENT - INTRODUCE OR UPDATE TERMS OF EXISTING VENDOR
• SUPPLIER MANAGEMENT REBATE SLABS - ACHIEVEMENT BASED ON CONTRACTUAL TERMS
• AGEING TRACKER - TO LIQUIDATE AGEING STOCKS (CURRENT + INCOMING)
• PLANOGRAM - DISPLAY MODELS BASED ON SELLOUT, CUSTOMER PROFILE, SUPPLIER AGREEMENT
• LOCAL PURCHASE PLAN - FORECAST ORDERS BASED ON SALES HISTORY & MAINTAIN STOCK COVER

OTHER ADHOC TASKS BASED ON MANAGEMENT REQUIREMENTS

Stock Control Officer at The Sultan Center
  • Kuwait - Al Farawaniyah
  • November 2016 to April 2019

Managing warehouse deliveries to all stores in kuwait & ensure availability of items at all stores through Auto - Replenishment
Prepare exceptional reports so as to ensure smooth functioning of auto - replenishment as per SIM (Store Inventory Management), SOS (Store Ordering System) & RMS (Retail Merchanising System)
Manage daily, weekly, monthly & quarterly tasks

Admin - Receiver at The Sultan Center
  • Kuwait - Hawali
  • December 2014 to October 2016

Entering all the invoices which are received throughout the day
Receiving supplier items using radio frequency guns
Returning expired / damaged items to suppliers

Senior Customer Service at Serco Global Services
  • India - Mumbai
  • July 2014 to December 2014

PERFORMING ALL MANDATORY CHECKS AS PER GUIDELINES PROVIDED BY BARCLAYS

OUT-CALLING SOLICITORS, ADVISORS OR APPLICANTS FOR MORTGAGE APPLICATIONS WHERE IT IS REQUIRED TO CONFIRM DETAILS

AMENDING CUSTOMER DATA IF REQUIRED ON BARCLAYS SECURE BROWER PORTAL & CUSTOMER GATEWAY

Logistics Officer / Purchase Supervisor at Karam Services
  • Qatar - Doha
  • November 2008 to December 2012

MANAGING STOCKS OF ITEMS IN OUR STORE, SUPPLIERS PAYMENT / ACCOUNTS INQUIRY, ARRANGEMENTS OF URGENT ITEMS (ELECTRICAL / MAINTENANCE WORKS, TOOLS, NEW PROJECT MOBILIZATION, UNIFORM ORDERS, BEDDINGS OR BUNKER REQUEST, STATIONERY ORDERS, PRINTERS, CARTRIDGES, RAMADHAN SPECIAL ORDERS ETC.), MY LOGISTICS STAFF & STAFF TIMESHEET

ORGANISE FRESH FRUITS & VEGETABLE DELIVERY SCHEDULE TO 6 LOCATIONS, DELIVERY SCHEDULE OF OUR LOGISTICS CHILLER VAN, SCHEDULE OF STORE TIMINGS & WHEN APPLICABLE ISSUE MEMO’S

AS PER REQUISITONS FROM STOREKEEPER’S / SUPERVISOR’S, ARRANGE QUOTATIONS FROM SUPPLIERS, SELECT THE COST EFFECTIVE SUPPLIER TAKNG INTO CONSIDERATION THE QUALITY AS WELL, GENERATE LOCAL / MANUAL PURCHASE ORDER AS PER ENTERPRISE RESOURCE PLANING (ERP) SYSTEM, FAX TO SUPPLIER & FOLLOW-UP ON ITEMS WHETHER RECEIVED OR NOT

PREPARE PURCHASE HISTORY REPORTS ALONGWITH CURRENT COST FOR ALL ITEMS

PREPARE REPORT ON CONSOLIDATED PURCHASE REQUEST FOR FOLLOWING MONTH, STOCK IN HAND & CONSUMPTION AS ON 25TH OF CURRENT MONTH FOR 5 LOCATIONS ALONGWITH CURRENT COST FOR FINANCE MANAGER & COUNTRY MANAGER

PREPARE REPORT ON PRICE COMPARISON ON BULK PURCHASED ITEMS BETWEEN LAST MONTH WITH CURRENT MONTH AND PREPARE SAVING OR LOSING RATIO

PREPARE REPORTS IF ANY ON OVER - STOCKED ITEMS, SLOW - MOVING AS WELL AS NEAR EXPIRY ITEM

INITIATING & INTRODUCING NEW SUPPLIERS, PREPARE SUPPLIERS AGREEMENTS & RENEWAL OR TERMINATION OF CONTRACT, PRICE NEGOTIATIONS WITH SUPPLIERS, PREPARE OUTSTANDING PAYMENTS WITH CREDIT PERIOD, CREDIT AMOUNT, ITEMS THEY SUPPLY, PREPARE ACCOUNTS PAYABLE REPORT EVERY MONTH END IN CO-ORDINATION WITH THE FINANCE MANAGER

PREPARE TENDER PRICING FOR FOOD, CLEANING & DISPOSABLE ITEMS, COMMISSARY ITEMS, SMALL EQUIPMENTS, KITCHEN EQUIPMENTS, CUTLERIES & ASSETS IN CO-ORDINATION WITH SR. OPERATIONS MANAGER

SOLELY REPRESENTED AS AN ISO CO-ORDINATOR FOR PURCHASE & LOGISTICS DEPARTMENT

Computer Operator at G. K. B OPTOLABS PVT. LTD.
  • India - Mumbai
  • July 2008 to November 2008

GENERATE REPORTS OVER FOOTFALL, CONVERSION, GROSS SALES, VAT & NET SALES ON DAILY BASIS ALSO MONTHLY SALES REPORT TO BE SENT VIA EMAIL TO GENERAL MANAGER

MONTHLY TARGET REPORTS ON PERFORMANCE OF EACH EMPLOYEE TO HEAD OFFICE

MAINTAIN RECORDS LIKE ELECTRICITY BILLS, WATER BILLS, CASH DEPOSIT FOR PROCEEDS OF PREVIOUS DAY, PETTY CASH ETC

HANDLE CUSTOMER GREVIANCES SO THAT CUSTOMER SATISFACTION IS MAINTAINED

GENERATE INVOICES ON PURCHASE OF ITEMS

Training Assistant at Efunds International
  • India - Mumbai
  • June 2005 to February 2007

ROOM BOOKING FOR TRAINING PURPOSES AT 3 SITES THROUGH ROOM BOOKING SYSTEM

ADMIN FORM I.E. MEAL ARRANGEMENTS AS WELL AS DROP FACILITY FOR THE TRAINEES & TRAINERS DURING TRAINING

EMPLOYEE MANAGEMENT SYSTEM I.E. EMS
TRACK OF NEW EMPLOYEES WHO HAVE JOINED AS WELL AS QUIT THE ORGANISATION

ATTENDANCE MANAGEMENT SYSTEM I.E. AMS
UPDATING THE WEEKLY OFFS OR ANY OFFS DURING THE WEEK FOR TRAINERS AS WELL AS TRAINEES

AUDIT CHECK SINCE THE AUDITORS KEEP A QUALITY CHECK EVERY MONTH

MAINTAINING REGISTERS FOR HEADPHONES, CD'S, VHS, CANDIES, TRAINEE MANUALS, TRAINERS MANUALS ETC

CO-ORDINATING WITH ADMIN TEAM, H.R. TEAM, ACCOUNTS TEAM AS WELL AS BAT TEAM WITH RESPECTIVE ISSUES IF ANY

Education

Bachelor's degree, Accounts
  • at University Of Mumbai
  • March 2004

First Class

Specialties & Skills

Accounting
Computer savvy
Category Management
Reporting
Purchasing
Quick Learner
Teamwork
Meeting Deadlines
Communication

Languages

English
Expert

Training and Certifications

ISO 22000 : 2005 Food Safety Management (Certificate)
Date Attended:
November 2009
Six Sigma Yellow Belt (Certificate)
Date Attended:
March 2023

Hobbies

  • Cricket, Carrom & Chess
    Participated Inter collegiate carrom tournament