Alexander Leon

Senior Software Engineer | Cloud Data Engineer

Software/ Data Engineer specializing in modernizing large-scale data pipelines. Led Talend → AWS Glue migrations, reducing costs by 70% and development overhead by 80%.

Contact MeView Work
Alexander Leon

Experience

Engineer & Cloud Engineer

Daugherty Business Solutions

Consulting (Bayer)

2020-02 - Present

As a consultant on a Bayer team I was able to expand my skillset which allowed me to modernize and operationalize end-to-end data pipelines.

Key Achievements

  • •Optimized BigQuery workloads (partitioning, clustering, query refactors) and delivered a measurable 33% reduction in slot utilization and measurable query performance improvements.
  • •Built CI/CD pipelines (including the flagship Discovery and Lab pipelines) and automated Glue deployments using GitHub Actions and parameter-driven CloudFormation to enable PR-based promotions and repeatable infrastructure deployments.
  • •Built a metadata-driven AWS Glue job framework that reduced development overhead by ~80% and sped new pipeline onboarding.
  • •Migrated Talend/Java pipelines to AWS Glue (PySpark) reducing operating costs from $21k to $6K annually (~70% cost reduction) and created a generic Glue job framework to ingest tables from metadata, improving pipeline scalability and reducing development overhead by ~80%.
  • •Standardized metadata via Glue Catalog and Glue Crawlers, enabling metadata-driven pipelines and self-service job generation.
  • •Created automated alerting (AWS Lambda → Teams/Email) to deliver real-time failure notifications and improve incident response times.
  • •Collaboratively designed high-volume orchestration patterns using Step Functions, AWS Batch, queued ingestion with DLQs, and cross-cloud integration with GCP Pub/Sub.
  • •Integrated HashiCorp Vault for dynamic secrets management, streamlining credential rotation and improving security posture.

ETL Data Engineer

RxSavings Solutions

2019-01 - 2020-01

Established ETL best practices and standardized development methodologies across the data team. Abstracted commonly used transformations into Talend routines, reducing maintenance effort and improving consistency. Led the Talend 6.5 to 7 migration and coordinated with DevOps to integrate Jenkins-based CI/CD. Developed data ingestion pipelines in Talend Open Studio to onboard healthcare partners, handling flat files, CSVs, positional formats and loading into MySQL.

Key Achievements

  • •Established ETL best practices and standardized development methodology across the data team, improving consistency and reducing maintenance effort.
  • •Standardized ETL development by abstracting common transforms into Talend routines and templates, reducing duplicate code and simplifying maintenance.

Talend Developer

Ad Victorium Solutions

2018-01 - 2019-01

Migrated Salesforce and other CRMs (NetSuite, Zendesk, etc.) into new Salesforce orgs using Talend. Built scalable ETL jobs handling hundreds of fields across multiple transformations and scheduled batch jobs. Improved efficiency by implementing metadata-driven ETL components to reduce manual job creation. For the Jagger Data Migration (AVS), solved Talend's 65K Java file size limit by breaking large jobs into optimized sub-jobs and using hashtables to pass data between sub-jobs, avoiding unnecessary I/O.

Key Achievements

  • •Implemented large-scale CRM migrations (Salesforce, NetSuite, Zendesk) into consolidated Salesforce orgs using Talend, mapping hundreds of fields and complex transformations to preserve data integrity during cutovers.

ETL Developer & Consultant

Onshore Outsourcing

2015-01 - 2018-01

Completed a bootcamp in C#, ASP.NET, HTML, and MSSQL culminating in a full-stack capstone project. Supported Hudson's Bay Company's financial reporting via Excel & JCL-based month-end processing. Developed Visual Basic automation for Schnucks to convert Excel sheets into PDF reports using Acrofields. Self-taught Talend to support Oracle-to-Domo integrations and trained multiple offshore teams in month-end processes and data transformation best practices.

Key Achievements

  • •Delivered a full-stack bootcamp capstone demonstrating backend services, database-driven workflows, and front-end integration using C#, ASP.NET, and MSSQL.

Education

No Degree

Full-Stack Development Bootcamp

C#, ASP.NET, HTML, MSSQL

2015-01 - 2015-06

Completed a full-stack bootcamp covering C#, ASP.NET, HTML, and MSSQL; delivered a capstone project demonstrating backend services, database-driven workflows, and front-end integration.

Skills

Data Engineering

Talend• Advanced
ETL• Advanced
AWS Glue• Advanced
Google BigQuery• Advanced
MySQL• Advanced
Oracle• Proficient
Domo• Proficient

Cloud & DevOps

AWS Lambda• Advanced
CI/CD• Advanced
Jenkins• Proficient
HashiCorp Vault• Proficient
Cloudformation• Proficient
GitHub Actions• Proficient

Programming & Scripting

SQL• Advanced
C#• Proficient
Python• Proficient
Visual Basic• Proficient
Java• Familiar

Tools / Platforms

Salesforce• Familiar
Git• Advanced

Projects

Bayer ETL Modernization

2020-02

Led migration from Talend to AWS Glue and built a generic Glue job framework to automatically ingest tables using metadata-driven patterns. Implemented Vault integration for dynamic secrets, an AWS Lambda alerting system for real-time failure notifications, and collaborated on cost optimization that reduced Talend licensing and migrated legacy storage to cloud. Reduced development overhead and improved pipeline scalability and reliability.

TalendAWS GlueGoogle BigQueryVaultAWS Lambda

Database Crawling & ERD Mapping Tool

2019-06

Built a tool to crawl relational databases, extract schema metadata, and generate ERD visualizations to accelerate onboarding and documentation of unfamiliar data sources and speed integration work.

PythonSQLGraphviz

CI/CD Pipelines & Discord Notification Bot

2021-01

Implemented Jenkins-based CI/CD pipelines for ETL deployments and created an automation bot to post build/deploy notifications and incident alerts to Discord/Teams, improving deployment visibility and incident response times.

JenkinsGitDiscord APIAWS

AI-Powered Resume Website & Portfolio

January 2026

Built a full-stack Next.js resume website with an intelligent admin CMS and AI-powered job matching system. Features include: (1) Dynamic resume management with real-time preview and export to PDF/DOCX with clickable links, (2) Vector database integration using OpenAI embeddings for semantic job matching with 45%+ accuracy threshold, (3) Intelligent content selection with expandable section selector for granular control over skills, achievements, and experience, (4) Automated achievement sorting by impressiveness using AI scoring algorithms, (5) Metadata-driven architecture with TypeScript interfaces and Drizzle ORM, (6) Docker containerization with persistent SQLite storage and automated CI/CD-ready deployment, (7) Authentication-protected admin panel with CRUD operations for all resume sections, (8) Responsive dark-themed UI with Framer Motion animations and Tailwind CSS, (9) Content length estimation and auto-truncation to enforce 2-page resume limit, (10) RESTful API architecture with proper error handling and type safety. The system reduces resume tailoring time from hours to minutes while maintaining professional quality and ATS compatibility.

Next.js 14TypeScriptReactTailwind CSSDrizzle ORMSQLitesqlite-vecOpenAI APIDockerFramer Motion@react-pdf/rendererdocxbcrypt
View Project

Certifications

ICAgile Certified Professional

ICAgile

Issued: 2017-06

Get In Touch

Location

Columbia, MO
United States

Download Resume