Freelancer profile translated to English.

Description

Hello, I am Antonio Ametrano, I am motivated by the experience of seeing simple data transformed into a business idea or a solution to a problem. I have more than three years dedicated to data analysis and visualization in the real estate sector and one in the sale of used vehicles. However, I am trained to work on commercial, academic and legal projects, with extensive experience in the latter two.

Main technical skills

• Python (Pandas, Playwright/BeautifulSoup): Extraction, cleaning and transformation of data from portals of various kinds. I implement automatic processes that avoid blockages and optimize times.

• Advanced Excel: Pivot tables, complex formulas and Power Query to debug data before integrating them into larger solutions; use of macros to automate repetitive processes.

• Power BI: Data modeling with fact and dimension tables, creation of DAX measures, performance KPIs and interactive visualizations (scatter plots, maps, opportunity ranking). I configure automatic updates in the cloud service.

Experience in real estate (3 years)

• I have developed more than 20 dashboards aimed at identifying investment opportunities: analysis of price per m², price trends by sector and studies of rent coverage versus mortgage payment.

• I documented detailed processes (CSS selectors, transformations in Pandas) and delivered user manuals to facilitate the adoption of the reports.

Projects in used vehicle sales (1 year)

• I built scrapers that extract brand, model, year, mileage and price from different portals. I normalized data and developed a series of dashboards of significant added value, using the best technology in the presentations.

• I developed an automated system in Python that weekly detects listings with prices below the average and sends reports of “relevant opportunities”.

Industry field of expertise

Languages

Spanish
Native or bilingual
English
Conversational

Workplace preferences

Remote only

Primarily works remotely

Ansalud Unidad de Rehabilitacion Mental
Administrator and partner
HEALTH AND WELLNESS
January 2016 - November 2021 (5 years and 10 months)
Santo Domingo, Dominican Republic
I managed the creation of the company including the documentation, obtaining the license and legal authorization, I created its internal rules, hired its personnel, initiated and maintained contact with the main institutions linked to the sector, I did marketing work, started its operation and signed a significant number of commercial contracts.
Consultor independiente
Web scraping, data analysis and reporting projects
January 2023 - Today (3 years and 5 months)
Santo Domingo, Dominican Republic
My original profession is that of a lawyer with a postgraduate degree. I have taken a turn to the area of programming and technology and this is what I am working on. I have around one year dedicated to data analysis and visualization in the real estate sector and in the sale of used vehicles. However, I am trained to work on commercial, academic and legal projects, with extensive experience in the latter two.
Main technical skills
• Python (Pandas, Playwright/BeautifulSoup): Extraction, cleaning and transformation of data from portals of various kinds. I implement automatic processes that avoid blockages and optimize times.
• Advanced Excel: Pivot tables, complex formulas and Power Query to debug data before integrating them into larger solutions; use of macros to automate repetitive processes.
• Power BI: Data modeling with fact and dimension tables, creation of DAX measures, performance KPIs and interactive visualizations (scatter plots, maps, opportunity ranking). I configure automatic updates in the cloud service.
Experience in real estate (3 years)
• I have developed more than 20 dashboards aimed at identifying investment opportunities: analysis of price per m², price trends by sector and studies of rent coverage versus mortgage payment.
• I documented detailed processes (CSS selectors, transformations in Pandas) and delivered user manuals to facilitate the adoption of the reports.
Projects in used vehicle sales (1 year)
• I built scrapers that extract brand, model, year, mileage and price from different portals. I normalized data and developed a series of dashboards of significant added value, using the best technology in the presentations.
• I developed an automated system in Python that weekly detects listings with prices below the average and sends reports of “relevant opportunities”.