JOHN DE LOS SANTOS
Corona
Summary
Results-driven professional with 15+ years in logistics and supply chain management. Expertise in building efficient data pipelines using SQL and Python to deliver actionable analytics and operational insights. Designs data-driven solutions that enhance performance and accuracy, supporting informed decision-making.
Overview
11
11
years of professional experience
Work History
Class A HAZMAT Driver
Ruan Transportation
Ontario
06.2025 - 01.2026
- Maintained strict compliance with DOT regulations and safety protocols
- Coordinated multi-stop delivery workflows (5–6 stops daily across 200–500 miles) to ensure timely deliveries
- Managed delivery routes with scheduling systems and logistics data to optimize route efficiency
- Ensured accurate shipment tracking and operational reporting to maintain service reliability
Class A HAZMAT Medical Delivery Driver
Baxter Regional Medical Centre
Ontario
02.2023 - 06.2025
- Executed time-sensitive medical logistics with high accuracy and reliability
- Managed 10–15 delivery points daily, ensuring compliance with regulations and safety standards
- Handled regulated freight, maintaining accurate documentation and tracking for accountability
Driver / Logistics Operations
Amazon DSP
Riverside
04.2015 - 01.2023
- Coordinated delivery operations through Amazon Relay systems to ensure timely and efficient transport
- Assisted in dispatch planning and load optimization to maximize operational efficiency
- Maintained accurate logs and compliance tracking to support regulatory adherence
Education
Bachelor of Science - Supply Chain Management & Operations
Western Governors University (WGU)
12-2026
Skills
- Excel
- ERP Systems
- Python
- SQL
- PostgreSQL
- Data Cleaning
- Data Warehousing
- Data Transformation
- Data Modeling
- Data Pipelines
- Streaming Data
- Kafka
Target Roles
- Data Engineering Intern
- Data Analyst Intern
- Supply Chain / Operations Analyst
Projects
- Real-Time Data Pipeline (Kafka → Python → PostgreSQL), Built a local data pipeline simulating real-world data ingestion workflows, Produced and consumed streaming data using Kafka topics, Processed structured JSON data using Python, Inserted transformed data into PostgreSQL databases, Wrote SQL queries to validate, filter, and analyze ingested data, Demonstrated end-to-end pipeline: ingestion → transformation → storage
- SQL Data Analysis & Transformation, Designed queries using INNER JOIN, LEFT JOIN, and aggregations, Transformed raw data into structured outputs for reporting, Practiced data validation and consistency checks, Simulated business reporting scenarios using relational datasets
Additional Development
- Actively learning: Python for data engineering
- SQL for analytics and transformation
- Data pipeline architecture
- Six Sigma principles
Technical Skills
Python (data processing, scripting), SQL (PostgreSQL, joins, data validation), Data Pipelines (ETL / ELT), Data Modeling (normalized structures, relational design), Data Transformation & Cleaning, Streaming Data (Kafka – producer/consumer workflows), PostgreSQL, Kafka (local setup with Docker), Excel, ERP Systems (NetSuite, Oracle)
Timeline
Class A HAZMAT Driver
Ruan Transportation
06.2025 - 01.2026
Class A HAZMAT Medical Delivery Driver
Baxter Regional Medical Centre
02.2023 - 06.2025
Driver / Logistics Operations
Amazon DSP
04.2015 - 01.2023
Bachelor of Science - Supply Chain Management & Operations
Western Governors University (WGU)