Andrés Felipe Vargas González

Software Engineer with a background in Business Administration and currently studying Computer Engineering and a specialization in Artificial Intelligence. I have a unique combination of business knowledge and technical skills for process optimization and data-driven decision making.

Technologies

Experience

Associate Workforce Capacity Planner, Optum – Bogotá, COL Jan 2023 – May 2024

• Analyzed the trends of the KPIs and created visualizations for upper management in Excel and Power BI, such as attrition, absenteeism, and forecast accuracy.

• Forecast calls for prediction by means of regression models.

• Implemented automated data flows with complex ETLs with Python.

• Designed and implemented an automated capacity plan with SQL, Excel and Python.

• Communicated results and planned strategies for continuous improvement.

• Automated the extraction and processing of large datasets from NICE using SQL and Python.

Workforce Scheduler, Transcom – Bogotá, COL Oct 2021 – Jan 2023

• Optimized schedules in Operational Capacity and created Hiring Plans to cover the Telephony demand.

• Designed Looker reports for upper management on KPIs and expose strategies to improve performance.

• Lead calls with external clients to explain results and future plans.

• Automated the visuals of the Schedules for Agents and Operation with Google JavaScript (Google Apps Script).

• Implemented automated dataflows to control the visual of Head Count and Attrition.

Senior Analyst, Teleperformance – Bogotá, COL May 2016 – Sep 2021

• Planned hiring strategies to fulfill the capacity of the contact center.

• Automated workforce reports with Python, Excel, VBA and JavaScript.

• Forecasting and regression models to predict calls demand.

• Web scraping with Puppeteer and Selenium.

• Implemented data flows for KPI control, such as absenteeism, attrition, attendance, and Service Level

Education

Fundación Universitaria Internacional de la Rioja, Specialization in Artificial Intelligence Nov 2024 – Ongoing

Coursework: AI Investigation, Machine Learning, Computational Perception

• Languages: Python, JavaScript, SQL, HMTL.

• Backend: FastAPI, Django, NodeJS.

• Frontend: Angular, React, CSS, Tailwind.

• SQL: SQL Server, PostgreSQL, Maria DB, MySQL.

• Analysis: Excel, Power BI, Tableu, Looker, Notebooks (Jupyter, Google Colab, Deepnote, Databricks).

• Cloud: Azure, Google Cloud, AWS.

Fundación Universitaria Internacional de la Rioja, Computing Engineering Aug 2022 – Ongoing

Coursework: Computer Science, Database management, Software Engineering

Corporación Universitaria el Minuto de Dios, Business Administration Jan 2012 – Apr 2019

Coursework: Financial management, Planning, Business Analysis

Software Engineer CXaaS and Reporting, Global Hitss – Bogotá, COL September 2024 – Mar 2025

• Integrated security and authentication in API communication with JWT.

• Designed and developed User Interfaces of Reporting with Angular to render Power BI reports and User management.

• Implemented MVC with ORMs to secure communication of the Frontent platform with the Backend.

• Designed and implemented Entity Models in SQL to provide solutions to Business cases.