Lealet Legaspi, Regional Junior Merchandise Analyst

Lealet Legaspi

Regional Junior Merchandise Analyst

Chalhoub Group

البلد
الإمارات العربية المتحدة - دبي
التعليم
بكالوريوس, Economics - Management
الخبرات
16 years, 2 أشهر

مشاركة سيرتي الذاتية

حظر المستخدم


الخبرة العملية

مجموع سنوات الخبرة :16 years, 2 أشهر

Regional Junior Merchandise Analyst في Chalhoub Group
  • الإمارات العربية المتحدة - دبي
  • يناير 2017 إلى فبراير 2019

Main Responsibility: Shares in the responsibility of setting up and managing the merchandise plan - build OTBs, allocate right product assortment across regional POS, monitor and manage product inventory and lifecycle, align gross margins with constant evaluation of KPI achievements, review product pricing, analyze inventory risk and opportunities, implement inventory allocation strategies while working hand-in-hand with Buyers and Division Manager on Buying and replenishment orders, implementation of sale strategies and promotions, liquidation of non-performing stocks, and with constant coordination to support departments (VM, Accounts, Logistics, Finance)
Achievement/s:
 Implemented a cost-effective process on product allocation and replenishment transfers by making efficient weekly stock rotations on store-to-store at local and regional level, hence reducing cost impact
 Reduced and consistently maintained the stock level requirement and achieved the target KPI of 6-month inventory amidst challenging retail market environment
 Narrowed gaps on cost variances by making an efficient delivery / shipment plan that reduced the overall impact of oversupply in the region
 Optimized sales opportunities with constant review on product performance at SKU level, reviews fast and slow-moving items, and placed a consistent periodic replenishment of top items and collections thereby avoiding stock loss and missed sales opportunity

Specific Tasks:
 Accomplishes periodic local, regional, and annual performance reports; analyses and reviews to provide insights for the proper implementation of the merchandise plan at regional level
 Evaluates historical sales performance data and gather local teams’ feedback, insights, and recommendations to review and prepare periodic sell-through/sell-outs and assess these to align stocks with Brand’s guidelines
 Assists Area Manager and Division Manager by giving sales reviews on gross margins by store, monitors KPI achievement, performances by product categories, subcategories, etc.
 Reviews sales trends and plans inventory allocation per store by making stock rotations on store-to-store, and replenishment transfers from warehouse to stores to ensure optimized replenishment and availability of merchandise
 Monitors and reviews the product performance at SKU level for entire region and initiate recommendations to Buyer for placement of new orders/replenishment on performing collections/SKUs.
 Contributes to setting up and maintaining the OTB budget along with the Buyer/s and participates on periodic reviews with Division Manager and Finance Analyst to develop ways on where and how to optimize profit and reduce costs.
 Consolidates purchases at regional level ensuring consistency with commitment to suppliers while adhering to target OTB
 Prepares/analyses product pricing in accordance with budget, market prices, prevailing market exchange rates, and conducts periodic reviews, to ensure alignment on sales target vs. budget and narrow gaps on cost variances.
 Analyzes and prepares sales promotions following Brand markdown guidelines and sales trends with respect to budget, sell-throughs, stock costs, provisions, and assessment and approval of Finance
 Responsible in coordinating and planning with Marketing team for timely availability of stocks for product launches and marketing events
 Reviews discontinued items or non-performing stocks and takes action to optimize sales and reduce risk either by: negotiation for possible returns to supplier or propose alternative viable and strategic solutions beneficial to both parties; monitoring of monthly stock coverage and prepares for stock liquidation plan for possible transfer stocks to a factory outlet or other channels and achieve the set landing stock; and implementing product promotion plans

Customer Service Executive في Chalhoub Group
  • الإمارات العربية المتحدة - دبي
  • نوفمبر 2012 إلى ديسمبر 2016

Specific Tasks:
 Coordinates and liaises with retailer customers by being the principal point of contact for supplier Brands and managing all processes of orders; accuracy of sales order entries and coordinates with Accounts (supplier and client) to ensure all payments are done as scheduled and commissions invoices are issued on time; track deliveries and confirm all are completely placed, correctly fulfilled, and shipped within the specified Brand delivery window avoiding cancellations
 Takes lead and accountable for all After Sales Services/Customer Service Support and coordination with Brand to resolve all issues ranging from basic to complex critical issues, answer to all brand queries regarding products and services and complaints including: screening client requests/complaints, providing quotations on costs of repairs, checking availability of parts and its status, estimating repair lead times to avoid delays, issues credit notes whenever necessary
 Manages delivery plan in line with stock needs and monitors this to ensure healthy stock cover and coordinates with stores teams on stock requirements, order replenishments
 Management of retail activities and requirements - ordering of uniforms, ordering of point of sales materials and supplies, liaises and assists in related administrative tasks as required by store teams
 Data management - Creation of item codes, supplier/customer, set-up and entry of data information and maintaining data consistency for accurate data in reports

Customer Service Logistics Executive في DHL Worldwide Express
  • الإمارات العربية المتحدة - دبي
  • مايو 2012 إلى سبتمبر 2012

Specific Tasks:
 Consistent monitoring of shipments to resolve quickly any impending critical issues and constant communication with warehouse inbound/outbound teams to deliver fast and on time
 Process orders through different management software solutions and warehouse management systems (such as SAP, ELOG, SQL); and prepares and maintains systematic analysis of housekeeping / discrepancy reports
 Coordinates with logistics team in providing the necessary documents for smooth flow of the shipping process, i.e. AWB, invoices, other documentations needed, etc.
 Constantly communicates and updates customers on status of orders, discuss any issues to better services offered, and establish a strong customer relationship
 Prepares and analyses various weekly and monthly reports

Buying Coordinator في UNIWORLD FZE
  • الإمارات العربية المتحدة - دبي
  • أكتوبر 2009 إلى أبريل 2011

 Prepares and evaluates the Deal Profitability Sheet, a report which translates the cost and sell prices to profit margins.
 Working with Excel reports and analysis (v-lookups, pivot tables, back tables, etc) for profit margins for each purchase shipment
 Entry of LPOs into the system (FOCUS) and entry of new supply or product codes.
 Generating reports on stocks levels to alert Buying Managers for placement of new orders
 Negotiates and coordinates with suppliers to obtain the best prices possible.
 Constantly coordinates with Logistics office to ensure on time delivery of goods
 Acts as assistant to Logistics manager on preparing the weekly shipment status report.
 Ensures the payments are arranged before shipment, coordinating with accounts on LC and necessary documents to logistics office
 Constantly communicate with suppliers on shipments of goods for timely delivery
 Prepares weekly purchasing and shipment status reports for Buying Manager and Purchasing Director
 Constantly following up with Accounts for necessary payments

Executive Secretary في EUROPEAN PHARMACEUTICALS GROUP LLC (HEALTHGATE)
  • الإمارات العربية المتحدة - الشارقة
  • أكتوبر 2007 إلى أغسطس 2009

 Assists the GM in liaising through various internal and external relations and communications with stakeholders -- government, local and international business partners including opening of new markets.
 Takes charge of general administrative and secretarial duties i.e. arranging for appointments, daily schedules, travel itineraries and requirements; preparing for minutes and corporate presentations and reports; screen calls; draft memos and prepares all business correspondences and communications
 Prepares and follows-up for purchasing, shipment and Customs requirements of supplies from international market
 Evaluates and handles local purchasing transactions, screening of suppliers, product quality and prices
 Assists and coordinates with General Manager and Store Manager on purchases of products from international market.
 Constantly communicates with local and international suppliers, follows-up and ensures timely delivery of goods
 Coordinates with accounting office for smooth process of purchase transactions
 Prepares purchases requests - LPOs for both local and international purchases
 Coordinates with the GM in planning for marketing and promotion strategies, opening of markets and seeking business partners by preparing all marketing and product profiles and business proposals & quotations
 Assists and coordinates with sales executives and medical representatives on various sales and marketing activities

Administration and Research and Development في DON BOSCO TECHNICAL INSTITUTE-VICTORIAS
  • الفلبين
  • أبريل 2002 إلى أغسطس 2007

Function: Administration and HR Assistant

 supports and assist the HR Manager in the implementation of HR policies and programs through constant updating and feedbacking through research and survey activities
 assists in formulation of human resource policies and guidelines in coordination with department heads and helps establish HR processes
 constantly updates records of all employees
 makes and prepares HR reports (leave, attendance, health and other benefits)
 involved in organizing, preparation and facilitating of employee-related activities (trainings, workshops, seminars and outings, etc.)
 acts as administrative secretary in matters relating to organizational affairs of the Institution; serving the Office of the Rector
 assisting department managers in coordinating different activities at the institutional level
 prepares minutes of the meeting of management group composed of division and department heads

Function: Center for Research and Development Department Executive

 conducts research activities and facilitates surveys used for Institutional evaluation and planning; construct survey methods and processes
 monitors the Institution’s implementation of strategies and programs by gathering reports from each department and preparing them for management review and evaluation
 makes analysis of data gathered by employing statistical methods, results of which are submitted to management as basis to project planning
 secretariat head for planning sessions at the Institutional level
 coordinates with all departments for updating of the institutional plan’s progress

Logistics Assistant في DOXO INGREDIENTS, INC
  • الفلبين
  • أكتوبر 2001 إلى مارس 2002

Function: Logistics Assistant

 coordinates with store manager on checking and updating stocks, and prepares the daily report
 responsible for preparing and checking of sales invoices
 served as Inventory Clerk I - mainly responsible for the ins and outs of the company’s products and employing the use of systems inventory.
 responsible for all product on-time deliveries and checks all deliveries before dispatch
 arrange for government health and food checks documents
 reporting on stock level and ordering of raw materials for production
 prepares and receives international shipments when needed

الخلفية التعليمية

بكالوريوس, Economics - Management
  • في University of the Philippines
  • أبريل 2001
الثانوية العامة أو ما يعادلها, Research and Development Management
  • في Secondary St. Mary Mazzarello School
  • مارس 1997

Specialties & Skills

Workflow
Minutes
Materials
Newspaper
Quotations
INVENTORY MANAGEMENT
ORGANIZATIONAL SKILLS
REPORTS
ACADEMIC
ADMINISTRATION
Customer Relations
Competitive Analysis
Procurement and Purchasing
Interpersonal Skills
Writing and Communication
Microsoft Desktop Programs
Oracle, SAP, SQL, Focus, ELOG
Advanced Excel
Problem Solving
Reporting Skills

اللغات

الانجليزية
متمرّس
الفيلبينية
اللغة الأم

التدريب و الشهادات

Philippine Civil Service Commission (الشهادة)
صالحة لغاية:
August 2001
Accounting for Non-Accountant (الشهادة)
تاريخ الدورة:
September 2008
Microsoft Excel 2010 Advanced (الشهادة)
تاريخ الدورة:
June 2015