Nexteam

Juan

Nexteam talent

Juan — surname withheld

FP&A

Languages
English
Spanish
French

Juan — surname withheld

FP&A

Juan is an EPM and FP&A professional specializing in end-to-end planning implementations, forecasting, cost modeling, and advanced analytics in international environments. In his current role at a pharmaceutical company, he owns budgeting, forecasting, and scenario planning processes in Planful, while building automated planning pipelines, ETL workflows, and executive-ready performance reporting. He has delivered measurable improvements in profitability analysis by implementing a comprehensive cost model and gross margin framework across products and markets.

Juan has also automated workforce allocation and macroeconomic assumption updates using Python, reducing manual effort and improving planning speed and consistency. He brings a strong blend of FP&A leadership and technical EPM depth to help teams scale forecasting discipline and decision support.

Education & Certifications

Master's Degree in Data Science and Analytics

University

2023–2025

Bachelor's Degree in Finance

University

2016–2021

Bachelor's Degree in Economics

University

2016–2021

Availability on request

Colombia

Full name and employer details shared on request.

Skills & Expertise
EPMFP&ABudgetingForecastingScenario AnalysisSensitivity AnalysisCost ModelingMargin ModelingGross Margin AnalysisVariance AnalysisPerformance TrackingETL ProcessesData PipelinesStakeholder ManagementDashboard DevelopmentOperational Cost Modeling

Industry Expertise

Pharmaceuticals
SaaS
E-Commerce
Government/Public Sector
International Trade
Enterprise Software
Logistics
Career Highlights
Senior Financial Planner

Owning FP&A processes in Planful, covering budgeting, forecasting, and scenario analysis. Designing and maintaining end-to-end financial planning pipelines, including ETL processes, templates, and simulations.

FP&A Senior Specialist

Supported investor relations activities with venture capital and angel investment firms, contributing to data preparation and financial narratives used in fundraising and stakeholder discussions. Prepared executive-level presentations for C-suite stakeholders, translating financial results, trends, and scenarios into clear, decision-oriented materials.

Corporate Finance Business Partner

Managed financial planning and analysis (FP&A) processes, including budgeting, financial analysis, and recurring reporting activities across planning cycles. Designed and managed financial analysis reports and models to support performance tracking and management review.

FP&A Analyst

Developed financial analysis and planning models to support operational performance management across cost and efficiency dimensions. Built dashboards and automated reporting for variable cost tracking and efficiency analysis, improving transparency and timeliness of insights.

International Trade Analyst

Performed economic and financial analysis to support export development programs across multiple industries and markets. Built and maintained databases for exports and international trade performance tracking, ensuring data accuracy and continuity.

+ Technical Skills :
ExcelPlanfulVENASQLPython
Employment
Pharmaceutical company

Senior Financial Planner

Started 2025
  • Owning FP&A processes in Planful, covering budgeting, forecasting, and scenario analysis;
  • Designing and maintaining end-to-end financial planning pipelines, including ETL processes, templates, and simulations;
  • Leading variance analysis, margin monitoring, and performance tracking across business units;
  • Managing financial follow-up of licensing, manufacturing, and distribution agreements with internal teams and external partners;
  • Supporting a Planful implementation from P&L build-out through systems integration, covering revenue templates, gross-to-net modeling, and cost modeling tied to partner agreement terms;
  • Building auxiliary templates to model floor price, supply price, royalties, custom fees, revenue sharing, and multi-currency complexity (USD, GBP, AUD, CNY) in Canadian-dollar reporting;
  • Running forecasting governance with clear processes, accountability for cost center owners and brand managers, and version control through daily scenario copies to trace material changes;
  • Driving systems connectivity between Planful and business systems (ERP and BI), initially via Python-based ETL and later through Boomi integrations for scalable automation.
ERP software company

FP&A Senior Specialist

2024–2025
  • Supported investor relations activities with venture capital and angel investment firms, contributing to data preparation and financial narratives used in fundraising and stakeholder discussions;
  • Prepared executive-level presentations for C-suite stakeholders, translating financial results, trends, and scenarios into clear, decision-oriented materials;
  • Developed SQL-based data models, dashboards, and automated reporting processes within an ERP environment to improve data reliability and reporting efficiency;
  • Used analytics outputs to strengthen executive decision support, improve reporting discipline, and enhance visibility into key financial and operational drivers.
Pharmaceutical company

Corporate Finance Business Partner

2022–2024
  • Managed financial planning and analysis (FP&A) processes, including budgeting, financial analysis, and recurring reporting activities across planning cycles;
  • Designed and managed financial analysis reports and models to support performance tracking and management review;
  • Monitored, maintained, and continuously improved FP&A software usage and master data quality to ensure accuracy and consistency;
  • Periodically imported large datasets and closely monitored data quality to support reliable analysis and reporting outputs;
  • Supported data migration and testing projects between business systems, assisting with validation, issue identification, and process stabilization.
Technology platform company

FP&A Analyst

2022
  • Developed financial analysis and planning models to support operational performance management across cost and efficiency dimensions;
  • Built dashboards and automated reporting for variable cost tracking and efficiency analysis, improving transparency and timeliness of insights;
  • Designed an input-metrics-driven operational cost model using data science techniques to identify key levers affecting variable costs under stress and multiple business scenarios;
  • Collaborated with regional teams in a high-growth international environment to align assumptions, validate data, and support performance discussions.
Trade promotion organization

International Trade Analyst

2020–2022
  • Performed economic and financial analysis to support export development programs across multiple industries and markets;
  • Built and maintained databases for exports and international trade performance tracking, ensuring data accuracy and continuity;
  • Developed predictive export models and automated KPI reporting to support monitoring, evaluation, and program decision-making;
  • Supported public and private stakeholders with analytical insights, structured reporting, and data-driven recommendations.

Interested in learning more about this candidate or scheduling a call?

Let us know, and we’ll follow up shortly.

Choose what you allow. Optional cookies are off until you enable them. You can browse, contact us, and request talent without accepting them.