Summary
Overview
Work History
Education
Skills
Languages
Timeline
Generic
Juan Guillermo Pinzon Ayala

Juan Guillermo Pinzon Ayala

Bogotá D.C.

Summary

Results-driven Industrial Engineer with expertise in financial planning, corporate finance, business valuation, budget construction, and treasury management. Delivered impactful financial performance through effective business partnering and collaboration across departments, enhancing strategic decision-making and driving profitability analysis.

Overview

6
6
years of professional experience

Work History

Senior FP&A Analyst

MasterCard
Bogotá D.C.
01.2025 - Current

Financial planning and analysis of revenue for Central and South America within MasterCard's consulting services. Support in executing monthly close processes, forecasting, and budgeting, as well as acting as a finance business partner to various stakeholders across the organization and regions. Development of dashboards to provide financial insights to commercial, product, and sales teams to track organizational performance.

Profitability executive

Coca Cola Femsa
Bogotá D.C.
06.2024 - 12.2024

Profitability team leader responsible for coordinating the team in the development of business cases for investment projects, making profitable portfolio-level decisions, overseeing the construction of financial assessments, and developing work routines with key teams to align business plan objectives. Management of cash flow and working capital, ensuring the availability of financial resources and meeting the company's operational needs.

Profitability Planner

Coca Cola Femsa
Bogotá D.C.
05.2023 - 05.2024

Developed business cases for investment projects, analyzed portfolio profitability to support business partnering and decision-making, constructed financial valuations to assess project viability, and created routines with teams to monitor company interests.

Senior Valuation Analyst

KPMG Advisory, Tax & Legal
Bogotá D.C.
10.2022 - 04.2023

Team leader in the development of valuation models, financial projections, and proposals for external and internal clients. Coordination of work teams to meet the requirements and deadlines of various projects. Construction of financial models specialized in companies within the financial sector (banks, insurance companies, investment funds, among others) to comply with different legal and tax contexts.

Valuation Analyst

KPMG Advisory, Tax & Legal
Bogotá D.C.
10.2020 - 09.2022

Developed valuation models and financial forecasts for external clients in financial and real sectors within M&A contexts, meeting accounting and tax requirements.

Junior Valuation Analyst

KPMG Advisory, Tax & Legal
Bogotá D.C.
11.2019 - 10.2020

Reviewed valuation models for external clients with audit teams for financial statement preparation.

Education

Master of Science - Finance

Universidad De Los Andes
Bogotá D.C.
09-2024

Bachelor of Science - Industrial Engineering

Universidad De Los Andes
Bogotá D.C.
03-2020

Skills

  • Financial modeling
  • Valuation analysis
  • Forecasting techniques
  • Budget management
  • Finance Business Partnering
  • Data analysis
  • Dashboard development
  • Portfolio analysis

Languages

English
Native/ Bilingual

Timeline

Senior FP&A Analyst

MasterCard
01.2025 - Current

Profitability executive

Coca Cola Femsa
06.2024 - 12.2024

Profitability Planner

Coca Cola Femsa
05.2023 - 05.2024

Senior Valuation Analyst

KPMG Advisory, Tax & Legal
10.2022 - 04.2023

Valuation Analyst

KPMG Advisory, Tax & Legal
10.2020 - 09.2022

Junior Valuation Analyst

KPMG Advisory, Tax & Legal
11.2019 - 10.2020

Master of Science - Finance

Universidad De Los Andes

Bachelor of Science - Industrial Engineering

Universidad De Los Andes
Juan Guillermo Pinzon Ayala