Alex Lopez

My name is Javier Alejandro López, I am 24 years old, I consider myself a person willing to face new challenges and to provide the required assistance whenever requested, I have the enthusiasm to learn and to expand my capabilities, as well as to offer alternatives to different problems.

I have 3+ years as a data analyst, working for different companies as well offering my services as a freelancer.

Technical Skills / Software

-Excel (Advanced Level):

LOOKUP / VLOOKUP / etc.

If statements

Dynamic tables

Pivot Tables

Charts

-Power BI (Advanced Level)

If statements

Variable use

General DAX knowledge

Calculate

Understanding ROW contex and filter context

-SQL

Oraginzation and transformation of data

Merge tables

Use of inner, outer, left and right joins

Description:

• I have been working as a Real Time Analyst in the Workforce Management Department. As an RTA I had to master the data gathering using different tools and software that allows me to compile results and forecast the upcoming needs of the operations team.

-General database knowledge

-Organize and transform data

-Forecast the performance for the upcoming days and weeks based on our requirements and staff.

-Ability to act and react promptly to last-minute requests

-Be creative in providing strategies and plans to increase the performance of the operations department.

-Improvise practical solutions for obtaining the required data, using Excel formulas and macros to streamline processes.

-Use of Visual Basic to program and create conditional formmating with macros on Excel

Lingüística aplicada a la enseñanza y traducción del inglés - Bachillerato general - Universidad Autónoma de Nuevo León