Gabriel Solari

Gabriel Solari

About

Detail

BI Expert Developer | Data Analytics | Master in Data Science & Big Data | Machine Learning | Deep Learning | Python | SQL | Power BI | DAX | VBA
Peru
Contact Gabriel regarding: 
work
Full-time jobs

Timeline

work
Job
school
Education
folder
Project
auto_stories
Publication

Résumé

Jobs verified_user 4% verified
  • Wirbi
    Analista BI
    Wirbi
    Sep 2024 - Dec 2024 (4 months)
    • Revisión / Análisis de SP's en SQL Server y reportes construidos en Reporting Services. • Creación de Dashboards en Power BI, siguiendo buenas prácticas para optimización de recursos utilizando Modelos Semánticos de Microsoft Fabric. • Cuadres de información entre fuentes de origen de data y nuevas capas construidas en DataBricks. • Tecnologías: SQL Server, Reporting Services, DataBricks, Microsoft Power BI, DAX , Microsoft Power Query, Microsoft Excel.
  • Infosys
    Power BI Expert Developer
    Infosys
    Jul 2024 - Aug 2024 (2 months)
  • Infosys
    Power BI Expert Developer
    Infosys
    Jul 2024 - Aug 2024 (2 months)
  • E
    Data Visualization Engineer
    Enfoque 7
    Mar 2024 - Jul 2024 (5 months)
  • e
    Data Visualization Engineer verified_user Verified experience
    enfoque Consultora de tecnología
    Mar 2024 - Jul 2024 (5 months)
  • Gesnext
    Business Intelligence Coordinator
    Gesnext
    Oct 2023 - Jan 2024 (4 months)
  • Gesnext
    Business Intelligence Coordinator
    Gesnext
    Oct 2023 - Jan 2024 (4 months)
  • Gesnext
    Coordinador de Business Intelligence
    Gesnext
    Oct 2023 - Jan 2024 (4 months)
    • • Encargado del proceso de migración a Microsoft Power BI. • Liderar mejoras de procesos de automatización utilizando VBA, Microsoft Power Automate y Microsoft Power Query. • Apoyo técnico con el equipo en temas de Microsoft Power BI y SQL Server. Server, BI, Excel
  • S
    Power BI Instructor
    SDC Learning
    Apr 2023 - Jul 2023 (4 months)
  • CIBERTEC
    Data Analytics Professor
    CIBERTEC
    Jan 2023 - Current (3 years 10 months)
  • KPMG en Perú
    Senior Business Intelligence Analyst
    KPMG en Perú
    Oct 2022 - Aug 2023 (11 months)
    • Application of K-Means and PCA for optimizing customer segmentation, enhancing business strategy.
    • Creation of dynamic reports with DAX for KPI calculation in Power BI. Efficient administration of Power BI Service at Data Analytics SAC.
    • Development and execution of automated workflows for efficient financial report management in the SAC cluster.
    • Development of predictive models using random forest classifiers, providing key insights for decision-making.
    • Effective cleaning of multilingual comments using nltk libraries, removing stopwords and special symbols for semantic analysis.
  • KPMG en Perú
    Senior Business Intelligence Analyst
    KPMG en Perú
    Oct 2022 - Aug 2023 (11 months)
    • Application of K-Means and PCA for optimizing customer segmentation, enhancing business strategy.
    • Creation of dynamic reports with DAX for KPI calculation in Power BI. Efficient administration of Power BI Service at Data Analytics SAC.
    • Development and execution of automated workflows for efficient financial report management in the SAC cluster.
    • Development of predictive models using random forest classifiers, providing key insights for decision-making.
    • Effective cleaning of multilingual comments using nltk libraries, removing stopwords and special symbols for semantic analysis.
  • KPMG
    Analista Senior de Business Intelligence
    KPMG
    Oct 2022 - Aug 2023 (11 months)
    • Aplicación de K-Means y PCA para optimizar la segmentación de clientes y mejorar la estrategia empresarial. • Creación de informes dinámicos con DAX para el cálculo de KPI en Microsoft Power BI. • Administración eficiente de Power BI Service en Data Analytics SAC con el uso de Row Level Security (RLS). • Desarrollo y ejecución de flujos de trabajo automatizados utilizando Microsoft Power Automate y Power Query para una gestión eficiente de informes financieros en el clúster SAC. • Desarrollo de modelos predictivos en Python utilizando clasificadores de bosque aleatorio (random forest), proporcionando conocimientos clave para la toma de decisiones. • Construcción de vistas en BigQuery para alimentar reportes en Microsoft Power BI. •
  • Wynwood House
    Senior Business Intelligence Analyst
    Wynwood House
    Aug 2022 - Oct 2022 (3 months)
    • Development of VBA scripts for automating reports and generating PDF files, optimizing processes and increasing operational efficiency.
    • Experience in cleaning and transforming data using Power Query, using the M language, both in Excel and Power BI environments, ensuring the quality and coherence of information.
    • Updating and ongoing management of dashboards in Power BI, adapting them to specific requirements and ensuring the availability of updated information for strategic decision-making.
  • Wynwood House
    Senior Business Intelligence Analyst
    Wynwood House
    Aug 2022 - Oct 2022 (3 months)
    • Development of VBA scripts for automating reports and generating PDF files, optimizing processes and increasing operational efficiency.
    • Experience in cleaning and transforming data using Power Query, using the M language, both in Excel and Power BI environments, ensuring the quality and coherence of information.
    • Updating and ongoing management of dashboards in Power BI, adapting them to specific requirements and ensuring the availability of updated information for strategic decision-making.
  • Wynwood House
    Analista Senior de Business Intelligence
    Wynwood House
    Aug 2022 - Oct 2022 (3 months)
    • Desarrollo de scripts en VBA para la automatización de informes y generación de archivos PDF, optimizando procesos y aumentando la eficiencia operativa. • Experiencia en la limpieza y transformación de datos utilizando Power Query, con el lenguaje M, tanto en entornos de Excel como en Power BI, asegurando la calidad y coherencia de la información. • Actualización y gestión continua de paneles en Power BI, adaptándolos a requisitos específicos y garantizando la disponibilidad de información actualizada para la toma de decisiones estratégicas. Tecnologías: Microsoft Power BI, DAX, Microsoft Power Query, Microsoft Excel, VBA.
  • Indra
    Data Engineer
    Indra
    Jul 2022 - Aug 2022 (2 months)
    • Capable of implementing SQL queries with Power BI's DirectQuery capability for real-time data monitoring. Proficient in analyzing live data directly from SQL databases to ensure dashboards display the most current information, facilitating agile decision-making.
    • Experienced in crafting dynamic dashboards in Power BI by selecting and configuring visualizations that convey critical metrics derived from SQL data. Expertise in customizing layouts to deliver intuitive and actionable insights into business performance.
    • Proficient in using Power BI's SQL Server connector to integrate data from diverse SQL databases into unified datasets. Skilled in data transformation and calculation within Power BI's Query Editor for comprehensive
  • Teleperformance
    Business Intelligence Analyst
    Teleperformance
    Jan 2022 - Jul 2022 (7 months)
    • Continuous optimization of reports in Power BI and Excel, enhancing visual presentation and accessibility of information.
    • Design and implementation of RPAs using Python (Selenium) for data extraction, optimizing data retrieval and ensuring process consistency.
    • Development of scripts in SQL Server for queries, stored procedures, and views, contributing to effective database management.
    • Efficient automation of reports in Power BI through direct queries, streamlining the generation and updating of key data.
    • Extensive management of essential KPIs such as AHT, SLA, OCC, OCR, and UCR for clients, ensuring effective monitoring of crucial metrics.
    • Monitoring, control, and continuous improvement of quality, produ
  • Teleperformance
    Business Intelligence Analyst
    Teleperformance
    Jan 2022 - Jul 2022 (7 months)
    • Continuous optimization of reports in Power BI and Excel, enhancing visual presentation and accessibility of information.
    • Design and implementation of RPAs using Python (Selenium) for data extraction, optimizing data retrieval and ensuring process consistency.
    • Development of scripts in SQL Server for queries, stored procedures, and views, contributing to effective database management.
    • Efficient automation of reports in Power BI through direct queries, streamlining the generation and updating of key data.
    • Extensive management of essential KPIs such as AHT, SLA, OCC, OCR, and UCR for clients, ensuring effective monitoring of crucial metrics.
    • Monitoring, control, and continuous improvement of quality, produ
  • Teleperformance
    Analista de Business Intelligence
    Teleperformance
    Jan 2022 - Jul 2022 (7 months)
  • C
    Junior Business Intelligence Analyst
    Core Business Corp.
    Oct 2021 - Dec 2021 (3 months)
    • Effective integration of Microsoft Outlook calendars into Power BI, enhancing visualization and synchronization of relevant events for more informed decision-making.
    • Implementation of report automation in Excel using VBA, optimizing the generation and updating of reports for improved operational efficiency.
    • Successful development of a comprehensive user management and equipment request platform in Excel, utilizing VBA to facilitate precise and organized tracking of operations.
  • C
    Junior Business Intelligence Analyst
    CORE BUSINESS CORP
    Oct 2021 - Dec 2021 (3 months)
    • Effective integration of Microsoft Outlook calendars into Power BI, enhancing visualization and synchronization of relevant events for more informed decision-making.
    • Implementation of report automation in Excel using VBA, optimizing the generation and updating of reports for improved operational efficiency.
    • Successful development of a comprehensive user management and equipment request platform in Excel, utilizing VBA to facilitate precise and organized tracking of operations.
  • C
    Analista Junior de Business Intelligence
    CORE BUSINESS CORP
    Oct 2021 - Dec 2021 (3 months)
  • I
    Asistente de Logísitca
    IMPORTACIONES HIRAOKA
    Apr 2021 - Oct 2021 (7 months)
    • Detailed tracking of mobile activity, including start and end of routes, time between clients, number of orders per mobile, among others, aiming to optimize operational efficiency and service quality.
    • Development and analysis of customer satisfaction indicators (T2B, B2B) within the CRM area, identifying improvement opportunities and strengthening business relationships.
    • Experience in accessing and managing users on the Beetrack platform, ensuring effective control of permissions and facilitating resource administration.
    • Expertise in automating reports in Excel using VBA, optimizing processes and streamlining report generation for efficient information management.
    • Monitoring key performance indicators of fleet
  • Hiraoka
    Data Analytics Assistant
    Hiraoka
    Apr 2021 - Oct 2021 (7 months)
    • Detailed tracking of mobile activity, including start and end of routes, time between clients, number of orders per mobile, among others, aiming to optimize operational efficiency and service quality.
    • Development and analysis of customer satisfaction indicators (T2B, B2B) within the CRM area, identifying improvement opportunities and strengthening business relationships.
    • Experience in accessing and managing users on the Beetrack platform, ensuring effective control of permissions and facilitating resource administration.
    • Expertise in automating reports in Excel using VBA, optimizing processes and streamlining report generation for efficient information management.
    • Monitoring key performance indicators of fleet
  • I
    Analista Junior de Business Intelligence
    IMPORTACIONES HIRAOKA
    Apr 2021 - Oct 2021 (7 months)
  • PepsiCo, Inc
    Data Assistant
    PepsiCo, Inc
    Feb 2018 - Mar 2021 (3 years 2 months)
    • Automation of reports in Excel using advanced formulas, table formats, and Macros recorder, significantly enhancing efficiency in report generation.
    • Development and tracking of customer reach indicators segmented by areas in the tertiary sales channel, providing valuable insights for business decision-making.
    • Effective management of customer registration and updates in Mapinfo using SQL language, ensuring database integrity and continuous updates.
    • Expert use of Mapinfo for precise customer location through geographical coordinates, facilitating strategic visualization and planning.
    • Outstanding experience in preparing specific reports for senior management in Excel, ensuring clear and precise presentation of key
  • PepsiCo
    Data Assistant
    PepsiCo
    Feb 2018 - Apr 2018 (3 months)
    • Automation of reports in Excel using advanced formulas, table formats, and Macros recorder, significantly enhancing efficiency in report generation.
    • Development and tracking of customer reach indicators segmented by areas in the tertiary sales channel, providing valuable insights for business decision-making.
    • Effective management of customer registration and updates in Mapinfo using SQL language, ensuring database integrity and continuous updates.
    • Expert use of Mapinfo for precise customer location through geographical coordinates, facilitating strategic visualization and planning.
    • Outstanding experience in preparing specific reports for senior management in Excel, ensuring clear and precise presentation of key
Education verified_user 0% verified
  • I
    Master en Data Science & Big Data
    IEBS Business School
    Nov 2022 - Nov 2023 (1 year 1 month)
  • IEBS Biztech School
    Master's degree, Data Science & Big Data
    IEBS Biztech School
    Nov 2022 - Oct 2023 (1 year)
    Skills: RStudio · MySQL · R (Lenguaje de programación) · Microsoft Excel
  • U
    Bootcamp de Marketing Data Analytics
    Universidad Internacional de LaRioja
    Oct 2022 - Oct 2023 (1 year 1 month)
  • UNIVERSIDAD INTERNACIONAL DE LA RIOJA UNIR
    Bootcamp, Marketing Data Analytics
    UNIVERSIDAD INTERNACIONAL DE LA RIOJA UNIR
    Oct 2022 - Oct 2023 (1 year 1 month)
    Skills: Python · R (Lenguaje de programación) · RStudio · SQL · PostgreSQL · Microsoft Excel
  • IEBS Business School
    Master en
    IEBS Business School
    Oct 2022 - Oct 2023 (1 year 1 month)
  • Universidad Internacional de La Rioja
    Marketing Data Analytics Bootcamp
    Universidad Internacional de La Rioja
    Oct 2022 - Oct 2023 (1 year 1 month)
  • D
    Data Science For Business
    Jul 2022 - Oct 2022 (4 months)
  • National University of Engineering
    Especialización, Data Science for Business
    National University of Engineering
    Jul 2022 - Oct 2022 (4 months)
    Skills: Python · Microsoft SQL Server · MongoDB
  • National University of Engineering
    Specialization, Excel VBA Developer
    National University of Engineering
    Jul 2021 - Current (5 years 4 months)
    Skills: Microsoft Excel · Macros en Microsoft Excel · Visual Basic for Applications (VBA) · Automation · Business Intelligence (BI)
  • National University of Engineering
    Specialization, SQL Server Data Base Administrator Developer
    National University of Engineering
    Apr 2021 - Current (5 years 7 months)
    Skills: SQL · Microsoft SQL Server · Transact-SQL (T-SQL) · Erwin · yEd Graph Editor
  • Universidad Nacional Mayor de San Marcos
    Investigación Operativa
    Universidad Nacional Mayor de San Marcos
    Mar 2014 - Jan 2022 (7 years 11 months)
  • Universidad Nacional Mayor de San Marcos
    Bachelor's Degree, Operations Research
    Universidad Nacional Mayor de San Marcos
    Mar 2014 - Jan 2022 (7 years 11 months)
    Skills: Microsoft Excel · Matlab · MySQL
  • Universidad Nacional Mayor de San Marcos
    Bachiller
    Universidad Nacional Mayor de San Marcos
    Mar 2014 - Jan 2022 (7 years 11 months)
  • Asociacion Cultural Peruano Britanica Britanico
    Advanced English
    Asociacion Cultural Peruano Britanica Britanico
  • Universidad Nacional de Ingeniería
    Data Science for Business
    Universidad Nacional de Ingeniería
  • Universidad Nacional de Ingeniería
    Programador en Excel VBA
    Universidad Nacional de Ingeniería
  • S
    Ingeniería de Datos e IA con Azure
    Smart Data Consulting
  • Universidad Nacional de Ingeniería
    Excel Empresarial
    Universidad Nacional de Ingeniería
  • DMC Peru
    Data Engineering
    DMC Peru
  • I
    Master
    IEBS Business School.
  • S
    Ingeniería de Datos e IA con GCP
    Smart Data Consulting
  • Universidad Nacional de Ingeniería
    SQL Server Database Administrator
    Universidad Nacional de Ingeniería
  • DMC Peru
    Data Governance & Data Stewardship
    DMC Peru
  • U
    Bachillerato
    UNMSM
Projects (professional or personal) verified_user 0% verified
  • M
    Medical Surveillance Analysis | Power BI
    Oct 2023 - Dec 2023 (3 months)
  • M
    Macro BCP Project
    Jul 2023 - Sep 2023 (3 months)
Publications verified_user 0% verified