Heli Escobar Email & Phone Number

Tegucigalpa, Hn

Honduras

DBT Expertise: Led the development of the DBT layer as its product owner, creating a robust foundation by generating the majority of DBT models. Ensured data quality through testing.Tableau Proficiency: Designed and implemented multiple Tableau dashboards tailored to the needs of operational teams and top-level management, including owners and executives.Google Cloud Platform (GCP): Navigated the GCP suite proficiently, utilizing its powerful tools for seamless data engineering… Show more DBT Expertise: Led the development of the DBT layer as its product owner, creating a robust foundation by generating the majority of DBT models. Ensured data quality through testing.Tableau Proficiency: Designed and implemented multiple Tableau dashboards tailored to the needs of operational teams and top-level management, including owners and executives.Google Cloud Platform (GCP): Navigated the GCP suite proficiently, utilizing its powerful tools for seamless data engineering and analytics.Airflow Automation: Developed Python DAGs using Apache Airflow in GCP.Real-Time Analytics: Utilized Google Streaming to integrate MySQL tables into BigQuery, enabling the creation of near-real-time analytics dashboards to keep stakeholders well-informed.Cloud Functions: Engineered cloud functions to extract data from BigQuery tables and deliver it to stakeholders daily, ensuring timely and relevant insights.Collaboration and Mentorship: Actively engaged in code reviews, offering constructive feedback on peers' pull requests. Mentored new team members, particularly in understanding the intricacies of the DBT layer. Show less

Honduras

Operational Analysis: Conducted thorough operational analyses to pinpoint areas for process optimization and efficiency improvements.Data Analysis & Visualization: Utilized Python, SQL, and Google BigQuery to extract, clean, and analyze data, providing crucial insights for informed decision-making. Developed impactful data visualizations and dashboards using Lookerstudio.Excel Proficiency: Generated custom Excel reports and employed advanced Excel features, including VBA macros,… Show more Operational Analysis: Conducted thorough operational analyses to pinpoint areas for process optimization and efficiency improvements.Data Analysis & Visualization: Utilized Python, SQL, and Google BigQuery to extract, clean, and analyze data, providing crucial insights for informed decision-making. Developed impactful data visualizations and dashboards using Lookerstudio.Excel Proficiency: Generated custom Excel reports and employed advanced Excel features, including VBA macros, to automate tasks and enhance data processing efficiency.Data Modeling: Applied data modeling techniques in MySQL and Google BigQuery to structure and organize data, facilitating the development of comprehensive reports and dashboards.Python Automation: Leveraged Python programming to automate various tasks, from report generation to distribution, streamlining workflows and improving overall efficiency.Database Management: Created stored procedures in MySQL for seamless data extraction, contributing to the invoicing process. Implemented scheduled queries to efficiently move data between MySQL and BigQuery.Collaboration & Reporting: Collaborated cross-functionally to understand business requirements, translating them into actionable insights. Generated PowerPoint presentations based on analytical findings to facilitate effective communication. Show less

Tegucigalpa, Francisco Morazán, Honduras

Lead of the Reporting Analyst team. Provide technical supervision, support and training to the analyst team.Coordinate workload to ensure timely deliveries.Prepare and present business reviews with current and historical successes or opportunities for the team.

Honduras

Manage and monitor multiple virtual servers (Linux based, Windows).Design Databases with normalization principles.Design Multidimensional Cube Reports using Sql Server Analysis Services.Create parameterized reports using SQL Server Reporting Services.Create python script for ETL process.

Tegucigalpa, Francisco Morazán, Honduras

Data Analyst, part of the reporting team in HN. In charge of report creation and maintenance using Microsoft Excel, Advanced Features (Power Query, Power Pivot, VBA, Dax, M Language, Database Connection). Creating Dashboards using different visualizations tools like MS Power Bi, Google Data Studio, Tableau.Sql developer. Creation of multiple DB objects (tables, procedures, triggers, constraints), Modeling data with Sql for reports creations.