Javier Andrés Mendoza Rocha
Download
Recommend
Messages
Share
Javier Andrés Mendoza Rocha

Javier Andrés Mendoza Rocha

About

Detail

Data Analyst
Antioquia, Colombia

Contact Javier regarding: 

groups
Networking

Timeline

work
Job
school
Education
flag
Award

Résumé

Jobs verified_user 0% verified
  • Américas BPS
    HP
    Business analyst
    Américas BPS, HP
    May 2022 - Current (3 years 1 month)
    - Design and manage dashboards in PowerBI and Excel, in which KPIs about PPS sales and stock are shown. Sales and stock are loaded through an ETL (Visual Studio) to a SQL (SQL Server) database. - Analyze the PowerBI dashboards to make well-founded decisions towards the business and market strategies.
  • I
    Energy quality analyst
    Ingeler SAS
    Feb 2022 - Apr 2022 (3 months)
    - Develop a Python app which extracts data from electrical measurement devices, transforms the DataFrame and loads it to a SQL database through Python and SQL queries. - Design a PowerBI dashboard which shows KPIs about active and reactive power (energy quality), to make decisions towards the design parameters of automated capacitor banks for every company client.
  • R
    Assistant Python and SQL programmer
    RightSide SAS
    Jul 2021 - Jan 2022 (7 months)
    - Actively work as a Python, VBA and SQL (Transact-SQL) support engineer in an energy economic dispatch program using data wrangling methods, SQL queries and Graphic User Interface (GUI) scripting in PyQt5 for operating the program. - Take the output data from the Python program to a PowerBI dashboard, to make energy planning decisions in the medium and long term.
  • Universidad ded Antioquia
    Automation lab’s monitor
    Universidad ded Antioquia
    Jan 2020 - Dec 2021 (2 years)
    - Make a Python-Arduino connection to load temperature and electrical current data to a SQL (SQL Server) database, which is connected to a PowerBI dashboard to automatically compute the optimal parameters for a power KID controller.
  • Universidad ded Antioquia
    Assistant Python and R coder
    Universidad ded Antioquia
    Feb 2018 - Jul 2018 (6 months)
    - Migrate R scripts containing a predictive model for electric load in the short and medium term to the Python language.
Education verified_user 0% verified
  • Universidad ded Antioquia
    Ingeniero electricista
    Universidad ded Antioquia
    Jan 2016 - Jun 2022 (6 years 6 months)
  • Colegio la Nueva Esperanza
    Bachiller académico
    Colegio la Nueva Esperanza
    Jan 2015 - Dec 2015 (1 year)
Awards verified_user 0% verified
  • Universidad ded Antioquia
    Matrícula de honor: mejor promedio de Ingeniería Eléctrica por nivel
    Universidad ded Antioquia
    Jul 2020
    - Promedio: 4,46 Comite de asuntos estudiantiles del consejo académico resolución 022 del 16 de julio de 2020.