Nexteam

Juan

Nexteam talent

Juan — surname withheld

FP&A

Languages
English
Spanish
Portuguese

Juan — surname withheld

FP&A

Juan is an FP&A advisory and EPM implementation consultant focused on Vena CPM, delivering end-to-end planning and reporting solutions for U.S. clients from discovery through build, validation, and post-go-live support. He leads requirements gathering through structured discovery sessions, designs planning templates for revenue, opex, capex, and workforce planning, and builds variance reporting and management-ready financial statements tied back to the source ERP. He consistently validates data integrity by reconciling ERP outputs to Vena and ensuring the P&L, balance sheet, and cash flow tie out before deploying dashboards and planning models. Juan brings a client-facing mindset, strong modeling discipline, and implementation rigor that helps finance teams standardize planning, improve reporting cadence, and drive better decisions.

Education & Certifications

Master's Degree in Finance

University

2018–2019

Bachelor's Degree in Civil Engineering

University

2011–2015

Availability on request

Colombia

Full name and employer details shared on request.

Skills & Expertise
FP&A AdvisoryBudgetingForecastingEPM ImplementationRevenue PlanningFinancial ModelingOPEX & CAPEX PlanningWorkforce PlanningVariance AnalysisManagement ReportingFinancial StatementsERP Data IntegrationData TransformationData ValidationTie-Out ReconciliationsPPP Bid ManagementRisk Analysis

Industry Expertise

Infrastructure
Mining
Oil and Gas
Utilities
Professional Services
EPM Software
FP&A
Career Highlights
Senior FP&A Consultant

Leading FP&A advisory engagements and implementing Vena CPM solutions to improve client planning and reporting. Running discovery sessions to understand business drivers, planning structure (departments, locations, entities), and success factors, then translating requirements into Vena model design.

Consultant

Managed outreach and contact with potential foreign investors for the mining sector. Lead organization of business roundtables for the Colombian mining sector with international investors and mineral buyers.

Business Development

Built financial models for infrastructure projects using project finance approaches to support bid and investment decisions. Coordinated, integrated, and prepared bids for PPP infrastructure projects across Colombia, Peru, and Panama.

+ Technical Skills :
Vena CPMSQLExcelPowerPointWord
Employment
Accounting and advisory firm

Senior FP&A Consultant

Started 2021
  • Leading FP&A advisory engagements and implementing Vena CPM solutions to improve client planning and reporting;
  • Running discovery sessions to understand business drivers, planning structure (departments, locations, entities), and success factors, then translating requirements into Vena model design;
  • Connecting and transforming ERP data into Vena, validating completeness and accuracy through tie-out reports before building financial statements and dashboards;
  • Designing and maintaining templates for revenue, OPEX, CAPEX, and labor planning, plus variance reports and monthly management reporting packs;
  • Advising clients on labor planning complexity by focusing stakeholders on decision-useful estimates and avoiding unnecessary detail that reduces usability;
  • Managing project timelines, delivery checkpoints, and post-implementation follow-up, including ongoing managed services support when applicable.
Public-sector mining organization

Consultant

2021–2023
  • Managed outreach and contact with potential foreign investors for the mining sector;
  • Lead organization of business roundtables for the Colombian mining sector with international investors and mineral buyers;
  • Presented mining promotion strategies to stakeholders and supporting engagement planning;
  • Coordinated stakeholder communications to support structured investor-facing initiatives.
Infrastructure business

Business Development

2016–2021
  • Built financial models for infrastructure projects using project finance approaches to support bid and investment decisions;
  • Coordinated, integrated, and prepared bids for PPP infrastructure projects across Colombia, Peru, and Panama;
  • Developed risk analysis for PPP projects valued between USD 50-200M to support commercial positioning and decision-making;
  • Supported administrative responsibilities for the company’s subsidiary and branch, including accounting, legal, and capitalization activities;
  • Built and managed relationships with infrastructure-sector stakeholders to support business development and pipeline growth.

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.