Edgar Guzman Cuevas, Developer in Mexico City, Mexico
Edgar is available for hire
Hire Edgar

Edgar Guzman Cuevas

Verified Expert  in Engineering

Data Engineer and Developer

Location
Mexico City, Mexico
Toptal Member Since
April 27, 2023

Edgar holds a bachelor's degree in industrial engineering and a master's degree in data analytics: This is why he enjoys making sense of data. As a business analyst at Toptal, he's developed support KPIs that helped track support operations and created a repository of dashboards, amongst other contributions. As an associate program manager at Uber, Edgar defined support processes to be executed by 500+ support agents across Latin America and managed three lines of business.

Portfolio

New Way Schools Inc
Microsoft Power BI
Toptal
Google BigQuery, Spreadsheets, SQL, Tableau, Zendesk, Zendesk API...
Uber
Spreadsheets, SQL, Google Sheets, Microsoft Power BI, Dashboards, Data Analysis...

Experience

Availability

Part-time

Preferred Environment

Google BigQuery, Tableau, Looker, Spreadsheets, SQL, QlikView

The most amazing...

...project I've designed is a self-service feature that Uber implemented in LATAM's help center, which is available for millions of users.

Work Experience

Power BI Specialist

2023 - 2023
New Way Schools Inc
  • Extracted data and created detailed dashboards to measure and compare progress based on various parameters. Main activities involved data visualization, data analysis, and working with Excel.
  • Tracked requisitions using project management tools such as Jira.
  • Improved and created a process approved by leadership for actioning maintenance in already existing reports and dashboards.
Technologies: Microsoft Power BI

Business Analyst

2021 - 2023
Toptal
  • Developed various BI applications with Tableau for executive teams covering different business areas such as marketing, finance, talent operations, people operations and company-wide OKRs.
  • Created ad hoc marketing campaign analyses (Google AdWords) and created interactive dashboards on Tableau that would unveil actionable insights while using project management tracking tools based on Kanban methodology.
  • Built Zendesk monitoring tools for customer support operations. Created KPIs for following up on the team's operations i.e. inflow tracking, average handle time, customer satisfaction, total resolution time, number of touches, policy adherence, etc.
Technologies: Google BigQuery, Spreadsheets, SQL, Tableau, Zendesk, Zendesk API, Google Sheets, Dashboards, Advertising, Data Analysis, Enterprise, Reporting, Business Intelligence (BI), Exploratory Data Analysis, Data Visualization, Dashboard Development

Associate Program Manager

2017 - 2021
Uber
  • Implemented regional fraud detection processes, generating annual savings of around US $234,000.
  • Owned the development of an in-app feature to improve the overall experience in cash trips, driving operational efficiencies by decreasing LATAM's arrears defect rate by 1,094 bps.
  • Optimized support processes in LATAM, driving annual savings of around US $990,000 per year.
Technologies: Spreadsheets, SQL, Google Sheets, Microsoft Power BI, Dashboards, Data Analysis, Enterprise, Exploratory Data Analysis, Data Visualization, Correlational Analysis

Qlikview Dashboard | Migration and Repatriation between Mexico and the USA

https://drive.google.com/file/d/1ERVksRfwJu7L_14md4RgouQW18QftqDb/view?usp=sharing
This Qlik report summarizes the repatriation events data of the US-Mexico border. It was created in partnership with the Mexican National Institute of Statistics and Geography (INEGI–Instituto Nacional de Estadística, Geografía e Informática).

Tableau Dashboard | Twitter Data Analysis for Conference

https://drive.google.com/file/d/1JEQ9JK8tGU0-Ps5YdsGAsjmjX6nAI6N7/view?usp=sharing
A company organized a data visualization best practices conference and collected Twitter data using the hashtag #DATAVIZ.

They required assistance in organizing, cleaning, and analyzing the data to identify the most relevant candidates to host the conference based on retweets and favorites and build a Tableau dashboard that would show the conclusions at first glance.

STEPS TAKEN
1) Identifying user vs. bot
2) Grouping sentiment values
3) Validating location
4) Standardizing retweets and favorite scores.
5) Calculating weighted relevance
6) Creating a Tableau dashboard

Dashboard for a Sales Team

https://drive.google.com/file/d/1rH_ZmP5IARhdSt4stocLkHDzYofAQUMh/view?usp=drive_link
The project aimed to provide sales management with dashboard analytics, focusing on:

1. Analyzing revenue and profit results for the last four quarters and comparing them with the previous year (general overview and breakdown by regions and item types).

2. Identifying the countries and regions with the best sales performance over the past five years by examining the number of sales and comparing revenue and profit.

3. Understanding global sales trends for different item types by tracking trends by country and region, identifying any changing order priorities, and analyzing order management for critical, high, normal, and low priority orders.

4. Examining the time period between order and ship date (breakdown by item type and region) and providing a comparison of the last five years in this regard.
2020 - 2022

Master's Degree in Data Science

Universidad Internacional de la Rioja - Remote

2013 - 2017

Bachelor's Degree in Industrial Engineering

Universidad La Salle - Mexico City

OCTOBER 2021 - PRESENT

Análisis y Visualización de Datos

Universidad Internacional de La Rioja

Libraries/APIs

Zendesk API, Pandas, NumPy, Scikit-learn

Tools

Tableau, Spreadsheets, Microsoft Power BI, Google Sheets, Looker, Excel 2013, AutoCAD, BigQuery

Paradigms

Business Intelligence (BI), Data Science

Languages

SQL, Python, C

Platforms

Microsoft, QlikView, Zendesk

Storage

Google Cloud, MongoDB

Other

Dashboards, Charts, Dashboard Development, Data Analysis, Interactive Charts, Enterprise, Data Analytics, Reporting, Exploratory Data Analysis, Data Visualization, Statistical Analysis, Linear Regression, Correlational Analysis, Google BigQuery, Statistics, Data, Big Data, Quality Control (QC), Physics, Administration, Calculus, Lean Project Management, Waterfall Methodology, Markets, Supply Chain, Thermodynamics, Electronics, Instrumentation, Advertising

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring