Skip to content
View asaygom's full-sized avatar

Block or report asaygom

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
asaygom/README.md

Alexis Sayago | Civil Engineer · Data & Software Builder

I build data-driven tools that connect complex operational problems with structured data, automation, dashboards, APIs, and web applications.

I am a Civil Engineer with 6+ years of experience in planning, project controls, schedules, progress tracking, executive reporting, and operational data. I am currently moving my career toward data engineering, analytics engineering, and software development.

My work sits at the intersection of engineering, data, automation, and product thinking.

Portfolio: https://asaygom.com
Languages: Spanish / English


What I build

  • Data pipelines that transform messy source files into structured, auditable datasets
  • SQL and Python workflows for cleaning, validating, and loading operational data
  • Power BI dashboards for project controls, executive reporting, and performance tracking
  • Web applications and APIs that expose data in usable ways
  • Small digital products that combine frontend development, business logic, and deployment

Featured repositories

Data platform demo for Chilean masters swimming results.

The project transforms public, semi-structured competition results into a cleaner relational data model, using scraping/download workflows, PDF extraction, Python parsing, intermediate CSVs, PostgreSQL staging/core tables, validations, FastAPI, and a React/TypeScript frontend.

Demo: https://swimstats-chile.vercel.app
Focus: data pipeline, PostgreSQL, data modeling, FastAPI, React, TypeScript, data quality.


Power BI dashboard demo for weekly project controls reporting in engineering/construction projects.

Focused on plan vs actual tracking, variance analysis, SPI/CPI, S-curves, risk visibility, and executive reporting.

Focus: Power BI, DAX, project controls, EVM, executive dashboards.


Analytics demo using Power BI and Microsoft Fabric concepts to track energy, CO2e, cost efficiency, and schedule delays across infrastructure assets.

Includes executive views, sustainability indicators, what-if analysis, and a documented path toward a Fabric-based analytical workflow.

Focus: Power BI, Microsoft Fabric, star schema, DAX, sustainability analytics.


Current stack

Data & Analytics

  • SQL
  • Python
  • Pandas
  • PostgreSQL
  • Power BI
  • Power Query
  • DAX
  • Microsoft Fabric fundamentals

Software & Web

  • JavaScript
  • TypeScript
  • React
  • Angular
  • FastAPI
  • REST APIs
  • Git / GitHub

Project Controls

  • Primavera P6
  • MS Project
  • EVM
  • SPI / CPI
  • S-curves
  • Executive reporting

What I care about

  • Turning operational chaos into structured and trustworthy data
  • Building reproducible workflows instead of manual reporting patches
  • Connecting technical implementation with business context
  • Designing data models, dashboards, and applications that people can actually use
  • Moving from dashboard-only work toward stronger data engineering, analytics engineering, and software development capabilities

Current direction

I am focused on roles and projects related to:

  • Data Engineering
  • Analytics Engineering
  • BI Engineering
  • Reporting Automation
  • Software Development
  • Data-driven web applications

Connect

Pinned Loading

  1. swimming-chile swimming-chile Public

    An evolving data platform that turns public masters swimming results into structured, auditable and queryable data exposed through a web application.

    Python 1

  2. p2-nordic-infra-sustainability-fabric-powerbi p2-nordic-infra-sustainability-fabric-powerbi Public

    Power BI dashboard analyzing energy consumption, CO2 emissions, project delays, and cost efficiency across Nordic infrastructure projects

    Python

  3. p1-plan-vs-actual-powerbi p1-plan-vs-actual-powerbi Public

    Weekly Plan vs Actual dashboard for engineering/construction projects. Power BI (DAX/modeling), variance hotspots and a simple pace index. Demo data included.

    Python 2

  4. Final-project-4Geeks-Back Final-project-4Geeks-Back Public

    Python 3

  5. Final-project-4Geeks-Front Final-project-4Geeks-Front Public

    JavaScript 3

  6. Build-a-StarWars-REST-API Build-a-StarWars-REST-API Public

    Forked from 4GeeksAcademy/flask-rest-hello

    Start a REST API's using Flask in 30 sec. One-click deploy to Heroku Server (free) & integrated with Gitpod.

    Python 1