Data Analyst Real Estate

Data Analyst/ Business Analyst

FELIPE COELHO

+55-11-919**-**** ****************@*****.***

https://www.linkedin.com/in/felipe-coelho-372b952b6/ Portfolio Link

Brazil, SP 08970-000

Skills

• SQL (My SQL, Postgre SQL)

• Python (Pandas, BeautifulSoup)

• Tableau

• Excel (XLookup, Conditional Formatting, Pivot Tables)

• Google Cloud Data Analytics Tools (Python, SQL,

Looker)

• Microsoft Power BI (Powerquery, Dax, Data Vis)

Projects

USER BASE INCREASE (DIVVY BIKES) – Personal Project (Google Data Analytics Capstone)

● Utilized SQL to query and clean a 9 million rows DB

● Explored the data using Tableau, uncovering insights and correlations.

● Compiled an Interactive Report in Tableau and a presentation in Powerpoint for practical suggestions. REAL ESTATE OPPORTUNITIES UNCOVERING – Personal Project

● Scrapped a big brazilian auctions website using Python Beautifulsoup and created a dataset

● Cleaned the data with Python.

● Provided an interactive dashboard with PowerBI, with the map of the state and all Real Estate opportunities. FINTECH PERFORMANCE DASHBOARD TRACKER – Personal Project (Google Cloud Data Analytics Capstone)

● Utilized Bigquery SQL to clean and query the dataset.

● Imported the SQL Consultation to Looker Studio and created an interactive dashboard. SALES TRACKING DASHBOARD – Personal Project

● Utilized Powerquery to clean the dataset and create calculated columns

● Set a Snowflake Schema for the dataset and used DAX formulas to create measures.

● Made an interactive dashboard in Power BI that tracks Sales Performance. MARKET SALES IMPROVAL – Personal Project

● Cleaned and prepared a dataset using Powerquery.

● Created measures with DAX and then stablished a schema.

● Explored the data with Power BI visualization tools.

● Created an interactive dashboard and Powerpoint presentation to transmit insights CUSTOMER SERVICE IMPROVAL (GOOGLE FIBER) – Personal Project (Google Business Intelligence Capstone)

● Utilized EXCEL to clean and prepare data for visualization.

● Explored data in Tableau to uncover the performance of store’s customer service.

● Built an interactive Dashboard in Tableau and a presentation in PowerPoint to present insights and suggestions. Related Work Experience

SERVICES PERFORMANCE ANALYST – Verbum Vitae Association (Volunteer work) – BRAZIL FEB 2019 - MARCH 2021

● Monitored a 40 volunteers team performance on general social services. Built regular reports on Excel and tracking tools.

● Presented regularly to association directors my analysis on how to get better results and how to improve the performance of each volunteer. Personal habilities analysis.

INVESTMENT ANALYST ASSISTANT – Verbum Vitae Association (Volunteer work) – BRAZIL MARCH 2021 - DEC 2022

● I assisted the association's investment manager with real estate preparation and sales, contributing to analysis and decision- making.

● I helped analyze the entire car fleet replacement during the period, including cost-benefit research and data-driven suggestions. LOGISTICS AND COST ANALYST – Verbum Vitae Association (Volunteer work) – BRAZIL JAN 2023 - AUG 2024

● Implemented cost-reduction strategies by identifying financial inefficiencies and proposing actionable solutions.

● Analyzed and optimized logistics, focusing on vehicle management and food transportation processes.

● Managed the simultaneous logistics of a 10-vehicle fleet, integrating the team to improve efficiency and results

● Built Regular reports with Excel and PowerPoint. Education

GOOGLE DATA ANALYTICS PROFESSIONAL CERTIFICATE Certificate here Proficient in SQL, Excel, Tableau, and completed a Capstone Project applying data analysis skills to real-world scenarios. GOOGLE BUSINESS INTELLIGENCE PROFESSIONAL CERTIFICATE Certificate here Developed skills in data analysis, visualization, and business insights using Google tools. GOOGLE ADVANCED DATA ANALYTICS PROFESSIONAL CERTIFICATE (IN PROGRESS - Not yet finished) Developed expertise in advanced data analysis, utilizing tools such as Python, SQL, and machine learning techniques to extract insights and drive business decisions.

Contact this candidate