Andrea Lopez Ramirez
Tableau Analyst at Inteligencia Avanzada- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Credentials
-
Share Data Through the Art of Visualization
CourseraApr, 2023- Nov, 2024 -
Analyze Data to Answer Questions
CourseraFeb, 2023- Nov, 2024 -
Process Data from Dirty to Clean
CourseraDec, 2022- Nov, 2024 -
EFSET English Certificate 67/100 (C1 Advanced)
EF Standard English Test (EF SET)Dec, 2022- Nov, 2024 -
Prepare Data for Exploration
CourseraNov, 2022- Nov, 2024 -
Ask Questions to Make Data-Driven Decisions
CourseraOct, 2022- Nov, 2024 -
Foundations: Data, Data, Everywhere
CourseraAug, 2022- Nov, 2024 -
Constancia Implementación NOM-035-STPS-2018
Grupo GR Soluciones en Recursos HumanosJan, 2020- Nov, 2024
Experience
-
Inteligencia Avanzada
-
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
-
-
-
SYS Expertos en Seguridad Privada / Silvia Adriana Mendoza Ugalde
-
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
-
-
-
Cineteca Nacional
-
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 -
Universidad Nacional Autónoma de México
Licenciatura, Empresa/comercio, general