Sobre 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
Experiencia
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
Educación
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
Profesionales del mismo sector Inmobiliaria que Manuel Barahona Gandia
Profesionales de diferentes sectores cerca de Madrid, Madrid
Otros usuarios que se llaman Manuel
Trabajos cerca de Madrid, Madrid
-
Consultor Power BI/Tableau
Encontrado en: Talent ES C2 - hace 3 horas
Grupo NS Madrid, España CompletaDescripción · Desde Grupo NS precisamos incorporar un consultor con amplia experiencia en Power Bi para una migración de informes de Tableau a PowerBI. · Skills · Power BI · Python · Valorable experiencia en Scala · Requisitos mínimos · Experiencia de al menos 3 años en power ...
-
Data Analyst
Encontrado en: Jobgoal ES C2 - hace 4 días
Buscadordetrabajo - Jobboard Madrid, EspañaInvolve RH cuenta con una posición como Data Analyst para transformar datos en información significativa para respaldar la toma de decisiones estratégicas de la empresa. Funciones: Analizar grandes conjuntos de datos para identificar tendencias y patrones. Desarrollar y mantener ...
-
Data Analyst Consultant
Encontrado en: Buscojobs ES C2 - hace 1 semana
Walters People Madrid, EspañaDesde Walters People buscamos un Data Analyst Consultant para incorporar en cliente proveedor de soluciones de software de forma indefinida.Buscamos un perfil con los siguientes requisitos:- Graduado en Ingeniería, Matemáticas, Física o similar.- Experiência en procesos ETL y de ...