Mervin George Kollannoor

• Responsible for the day-to-day administration of various functions within the Equilibrium Group companies including business administration, human resources, marketing, IT, accounts and logistics.
• Responsible for managing the Group websites and social media platforms and for liaising with web designers and IT companies.
• Provides accounts assistance including price monitoring, expense and revenue forecasting, VAT returns, petty cash reconciliation and annual account submissions.
• Assists with the design and development of sales and marketing collateral including brochures, flyers, packaging, branded materials, logos and exhibition displays.
• Working for the 5 group companies - Equilibrium Engineering Consultancy, Equilibrium Equipment Trading, Khaleej Bakeries & Pastries, House of Treasures, Street Nine Restaurant

• Provided consultation and mentoring services to students and parents to improve the child’s studying pattern with the help of Curriculum-based Learning App for Science and Maths.

• Enrolled students to the App based on their interests and by analysing their capacity through an aptitude test.

• Helping the Category Manager for Procurement related activities and Logistics to our store.
• Taking quotations from forwarders, calculating margins, and creating purchase orders and proceeding with the logistics of the shipment to our store.
• Following with our Accountants regarding payments and Clearing agent to get the shipment cleared and duties paid.
• Tracking and following up on the material readiness and expediting shipment pickup with our suppliers and forwarders.
• Evaluating freight invoices and confirming the landed cost and comparing the quotations and settling disputes with forwarders regarding invoicing and entering into the ERP system.
• Coordinating with the store staff and informing arrival dates and prioritizing on shipments that are urgent and needs to get GRN’ed into the system and displayed on the shop floor.
• Getting RMA confirmations from suppliers and management and doing the needful returns in situations of faulty or damaged products.
• Reviewing contracts of suppliers and advising renewals on expiry and following up on originals.
• Listing items in the ERP system with correct cost prices and tag prices and naming methodology.
• Helping the Social media coordinator with Photoshop skills.
• Approaching new suppliers and discussing possibilities of new business opportunities as advised by the Category Manager.
• Sending Weekly Sales Report and Forecasting Trends and taking approvals from Category Manager and proceeding with replenishment orders.

• Ensure support for documentation of import and export of Jewellery. Scheduling Jewellery export with Etihad Cargo Services and coordinating- Ensure support for documentation of import and export of Jewellery. Scheduling Jewellery export with Etihad Cargo Services and coordinating with the PRO for the needful.
• Entering Jewellery records into the ERP system (Ace Gold) and tagging the purchased Jewellery. Creating price lists for the Jewellery when items come on consignment basis.
• Preparing sales report at the end of every month and informing suppliers and entering invoices received into the system. Communicates with suppliers through emails and phones calls for all day to day needs.
• Oversee Human Resource related documents, such as Salary Certificate, Leave Application and resumption forms, Employee tickets for annual vacation, Vacation Planner, updating employee Salary details in master list.
• Ordering of spare parts for watch repair. Ordering Jewellery as per customer needs and for stock purpose. Registering and updating them in the Purchase Order Registry for everyone to view the status of orders.
• Preparing LPOs / documentation for Stock purchases of Jewellery and delivering as per the Sales staff requirements. Prepared quotations for tenders and invoices for clients.
• Arranging documentation for Jewellery Exhibitions attended by us in Abu Dhabi, Dubai and Sharjah.
• Prepares documents for renewal of staff health card, health insurance claim, CCTV maintenance, alarm system.
• Attended Abu Dhabi Customs training session on the new E-Clearance procedures of “Dhabi System”. Occasionally used to help the PRO in making Bill of Entry through the Dhabi System and solving issues related to the system.
• Accomplished Secretarial functions, and send emails on behalf of the General Manager as advised. Taking down calendar appointments and reminding him as per necessity.
• Facilitated implementation of RFID system. Handles day to day IT related issues and ordering of IT devices.
• Assists in the stock count at the end of the year for Jewellery. This includes reconciling sales floor, safe and system stock.
• Executes the Media Plan for the yearly advertisements and also does Art Work editing whenever necessary.

• My duties extend from the Logistics of 2 branches in Dubai and 2 in Abu Dhabi and Purchase and Logistics for Qatar.
• For Qatar, taking quotations from suppliers and advising prices to the salesman and then creating purchase orders and logistics related procedures.
• Procured quotations from forwarders on 20’, 40’ and LCL container loads and decided on which forwarder to use.
• Tracking and following up on the material readiness and expediting shipment pickup with our suppliers and forwarders.
• Follow up with suppliers for attested documents and arranging for customs clearance.
• Calculating the total cost of containers arriving to the warehouses and entering into the ERP system.
• Coordinating with the salesman and informing arrival dates and prioritizing on shipments that are urgent.

• Preparing quotations, purchase orders and placing - Preparing quotations, purchase orders and placing orders and efficiently liaised with international publishers via Email or Phone for purchase of books.
• Tracking and following up on the shipment with our shipper in UK, US and France.
• Methodically analyzed customer needs and monitored and coordinated with our warehouses’ daily transactions and scheduled delivery for books to the various U.A.E schools assigned to me while adhering to the company policies.
• Ensure that all school accounts that I handle are posted in the system and assure that the delivery orders and invoices are done through the Tender Maintenance System and that it is delivered along with the books on the delivery date.
• Visiting the warehouse to list down the sample books, damaged books, extra books, wrong book deliveries, wrong supply of ISBNs/Barcode from different publishers so as to write off or do needful adjustment in the ERP system. Assisting in annual stock take to make sure the delivery of all books have taken place.
• Created a Publisher database with ISBNs which can be easily used for finding out a publisher.

Major orders accomplished:
• Supply of Library Order to 7 Campuses throughout UAE for Institute of Applied Technology in 2011.
• Academic Year - Book Supply for Ittihad Schools : Abu Dhabi, Dubai and Al Ain for 2010 and 2011.