Nicolás Guerrón

Own end-to-end FP&A; responsibilities across various legal entities and multiple business segments in Israel, Ireland, and Italy — covering monthly, quarterly, and annual reporting for local, sub-regional, and regional management audiences. Manage rolling forecast and annual budget cycle. Redesigned P&L reporting framework expanding high-level consolidated reporting with granular, business-line level visibility.

Built multi-scenario investment analysis models for hydrogen offtake negotiations, stress-testing pricing, volume, and CAPEX assumptions for large scale deals across Europe. Conducted extensive pricing analysis across hydrogen supply contracts, directly informing commercial strategy and supporting deal structuring across multiple European markets. Collaborated cross-functionally with business development, legal, and operations teams to assess project feasibility and commercial risk across multiple jurisdictions.

Key user of ERP migration: Create, test and execute mappings between ERP and FMS system, to ensure the correct processing of financial information. Project manager of POS and PMS systems integration: proposes, create, manage and validate all the setups needed for a correct posting of financial data. Develop Excel models that reduced 80% of the time required to validate month-end revenues checks and Cash and Cards reconciliation. Manage a team of 4 members ensuring the correct posting of revenue in PMS and ERP system for 16 different properties across 6 different countries. Coordinate the correct execution of internal projects. Train operation teams across 6 countries to assure the correct use of PMS systems, mitigating errors impacting revenue. Complete external audit request. Backup and support revenue and payment flow.

Verifying, monitoring, and reviewing all hotel revenue reports. Ensuring that daily revenues and settlements are in balance. Summarizing revenue and settlement information in a Journal Entry format associated with the proper back office chart of account numbers and descriptions. Develop and maintain all income journal and cash receipts and make all required adjustments for same and perform month end closing

Developed discounted FCF Excel models and scenario analysis for M&A transactions worth over $60 million. Executed financial analysis for over 100 companies across various industries, determining their profitability, leverage strategies, quality of assets, and normalizing revenue. Providing key insights depending on the client's request. Evaluated projects using ROI and IRR analysis, ensuring maximum return on investment for stakeholders. Structured the issuance of bonds and diverse financial instruments through the Ecuadorian stock market, raising over $30 million. Analyzed investment portfolios for Ecuadorian insurance companies for over $150 million worth of assets, providing key insights and recommendations that improved the portfolio performance and increased ROI Developed sophisticated analytical models in Excel and created visually compelling Power BI reports for the Ecuadorian stock market, banks, insurance companies, investment funds, and macroeconomic indicators. These reports provided key insights to financial decision-makers, enabling them to make more informed investment decisions and resulting in increased profitability for their organizations

Manage investment portfolio of around $50 million dollars. Forecast and control investment income and expenses. Analyze and negotiate investment options in order to increase portfolio ROI. Coordinate local and international trading operations.

Planned improvements for the production units of the university. Audited university headquarters and branches.

Created economic proposals and determined price. Developed projects cash flow and measure its viability. Analyzed database and generateed projections and budgets.