Juan

Nexteam talent
Juan — surname withheld
FP&A
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
Industry Expertise
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.
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.