• Wrote SQL queries, procedures and jobs to implement reports and automatizations.• Centralized the general mantainence of up to 9 store’s database on a remote server.• Schedule tasks using Python and Google Sheets (Appscripts) to automate emailed reports and update spreadsheets every 15 to 60 minutes.• Created table structures for new data to be collected, minimizing user error by 75%.• Designed statistical models using R, to improve forecast of the next quarters sells by 50% and prevent over stock of inventory.• Audited procedures in order to spot flaws and improve the system.• Cleaned data entered by users to ensure integrity.• Reduced up to 80% of the costs associated with technical support, by summarizing the users needs so the consulting times were shorter.• Worked back to back with consulting teams to minimize implementations errors.• Created 10+ reports using Foxpro (ERP's code language)

• Reduced from 1 week to just 30 minutes the expected time of prices update in Google Sheets.• Advanced formulas implementation, reducing up to five times the working hours required for certain tasks.• Cleaning and matching data of 2000+ products between stores.• Introduction in the use of Google Sheets and Google Drive to 6 departments, as well as intermediate formulas.• Modification of multiples lines of code in SQL to implement new objectives or changes in the ERP.• Documentation of the purchasing process,reception and billing. It removed up to 90% of the negative stock, as well as being able to create new reports that contemplate the whole picture.• Creation of forms that reduced in 50% the time required for the users to deliver a report of all the money recolected by the store at the end of the day.