John Marelich

John Marelich Email and Phone Number

Data Engineer and Supply Chain Systems Manager @ Marie Veronique
Menlo Park, CA, US
John Marelich's Location
Menlo Park, California, United States, United States
John Marelich's Contact Details

John Marelich personal email

n/a
About John Marelich

By day, I'm a fusion of Data Engineer & Supply Chain Systems Manager, unraveling the intricate dance of data and business. My supply chain background grounds me in the business world, while my enthusiasm for Data Engineering propels me into the digital complexities of data and software. Like a philosopher delving deep into the cosmos for understanding, I'm driven by a quest to demystify complexity, building intricate systems that are intuitive and user-friendly. It is my goal to ensure that the projects I undertake resonate profoundly with real human needs.Beyond the structured world of data, I'm often drawn to the mysteries of the cosmos. My avid interest in astronomy and cosmology is a clear extension of my intrinsic curiosity, and it probably explains my career choice. Just as I strive to comprehend and demystify the complexities of the universe, in the realm of Data Engineering, I'm fervently passionate about making intricate concepts accessible and palatable for my fellow Earthlings and Data Consumers.Outside the bits and bytes of my career, you'll probably catch me playing shortstop on my baseball team (for 13 years!) in our local league, the SVABL. When I'm not doing that, I'm probably playing bass, guitar, and/or vocals in one of my two bands, or doing some kind of strenuous exercise. Lastly, but most importantly, I live for my three daughters, who leave me both inspired and fulfilled every day.

John Marelich's Current Company Details
Marie Veronique

Marie Veronique

View
Data Engineer and Supply Chain Systems Manager
Menlo Park, CA, US
Employees:
19
John Marelich Work Experience Details
  • Marie Veronique
    Data Engineer And Supply Chain Systems Manager
    Marie Veronique
    Menlo Park, Ca, Us
  • Marie Veronique
    Data Engineer & Supply Chain Systems Manager
    Marie Veronique Mar 2023 - Present
    Berkeley, California, United States
    • Created and established the company’s first Data Engineer role by gaining the trust and autonomy from Executive Leadership, defining this key technical position, and building a foundation for the company’s data-driven future.• Built a scalable data infrastructure by integrating AWS EC2, Docker, Apache Airflow, PostgreSQL, dbt-core, GitHub, Asana, and a custom Python framework, facilitating API-based data extraction, business logic transformations, and automated CI/CD workflows, in support of company analytics.• Developed a custom Python data extraction framework that abstracts the technical setup of data onboarding, such as database connections, and table and constraint creation, which significantly reduced data onboarding time from weeks to minutes.• Used dbt project to transform data from multiple sources into a star schema, with materialized views as data marts tailored to various internal departments, enabling consistent analytics in support of dashboards and reporting.• Automated data pipelines by orchestrating ETL workflows with Apache Airflow and containerizing applications using Docker, ensuring consistency across environments, improving resource efficiency, and reducing manual intervention.• Implemented automated CI/CD pipeline using GitHub Actions, and a custom-built GitHub-Asana integration to sync version control and project management, which streamlined deployment, enhanced workflow transparency, and minimized manual errors.• Replaced a legacy Zapier and Google Form integration by building a custom HTML/CSS/JavaScript form within Shopify that submitted form data directly to HubSpot Forms API, saving the company $6,000 annually and streamlining the wholesale partner application process.• Built customized Looker Studio dashboards in direct collaboration with teams like E-Commerce, Sales, Operations, Finance, and Executive Leadership to tailor data insights, facilitating data-driven decision making across the company.
  • Marie Veronique
    Procurement Analyst
    Marie Veronique Feb 2021 - Feb 2023
    Berkeley, California, United States
    • Built the procurement operations function from the ground up, introducing structured processes and standard operating procedures and work instructions across the organization.• Streamlined day-to-day purchasing across various departments like manufacturing, R&D, and facilities into a centralized system, replacing departmental silos.• Pioneered a product sourcing system, linking departments like Procurement, Regulatory, Quality, R&D, and Brand.• Developed RFQ process and integrated it with documentation review, and sample testing procedures.• Transitioned from retail to wholesale suppliers, achieving better pricing and optimizing payment and delivery terms.• Project Manager for an ERP data cleanup initiative, introducing a company-wide Data Dictionary, Data Management processes, and simulating part 11 compliance with Regulatory.• Developed a Google Apps Script-based automated data pipeline to extract and centralized key ERP data tables, replacing manual exports, and supporting day-to-day operations through a suite of integrated Google Sheets tools, improving efficiency and integration across Procurement, Quality, Finance, and Production teams.• Engineered and implemented the core system used company-wide for operational planning– from forecasting to procurement to production scheduling– by designing the business logic and tools that transform monthly sales forecasts into actionable, automated day-to-day plans for the Operations teams.• Overcame challenges such as a lack of established procurement systems and reduced top management's operational load.
  • Eat Club
    Buyer
    Eat Club May 2018 - Jul 2020
    San Leandro, California, United States
    • Purchased goods and materials for the company’s main production operations facility• Responsible for about $8 million per year in total purchases for both perishable and non-perishable goods• Drove product sourcing projects, including a strategic transition to a new produce supplier that decreased costs and delivery wait times, widened order windows, and increased food quality and food safety• Collaborated as a diplomat on internal projects with other managers/departments (Production; R&D; QA; Warehouse) to facilitate process improvements• Implemented a tool that streamlined communication of data/information internally• Presented data, concepts, and execution plans to meeting groups; Led daily/weekly meetings• Maintained diplomatic relationships with suppliers and external associates
  • Whole Foods Market
    Prepared Foods Associate Team Leader
    Whole Foods Market Nov 2015 - May 2018
    San Francisco- Haight Street
    • Menu development & merchandising strategies• Reorganized kitchen operations; updated recipe database; implemented menu schematics• Hiring, training, scheduling, employee development, employee termination• Developed buyers to run kitchen menu planning and execution in my absence• Accountable for financials, including cost of labor and cost of goods • Trained Team for new store opening - Whole Foods Market Santa Clara, July 2016
  • Whole Foods Market
    Prepared Foods Leadership
    Whole Foods Market Aug 2013 - Oct 2015
    Redwood City, California, United States
    • Menu development & merchandising strategies• Reorganized kitchen operations; updated recipe database; implemented menu schematics• Consistently placed 2nd or 3rd in NorCal region for One Day Sales• Accountable for financials, including cost of labor and cost of goods • Hiring, training, scheduling, employee development, employee termination• Trained Team Members at New Store Openings - Whole Foods Market Castro, October 2013;• Developed and executed menus for local community events - Redwood City Salsa Festival, September 2013; Redwood City Oktoberfest, September 2013
  • Whole Foods Market
    Prepared Foods Buyer/Specialist
    Whole Foods Market Feb 2013 - Aug 2013
    Redwood City, California, United States
    • Earned ownership of weekly and monthly menu blend, increasing profit margin by 5% • Meet sales and profit margin goals set by Regional Finance team - I exceeded profit margin goals for every fiscal period• Wrote and expedited all purchase orders for operations with ERPs (DVO, IRMA)• Analyzed inventory usage for merchandising trends to determine stock levels• Recipe development and execution• Developed and Executed menu and operations for special catering events - Tour de Peninsula, Burlingame, CA, August 2013
  • Whole Foods Market
    Prepared Foods Sous Chef
    Whole Foods Market May 2012 - Feb 2013
    Redwood City, California, United States
  • Whole Foods Market
    Prepared Foods Cook
    Whole Foods Market Aug 2011 - May 2012
    Redwood City, California, United States
  • Amf Bowling
    Team Member
    Amf Bowling Jan 2007 - May 2011
    Redwood City
    • Bowling Customer Service• Food & Beverage Service• C – Certified Pinspotter Mechanic• Bartender • Buyer for all perishable products
  • Gilbert Tuners
    Guitar Tuner Production
    Gilbert Tuners Apr 2002 - Aug 2002
    Redwood City
    Built guitar tuning pegs for family business in shop environment

John Marelich Skills

Cooking Culinary Skills Food And Beverage Inventory Management Microsoft Excel Customer Service Catering Retail Time Management Food Safety Inventory Control Attention To Detail Communication Restaurant Management Team Leadership Menu Development Purchasing Food Industry Leadership Event Planning

John Marelich Education Details

Frequently Asked Questions about John Marelich

What company does John Marelich work for?

John Marelich works for Marie Veronique

What is John Marelich's role at the current company?

John Marelich's current role is Data Engineer and Supply Chain Systems Manager.

What is John Marelich's email address?

John Marelich's email address is jo****@****ket.com

What schools did John Marelich attend?

John Marelich attended Bellevue University, Cañada College.

What are some of John Marelich's interests?

John Marelich has interest in Exercise, Cooking, Punk Rock, Baseball, Socializing, Being A Professional Chef, Metal, Meeting Women, Guitar And Bass, Astronomy And Cosmology.

What skills is John Marelich known for?

John Marelich has skills like Cooking, Culinary Skills, Food And Beverage, Inventory Management, Microsoft Excel, Customer Service, Catering, Retail, Time Management, Food Safety, Inventory Control, Attention To Detail.

Who are John Marelich's colleagues?

John Marelich's colleagues are Gianna Ancich, Eleanor Bagley, Monica Kim, Sophia V., Heather Hiett, Isabella Ayala Decredico, Daniela Palacios.

Not the John Marelich you were looking for?

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.