Victor Hugo Pasapera, Developer in Miguel Hidalgo, Mexico
Victor is available for hire
Hire Victor

Victor Hugo Pasapera

Verified Expert  in Engineering

Bio

Victor is an automation and business intelligence specialist with a proven track record of streamlining processes. He has focused on designing data pipelines and creating impactful visualizations using Microsoft Power BI, Microsoft Power Apps, Microsoft Power Automate, and Python. Victor is known for transforming complex data into actionable insights, driving efficiency, and enabling decision-making at all organizational levels.

Portfolio

WTW
Python, Microsoft Power Platform, Microsoft Power Automate, SharePoint...
Rappi
Automation, Azure Databricks, Python, Microsoft Power BI, Microsoft Office...
Autotodo Mexicana
Automation, Windows Server, PySpark, Spark, Microsoft Excel, SQL, Oracle...

Experience

  • Excel 365 - 10 years
  • Windows - 8 years
  • Microsoft - 8 years
  • Microsoft Power BI - 7 years
  • Python - 6 years
  • SQL - 6 years
  • Microsoft Power Automate - 5 years
  • Microsoft Power Platform - 4 years

Availability

Full-time

Preferred Environment

Windows, Microsoft, Microsoft Power BI, Microsoft Power Automate, Python, SQL, Excel 365, Office 365, Data Analysis, Dashboards, Dashboard Design, Tableau, ETL, Data Visualization, Data Engineering, Data Architecture, DAX

The most amazing...

...solution I've created is a purchasing system that analyzes over 500,000 stock-keeping units (SKUs).

Work Experience

Associate Lead

2023 - PRESENT
WTW
  • Automated daily price updates for over six months of data, reducing processing time from four hours to 20 minutes using Python and Microsoft Power Automate. I delivered validated, standardized results for live production.
  • Supervised data collection and validation processes for financial reporting.
  • Developed automated workflows for daily price updates using Python, Microsoft Power Automate, and SharePoint.
Technologies: Python, Microsoft Power Platform, Microsoft Power Automate, SharePoint, Data Analysis, Dashboards, Business Intelligence (BI), Data Analytics, Dashboard Design, Tableau, Web Dashboards, R, Data Visualization, Data Engineering, Data Architecture, DAX, Microsoft Access, Data Integration, Reports, LinkedIn API, Google Analytics 4, SQL, Git, Dimensional Modeling, Azure Databricks, Project Design, Industrial Automation, MySQL, Azure, OAuth, Power BI REST APIs, APIs, Business Analysis, Power BI Desktop, Microsoft Excel, Power BI Embedded, Microsoft 365, Visual Basic for Applications (VBA), Microsoft Power Apps, Excel 2016, Excel Add-ins, Excel Expert, Data Pipelines, Data Scraping, Data Structures, Databases, Microsoft SQL Server, SQL Stored Procedures, Data Modeling, Excel VBA, Database Management, Azure Service Fabric, External Financial Reporting, Power Query, Dashboard Development, GitHub, Amazon Web Services (AWS), Data Migration, Azure Data Lake, PostgreSQL, Visualization, Power Pivot, Excel Macros, Data Scientist

SP&A, Marketing Intelligence Lead

2022 - 2023
Rappi
  • Conducted benchmarking studies to analyze competitor performance.
  • Created custom Power BI dashboards for directors and managers, delivering actionable marketing insights.
  • Designed and evaluated marketing campaigns leveraging Python, SQL (Snowflake), and Power BI.
  • Created, optimized, and maintained ETL using Databricks and Axure functions with Python.
Technologies: Automation, Azure Databricks, Python, Microsoft Power BI, Microsoft Office, Snowflake, Google, Project Design, Industrial Automation, MySQL, OAuth, Power BI REST APIs, APIs, Business Analysis, Power BI Desktop, Data Science, Microsoft Excel, Power BI Embedded, Microsoft 365, Visual Basic for Applications (VBA), Microsoft Power Apps, Excel 2016, Excel Add-ins, Excel Expert, Data Pipelines, Azure Data Factory (ADF), Data Scraping, Data Structures, Databases, Firebase, User Behavioral Analytics (UBA), Google Cloud Platform (GCP), Database Optimization, Data Modeling, Excel VBA, Database Management, Azure Service Fabric, Power Query, Dashboard Development, Data Warehousing, Azure Data Lake, PostgreSQL, Visualization, Excel Macros, Data Scientist

Replenishment Analyst to Big Data Chief

2017 - 2022
Autotodo Mexicana
  • Developed purchasing systems integrating machine learning models and statistical software to optimize forecasts.
  • Led the creation of operational KPIs through Power BI dashboards.
  • Streamlined supply chain processes, achieving significant cost and time savings.
  • Implemented ETL pipelines to integrate and clean data from various sources.
Technologies: Automation, Windows Server, PySpark, Spark, Microsoft Excel, SQL, Oracle, Python, Azure, Databricks, Project Design, MySQL, OAuth, Business Analysis, Power BI Desktop, Data Science, Visual Basic for Applications (VBA), Excel 2016, Excel Add-ins, Excel Expert, Data Pipelines, Azure Data Factory (ADF), Data Structures, Databases, Microsoft SQL Server, SQL Stored Procedures, Database Optimization, Data Modeling, Excel VBA, Database Management, Power Query, Dashboard Development, Data Warehousing, Data Migration, PostgreSQL, Visualization, Power Pivot, Excel Macros, Data Scientist

Experience

Forecasting System

I created a purchasing system that analyzes over 500,000 stock-keeping units (SKUs). This project involved designing a forecasting model that reduced procurement costs by 15%, enhancing data accessibility with interactive Microsoft Power BI dashboards, and conducting weekly optimizations to automatically select the best forecasting model.

Daily Pricing Automation

I automated daily price updates for over six months of data, reducing processing time from four hours to 20 minutes using Python and Microsoft Power Automate. As a result, I delivered validated, standardized results for live production.

Marketing Intelligence Dashboard

This project involved building benchmarking tools to compare the company's market position against competitors. I enabled strategic decision-making through detailed performance reports and optimized marketing campaigns based on benchmark data and daily web scraping.

Education

2012 - 2017

Bachelor's Degree in Actuarial Science

Benemérita Universidad Autónoma de Puebla (BUAP) - Mexico

Skills

Libraries/APIs

PySpark, Power BI REST APIs, LinkedIn API

Tools

Microsoft Power BI, Microsoft Access, Microsoft Excel, Power BI Embedded, Excel 2016, Power Query, Power Pivot, Tableau, Git, Power BI Desktop, Microsoft Power Apps, Mathematica, GitHub

Languages

SQL, Visual Basic for Applications (VBA), Excel VBA, Python, R, Snowflake

Paradigms

Business Intelligence (BI), ETL, Dimensional Modeling, Automation, User Behavioral Analytics (UBA)

Platforms

Microsoft Power Platform, Windows, Microsoft, Microsoft Power Automate, Microsoft Fabric, Azure, Google Cloud Platform (GCP), Azure Service Fabric, SharePoint, Windows Server, Oracle, Databricks, Firebase, Amazon Web Services (AWS)

Storage

Data Integration, Data Pipelines, Databases, MySQL, Microsoft SQL Server, SQL Stored Procedures, Database Management, PostgreSQL

Frameworks

Spark

Other

Excel 365, Office 365, Data Analysis, Dashboards, Data Analytics, Analytical Dashboards, Dashboard Design, Web Dashboards, Data Visualization, Data Engineering, DAX, Reports, Excel Expert, Data Structures, Data Modeling, Dashboard Development, Data Warehousing, Data Migration, Visualization, Excel Macros, Project Design, Data Architecture, Azure Databricks, Industrial Automation, OAuth, APIs, Business Analysis, Data Science, Microsoft 365, Excel Add-ins, Data Scraping, Database Optimization, External Financial Reporting, Azure Data Lake, Data Scientist, Statistics, Probability Theory, Computer Skills, Google Analytics 4, Microsoft Office, Google, Azure Data Factory (ADF)

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring