Anthony Regalado
San Antonio,TX
Summary
Detail-oriented professional experienced in building robust ETL pipelines and automating data processes. Skilled in SQL and C#, with a proven track record of improving operational efficiency through data analysis and problem-solving.
Overview
1
1
year of professional experience
Work History
Purchasing Admin / Data Analyst
Mannapov LLC
San Antonio, TX
09.2025 - Current
Partnered with purchasing and E-commerce teams to translate operational needs into automated data workflows.
● Built a production grade SSIS ETL pipeline to ingest and standardize vendor pricing datasets, replacing manual workflows and enabling reliable daily analysis.
● Developed C# Script Tasks for dynamic sheet detection, directory traversal, and metadata extraction across inconsistent Excel formats.
● Designed a staging → final SQL Server architecture with cleansing logic, idempotent execution, and row level error logging.
● Created VBA automation tools to accelerate vendor dataset analysis and improve pricing accuracy.
● Identified $2M+ in unsent Amazon inventory by analyzing SKU to ASIN mapping issues, driving immediate corrective action.
Education
Computer Programming Technology
Texas State Technical College
Harlingen05-2024
Skills
ETL & Automation: SSIS, C# Script Tasks, VBA
Databases: SQL Server, MySQL, PostgreSQL
Programming: SQL, Python, C#
Data Tools: Excel, Google Sheets, Tableau
Version Control: Git, GitHub
Concepts: Data Modeling, Error Logging, Staging/Final Architecture, Data Quality
Accomplishments
● Identified $2M+ in unsent Amazon inventory by analyzing SKU to ASIN mapping issues, driving immediate corrective action.
Timeline
Purchasing Admin / Data Analyst
Mannapov LLC
09.2025 - Current
Computer Programming Technology
Texas State Technical College