Luis Peña Email & Phone Number

Miranda, Venezuela

Venezuela

• 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.

Venezuela

• 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.