Hamill Cavero

Business Intelligence and Data Science professional experienced in building interactive dashboards, ETL and automation. Skilled in Python, SQL, Dash/Plotly, Power BI and PostgreSQL, focused on query optimization and delivering actionable insights for decision-making.

Business Intelligence Analyst at EsSalud (2025-02 – 2025-08)

• Built Python (Dash/Plotly) dashboards connected to PostgreSQL, used nationwide with monthly updates.
• Optimized SQL queries to reduce response times for critical analyses.
• Replaced over 100 Power BI subscriptions with Dash web apps, reducing licensing costs.
• Automated SAP processes with Python to eliminate repetitive manual tasks.

Business Intelligence Intern at WOW Perú (2024-04 – 2024-09)

• Designed Power BI dashboards that reduced analysis time by 20% and aligned metrics between Sales and Customer Experience.
• Implemented ETL workflows in PostgreSQL and Python.
• Identified and corrected errors in billing and technical visits, improving indicator accuracy.
• Developed a Python script to transform HTML→Excel and integrated it into Power BI models.

Data Analytics Intern at Anders (2023-09 – 2024-02)

• Managed ETL processes to integrate inventory data into SAP Business One.
• Created SQL and Excel reports to improve sales visibility.

Web Support at Falcon Systems (2022-03 – 2022-05)

• Updated and optimized the product database.
• Customized PCs and enhanced the e-commerce store with HTML improvements.

BSc in Computer Science – Universidad Peruana de Ciencias Aplicadas (UPC) (2018 – 2023)

Technical Degree in Game Development – ISIL (2015 – 2017)