KARELYS MENDOZA

Data Analyst | Digital Consultant | Real Estate

ABOUT ME

Highly motivated and effective professional. Mother of two. Recently moved to Frankfurt am Main for personal reasons. Looking for a new challenge in Data Analysis and/or Digital Consulting. I want to combine my long experience in Real Estate with Data Analysis and Technology. For that I continue to develop skills in Python, SQL, Tableau, Power BI, Big Query, Looker, Machine Learning and beyond.

Phone: (+49) 1706128950

Email: karemen@gmail.com

Website: www.kmendoza.info

Current address: Frankfurt am Main (Germany)

Languages: Spanish, English and currently learning German (Integrationkurs, Level B1).

MY RESUME

EXPERIENCES

Stadtdaten, Frankfurt – Germany                                                                                                                                            09/2022 - Present Co-Founder/Data Analyst

Making key Real Estate data accessible to everyone to help people make better decisions

Skills: Self-employment · Pandas (Software) · Data Visualization · Data Analytics · Cloud Computing · SQL · Tableau · Python (Programming Language) · Microsoft Power BI · Business Strategy · Real Estate

JLL, Madrid - Spain                                                                                                                                                             09/2016 – 03/2021  Senior Consultant Capital Markets – Residential Investment

JLL is a Technology company providing Real Estate services. They help their customers to improve their decision-making processes by providing accurate market analysis and asset value estimation. 

Managed multi-million euro Capital Markets transactions throughout Spain, using ML/AI/Big Data tools (such as GEA), and feeding accurately huge databases.

Responsible for Real Estate market analysis and asset value estimation. Also responsible for analyzing the different Business Strategies and choosing the most optimal one for each project.

Build trust with buyer/seller customers. The CRM of these customers is done with CapForce/SalesForce

Skills: Valuation · Consultation · Communication · Business Intelligence (BI) · Data Analytics · Microsoft Power BI · Creative Problem Solving · Business Strategy · Real Estate, “ad hoc” ML/AI tool, CapForce/SalesForce

JLL, Madrid - Spain                                                                                                                                                             02/2014 – 09/2016  Commercial Manager of Residential Asset

Responsible for the commercialization of foreclosed residential assets. Portfolio management valued at approximately €83M, comprising more than 400 Real Estate assets.

Participated in the creation of an “ad hoc” web tool for the management of residential Real Estate assets.

Skills: User Experience (UX) · Valuation · User Interface Design · Creative Problem Solving · Real Estate · Microsoft Office · Bienes inmuebles 

Grupo Rentalis, Madrid - Spain                                                                                                                   10/2012 - 05/2014  Founder/Commercial Real Estate Consultant 

Portfolio management of 45 properties - Commercialization of the product, preparation of asset value estimation, preparation of economic and financial feasibility studies. Responsible for the closing of operations, through the elaboration and management of the signing of contracts and delivery of keysManagement of the company.

Skills: Consultation · Rentals · Self-employment · Creative Problem Solving · Real Estate · Microsoft Office

Apartyment Soluciones de Vivienda, Madrid - Spain                                                                                              12/2010 – 08/2012 Commercial Real Estate Consultant

Portfolio management of 135 properties - Commercialization of the product, preparation of asset value estimation, preparation of economic and financial feasibility studies. Responsible for the closing of leasing operations, through the elaboration and management of the signing of leasing contracts and delivery of keysProperty ManagementManagement of the company.

Skills: Consultation · Rentals · Creative Problem Solving · Negotiation · Real Estate · Microsoft Office

Bovis Lend Lease, Madrid - Spain                                                                                                                                 06/2008 – 06/2009 Construction Manager Junior - Internship 


New Wyeth-Farma Pharmaceutical Building Project - €9.5 million

Wyeth-Farma Office Building Refurbishment Project - €2.6 million

Coordination of subcontractors and sequence of activities to be executed in the "urbanization package" of the new building (Gantt). Budget of €120.000 - Cost and time control by applying the "Earned Value" - Support in the preparation of the "Cost Plan" for the Refurbishment Project of the office building -Planning in MS Project. 

Skills: Project Management · Microsoft Project · Microsoft Office

Baruta City Hall, Caracas – Venezuela                                                                                                                             10/2005 – 02/2008 Specialist in Urban Management

Systematization of the calculation, notification, collection and follow-up of the Special Added Value Tax to manage the financing of urban plans. Collection of ca. €916,000.

Skills: Microsoft Office

TRANSyT – Research Center UPM, Madrid - Spain                                                                                                   05/2005 – 09/2005 Researcher - Internship 

Development of a strategic environmental assessment ("Environmental Screening") based on the "Strategic Environmental Assessment of infrastructure plans of the Community of Castilla y León". ArcGIS (GIS) was used to quantify and qualify direct and indirect impacts. As an additional result, modifications to the infrastructure plans proposed by national entities were recommended.

Skills: ArcGIS Products · Microsoft Office

EDUCATION

DATA ANALYST WITH PYTHON (01/2023 – 06/2023)

Datacamp – app.datacamp.com (Certification available)


CRASH COURSE ON PYTHON (09/2022 - 12/2022)

Google Coursera


ENTERPRISE DESIGN THINKING PRACTITIONER (05/2022 - 06/2022)

IBM


GOOGLE CLOUD DIGITAL LEADER TRAINING (11/2021 - 04/2022)

Google Coursera


MASTER'S DEGREE IN REAL ESTATE MANAGEMENT (10/2009 – 06/2010)

UNIVERSIDAD EUROPEA DE MADRID (Madrid, Spain)


MASTER'S DEGREE IN PROJECT AND CONCESSION MANAGEMENT AND FINANCING (02 - 12/2008)

UNIVERSIDAD EUROPEA DE MADRID (Madrid, Spain) 


URBAN PLANNER (09/1999 – 11/2005)

UNIVERSIDAD SIMÓN BOLÍVAR (Caracas, Venezuela)

Homologated in Spain with No. 0672263/2009/H02349

CERTIFICATIONS

CRASH COURSE ON PYTHON

API / DATA VISUALIZATION WITH TABLEAU SPRINTS

CONTACT

Frankfurt am Main (Germany) - +491706128950

Email: karemen@gmail.com