Yotsan Alejandro Vanegas Idarraga

Developed data solutions for two corporate projects, CARD and Roster, integrating account, employee, assignment, and work-hour data using SQL Server, Python, and Power BI. Analyzed and validated 1.23 million CARD records, representing 2.50 million recorded hours, to assess alignment with master accounts and use in cost analytics.

Developed a natural language processing pipeline with Transformers and Hugging Face to structure information from 1.35 million records and more than 654,000 free-text documents. Implemented validation rules with regular expressions that eliminated 52.6% of false positives identified during information extraction.

Integrated historical payroll, 360-degree assessment, performance, and employee climate data into a unified People Analytics database, including data cleaning and validation processes. Developed a generative AI agent to analyze and categorize more than 2,000 corporate roles and identify 300 strategic positions for training and skills-reskilling initiatives.

Managed price and inventory updates for more than 35,000 products, integrating information across Siigo, retail platforms, an online store, and two physical branches.

Developed a solution to extract and structure data from E14, E24, and E26 electoral forms, automating document ingestion for analysis. Implemented algorithmic validations and inconsistency detection across more than 10,000 data nodes to support auditing and the 2026 electoral count.

Minor in Statistics, completed in June 2026. Training in time series, multivariate analysis, geostatistics, and Bayesian statistics.

Activities and societies: Undergraduate Teaching Assistant for Linear Algebra from Jul to Dec 2023.

Bachelor's Degree in Data Science, graduated in July 2026. Developed regression models, financial models, decision trees, ensemble methods, and machine learning and deep learning models in university projects using Python and R.

Completed diploma programs in programming fundamentals, basic programming, software development, and mobile applications.