Marcus Garcia Email & Phone Number

San Bernardino, California, United States

San Bernardino, California, United States

• 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 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.
• 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.
• Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.

San Bernardino, California, United States

• 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

United States

• Requires stocking of inventory such as water, soda, liquor, and paper products.
• Decreased shrink by an overall 2%.
• Tend to customer needs and renting out RugDoctor equipment resulting in a 3% increase in RugDoctor sales.
• Assist management with the organization and placement of products.

United States

Irvine, California, United States

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

Business Administration And Marketing

Activities and Societies: Sigma Phi Epsilon

Associate Of Science - As, Business Administration For Transfer

Associate Of Arts - Aa, Social And Behavioral Studies

Associate Of Arts - Aa, Administration And Information Systems