Philip Mateo Ramirez Parada
About
Detail
Junior BI Analyst
Bogota D.C., Colombia
Contact Philip regarding:
Flexible work
Starting at
USD10/hour
groups
Networking
Résumé
Jobs
verified_user
0% verified
- AData AnalystAlimentos Polar Colombia.Jul 2024 - Jan 2025 (7 months)• Identify and visualize potential clients for the company, using tools such as R, SQL, Excel, PowerBI, data sources such as (RUES, Italcol, OpenStreetMap, etc.) using web scraping, APIs (Google cloud: Geocoding, Places, Maps Javascript), georeferencing systems (ArcGis, Google Maps) and maps of Colombia (Shapefiles, GeoJson, etc.). • Build pricing dashboards for the Revenue Management strategy, through SQL storage, automation in R (CronR, Rvest, DBI and odbc), and tracking in Power BI and Excel of the company's weekly web scraping of prices, market share and KPIs in different countries (Colombia, Argentina, Ecuador, etc.), through e-commerce and websites. • Perform the identification and cleaning of unique customer data for the different
- UResearch Assistant - Sports EconomicsUniversidad de los Andes.Mar 2024 - May 2024 (3 months)• Responsible for conducting data collection procedures on Argentine Football Lineups in the mid-20th century, from PDF files with the help of Excel and Adobe (OCR). Additionally, I utilized Python to extract information from .txt files, which enhanced the efficiency of data processing. I managed a personal database using SQL to upload the extracted files and employed Business Intelligence (BI) tools to visualize the information, providing deeper insights into the data collected. Furthermore, I applied big data analysis techniques using R to explore larger datasets, which contributed to a more comprehensive understanding of trends and patterns within the sports economics field.
Education
verified_user
0% verified
Foundations: Data, Data, EverywhereGoogleJun 2023- Intermediate SQL QueriesDataCampJul 2022
- PIntroducción a la programación en Python I: Aprendiendo a programar con PythonPontificia Universidad Cat´ olica de ChileJul 2021
- UIntroducción a Data Science: Programación Estadística en RUniversidad Nacional AutónomaMéxico,Jun 2021
- B.S. EconomicsUniversidad de los AndesJan 2020 - Jan 2025 (5 years 1 month)
Projects (professional or personal)
verified_user
0% verified
- Web Scraping with e-commercesIndependienteMar 2025 - May 2025 (3 months)In my role focused on web scraping for e-commerce platforms, I developed and implemented automated scripts to extract product data, pricing, and inventory levels from various websites. This process not only improved data accuracy but also significantly reduced the time required for data collection. Additionally, I utilized BI (Business Intelligence) tools, specifically Power BI, to analyze and visualize key metrics such as index prices and stock levels, enhancing our ability to make informed business decisions based on real-time data insights.