Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic
Julian Camilo Lopez Sanchez

Julian Camilo Lopez Sanchez

Real Estate Data Analyst
Bogotá

Summary

Highly motivated and analytical Data Analyst with background in financial analysis and real estate data. Proficient in leveraging advanced data analysis techniques and visualization tools to deliver actionable insights and support strategic decision-making. Adept at collecting, cleaning, and analyzing complex datasets, with hands-on experience in web scraping, financial modeling, and market research. Demonstrates strong analytical skills, attention to detail, and a commitment to delivering high-quality results within deadlines. Proven ability to communicate findings effectively and contribute to data-driven strategies that drive business growth.

Overview

4
4
Certifications

Work History

Software Development

Solución Empresarial
08.2024 - 08.2024
  • Led the development of an MVP software solution for coding contributions for the PILA system, using Google Sheets, JavaScript, and HTML visualization.
  • Managed the project from conception to completion, ensuring strict adherence to budgetary constraints and timeline targets.
  • Integrated security measures into the software development lifecycle, incorporating secure coding practices and security testing tools.
  • Applied best practices in software development, ensuring consistency across the project and adherence to industry standards.
  • Collaborated with cross-functional teams to integrate the software seamlessly into existing systems, minimizing disruption and optimizing functionality.
  • Enhanced data management and reporting capabilities, enabling efficient handling of contributions for companies and individuals within the PILA framework.

Real Estate Data Analysis

Tuddi
07.2024 - 07.2024
  • Collected real estate data through web scraping and direct acquisition from a real estate agency.
  • Performed extensive preprocessing, including data cleaning, manipulation, and transformation, to ensure data quality and consistency.
  • Conducted detailed data analysis to uncover insights and trends, focusing on identifying attractive investment opportunities.
  • Developed visualizations using Python in Jupyter notebooks to effectively communicate findings and support data-driven decisions.
  • Identified properties with significant discounts and potential for investment, providing actionable recommendations.
  • Executed the project for Tuddi, a startup specializing in real estate listings in Colombia, enhancing their data-driven strategies and insights.

Freelancing

Upwork Client
05.2024 - 06.2024
  • Consistently delivered high-quality work ahead of deadlines, receiving a client rating of 4.6 out of 5 for speed and efficiency.
  • Adapted swiftly to changing project requirements, showcasing flexibility and adaptability under pressure.
  • Developed customized solutions to address unique client needs, resulting in repeat business and referrals.
  • Strengthened client relationships with regular communication and timely updates, earning praise for sincerity and dedication.
  • Executed complex tasks effectively, demonstrating a thorough understanding of project requirements and delivering results within tight deadlines.
  • Worked on exciting Machine Learning projects involving least squares regressions, dual representations, and Gaussian kernel approximations.

Trading Strategy Analysis

Family Business
04.2024 - 04.2024
  • Conducted an in-depth analysis of emerging public companies using advanced trading strategies and financial theories from seminal papers.
  • Applied methodologies from "Value Investing: The Use of Historical Financial Statement Information to Separate Winners from Losers" to evaluate the financial health and potential of emerging companies.
  • Utilized insights from "An Empirical Evaluation of Accounting Income Numbers" to assess the reliability and predictive power of financial statements.
  • Incorporated findings from "Do Stock Prices Fully Reflect Information in Accruals and Cash Flows about Future Earnings?" to analyze stock price efficiency and its implications for future earnings predictions.
  • Evaluated strategies based on "Betting Against Beta" to understand the relationship between risk and return in emerging markets.
  • Implemented momentum strategies as outlined in the paper "Momentum" to identify and capitalize on trends in stock prices.
  • Provided actionable recommendations for investment decisions based on comprehensive analysis of these strategies and their application to emerging public companies.

Education

Bachelor of Science - Civil Engineering

Universidad De Los Andes
Bogota, Colombia
05.2001 -

Skills

    Soft Skills
  • Communication Skills: Effective verbal and written communication for reporting and presenting findings, and explaining complex data to stakeholders
  • Problem-Solving: Capability to develop customized solutions and strategies based on data analysis and overcome data-related challenges
  • Adaptability: Flexibility in handling changing project requirements and quickly learning and applying new tools and methodologies
  • Collaboration: Experience working effectively in cross-functional teams and supporting strategic planning and decision-making
  • Time Management: Efficiently managing multiple tasks and deadlines, delivering high-quality work within specified timelines
    • Hard Skills
  • Python: Advanced proficiency in data analysis, visualization, machine learning, deep learning, and web scraping (including libraries such as Pandas, NumPy, Matplotlib, Seaborn, Plotly, Scikit-learn)
  • SQL: Skilled in querying databases, performing data manipulations, and integrating data sources
  • JavaScript: Experience in enhancing web applications with interactive functionalities
  • HTML: Basic understanding for web page creation and customization
  • Excel: Advanced skills in data manipulation, analysis, and financial modeling
  • Power BI: Expertise in creating interactive dashboards and visualizations

Certification

AI in Healthcare Specialization

Timeline

Software Development

Solución Empresarial
08.2024 - 08.2024

Real Estate Data Analysis

Tuddi
07.2024 - 07.2024

Freelancing

Upwork Client
05.2024 - 06.2024

Trading Strategy Analysis

Family Business
04.2024 - 04.2024

Bachelor of Science - Civil Engineering

Universidad De Los Andes
05.2001 -

Similar Profiles

CREATE PROFILE
Julian Camilo Lopez SanchezReal Estate Data Analyst