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 is supported. This note will only be visible to 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 architectures

I'm an Analytics Engineer specializing in the design and implementation of data platforms featuring centralized orchestration, MLOps infrastructure, and secure automation pipelines. I bridge the gap between complex business workflows and high-performance, resilient technical systems that drive measurable strategic impact.


What I do

Centralized Orchestration & Infrastructure Deployment of orchestration platforms (Dagster) on dedicated Linux servers to centralize, monitor, and automate critical corporate workflows, reducing operational overhead and standardizing failure monitoring.

MLOps & Automated Forecasting Design and integration of end-to-end MLOps pipelines for autonomous demand forecasting, improving inventory metrics and removing dependencies on legacy third-party ERP architectures.

Data Engineering & Web Scraping Development of optimized extraction pipelines using modern libraries (Polars) and robust web scraping systems (Selenium/Scrapy) to inject real-time market intelligence directly into decision-making environments.

DevSecOps & Governance Implementation of version control standards, code quality frameworks, and AI-assisted agentic workflows (Claude AI) to standardize internal software development and guarantee code alignment.

Infrastructure Security & Migration Restructuring legacy workflows into secure protocols (SFTP/SSH) and transforming full-refresh pipelines into incremental extraction models to optimize performance and information integrity.


Core Technical Stack

Programming & Querying

Python SQL

Data Engineering

Polars Pandas NumPy

SQLAlchemy FastAPI Selenium Scrapy

SciPy Statsmodels Scikit Learn Feature Engineering

Infrastructure & Orchestration

Dagster Docker Linux Server SSH/SFTP

Databases & Storage

SQL Server PostgreSQL Data Warehouse

Business Intelligence & Analytics

Power BI DAX Power Query

Development Workflow & DevSecOps

Git GitHub

VS Code Cursor Google Antigravity


Selected Work (Professional Projects)

While most of my corporate engineering repositories are private, my core achievements focus on building data products end-to-end:

  • Autonomous Demand Forecasting Infrastructure: Designed an end-to-end MLOps platform that led to a 30% improvement in forecast accuracy and a 3% stockout reduction for high-priority SKUs.
  • Centralized Linux Orchestration Server: Migrated dispersed, manual tracking tasks into a single Dagster instance, automating job control and recovery while optimization saved approximately 4 operational hours weekly per user.
  • AgTech Supply Chain Scraping Engines: Built automated data-harvesting pipelines using Selenium and Scrapy to extract complex market pricing structures for immediate strategic raw material negotiation.
  • DevSecOps & Secure Pipelines Architecture: Standardized development repositories via GitHub using agentic LLM coding assistant workflows, alongside drafting infrastructure migrations from FTP legacy models to incremental SSH/SFTP environments.

Technical summaries and non-confidential project architecture details can be provided 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