Summary
Overview
Work History
Education
Skills
Websites
Courses
Timeline
Generic
Grant Bartolo

Grant Bartolo

Cypress

Summary

Analyst with 7+ years of experience leveraging Power BI, Excel, and SAP to build or manage dashboard reports that led to improved operational efficiency for multiple Fortune 500 companies. Eager to contribute to a dynamic and growing organization and further its strategic goals through actionable insights and data driven solutions.

Overview

7
7
years of professional experience

Work History

Inventory Control Analyst

DENSO
10.2024 - 04.2025
  • Managed the inventory allocation for parts in the automotive aftermarket.
  • Oversaw the transfer of parts between warehouses, ensuring that each had a sufficient amount of safety stock inventory.
  • Produced inventory forecasts and identified demand trends for vendors that allowed them to plan for inventory space allocation and create future purchase plans.
  • Generated purchase order sheets using demand forecasts that allowed the procurement team to have enough parts inventory to fill any outstanding customer orders.
  • Ensured that any backorder in parts was alleviated or accounted for, leading to a higher fill rate for the procurement team.

Data Analyst

EKN Engineering
08.2018 - 08.2024
  • Spearheaded Power BI reporting and dashboard creation for the permits and compliance team.
  • Built a dashboard that tracked the screening and submission process for development permits, helping to identify process bottlenecks, leading to increased operational efficiency and faster permit submission cycle time.
  • Developed a dashboard that allowed construction crews to bundle work orders and clear existing orders out of production backlog, leading to tangible cost savings and increased resource allocation efficiency.
  • Generated a report using permit filing data that assisted the organization with client acquisition, driving new business growth.
  • Created ad-hoc reports that were used to generate key performance indicators.

Education

Bachelor of Arts - Economics

University of California, Irvine

Skills

  • Power BI
  • Microsoft Excel
  • SAP
  • Oracle Warehouse
  • Reporting
  • Forecasting
  • Data Analysis
  • Data Visualization
  • Data Story Telling
  • Inventory Analysis
  • Inventory Management
  • Project Management
  • Stakeholder Management
  • Customer Relationship Management
  • Communication

Courses

Data Science Certificate

  • UC Irvine, School of Continuing Education


Microsoft Excel Pivot Tables Certificate

  • Irvine Valley College

Timeline

Inventory Control Analyst

DENSO
10.2024 - 04.2025

Data Analyst

EKN Engineering
08.2018 - 08.2024

Bachelor of Arts - Economics

University of California, Irvine
Grant Bartolo