Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Viviane Lacerda

Sydney

Summary

Genuine passion for data analysis and with an enthusiastic and "hands-on" personality. Experience in global companies for over 10 years (Mastercard, Nespresso, BAT, AB Inbev, Votorantim Group). Advanced skill level with SAP ERP, Microsoft Office and Advanced Excel (Pivot Table, macros, etc), and BI systems. Courses in Tableau and SQL. Experience in delivering actionable insights through data analysis and reporting, Dedicated team player with a strong work ethic and remarkable initiative.

Overview

12
12
years of professional experience
1
1
Certification

Work History

Specialist, Product Operations

Mastercard
03.2022 - Current
  • Responsible for manage the catalogue of merchandise products and maintaining accurate, up-to-date product information. Regularly updated product data (pricing, copy, etc.) and created annual redemption dashboards to analyze product performance and demand trends.
  • Data Reporting & Analysis: Regularly updated product databases, pricing, copy writes and related content, ensuring the integrity of data for accurate reporting.
  • Suppliers & Client Support: Work with suppliers, vendors, Fulfilment, Finance, Contact Centre, and Account Management to ensure seamless product life cycle management and reporting.
  • Process Management & Documentation: Managed the full product life cycle, including the creation and deactivation of products using MRS. This involved coordinating with different teams to ensure timely updates to product catalogues.

While I was not working with SQL directly in this role, I often worked with large data sets and required the ability to manipulate and analyze data within spreadsheets and databases to ensure accurate reporting and trend analysis. I also worked with different teams to ensure that data issues were flagged and resolved in a timely manner.

Sales representative

Nespresso
11.2019 - Current
  • Improved sales by 120% through an engaging online campaign for the Vertuo line machine.
  • Implemented national trade machine promotion campaigns.
  • Briefing the Marketing agency on a regular basis.
  • Complete daily reports of consumers' behaviors and sales of the day.
  • Document all customer interactions using SalesForce to capture data in processing system.
  • Increased sales by offering advice on purchases and promoting additional products
  • Utilized professional sales techniques to persuasively communicate with clients

Trade Marketing Analyst

BAT - British American Tobacco
05.2018 - 03.2019
  • Conducted analysis of the distribution of campaign's material, to detect problems related to availability of promotions, branding and trade at the area, regional and / or territory levels. Provided timely and adequate information to accelerate decision-making in the region.
  • Support implementation of our campaigns and Visibility programs in Key Convenience store accounts. Ensure accurate tracking of various business KPIs, provide regular monthly reporting of progress of actual planned campaign.
  • Measured marketing program effectiveness via regular monitoring of KPIs.
  • Implemented trade marketing materials to communicate strategies to 620 member team.
  • Collaborated with merchandising team on creating differentiated in-store experiences through unique merchandising and collateral opportunities.

Demand Analyst

BAT - British American Tobacco
04.2017 - 03.2018
  • Conducted analysis of product distribution, to detect problems related to the availability of products per area, regional and / or territory levels, to provide timely and adequate information to accelerate decision-making in the region.
  • Applied sales forecasting techniques and strategic planning to verify sales and profitability of products, lines and services.
  • Developed accurate sales forecasts by analysing sales feedback and wrote reports for senior leadership.
  • Responsible for carrying out and consolidating analysis of regional sales information, evaluating key indicators in region and detecting main areas of opportunity to support decision- making.
  • Responsible for weekly/monthly presentations of S&OP.
  • Increased market share by devising plans based on research findings and data (68% to 69% in 6 months). Provided information of market behavior at the regional area and territorial levels, using Nielsen Data, consequently the market share increased.

Demand Planning Analyst

Votorantim Group
03.2014 - 03.2017
  • Main Achievement: Created new tool on SAP to measure if the customer is receiving the product on the correct day. This increased the perception of service by 14% and the NPS increased 1 point after this.
  • Follow-up of service level indicators (OTIF / Fill rate / Lead Time).
  • Follow-up of production process, to ensure sale/distribution of Finished goods to warehouses and final customers.
  • Studied movement of goods to identify gaps in efficiency and other areas needing improvement.
  • Elaboration/presentation of S&OP meetings weekly, monthly, quarterly and by semesters.
  • Saved about R$50,000 monthly due to creating an excel sheet to control wastage of products due to shelf life.
  • Analyzed weekly and monthly patterns to forecast business needs, reducing inventory costs.
  • Utilized internal systems and reporting tools to track product performance, stock levels, and demand trends, generating actionable insights and reports to guide product selection and promotional decisions.

Costumer Service Logistics Analyst

AMBEV at AB InBev
11.2012 - 02.2014
  • Coordinated resolution of issues with supply chain participants, including warehouses, sales brokers and carriers.
  • Reduced by 8% the returning of shipments due to logistics issues by following up daily and providing correct information to avoid repeating mistakes.
  • Support brewery service level agreements (direct loading, manage floor inventory).
  • Monitoring of product availability in factories.
  • Responsible for presenting material in weekly / monthly meetings for large chain supermarket area.
  • Created program to check monthly if logistics area was compliant under ISO 9001 and 28000, so we stopped struggling during annual audit.

Education

Diploma - Project Management

Greystone College
Sydney, NSW
02.2021

Bachelor of Administrative Studies - Administration

Catholic University
Pernambuco - Brazil
06.2014

Skills

  • Client relationship management
  • Cross-functional collaboration
  • Advanced Microsoft Excel (pivot tables, VLOOKUP, macros)
  • Data analysis & insights
  • Courses in SQL scripting and Tableau
  • Ad hoc report generation
  • Reporting automation & process improvement
  • Great team player
  • Strong time management & multitasking
  • Solving problems

Certification

Leadership and Coaching – Senac Course; Six Sigma Green Belt – At AB-Inbev; Emotional Intelligence – Febracis. Tableau for beginners - General Assembly - Sydney.

Timeline

Specialist, Product Operations

Mastercard
03.2022 - Current

Sales representative

Nespresso
11.2019 - Current

Trade Marketing Analyst

BAT - British American Tobacco
05.2018 - 03.2019

Demand Analyst

BAT - British American Tobacco
04.2017 - 03.2018

Demand Planning Analyst

Votorantim Group
03.2014 - 03.2017

Costumer Service Logistics Analyst

AMBEV at AB InBev
11.2012 - 02.2014

Leadership and Coaching – Senac Course; Six Sigma Green Belt – At AB-Inbev; Emotional Intelligence – Febracis. Tableau for beginners - General Assembly - Sydney.

Diploma - Project Management

Greystone College

Bachelor of Administrative Studies - Administration

Catholic University
Viviane Lacerda