Caesar Klidge Galutera

Caesar Klidge Galutera

About

Detail

Data Analyst at Freedom Property Investors | Aspiring Data Engineer | Expertise in SQL • Python • Excel • Looker Studio • AWS • HubSpot
Metro Manila, Philippines

Timeline


work
Job
school
Education
folder
Project

Résumé


Jobs verified_user 0% verified
  • Freedom Property Investors
    Data Analyst
    Freedom Property Investors
    Jun 2025 - Current (1 year 5 months)
  • Freedom Property Investors
    Data Analyst Intern
    Freedom Property Investors
    Dec 2024 - May 2025 (6 months)
    • Designed and delivered 10+ tailored reports and dashboards, enabling data-driven strategic planning
    • Queried, cleaned, and transformed datasets with over 50,000 records using Google BigQuery and SQL, improving data quality and enabling more accurate analysis and reporting
    • Presented monthly performance insights and data-backed recommendations to stakeholders, influencing resource allocation and project direction
    • Assisted the team in building 10+ automated, interactive dashboards in Looker Studio to provide real-time visibility into KPIs such as conversion rates, and property performance
    • Developed visually compelling slide decks and reports for internal proposals, increasing stakeholder engagement and clarity of b
  • L
    Community Center Finance & Administrative Associate
    LoveYourself Inc
    Jan 2024 - Dec 2024 (1 year)
    • Oversaw daily operations of a community center serving 50+ clients monthly, ensuring financial transparency and operational continuity
    • Streamlined procurement and payment processes, reducing overhead delays by 30% and supporting uninterrupted service delivery
    • Coordinated logistics for 20+ center-based and outreach activities, ensuring timely execution and resource availability
    • Collaborated with internal departments (CMO, LY-SR, PR) and 10+ external partners to align efforts for HIV-related services and testing campaigns
    • Supported implementation of community-based HIV initiatives, achieving 100% adherence to program timelines and budget allocations
    • Led planning and delivery of 15+ community engagements an
Education verified_user 0% verified
  • University of Baguio
    Bachelor's degree, Computer Science
    University of Baguio
    Aug 2021 - Jun 2025 (3 years 11 months)
Projects (professional or personal) verified_user 0% verified
  • S
    Serverless ETL Pipeline with OpenWeather API and AWS S3
    Apr 2025
    This project demonstrates a lightweight ETL (Extract, Transform, Load) pipeline using Python and cloud technologies. The script fetches real-time weather data from the OpenWeatherMap API, processes it to extract key metrics, and uploads the results to an AWS S3 bucket in JSON format.

    It’s designed to be deployable in a cloud function environment (e.g., AWS Lambda), showcasing key skills in API integration, cloud storage, and error handling.
  • H
    HubSpot CRM Integration & Data Reporting Automation
    Jan 2025 - Mar 2025 (3 months)
    As part of an initiative to streamline and centralize data management, I supported the transition of a partner team’s manual, Excel-based tracking system into a fully integrated HubSpot pipeline aligned with Freedom Property Investors’ main CRM environment.

    Key contributions:

    - Assisted in designing and configuring custom deal stages, pipelines, and property fields in HubSpot to align with the team's specific workflows.

    - Helped with data migration and cleanup from Excel into HubSpot, ensuring accuracy, consistency, and proper associations.

    - Developed a real-time reporting dashboard in Google Sheets powered by BigQuery, providing insights into attributed, non-attributed, and bulk property referra
  • C
    CMRMS: Designing and Developing a Centralized Medical Records Management System for University
    Jan 2024 - Dec 2024 (1 year)
    Led the end-to-end design and development of a Centralized Medical Records Management System (CMRMS) aimed at transforming how student and staff health data is managed across the university. The system integrates patient profiles, medical history tracking, and reporting functionalities into a secure, user-friendly platform.

    Key Contributions:

    - Led a small, cross-functional team of five developers, analysts, and UI/UX designers using Agile methodologies to deliver a centralized medical records system.
    - Designed the system architecture ensuring scalability, modularity, and integration with existing university systems.
    - Implemented secure login/authentication and data encryption protocols to ensure compliance
  • B
    Berrymart-Multivendor-ecommerce Project
    Mar 2023 - May 2023 (3 months)
    Berrymart is a multivendor eCommerce platform developed as a requirement for our Computer Science course. The project aimed to simulate a real-world marketplace where multiple vendors can register, manage their products, and sell to customers through a centralized system.

    Key Contributions as Business Analyst:

    - Gathered and analyzed functional and non-functional requirements from stakeholders (instructors, peers, and hypothetical vendors).
    - Defined business logic for vendor onboarding, product listings, order processing, and transaction tracking.
    - Collaborated closely with the developer to ensure the platform aligned with business goals and user expectations.

    Outcome:

    - Delivered a f