Learn Data Skills
Beta

Guilherme Cavalcanti

Senior Business Development Associate

Shopee | Brazil

Technologies

My Portfolio Highlights

My New Track

SQL Fundamentals

My New Track

SQL for Business Analysts

My New Track

SQL Fundamentals

Quantitative storyteller, weaving narratives through data analysis.

My Work

Take a look at my latest work.

project

Analyzing Students' Mental Health

SQL
project

Evaluate a Manufacturing Process

SQL
track

SQL for Business Analysts

project

Analyzing Students' Mental Health

SQL

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

Courses

Introduction to Python
Introduction to SQL
Intermediate SQL
Intermediate Python

My Work Experience

Where I've interned and worked during my career.

Shopee Brazil | Jan 2024 - Present

COMMERCIAL PLANNING SENIOR ANALYST

• Facilitate collaboration between Marketing and Commercial teams, ensuring strategic alignment in campaigns, maximizing product and seller exposure, and increasing the conversion rate by 23%. • Lead projects for mapping and improving processes, ensuring operational efficiency, and managing performance reports and indicators. • Analyze commercial performance, identifying opportunities for internal initiatives that contribute to platform growth, providing analytical support for optimizing results. • Manage calendars and deadlines for the merchandising and marketing teams, influencing campaign planning and continuously reviewing processes to identify automation and improvement opportunities, resulting in a 30% reduction in the execution time of internal workflows. • Serve as primary support for leadership in developing junior professionals, contributing to team qualification and the professional development of employees.
Show More

Shopee Brazil | Feb 2022 - Jan 2024

COMMERCIAL PLANNING ANALYST

• Implemented tools in Python for automating reports and processes, optimizing data updates by 40%, and reducing repetitive manual tasks by 8 hours per week, improving the team's operational efficiency. • Developed a Python tool for data manipulation and validation, optimizing the product pricing process and resulting in a gain of 5 hours per week in efficiency and quality of the process. • Conducted performance analyses of channels and products, transforming large volumes of data into strategic information that identified opportunities positively impacting business performance. • Led the consolidation of the 'Flash Sales’ channel as one of the main sales channels for the FMCG cluster, achieving over 30% representation in big campaigns, ensuring alignment between the Marketing and Commercial teams. • Contributed to the digital marketing strategy of the FMCG cluster, presenting KPIs of the 'Flash Sales' to senior leadership and ensuring the execution of the defined strategies.

Shopee Brazil | Feb 2021 - Jan 2022

COMMERCIAL PLANNING JUNIOR ANALYST

Responsible for the growth of the 'Flash Sales' channel in the FMCG cluster, achieving order and revenue targets, with an 18% increase in the channel's participation in promotional campaigns. I planned the commercial calendar and, based on performance analyses, we achieved a 15% growth in sales. I mapped and optimized the negotiation process of the commercial team, reducing execution time by 20%, and acted as the focal point with the Marketing team to ensure alignment of strategies in campaigns.

Shopee Brazil | Oct 2020 - Jan 2021

BUSINESS INTELLIGENCE JUNIOR ANALYST

Conducted performance analyses of sellers and products in the fast-moving consumer goods (FMCG) cluster, identifying bestsellers and market trends, resulting in a 12% increase in sales and an 8% improvement in the conversion rate. I developed daily, weekly, and monthly KPI reports, enhancing the efficiency of negotiations and product ranking in the 'Flash Sales' channel. I collaborated with the Marketing team to execute strategies and maximize results in promotional campaigns.

Paraiba Technology Park & Apex Brasil | Oct 2016 - Nov 2018

EXPORT JUNIOR ANALYST

Prospected 250 industries with export potential, developed market research reports defining 2 target markets, contributing to 146 industries exporting their products. Additionally, I conducted presentations for directors and managed information in the CRM, improving the organization and operational efficiency of the commercial team.

My Education

Take a look at my formal education

Business Course in Strategy, Finance & Valuation, Marketing, Soft Skill, Accounting, and InvestmentsBusiness Training Company | 2020
Bachelor's Degree in Business ManagementUniversidade Federal de Campina Grande | 2019
Specialization Certificate in Strategic Management, Innovation and SustainabilityPearson College London | 2019

About Me

+8 years of experience in strategic planning, commercial intelligence, and data analysis, I aim to transform data into actionable insights. I leverage my analytical skills to provide valuable insights supporting intelligent decision-making.

Powered by

  • Work
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free