Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic
Mario Alberto Garcia Lopez

Mario Alberto Garcia Lopez

Experienced Data Scientist
Monterrey,Nuevo Leon

Summary

Experienced Data Scientist with a strong knowledge and passion about data analytics and tools like SQL, Power BI, and Python Language

Overview

5
5
years of professional experience
6
6
years of post-secondary education
1
1
Certification
1
1
Language

Work History

Project Engineer

Open Systems International
Minneapolis, Minnesota
09.2022 - 03.2025
  • Built and Designed SCADA systems.
  • Roles and responsibilities including working directly with the customer on SCADA system design and build, install and support the client needs.
  • I was able manage and support a project with 10+ servers going on-site with client to establish their needs in the system

Payroll Analyst

Pepsico
Monterrey, Nuevo León
09.2021 - 09.2022
  • Submitting and analyzing payments in time and not on time for Pepsico workplaces in USA.
  • Developing and supporting payroll movements through the North America offices and using SAP to retrieve data and post late and on time payments for the customer depending on the type of payment we were using.
  • I was able to help 100+ employees in a day to get their payments in the right day

Sales Executive / IT Consultancy

MicroRed
Monterrey, Nuevo León
02.2021 - 09.2021
  • Searching for leads and potential customers to buy Dell products including computers and IT infrastructure and also analyzing all the products and technology that Dell has to offer. I help to sell IT structure to 5 companies and help to reach 150 leads

CRM Developer Intern

Definity First
Monterrey, Nuevo León
11.2019 - 01.2021
  • Worked in CRM Developing in Definity First, my principal task was to give support for different customers in their CRM environment taking some tickets for app support

HR Business Intelligence

Cemex
Monterrey, Nuevo León
02.2020 - 06.2020
  • Retrieving data for HR and transformed it to give a Power BI dashboard that can help to take decisions on Mexico's hub helping HR department to take decisions.
  • Designing a dashboard with metrics like Termination Rate, Open Positions per Month, and help with the relational database model
  • Help to retrieve data from the 5 sectors of CEMEX here in Mexico and build the dashboard from scratch

Education

B.S - Business Informatics

ITESM
Monterrey, Mexico
01.2017 - 07.2022

Skills

SQL

Sales

Power BI

Tableau

Python

C

Microsoft Excel

SAP

Linux/Unix

Artificial Intelligence

R

Oracle SQL

Project management

Snowflake

Certification

Google Data Analytics

Timeline

Google Data Analytics

03-2025

Project Engineer

Open Systems International
09.2022 - 03.2025

Payroll Analyst

Pepsico
09.2021 - 09.2022

Sales Executive / IT Consultancy

MicroRed
02.2021 - 09.2021

HR Business Intelligence

Cemex
02.2020 - 06.2020

CRM Developer Intern

Definity First
11.2019 - 01.2021

B.S - Business Informatics

ITESM
01.2017 - 07.2022

Similar Profiles

CREATE PROFILE
Mario Alberto Garcia LopezExperienced Data Scientist