Open to opportunities

Mariana Lopez Guerra

@marianalopezguerra

Message

I translate complex financial data into actionable insights using Power BI, SQL, and BigQuery.

Colombia

Message

What I'm looking for

I’m looking for a senior finance role where I can partner with leadership using financial analysis and BI tools (Power BI, SQL, BigQuery) to improve profitability, strengthen cash flow control, and turn KPIs into clear, repeatable decision frameworks.

I’m a financial expert with 8+ years of experience translating complex financial data into clear, actionable insights for decision-making. I build dashboards, financial models, and performance tracking systems to turn raw numbers into strategic clarity.

As Senior Financial Accounts at LLE Educational Services, I oversee and validate financial statements (Balance Sheet, P&L, Cash Flow), manage and forecast cash flow, and analyze profitability by business line. I identify inefficiencies, optimize expenses, and support leadership decisions on pricing, cost reduction, and investments by defining and monitoring financial targets.

Previously, I directed financial operations and reporting as a Financial Executive at Mercury Towers / Melia Hotels International, ensuring data integrity, bank payments/reconciliations, and compliance. Earlier, as Financial Controller & Planning at Linea Directa SAS, I led annual budgeting (10-figure budgets), built forecasts and scenario simulations, and developed Power BI dashboards tracking performance vs. budget across multiple currencies, all through repeatable, cross-functional financial frameworks.

Experience

Work history, roles, and key accomplishments

Current

Senior Financial Accounts

Current

Lle Educational Services Fzco

Jan 2025 - Present (1 year 5 months)

Oversaw and validated financial statements and managed cash flow forecasting to support operational liquidity. Analyzed profitability by business line and implemented expense optimization to strengthen pricing, cost reduction, and investment decisions.

Financial Statements Cash Flow Forecasting Profitability Analysis Budgeting & Forecasting KPI Tracking Financial Reporting Financial Modeling Financial Compliance Data Visualization

Financial Executive

Mercury Towers / Melia Hotels International

Jan 2023 - Jan 2025 (2 years)

Directed financial operations including accounts payable/receivable, payroll, and financial reporting while ensuring data integrity for reliable decision-making. Managed bank payments and reconciliations across multiple accounts and currencies and improved control and cash flow visibility.

Payroll Operations Financial Reporting Bank Reconciliation Financial Compliance Audit Readiness Data Integrity Cash Flow Management

Financial Controller & Planning

Linea Directa Sas

Jan 2020 - Jan 2023 (3 years)

Served as a financial partner to leadership by delivering strategic analysis to support budgeting and business decisions. Built forecasts and scenario simulations, developed Power BI dashboards for budget vs. performance tracking, and consolidated multi-currency financial statements into repeatable reporting frameworks.

Financial Analysis Budgeting Financial Forecasting Scenario Modeling Power BI SQL BigQuery

Account Coordinator

Linea Directa Sas

Jan 2016 - Jan 2020 (4 years)

Managed accounts receivable to maintain collection targets and worked with commercial teams to improve financial performance. Performed credit analysis and application of payments while ensuring accurate financial data for reporting and operational clarity.

Accounts Receivable Collections Management Credit Analysis Payment Application Reporting Operational Finance