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).
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 keys – Management 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 keys – Property Management – Management 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
Frankfurt am Main (Germany) - +491706128950
Email: karemen@gmail.com