Juan

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