Luis Villa
Hamilton,ON
Summary
Experienced professional with a strong background in medical sciences and pharmacy operations, aiming to utilize 10 months of practical data analysis experience to progress in the field. Possessing a robust understanding of scientific principles and a sharp analytical acumen, I have quickly honed skills in data manipulation, visualization, and interpretation. Dedicated to ongoing learning and advancement, I am enthusiastic about applying my abilities to add value to your team.
Overview
3
3
years of professional experience
Work History
Internship - Digital Merchandising Analytics
Loblaw Companies Limited
05.2024 - Current
- Implemented Python scripts for automating manual financial reports, resulting in a weekly time savings of approximately 1.5 hours throughout the program duration
- Designed an algorithm to optimize the assortment selection for a Micro-fulfillment Center servicing online delivery for downtown Toronto customers
- Project involved querying data from GCP and creating a Looker dashboard, resulting in a streamlined process and a weekly time savings of ~1-2 hours.
Internship - Omni Channel Analytics
Loblaw Companies Limited
01.2024 - 05.2024
- Utilized Python to automate several manual steps in an Excel financial report, resulting in a time saving of approximately 30 minutes per week
- Developed an assortment generator for the online retail platform
- Assortments generated based on various metrics including sales, units sold, and seasonality, catering to different events and holidays throughout the year
- Project involved querying data and creating a SAS code to make the project reproducible.
Internship - Space Optimization Analytics
Loblaw Companies Limited
08.2023 - 01.2024
- Conducted in-depth sales data analysis for prominent brands, utilizing Teradata SQL Assistant and SAS Enterprise Guide to assess optimal fixture space allocation
- Presented findings to category directors, informing future negotiations
- Analyzed the impact of a major sale on product baseline utilizing SQL for data extraction and Excel for detailed analysis
- Results were summarized in a comprehensive report
- Developed a Python code to automate a proofing report based on specific conditions, resulting in ~1 hour saved weekly for the team.
Pharmacy Technician
Colborne Pharmachoice
11.2021 - 08.2023
- Responsible for accurately processing written prescriptions and refill requests, calculating dosages and preparing prescription labels, and filling the medication for approval by pharmacists, all while ensuring compliance with regulations
- Utilized spreadsheet software to track product usage and expiration dates to maintain adequate inventory of medications and supplies
- Utilized this data to help increase the pharmacy's revenue by decreasing over-stock medication and optimizing its placement on the shelf
- Record of providing excellent customer service and maintaining rigid schedules for medication preparation
- Collaborated with other healthcare professionals, including physicians and nurses, and insurance companies to optimize patient care and ensure proper billing.
Education
BSc in Honours Medical Sciences -
Brock University
10.2018
Skills
- BigQuery (GCP), SQL (Teradata SQL Assistant)
- Microsoft Office Suite (Excel, PowerPoint, Word)
- Python (Pandas, Numpy) - Data Analysis & Process Automation
- Data Visualization (Looker Dashboards, Excel)
- Strong analytical and problem-solving skills
- Keen attention to detail and time-management
- Excellent communication in English and Spanish
Timeline
Internship - Digital Merchandising Analytics
Loblaw Companies Limited
05.2024 - Current
Internship - Omni Channel Analytics
Loblaw Companies Limited
01.2024 - 05.2024
Internship - Space Optimization Analytics
Loblaw Companies Limited
08.2023 - 01.2024
Pharmacy Technician
Colborne Pharmachoice
11.2021 - 08.2023
BSc in Honours Medical Sciences -
Brock University
Similar Profiles
Vaishnavee Govindarajan HariharasudhanVaishnavee Govindarajan Hariharasudhan
Customer Experience Associate at Loblaw Companies LimitedCustomer Experience Associate at Loblaw Companies Limited
Duncan RitchieDuncan Ritchie
Senior Director, People Process & Technology at Loblaw Companies LimitedSenior Director, People Process & Technology at Loblaw Companies Limited
Arslan AhmedArslan Ahmed
Manager, Commodities at Loblaw Companies LimitedManager, Commodities at Loblaw Companies Limited
Vali AlasgarovVali Alasgarov
Part-timer (meat Cutter) at Loblaw Companies LimitedPart-timer (meat Cutter) at Loblaw Companies Limited
Yassine BenkandilYassine Benkandil
Graduate Researcher at McMaster UniversityGraduate Researcher at McMaster University