Joan Cera-Cueto, Trade Marketing Executive (Central Commercial Team)

Joan Cera-Cueto

Trade Marketing Executive (Central Commercial Team)

AUJAN Coca-Cola Beverages Company

Location
United Arab Emirates - Dubai
Education
Bachelor's degree, Social Science
Experience
9 years, 2 Months

Share My Profile

Block User


Work Experience

Total years of experience :9 years, 2 Months

Trade Marketing Executive (Central Commercial Team) at AUJAN Coca-Cola Beverages Company
  • United Arab Emirates - Dubai
  • April 2018 to June 2018

Perform analytical audits on market and trends
Create Management Information on activations
BTL Budget tracking and updating

Demand and Forecast Planner (GCC) at AUJAN Coca-Cola Beverages Company
  • United Arab Emirates - Dubai
  • March 2016 to March 2018

Managed the Confectionery business of the company (Bahrain and Qatar) - from enforcing sales management, budget preparation, activation/promotion, and stocks and shipment monitoring
Updated rolling forecast every month based on promotion uplifts and different marketing & sales activities of 5 countries (Bahrain, Kuwait, Qatar, Oman and Yemen)
Managed regional demand review meeting with sales, marketing & production teams
Designed Sales Development Dashboard for higher management to devise sales strategies
Continuous coordination with the sales team and monitoring of the recurring stock to increase sales
Prepared monthly S & OP review for EXCOM’s strategic planning
Undertook sales performance analysis and develop insights into improving revenue generation
Reviewed historical sales trends, research demand drivers, preparing forecast data, developing statistical forecast models, and evaluating forecast results
Participated in company planning strategy
Prepared annual budget including volumes with value matrix analysis
Conducted market analysis for all key markets and updating annually for developing a trend in market movements
Generated regular and special reports for the line manager that summarize and forecast business activities & financial position of the products

Forecaster/Demand Planner/ Sales Analyst at Gulf Catering Company
  • Saudi Arabia - Riyadh
  • January 2014 to January 2016

As Forecaster/ Demand Planner
Led forecasts and inventory planning meetings with the CEO, Project Manager, Sales Manager, Purchasing and Warehouse Managers
Reviewed & recommended sales forecasts and inventory goals (emphasis on brand transitions, new product introduction, and promotions)
Facilitated re-engineering, best practices & consensus between functional experts (Demand Planning, Inventory Planning, Purchasing, Sales & Marketing, Operations, Finance, and IT)
Established and utilized best methods (statistical models and software tools)
Developed reports and communicated forecast and inventory measurements to management (forecast accuracy, inventory plan vs. targets)
Managed inventory targets (including safety stock levels) that are approved by management; monitored SKU levels and recommended SKU rationalization initiatives in the future

As Sales Analyst
Prepared Cost-Volume-Profit (CVP) and Menu Engineering Analyses for analyzing line of business operations to determine profitability
Analyzed sales records & trends and evaluated performance measured against sales quotas while taking into consideration current economic conditions
Provided assistance to the management in developing and reviewing the sales budget and rolling sales forecast including sales to budget variance analysis
Coached sales professionals (Project Manager, Sales Manager and Forecaster)

Associate Manager – OIC/ Sales Information and Planning Associate at Universal Robina Corporation
  • Philippines
  • January 2010 to April 2011

As Associate Manager - OIC (Dec’10 - Apr’11)
Provided vital and direct support to department head in decision-making and action-planning processes through consolidation and analysis of qualitative and quantitative data at national level and market information
Identified opportunities and threats arising from area-specific market and consumer trends and developments
Conducted regular and ad hoc research and tracked studies and recommended possible research approaches to explore/study certain market & consumer scenarios
As Sales Information and Planning Associate
Ensured information was accurate, reliable and updated to facilitate timely decision-making of key officials in the assigned sales area
Prepared monthly operations report and business operations review which included price gap versus competition, market prices, placement analysis, sales to trade and program update

Sales Information Analyst at SAN MIGUEL Corporation
  • Philippines
  • November 2008 to June 2010

Ensured long range planning and prepared sales (volume & revenue) for the following year based on the company’s projected market share and growth as against the estimated industry size and growth
Tracked and analyzed key performance indicators like product availability, market share, pricing, inventory levels and volume

Developed physical distribution sales highlights for weekly management meeting (both Monterey and Magnolia)
Generated data from SAP for monthly operations review
Consolidated and evaluated data (profit and loss from the Finance Department together with the selling and other expenses for the monthly operations and business operations review)
Prepared qualitative write-ups of national performance highlights (both Monterey and Magnolia)

Finance Analyst at Solidbase Manpower Incorporated
  • Philippines
  • May 2008 to October 2008

A/R reconcillation

Branch Supervisor at PLDT - Digital Paradise Inc.
  • Philippines
  • February 2004 to October 2005

Supervising branch' sales performance

Education

Bachelor's degree, Social Science
  • at University of the Philippines
  • April 2007

Competitive market analysis of San Miguel Foods Inc.’s top competitor - A research presented by the Sales and Information Management Team to San Miguel – Pure Foods President •The Role of Ethnicity on Vote Choice of Local Officials in Baguio City - A Bachelor’s Thesis

Specialties & Skills

Budgeting and Forecasting
Sales Trend Analysis
Strategic Planning
ANALYSIS
BUDGETING
BUSINESS OPERATIONS
DELIVERY
FINANCE
INVENTORY MANAGEMENT
MARKETING
PRICING

Languages

English
Expert