Summary
Overview
Work History
Education
Skills
Languages
Websites
Certification
Work Availability
Timeline
Accomplishments
Hi, I’m

Mateo Carreno

Bogotá,DC

Summary

Chemical Engineer from the Universidad de La Sabana currently serving as Sales Strategy Asst Analyst at PepsiCo, passionate about the optimization and improvement of production processes using software tools such as Power BI, Power Apps, Power Automate, Python as a programming language and the Office package. Identified by his proactivity, autonomous learning, assertive communication and public speaking. Finally, recognized by the Universidad de La Sabana as best internship during his period at PepsiCo.

Overview

2
years of professional experience
1
Certificate

Work History

PepsiCo
Bogotá

Sales Strategy Asst Analyst
02.2024 - Current

Job overview

Responsibilities:

  • Manage databases and create weekly automated reports with essential KPIs for the 3PD sales channel.
  • Develop cost-benefit analysis of the compensation plan for new customer acquisition.
  • Implement and transform distributors nationwide to increase sales and market share by diversifying the 3PD portfolio.
  • Perform the process of constitution or cancellation of distributors' warranties.
  • Design and follow up on the geo-reference collection plan for the 3PD channel customer base.

Achievements:

  • Recognition as the best LATAM Project, for the transformation of the channel.

PepsiCo
Funza

Quality and Food Safety Intern (First Gen)
06.2023 - 12.2023

Job overview

  • Responsibilities:
    Develop an App (Power Apps) for GMP non-compliance reporting in plant with automated report sending flow via email and integrated with a Power BI dashboard for information visualization.
  • Automate weight taking in scales of production lines and load data into SAP.
  • Develop application for self-inspection records in warehouses with Power BI report for easy visualization of information.
  • Design Power BI dashboard for consumer and customer complaints.
  • Produce tests together with R&D team for sodium reduction program across the portfolio.

Achievements:

  • Reduced time to corrective action on GMP non-compliances by 85%.
  • 100% eradication of errors in weight taking on production lines.
  • Digitalization throughout the entire business chain.
  • 30% progress in the second phase of the sodium reduction project.

BestBiz SAS
Bogotá

Internet Sales Agent
01.2022 - 05.2023

Job overview

Responsibilities:

  • Acquisition of new customers internationally, through different means such as LinkedIn and mailing.
  • Strengthening sales with previously established customers, carrying out customer loyalty programs.
  • Control and development of more efficient plans for inventory distribution through sales analysis.
  • Filled customer orders by packaging items or transferring to manufacturers or third-party distributors.
  • Designed graphical elements such as banners, buttons, images and logos used on the company's webpage.
  • Offered technical and non-technical support and services to clients and staff regarding product use, operation and maintenance.
  • Created successful strategies to develop and expand customer sales.

Achievements:

  • Increase active customer base by 13%.
  • Increase sales 24% by 2022.
  • Reduce shipping times by 1 day on average.

Education

Universidad De La Sabana
Chia, Cundinamarca

Bachelor of Science from Chemical Engineering
03-2024

University Overview

Skills

  • Microsoft (Power BI, Power Apps, Power Automate,
    Excel, Word, PowerPoint)
  • Python
  • SQL
  • Autonomous learning
  • Data interpretation
  • Proactivity
  • Assertive communication
  • Teamwork

Languages

Spanish
First Language
English
Advanced (C1)
C1
French
Elementary (A2)
A2

Certification

  • Introduction to Python (DataCamp)
  • Intermediate Python (DataCamp)
  • Data Literacy (DataCamp)
  • Data Manipulation in SQL (DataCamp)
Availability
See my work availability
Not Available
Available
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse

Timeline

Sales Strategy Asst Analyst
PepsiCo
02.2024 - Current
Quality and Food Safety Intern (First Gen)
PepsiCo
06.2023 - 12.2023
Internet Sales Agent
BestBiz SAS
01.2022 - 05.2023
Universidad De La Sabana
Bachelor of Science from Chemical Engineering

Accomplishments

Accomplishments
  • Recognition by Universidad de La Sabana as best internship during his time at PepsiCo.
Mateo Carreno