Marcus Garcia
Data Scientist
Riverside,CA
Summary
Data Scientist familiar with gathering, cleaning and organizing data for use by technical and non-technical personnel. Advanced understanding of statistical, algebraic and other analytical techniques. Highly organized, motivated and diligent with significant background in Data Analytics.
Overview
4
4
years of professional experience
8
8
Certifications
Work History
Data Scientist
Stater Bros Markets
12.2023 - Current
- Wrote, tested, and implemented JavaScript web scraping tool utilizing Selenium to allow dynamic webpage scraping. Effectively scraped customer data for all Stater Bros. Markets stores from third party, saving manual labor time of roughly 8 hours every 2-3 weeks.
- Developed versatile data models which are utilized by data analytics for streamlined reporting; decrease in repetitive data collection methods by 30%.
- Collaborated with Marketing stakeholders to identify which items on schematic are not selling; identified categories for marginal increase.
- Initiated enterprise data team; provided insights to standard operating procedures and developed data analysts in short time frame of 3 months.
- Conducted feature engineering efforts to enhance model performance by creating new relevant variables from raw input data sources
Data Analyst
Stater Bros. Markets
01.2023 - 12.2023
- Developed SQL query which matched each store, both brick and mortar and e-commerce, to its respective comparable store for each day in the last 2 years for sales comparison; data that previously had to be manually coded in DAX measures and Excel formulas
- Coded Python script, utilizing Pandas, RegEx, Shutil and OS libraries, which performs Excel file cleaning resulting in a total of 6 hours of time saved per week and fully prepared files to plug into Survey data model via Power BI
- Established Insights to POS and Margins by Super Vendor in Power BI using DAX and compared performance to overall chain; a relationship that was not fully formed between sub-vendors, primary vendors, and super vendors
- Implemented Python script which imports data from Excel and creates new files grouped Vendor and items which is utilized for check stand billing, eliminating a total of 4 hours in manual Excel filtering, copying, and pasting
- Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.
Master Data Management Analyst
Stater Bros. Markets
04.2021 - 01.2023
- Performed system analysis, documentation, testing, implementation, and user support for platform transitions.
- Verified the accuracy of data for analysis and entry for over 50,000 products, 4,000 vendors and 170 Stater Bros locations
- Created and implemented new business tools via Excel and SQL for data manipulation for core attributes resulting in an overall decrease in error and decrease in process time by 65%
- Collaborated with Ecommerce Team to create new product attributes so showcase Digital Deals promotions via website resulting in an increase of sales by 10% and increase in click-through rate by 18%
- Weekly reporting and analysis of digital coupons and promotions including conversion rates and overall impressions utilized by upper-level management
Digital Marketing/Data Analyst Intern
Dylan Sky
01.2020 - 05.2021
- Strategically planned and executed marketing campaigns throughout the holiday season that led to a 30% increase in brand awareness, and a 15% increase in quarterly revenue.
- Utilization of PPC and SEM tracking, analyzing, and reporting that helped drive conversion on Omni channels.
- The main operator of the Etsy account, analyzing and reporting on given data from keywords, impressions, sales, etc. Leading to a 30% increase in Click-through-rate.
- Analyzed and interpreted master data from multiple sources, Amazon, Etsy, and social media such as Instagram.
- Used customer search analytics on Etsy to optimize product listings and improve overall account appearance.
Education
Bachelor of Science - Business Administration
University of California, Riverside
Riverside, CA06.2021
Associate of Science - Business Administration For Transfer
Riverside City College
Riverside, CA06.2019
Associate of Arts - Administration And Information Systems
Riverside City College
Riverside, CA06.2019
Associate of Arts - Social And Behavioral Studies
Riverside City College
Riverside, CA06.2019
Skills
Data formatting
Certification
IBM Data Science Professional
Timeline
IBM Data Science Professional
02-2024
Machine Learning with Python
02-2024
Data Analysis with Python
01-2024
Databases and SQL for Data Science with Python
01-2024
Python for Data Science, AI & Development
01-2024
Data Scientist
Stater Bros Markets
12.2023 - Current
Data Analyst
Stater Bros. Markets
01.2023 - 12.2023
Python Regular Expressions Complete Masterclass
12-2022
The Data Analyst Course: Complete Data Analyst Bootcamp 2022
10-2022
2022 Complete Python Bootcamp from Zero to Hero in Python
06-2022
Master Data Management Analyst
Stater Bros. Markets
04.2021 - 01.2023
Digital Marketing/Data Analyst Intern
Dylan Sky
01.2020 - 05.2021
Bachelor of Science - Business Administration
University of California, Riverside
Associate of Science - Business Administration For Transfer
Riverside City College
Associate of Arts - Administration And Information Systems
Riverside City College
Associate of Arts - Social And Behavioral Studies
Riverside City College