Skip to content
View PogloLopez's full-sized avatar

Block or report PogloLopez

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Maximum 250 characters. Please don't include any personal information such as legal names or email addresses. Markdown supported. This note will be visible to only you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
PogloLopez/README.md

Header

Hi, I'm Pablo López

Turning operational complexity into scalable data solutions

I'm a Data Analyst specialized in Data Workflows, Automation, and Demand Planning. I design data pipelines, analytical tools, and decision-support systems that connect business operations with reliable, actionable data. My work sits at the intersection of analytics, automation, and business impact.


What I Do

Analytics for Operations & Demand Planning
Development of analytical tools that support inventory planning, forecasting follow-up, product performance tracking, and commercial decision-making.

Process Automation
Automation of manual business processes using Python-based tools that reduce operational workload and improve decision speed.

Data Pipelines & ETL
Design of reproducible ETL processes in Python and SQL to move operational data into structured environments (DWH), including validation layers, logging, and parameterization.

Data Quality & Structuring
Cleaning, classification, and restructuring of core business datasets (products, customers, sales), improving signal quality for analytics and forecasting.

Business-Focused Solutions
Translation of operational problems into technical solutions with measurable impact (efficiency, sales performance, stock availability).


Core Technical Stack

Programming & Querying
Python SQL

Databases & Data Warehouse
SQL Server PostgreSQL Data Warehouse

Data Engineering & ETL
ETL Pipelines Process Automation Web Scraping

Python Data & Machine Learning Ecosystem
Pandas NumPy SciPy Statsmodels Scikit Learn Feature Engineering

BI & Decision Support
Power BI DAX Power Query Tableau

Development Workflow
Git GitHub Jupyter VS Code Documentation


Selected Work (Professional Projects)

Although most of my work is in private corporate repositories, my recent projects include:

• Automation tools for operational decision-making (inventory movement planning, commercial factor adjustments)
• ETL pipelines for forecast integration into Data Warehouse environments
• Product catalog restructuring to improve analytical signal and reduce stock-out distortion
• Recovery and optimization of large-scale web scraping processes
• Data governance and version control implementation for analytics development environments

Case studies and technical breakdowns available upon request.


📜 Certifications

Explore my professional certifications and courses:
View Certificates


Connect

Focused on building reliable data systems that create measurable business impact.

Pinned Loading

  1. prueba_data_mercaldas prueba_data_mercaldas Public

    Prueba técnica de planeación de demanda para Mercaldas: ETL, análisis estratégico, visualización en Power BI y modelos predictivos en Python.

    Jupyter Notebook

  2. online_retail online_retail Public

    Exploratory Data Analysis of Online Retail Sales | Analyzing transactional data from an online store (2010–2011) to uncover sales trends, customer behavior, and product performance using Python and…

    Jupyter Notebook

  3. trafficker_tech_test trafficker_tech_test Public

    Prueba técnica realizada para proceso de selección. Incluye flujos de trabajo con Python, SQLite y Power BI para analizar el comportamiento de jugadores, depósitos y rendimiento de fuentes de tráfi…

    Jupyter Notebook

  4. nesarc_research nesarc_research Public

    Analyzing the relationship between Social Anxiety Disorder (SAD) and family history of behavioral problems using NESARC data. Includes statistical hypothesis testing (ANOVA, Chi-Square, Pearson Cor…

    Jupyter Notebook