Summary
Overview
Work History
Education
Skills
Timeline
Hi, I’m

Edgar Lopez

Analyst
Chicago,IL

Summary

As a data analyst my goal is to use technology resources to help an organization be more productive and successful by providing the necessary information employers need to make better decisions.

Overview

3
years of professional experience
6
years of post-secondary education
1
Language

Work History

Rayados Soccer Academy Chicago & Indiana
Chicago, IL

Club Manager, Coach, Data and Video Analyst
03.2021 - Current

Job overview

Club Manager

  • Manage the organization of the academy.
  • Manage social media accounts.
  • Handle all players registration.
  • Generate practices and game schedules
  • Coordinate teams registrations to leagues and tournaments
  • Coordinate team’s travel arrangements for tournaments.
  • Handle the orders of players game and training gear.

Coach

  • Coach of the U14 boys team.
  • Coach of the U13 girls team.
  • Assist coaches with other teams training and games.

Data and Video Analyst

  • Assist coaches to analyze videos of their games and practices.
  • Provide players with video highlights.
  • Create tactical sessions with coaches and players.
  • Provide player and team data analysis

Navistar, Inc.
Lisle, IL

Data Analyst
01.2020 - 06.2020

Job overview

  • Assisted the medium duty platform department with a 5-year Feature Complexity Reduction Data project which was completed under a 6-month contract.
  • Conducted database searching and analysis for historical trends using Excel, Power BI and different software’s.
  • Identified low volume feature codes and developing Excel spreadsheets with the information needed for review meetings.
  • Leaded daily review meetings with the team in which they would decide on whether we keep, review with another department, or remove a feature code.
  • Supervised and completed the removal process of all the feature codes.
  • Assisted application engineers with trucking orders by making sure that they contained active and compatible feature codes which gives the green light to start building orders.
  • Supported the project manager lead by replacing old feature codes with new ones in different Excel spreadsheets.
  • Assisted the medium duty platform with cost saving project which consist in searching for similar feature codes and removing the most expensive ones.
  • Participated in requirements meetings and data mapping sessions to understand business needs.
  • Transformed project data requirements into project data models.

National Material LP
East Chicago, IN

Data Analyst Intern
07.2019 - 12.2019

Job overview

  • Utilized various professional statistical techniques and maintained large databases to collect and analyze data from partners and customers.
  • Identified, analyzed and interpreted trends or patterns in complex data sets by finding correlations and visualizing with charts.
  • Provided analytical feedback to the sales, quality, and finance departments.
  • Identified and analyze the reason of late shipments.
  • Collected data and analyze results using Microsoft Excel and Microsoft Dynamics AX.
  • Transformed raw data into a more descriptive analytical report.
  • Analyzed weekly financial reports.
  • Assisted inside sales representatives organize customers sales reports.
  • Assisted the quality department entering steel coils test results into Microsoft Dynamics Ax software.

Whole Foods Market Inc
Chicago, IL

Produce Overnight Receiver Supervisor
04.2017 - 11.2018

Job overview

  • Reviewed incoming shipments for correctness to ensuring no damage or duplication of orders.
  • Oversaw and lead a small group of 5 employees during the overnight shift.
  • Coordinated and supervised all of the receiving products were properly stored in their designated sections on a timely manner
  • Leaded and encouraging team members to ensure productivity goals were met.
  • Contributed with product display change decisions based on current sales and products available.
  • Provided new item setup, merchandising and inventory control.
  • Maintained communication between upper managers and employees.

Education

Purdue University Northwest
Hammond, IN

Bachelors of Science in Business from Business Information And Analytics
08.2018 - 05.2021

University Overview

GPA: 3.44

Morton College
Cicero, IL

Associate of Science from Applied Science
05.2013 - 05.2016

University Overview

GPA: 3.5

Skills

IBM SPSS ModelerTableauData VisualizationData management

Data validation

Data analysis

Project Management

Microsoft Office Suite

Problem-Solving

Timeline

Club Manager, Coach, Data and Video Analyst

Rayados Soccer Academy Chicago & Indiana
03.2021 - Current

Data Analyst

Navistar, Inc.
01.2020 - 06.2020

Data Analyst Intern

National Material LP
07.2019 - 12.2019

Purdue University Northwest

Bachelors of Science in Business from Business Information And Analytics
08.2018 - 05.2021

Produce Overnight Receiver Supervisor

Whole Foods Market Inc
04.2017 - 11.2018

Morton College

Associate of Science from Applied Science
05.2013 - 05.2016
Edgar LopezAnalyst