Skip to main content
Portrait of César Alexander
Now
Software & Data Engineer, TransNort
Focus
Azure, Software & Systems Design
Elsewhere
GitHub (opens in a new tab)LinkedIn (opens in a new tab)
Monterrey, MX

I build data pipelines and web apps.

Computer Science graduate from UANL, now a Software & Data Engineer at TransNort.

Experience

  1. Jul 2026
    - Present

    TransNort logo

    Software & Data Engineer

    TransNort, Monterrey

    • Engineered operational data workflows integrating Samsara telematics, SQL-based services, REST APIs, and Azure infrastructure to support fleet monitoring, operational analytics, and automated reporting.
    • Improved data consistency and freshness across distributed Azure workloads by implementing reliable cache invalidation, authoritative reads, concurrency handling, and synchronization between transactional writes and downstream read models.
    • Designed robust batch processing and data-import workflows using idempotency, deduplication, canonical identifiers, preflight validation, and transactional safeguards to prevent duplicate or partially committed operational data.
    • Built automated data processing and reporting pipelines that classify, aggregate, and enrich Samsara and SQL data, orchestrating scheduled production jobs with Azure Functions and GitHub Actions and implementing failure recovery and deduplication.
    • Samsara
    • SQL
    • REST APIs
    • Azure
    • Azure Functions
    • GitHub Actions
  2. May 2026
    - Jul 2026

    DEACERO logo

    Developer Analyst

    Grupo DEACERO, Monterrey

    • Diagnosed production application issues by tracing SQL Server execution flows, identifying data inconsistencies and blocked process states, and applying controlled SQL corrections to restore operational processes.
    • SQL
    • SQL Server
    • GCP
    • Python
    • Jira
  3. Mar 2025
    - May 2026

    DEACERO logo

    Data Engineer Intern

    Grupo DEACERO, Monterrey

    • Led the migration of mission-critical ETL workflows from SQL Server to Google BigQuery, refactoring legacy T-SQL logic and building a Python-based QA framework to validate data consistency across large-scale inventory datasets.
    • Designed and implemented a Salesforce-to-BigQuery replication architecture using Google Datastream, automated dataset validation, and dynamic object streaming through GCP REST APIs, reducing data latency to near real-time levels.
    • Built a reusable multi-source replication module for SQL Server and Salesforce, improving code maintainability, error handling, and extensibility across replication workflows.
    • Operated and monitored CDC-based replication pipelines for SQL-to-SQL and SQL-to-BigQuery synchronization, ensuring reliable data consistency across environments.
    • Python
    • T-SQL
    • SQL Server
    • BigQuery
    • Datastream
    • Salesforce
    • CDC
  4. Jan 2025
    - Mar 2025

    Banorte logo

    Application Developer Intern

    Banorte

Projects

VLRCards

FIFA-style rating system and player database for VALORANT, built on VCT data from vlr.gg with a Python ETL pipeline, FastAPI and Next.js.

  • Python
  • FastAPI
  • Next.js
  • SQLite
Astro, TypeScript, FastAPI, SQLAlchemy, PostgreSQL, Supabase

Saldito

Mobile-first personal finance app for accounts, budgets and savings goals, with cash-flow forecasting and spending analytics.

Supabase Realtime, PowerSync

PSell Kitchen Dashboard

Kanban-style kitchen operations with real-time, bidirectional sync across web and mobile clients.

C#, .NET, MySQL

Secure Distributed Banking Ledger

A secure REST API for financial transactions with JWT authentication.

C#, .NET, SQL Server, Azure

Enterprise Event Management System

Normalized SQL Server schemas and CRUD API endpoints deployed on Azure.

Skills

07 categories / 44 skills

Cloud & Data

Languages

  • Spanish (Native)
  • English (C1 - Professional Proficiency)

About me

Software and Data Engineer experienced in building reliable cloud-based data workflows and operational systems across Microsoft Azure and Google Cloud Platform.

Education
Bachelor of Science in Computer Science, Universidad Autónoma de Nuevo León (UANL), FCFM
Certifications
Advanced Web Development Applications, US-ITBasic Data Science, Google
Activities
Participant at Gran PremioMX (Algorithm & Problem Solving Competition)