You're seeing this page as if you were . The main menu is still yours, though. Exit from immersion
Jhonatan PalaciosJP

Jhonatan Palacios

Specialist in Analysis and BI.

€170/day
Santafe de Bogotá, CO
3-7 years

Average response time: 1 hour

Freelancer profile translated to English.
Back to original language

About Jhonatan

🎯 Data Analysis & Business Intelligence Specialist

Business Administrator with a Specialization in Business Intelligence Project Management and over 4 years of experience transforming data into strategic decisions.

I work with companies that need real visibility into their business: from interactive dashboards in Power BI to process automation with Python. I adapt quickly, deliver concrete results, and explain data clearly for non-technical profiles.

🔧 What I can do for you:
• Creation and optimization of dashboards in Power BI
• Data analysis and cleaning with SQL, Pandas, and Polars
• Report automation with Python and Vibe Coding
• Migration of Excel reports to Power BI
• Data modeling and KPI construction
• Training and capacity building in Power BI for teams
  • Spanish

    Native or bilingual

Remote only
Primarily works remotely

Experience

  • DROGUERIAS Y FARMACIAS CRUZ VERDE SAS.
    Senior Dispensing Analyst.
    PHARMACEUTICALS INDUSTRY
    January 2020 - Today (6 years and 7 months)
    Santafe de Bogotá, Colombia
    -Analysis and monitoring of the sufficiency of the Sura capitation for technical notes, Elaboration and monitoring of indicators, responsible for Dispensing capitation billing – SURA, Administration, analysis, validation, cleaning, and reporting of national dispensing transaction databases. I led the optimization of performance indicators for SURA capitation, improving operational efficiency. I implemented automation solutions for data validation and cleaning, reducing processing time by 20%.
    Microsoft Excel SQL Python Microsoft Power BI Microsoft Power Query
  • ADMINISTRACION DEL TALENTO HUMANO MX EST SAS
    Junior Administrative Analyst for Cruz Verde. Dispensing Management
    PHARMACEUTICALS INDUSTRY
    April 2020 - June 2020 (2 months)
    Responsible for Dispensing capitation billing – SURA, Administration, analysis, validation, cleaning, and reporting of national dispensing transaction databases for Capita SURA.
  • femsa
    Administrative and Financial Management.
    PHARMACEUTICALS INDUSTRY
    January 2020 - February 2020 (1 month)
    Santafe de Bogotá, Colombia
    - Analysis and administrative management of leases for Cruz Verde's stores, warehouses, and administrative offices nationwide. – SOX Controls Management. – Provision Monitoring. – Monthly closings and reconciliations.

Recommendations

Be the first to recommend Jhonatan

Help this freelancer shine by sharing your experience working together.

These freelancer profiles also match your criteria

AgathaA

Agatha Frydrych

Backend Java Software Engineer

4.7

(3)

2

BaptisteB

Baptiste Duhen

Fullstack developer

4.6

(4)

5

AmedA

Amed Hamou

Senior Lead Developer

4

(2)

7

AudreyA

Audrey Champion

Web developer

4.3

(3)

4

Education

  • Specialist
    Politécnico Grancolombiano
    2024
    Especialista
  • Diploma
    Fundación Universitaria Cafam
    2018
    Diplomado

Skill set

Categories