Looking for a job

João Fernandes

@joofernandes2

Data and BI Specialist at Meliá Hotels International, building ESG reporting models for 383 hotels and automating validation.

Spain

Message

At Meliá Hotels International, I built semantic models for corporate reporting across 383 hotels, covering approximately 150 ESG datapoints. I also contributed to CSRD reporting and automated recurring reporting and validation with Power Automate, Python, and Power BI.

At ION Group, I built and owned a Group Finance consolidation model covering 200+ legal entities. I led 5+ post-acquisition data migrations and automated intercompany reporting, saving approximately one week of labour during month-end close.

Experience

Work history, roles, and key accomplishments

Current

Data and BI Specialist

Current

Meliá Hotels International

Apr 2024 - Present (2 years 7 months)

Contributed to CSRD reporting by improving ESG reporting and supporting audit. Built semantic models for corporate reporting across 383 hotels, covering approximately 150 ESG datapoints.

MS Fabric Power BI SAP Datasphere SAP BW Power Automate Workiva ESG Reporting CSRD Data Validation Semantic Modeling

Finance transformation data analyst

ION Group

Apr 2019 - Dec 2023 (4 years 8 months)

Built and owned the Group Finance consolidation model covering 200+ legal entities and multi-currency financial data. Led 5+ post-acquisition data migrations and automated intercompany reporting processes.

Power BI DAX Power Query SQL Python Power BI Dataflows NetSuite Salesforce PowerApps Power Automate Git Jira Financial Consolidation ETL R2R O2C P2P

Finance and BI Analyst

Infosys BPM

Mar 2018 - Apr 2019 (1 year 1 month)

Analysed financial statements and corporate disclosures in Bloomberg Terminal using IFRS and US GAAP. Produced and reviewed sector, ETF and fund research for financial and market reporting.

Bloomberg Terminal Excel PowerPoint Financial Analysis IFRS US GAAP

Finance Assistant

TIMWE Group

May 2017 - Feb 2018 (9 months)

Prepared daily cash and bank reconciliations for executives, supporting liquidity visibility and financial controls. Supported weekly Accounts Payable planning and built a debt tracker for internal management.

Cash Reconciliation Bank Reconciliation Accounts Payable Financial Control Debt Tracking