Manuel Barahona Gandia

Extremely motivated to constantly develop my skills and grow professionally. I am flexible, reliable and very keen to progress within my career and be able to pass on my knowledge gained within my vast experience within the industry

BI and Analytics ManagerBI and Analytics Manager

Round Hill Capital · Full-timeRound Hill Capital · Full-timeFeb 2020 - Present · 3 yrsFeb 2020 - Present · 3 yrsMadrid, Community of Madrid, SpainMadrid, Community of Madrid, Spain

• Lead, coach, and inspire a team that offers effective data using Power BI to drive insights and intelligence in the business.
• Assist to IM, AM, PM , DM and Fund Controllers with preparation of quarterly investor reports and maintenance of financial models.
• Supports the execution of the Business Plan to achieve operational excellence by analysing reports and underwritings.
• Work closely with Corporate Finance integrating our different accounting systems with Power BI to deliver automated reconciliation in GAAP/IFRS accounting standards.
• Building, modifying and updating complex financial models (Power BI or Excel), creating scenarios in the models and produce results for external and internal purposes.
• Act like an Business Consultant to enhance current process and implement efficiency. Promoting the "One Source Of Truth" and truly data driven organisation. 
• Developing data models in Power BI or Excel and visualizing insights bringing life to the data. (DAX and Power Query)
• Supporting the Lead Data Engineering for data ingestion and ETL techniques with MSFT platform tools, both OnPrem (SQL Server Analysis Services) and in the Cloud (Azure Data Factory)

Power BI • M Power Query • DAX • Modern Excel(E365) • Tableau • SQL • Python • R • VBA• Lead, coach, and inspire a team that offers effective data using Power BI to drive insights and intelligence in the business. • Assist to IM, AM, PM , DM and Fund Controllers with preparation of quarterly investor reports and maintenance of financial models. • Supports the execution of the Business Plan to achieve operational excellence by analysing reports and underwritings. • Work closely with Corporate Finance integrating our different accounting systems with Power BI to deliver automated reconciliation in GAAP/IFRS accounting standards. • Building, modifying and updating complex financial models (Power BI or Excel), creating scenarios in the models and produce results for external and internal purposes. • Act like an Business Consultant to enhance current process and implement efficiency. Promoting the "One Source Of Truth" and truly data driven organisation. • Developing data models in Power BI or Excel and visualizing insights bringing life to the data. (DAX and Power Query) • Supporting the Lead Data Engineering for data ingestion and ETL techniques with MSFT platform tools, both OnPrem (SQL Server Analysis Services) and in the Cloud (Azure Data Factory) Power BI • M Power Query • DAX • Modern Excel(E365) • Tableau • SQL • Python • R • VBA

Skills: Strategy · Real Estate Financing · Forecasting · Analytics · Presentation Skills · SQL · Business Development · Business InsightsSkills: Strategy · Real Estate Financing · Forecasting · Analytics · Presentation Skills · SQL · Business Development · Business Insights

Senior Business AnalystSenior Business Analyst

Aroundtown Commercial Properties · Full-timeAroundtown Commercial Properties · Full-timeJan 2018 - Feb 2020 · 2 yrs 2 mosJan 2018 - Feb 2020 · 2 yrs 2 mosAmsterdam Area, NetherlandsAmsterdam Area, Netherlands

Key Achievements – build detailed, fully integrated financial consolidation reports for IFRS and Dutch GAAP for all the portfolios connected to the Yardi Voyager software saving huge time and allowing efficiency at all levels. Building and oversight a wide variety of financial models:
- Rent Roll and Tenant Schedule
- Incentive Analysis (Rent Free and Tenant Incentive)
- CapEX analysis.
- Cash flow of the PropCo's.
- Asset Management overview

• Assist in the asset management reporting across the portfolio including preparation of monthly and quarterly reports and maintenance of financial models. 
• Consolidation and analysis of results for quarterly and annual reports.
• Defining and preparing processes for annual budgeting and monthly forecasting cycles and performance reporting.
• Cooperation with Asset Management team to facilitate regular asset reviews.
• Involvement in the set-up of strategic 5-year business plan.
• Managing and supervising cash activities.
• Automate manual business processes into refreshable connections using excel power query and power pivot.Key Achievements – build detailed, fully integrated financial consolidation reports for IFRS and Dutch GAAP for all the portfolios connected to the Yardi Voyager software saving huge time and allowing efficiency at all levels. Building and oversight a wide variety of financial models: - Rent Roll and Tenant Schedule - Incentive Analysis (Rent Free and Tenant Incentive) - CapEX analysis. - Cash flow of the PropCo's. - Asset Management overview • Assist in the asset management reporting across the portfolio including preparation of monthly and quarterly reports and maintenance of financial models. • Consolidation and analysis of results for quarterly and annual reports. • Defining and preparing processes for annual budgeting and monthly forecasting cycles and performance reporting. • Cooperation with Asset Management team to facilitate regular asset reviews. • Involvement in the set-up of strategic 5-year business plan. • Managing and supervising cash activities. • Automate manual business processes into refreshable connections using excel power query and power pivot.

Skills: Strategy · Forecasting · Analytics · Statistical Data Analysis · Presentation Skills · Business DevelopmentSkills: Strategy · Forecasting · Analytics · Statistical Data Analysis · Presentation Skills · Business Development

BI Data AnalystBI Data Analyst

TROOSTWIJK · Full-timeTROOSTWIJK · Full-timeSep 2016 - Dec 2017 · 1 yr 4 mosSep 2016 - Dec 2017 · 1 yr 4 mosAmsterdam Area, NetherlandsAmsterdam Area, Netherlands

Key Achievements – Research team is responsible for gathering, configuration, analysis and execution of the BI Project. Creation of diverse cubes using SSAS technologies to develop an Online Analytical Processing (OLAP) solution. 
Goal is transform and shift the current process into the Business Intelligence world.

• Developing and providing Real Estate insights to departments through interpretation of queries, reports, dashboards, and other metrics within the BI tools (Power BI and Tableau).
• Establish reporting methodologies, perform ad-hoc database analysis to support automations to Internal Departments.
• Performing design; write technical specifications; programming in the BI tools making automated graphs and reports.
• Develop analytical techniques and ways of presenting data / information depending on the audience.
• Post evaluation of the delivery and enrich data.
• Contribute to project teams and take responsibility for completing high quality work within agreed timescales.
• Creation of clear dashboards from large amount of data to deliver visualization to diverse internal departments.Key Achievements – Research team is responsible for gathering, configuration, analysis and execution of the BI Project. Creation of diverse cubes using SSAS technologies to develop an Online Analytical Processing (OLAP) solution. Goal is transform and shift the current process into the Business Intelligence world. • Developing and providing Real Estate insights to departments through interpretation of queries, reports, dashboards, and other metrics within the BI tools (Power BI and Tableau). • Establish reporting methodologies, perform ad-hoc database analysis to support automations to Internal Departments. • Performing design; write technical specifications; programming in the BI tools making automated graphs and reports. • Develop analytical techniques and ways of presenting data / information depending on the audience. • Post evaluation of the delivery and enrich data. • Contribute to project teams and take responsibility for completing high quality work within agreed timescales. • Creation of clear dashboards from large amount of data to deliver visualization to diverse internal departments.

Skills: Analytics · Statistical Data Analysis · Presentation Skills · SQLSkills: Analytics · Statistical Data Analysis · Presentation Skills · SQL

NPL Portfolio AnalystNPL Portfolio Analyst

Hudson Advisors, LLC (Lone Star Funds) · Full-timeHudson Advisors, LLC (Lone Star Funds) · Full-timeJan 2015 - Sep 2016 · 1 yr 9 mosJan 2015 - Sep 2016 · 1 yr 9 mosDublinDublin

Key Achievements – EPA team is responsible for the cash reconciliation and portfolio accounting over all the European deals SPV (Special Purpose Vehicle) and REO (Real Estate Owned) structures (Performing Loans and Non Performing Loans).

• Monitoring NPL and debt collections received in relation to loans and ensuring accurate balances as per waterfall requirements. 
• Programming in VBA to interpret and support portfolio analysis. Goal is to enhance data interrogation and automation oversight.
• Supporting Portfolio Management by developing and maintain reports and models to identify performance issues.
• Reconciliation of balances between Asset Ledger and the General Ledger in our systems.
• Ad-hoc requested by the Asset Managers such as Interest Agreement Letter, Statements, Default scenarios or Interest Cert.
• Analyze and validate financials to identify disparities and correct inaccuracies.
• Calculating and processing any Direct Debit associated with the loans within any portfolio.
• Generation of Accounting Reports for internal department (Asset Management, Portfolio Management)
• Liaising with Debt Compliance – preparing quarterly consolidations for the investments and/or to the third party financing.
• Liaising with Treasury – processing and preparation of the invoices on behalf of any European SPV.
• Liaising with Investment Accounting – conducting detailed portfolio analysis to reconcile general ledger and journal entries.Key Achievements – EPA team is responsible for the cash reconciliation and portfolio accounting over all the European deals SPV (Special Purpose Vehicle) and REO (Real Estate Owned) structures (Performing Loans and Non Performing Loans). • Monitoring NPL and debt collections received in relation to loans and ensuring accurate balances as per waterfall requirements. • Programming in VBA to interpret and support portfolio analysis. Goal is to enhance data interrogation and automation oversight. • Supporting Portfolio Management by developing and maintain reports and models to identify performance issues. • Reconciliation of balances between Asset Ledger and the General Ledger in our systems. • Ad-hoc requested by the Asset Managers such as Interest Agreement Letter, Statements, Default scenarios or Interest Cert. • Analyze and validate financials to identify disparities and correct inaccuracies. • Calculating and processing any Direct Debit associated with the loans within any portfolio. • Generation of Accounting Reports for internal department (Asset Management, Portfolio Management) • Liaising with Debt Compliance – preparing quarterly consolidations for the investments and/or to the third party financing. • Liaising with Treasury – processing and preparation of the invoices on behalf of any European SPV. • Liaising with Investment Accounting – conducting detailed portfolio analysis to reconcile general ledger and journal entries.

Skills: Forecasting · Analytics · Presentation SkillsSkills: Forecasting · Analytics · Presentation Skills

Product DocumentationProduct Documentation

Amundi · Full-timeAmundi · Full-timeJan 2013 - Jan 2015 · 2 yrs 1 moJan 2013 - Jan 2015 · 2 yrs 1 moDublinDublin

Key Achievements – Responsible for developing an automated KIID process (over nine thousand KIIDs in over 16 languages) resulting in significant cost and resource savings.
Awards – “Pioneer of the Year” accolade in 2013.

• Support UCITS products for fund launches / share class launches / merger / closures from a KIID perspective.
• Project Management the legal and marketing material according to the scheduled plan. Assist to Product Managers as BAU.
• Interface with internal stakeholders, assist to PWG Boards, and work along with the Product Managers to ensure delivery.
• Create, update and publish KIID documents as required by UCITS IV regulations with CSSF Regulator and local jurisdictions.
• Project Management uploads of KIIDs and legal material to the external website as well as internal intranet or 3rd parties.
• Participating in a system enhancements of the KIID document and Implementation (Business Analyst and Executing Testing)
• Manage production & translations of the communication to unit holders (UHN, Q&A AR, SAR and Prospectus).
• Assisting to Legal Lux for registration and listing of the ISINs in the Country of Registration file.
• Maintain the documentation in SharePoint to ensure all teams have access to the most recent materials KIIDs and Factsheets.
• Produce, proofread and edit shareholder communication pieces according with Legal Regulatory.
• Manage relationships with external data vendors (invoices) and act as central point of contact for data issues.Key Achievements – Responsible for developing an automated KIID process (over nine thousand KIIDs in over 16 languages) resulting in significant cost and resource savings. Awards – “Pioneer of the Year” accolade in 2013. • Support UCITS products for fund launches / share class launches / merger / closures from a KIID perspective. • Project Management the legal and marketing material according to the scheduled plan. Assist to Product Managers as BAU. • Interface with internal stakeholders, assist to PWG Boards, and work along with the Product Managers to ensure delivery. • Create, update and publish KIID documents as required by UCITS IV regulations with CSSF Regulator and local jurisdictions. • Project Management uploads of KIIDs and legal material to the external website as well as internal intranet or 3rd parties. • Participating in a system enhancements of the KIID document and Implementation (Business Analyst and Executing Testing) • Manage production & translations of the communication to unit holders (UHN, Q&A AR, SAR and Prospectus). • Assisting to Legal Lux for registration and listing of the ISINs in the Country of Registration file. • Maintain the documentation in SharePoint to ensure all teams have access to the most recent materials KIIDs and Factsheets. • Produce, proofread and edit shareholder communication pieces according with Legal Regulatory. • Manage relationships with external data vendors (invoices) and act as central point of contact for data issues.

Skills: Analytics

Ba(hons) in Finance.  Place:  Dublin   University:  DBS Dublin Business School   Dates: 2008-2012

FP2 Informatica. D.A.I. (Desarrollo de app. Informaticas)  Place: Madrid   University: Colegio JOYFE  Dates: 2002-2004