Andrea Lopez Ramirez

Tableau Analyst at Inteligencia Avanzada
  • Claim this Profile
Contact Information
us****@****om
(386) 825-5501
Location
Mexico City, Mexico, MX

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

You need to have a working account to view this content.
You need to have a working account to view this content.

Credentials

  • Share Data Through the Art of Visualization
    Coursera
    Apr, 2023
    - Nov, 2024
  • Analyze Data to Answer Questions
    Coursera
    Feb, 2023
    - Nov, 2024
  • Process Data from Dirty to Clean
    Coursera
    Dec, 2022
    - Nov, 2024
  • EFSET English Certificate 67/100 (C1 Advanced)
    EF Standard English Test (EF SET)
    Dec, 2022
    - Nov, 2024
  • Prepare Data for Exploration
    Coursera
    Nov, 2022
    - Nov, 2024
  • Ask Questions to Make Data-Driven Decisions
    Coursera
    Oct, 2022
    - Nov, 2024
  • Foundations: Data, Data, Everywhere
    Coursera
    Aug, 2022
    - Nov, 2024
  • Constancia Implementación NOM-035-STPS-2018
    Grupo GR Soluciones en Recursos Humanos
    Jan, 2020
    - Nov, 2024

Experience

    • Mexico
    • Marketing Services
    • 1 - 100 Employee
    • Tableau Analyst
      • Jun 2023 - Present

      Extracted raw data from databases using SQL Server running and creating querys for weekly reporting to analyze the price, share of self, exhibit shelves, out of stock products and assistance in channel promotion activities. Cleaned large amount of data preparing it for data analysis, identifying and correcting errors and inconsistencies in datasets to get reliable data for analysis. Maintained and updated dashboards in Tableau of metrics as assistance, entries and exits, photographic campaigns and survey implementations, Managed data synchronization in Firebase with an app to update real time channel promotion activities. Show less

  • Profesional independiente
    • Mexico City, Mexico
    • Freelancer / Data Analyst
      • Nov 2022 - Present

    • Mexico
    • Security and Investigations
    • 1 - 100 Employee
    • Administrative Coordinator
      • Sep 2019 - Sep 2022

      Managed and optimized administration processes by the revision and edition of five organization manuals yearly using data to understand the business and the day-to-day operations. Provided reports to Accountant one report monthly with two spreadsheets by preparing and analyzing financial and accounting information like recorded transactions, billing information, bank reconciliation, checks and payroll withholdings and deductions. Negotiated renovations and yearly increases average 10 contracts yearly and negotiated average three new contracts yearly by organizing work meetings and email communication. Obtained permission and renovation to operate private security yearly by observing regulations and carrying out administrative procedures and responding the requests from authorities. Applied the NOM-035-STPS-2018 to all 80 employees by training them about prevent the psychosocial risks and applying surveys to measure if the employees has been exposed to severe traumatically events analyzing and reporting that information to take actions. Show less

    • Becaria
      • Oct 2016 - Dec 2018

      Managed Format Disclosure of Conflict of Interest of 1,200 employees by collecting signatures of the format, storing all archives, and elaborate and update a spreadsheet of the data generated. Assisted the manager with the redaction of the annual intern report of the institution by collecting and analyzing data from surveys and gather historical information. Prepared PowerPoint presentations to train the stakeholders of all institution to know and apply the COSO Enterprise Risk Management to build the internal control system. Show less

    • Movies, Videos, and Sound
    • 1 - 100 Employee
    • Social Service Worker
      • Nov 2013 - May 2014

      Organized document storage of the accounting records of Administration and Finances Unit to assist the auditors with specific information. Organized document storage of the accounting records of Administration and Finances Unit to assist the auditors with specific information.

Education

  • Universidad Nacional Autónoma de México
    Maestría en auditoría, Auditoría
    2017 - 2019
  • Universidad Nacional Autónoma de México
    Licenciatura, Empresa/comercio, general
    2011 - 2016

Community

You need to have a working account to view this content. Click here to join now