# Juan Aguas

Juan Aguas is a remote worker on Himalayas, Analista Workforce at Ayesa atech BPO, based in Colombia.

Source: https://himalayas.app/@awas

```text
Operations & Reporting Analyst | Excel, VBA, Data Accuracy
```

| Detail | Value |
| --- | --- |
| Availability | Looking for a job |
| Location | Colombia |
| Authorized to work in | Colombia |
| Salary expectations | 30k+ USD |
| Job categories | Workforce Analyst |
| Skills | Workforce Management, Shift Scheduling, Resource Allocation, Real time Monitoring, Traffic Forecasting, Staffing, Erlang, Call Center Operations, TMO Analysis, Service Level Analysis, Abandon Rate Analysis, Excel, Advanced Excel Formulas, Pivot Tables, VBA Macros |

## About

```text
Operations analyst with 3+ years in high-volume contact center environments, focused on accurate data handling, consistent processes and Excel automation. I manage scheduling and real-time monitoring in web-based systems, report on key metrics (service level, AHT, abandonment rate) and build Excel/VBA tools that reduce manual work. I learn new software quickly, work independently and communicate clearly in writing.
```

## Experience

### Analista Workforce (current)

Ayesa atech BPO. Sep 2023 - Present

```text
Plan agent shifts around demand and monitor agent states in real time (CCPulse). Track KPIs (service level, AHT, abandonment rate) with pivot tables and advanced formulas. Built Excel/VBA dashboards that automate reporting, plus an Erlang C tool for traffic forecasting and staffing. Handle admin requests by email, following set procedures.
```

Skills: Excel, VBA, Advanced-Formulas, CCPulse, Erlang, Workforce-Management, Prediction, Dimensioning, Tasa-De-Abandono, TMO, Pivot-Tables, Service-Level-Objectives, AHT

### Asesor de Servicio al Cliente

Almacontac. Apr 2022 - Jul 2023

```text
Handled customer requests by phone and chat, tracked cases to resolution and kept customer account records accurate and up to date.
```

Skills: Atención-al-Cliente, Comunicación, Gestión-De-Solicitudes, Seguimiento-De-Casos, Client-Management, Client-Services, SQL

## Education

### Colegio Ramón de Zubiría

Bachiller Académico, General Studies

```text
Completed high school education, earning the title of Bachiller Académico in 2020.
```

## Tech stack

- Microsoft Excel
- Erlang

To contact Juan, message them from this profile with a Himalayas employer account: [Hire on Himalayas](https://himalayas.app/hire).

## People also viewed

- [Juan Drummer](https://himalayas.app/@juanramos9110): Quality Assurance Analyst, Ubiquity
- [Fredy Espinosa](https://himalayas.app/@fredyespinosa): WFM Assistant Manager, IGT Solutions
- [Marlon García](https://himalayas.app/@marlongarca): Sales Development Representative, RocketLevel Commercial
- [Ivanna Hinojosa](https://himalayas.app/@ivannahinojosa): Workforce Operations Coordinator, 5CA
- [Jacobo Giraldo](https://himalayas.app/@jacobogiraldo): Técnico GTR, Emergia Contact Center
- [Jorge Concha](https://himalayas.app/@jorgeconcha): Workforce Assistant Manager, ATAIN
- [Daniel Ricardo Rodriguez](https://himalayas.app/@danielricardorodrigu): Executive Assistant / Operations Analyst, Stellar
- [Steven A Florez C](https://himalayas.app/@stevenaflorezc): Administrative Specialist & Marketing Assistant, SYNC
- [santiago valencia](https://himalayas.app/@santiagovalencia1): Workforce Management and Reporting Lead, Atento
- [Bree Lozano](https://himalayas.app/@breelozano): Data Analyst, RSM ATL
