A

Andres Alejandro Diosa Palacio

About

Detail

Medellín, Antioquia, Colombia

Timeline


work
Job
school
Education

Résumé


Jobs verified_user 0% verified
  • Yuno
    Operations Analyst
    Yuno
    Sep 2024 - Mar 2025 (7 months)
  • itelCX
    REPORTING ANALYST II
    itelCX
    Jan 2023 - Current (3 years 10 months)
    In my role, I have created and developed dashboards using Power BI, Amazon Quicksigth, MS Excel and Looker Studio to address different business needs. These dashboards included financial and opera�onal metrics, IT team performance, assets purchase tracking, termina�on tracking, payroll execu�on, transporta�on cost monitoring, supervisor coaching compliance dashboards, �me and atendance tracking and others. Each dashboard was designed to provide clear, ac�onable insights to stakeholders across different departments.
  • U
    FINANCIAL CONTROLLER AND TREASURE ANALYST
    ULTRA AIR S.A.S.
    Dec 2021 - Dec 2022 (1 year 1 month)
    Crea�on of a Power BI dashboard using a star type data model under different filters context, allowing to find mistakes for over +200.000 USD on the accoun�ng system and op�mize up to 70% �me of upda�ng and reviewing of costs reports. Crea�on of a Power BI to gather insights about the performance of individual domes�c routes, applying different ETL processes using Power Query and DAX formulas.
  • C
    PURCHASE AND FYNANCIAL ANALYST
    COMERCIALIZADORA TECNOPINTURAS.
    Apr 2021 - Dec 2021 (9 months)
    Use Power Query to load and transform financial data and being able to create a more detailed financial report for each business unit allowing managers to iden�fy its individual contribu�on of the total company revenue this led managers to face insights never seen before.
  • C
    HEAD OF TREASURY
    CARNES CASA BLANCA.
    Jan 2020 - Mar 2021 (1 year 3 months)
    Lead the treasury team guaranteeing the achievements of the objec�ves, ge�ng on �me financial reports, se�ng up all on �me when migra�on to another ERP systems and others.
  • Vivaair
    TREASURY ANALYST
    Vivaair
    May 2019 - Aug 2020 (1 year 4 months)
    Improve the cash flow model using rela�onal data structure in the data and advanced formulas in MS Excel, reducing the �me to review, upda�ng and review up to 70%
  • W
    SUPERNUMERARY ANALYST
    WILLIS TOWERS WATSON.
    Feb 2018 - May 2019 (1 year 4 months)
    Being a key actor in a project which was intended to migrate to a newer opera�on system, I defined the requirements of the business context and se�ng up all the parameters needed for each user.
  • G
    FINANCIAL INTERN
    GRUPO BANCOLOMBIA SA.
    May 2016 - May 2017 (1 year 1 month)
    Create a dashboard using advanced formulas and visualiza�on in MS Excel this helped the managers to keep track of its main KPI and its clients' accounts.
Education verified_user 0% verified
  • U
    SPECIALIZATION IN DATA ANALYTICS
    UN SEDE MEDELLIN.
    Mar 2022 - Dec 2022 (10 months)
  • U
    ADVANCED MS EXCEL, VBA PROGRAMMING AND MACROS
    UN SEDE MEDELLIN.
    Jan 2014 - Jan 2016 (2 years 1 month)
  • U
    ADMINISTRATOR ENGINEER
    UN SEDE MEDELLIN.
    Jan 2012 - Jan 2017 (5 years 1 month)
  • B
    GET JOB READY: POWER BI DATA ANALYTICS FOR ALL LEVELS
    BASICS
  • C
    SQL BEGINNER TO ADVANCED FOR DATA PROFESSIONALS
    Codebasics