# Zander Hamilton

Zander Hamilton is a remote worker on Himalayas, Senior Data Analyst at Southern Glazer's Wine & Spirits, based in United States.

Source: https://himalayas.app/@zanderhamilton

```text
Senior Data Analyst at SOUTHERN GLAZER’S WINE & SPIRITS who automated 50+ manual Excel reports with Python across AWS and Databricks.
```

| Detail | Value |
| --- | --- |
| Availability | Looking for a job |
| Location | United States |
| Authorized to work in | United States |
| Salary expectations | 100k+ USD |
| Job categories | Data Analyst, Supply Chain Engineer, Inventory Manager, Logistics Specialist |
| Skills | Data Analysis, SQL, Python, Data Pipelines, data transformation, Report Automation, Business Intelligence, Supply Chain Analytics, Route Optimization, Vendor Scorecard, Data Quality, Process Design, Standard Operating Procedures, AWS, Databricks |

## About

```text
At SOUTHERN GLAZER’S WINE & SPIRITS (SGWS), I automated over 50 ad-hoc manual Excel reports with custom Python scripts in AWS and Databricks. I also engineered SQL transformations across production data from legacy systems.

I designed interactive Power BI dashboards to support supply chain initiatives and maintain data accuracy for leadership. I tracked cross-functional projects in Jira and used AI tools for script testing, debugging, and technical documentation.

At ATLAS COPCO RENTAL, I built data pipelines and mapping transformations with Python and SQL to bring purchasing data into Power BI dashboards. I also developed vendor KPI scorecards and authored SOPs to standardize practices across facility locations.

At BOOSTED COMMERCE, I managed inventory and replenishment workflows across Netsuite ERP and 3PL warehouse systems, using SQL, Excel, and Power BI for operational analysis. Earlier, at XPO LOGISTICS, I headed a weekend dispatch team and applied route optimization while maintaining a 95% on-time fulfillment rate across six consecutive quarters.
```

## Experience

### Senior Data Analyst (current)

Southern Glazer's Wine & Spirits. Jan 2024 - Present

```text
Automated over 50 ad-hoc manual Excel reports by building and deploying custom Python scripts within AWS and Databricks environments. Engineered efficient SQL queries in Redshift and Databricks to extract, transform, and consolidate production data across legacy systems.
```

Skills: Python, AWS, Databricks, SQL, Redshift, Power-BI, Jira, AI-Tools, AS-400, SAP-S-4HANA, TMS

### Supply Chain Engineer

[Atlas Copco Rental](https://himalayas.app/companies/atlas-copco-rental-llc). Mar 2023 - Jan 2024

```text
Built end-to-end data pipelines and mapping transformations using Python and SQL to ingest purchasing data into Power BI user dashboards. Developed and monitored vendor KPI scorecards to track performance metrics and enforce data quality.
```

Skills: Python, SQL, Power-BI, Data-Pipelines, KPI-Scorecards, SOPs, Vendor-Management, Project-Management

### Inventory Manager

Boosted Commerce. Jan 2022 - Feb 2023

```text
Managed replenishment workflows and inventory health across Netsuite ERP and 3PL Warehouse Management Systems (WMS) across sales channels. Conducted ad-hoc operational analytics using SQL, Excel, and Power BI to support strategic decision-making.
```

Skills: NetSuite, 3PL-WMS, SQL, Excel, Power-BI, Inventory-Management, Replenishment, Operations

### Logistics Specialist

[XPO Logistics](https://himalayas.app/companies/xpo). Jul 2019 - Dec 2021

```text
Headed a team of weekend dispatchers and drivers, managing live transaction queues to ensure full delivery fulfillment across Southern California. Applied route optimization to decrease wasted operational costs, maintaining a 95% on-time fulfillment rate across 6 consecutive quarters.
```

Skills: Route-Optimization, Team-Leadership, SLA-Management, Cost-Optimization, Dispatch, Logistics

## Education

### University of Texas at Austin

Bachelor of Science, Economics

```text
Bachelor of Science in Economics from the University of Texas at Austin.
```

## Tech stack

- Amazon Redshift
- Databricks
- Jira
- Python
- Microsoft Excel
- NetSuite
- SQL
- Power BI
- AWS

To contact Zander, message them from this profile with a Himalayas employer account: [Hire on Himalayas](https://himalayas.app/hire).

## People also viewed

- [Abdullah Sher](https://himalayas.app/@abdullahsher): Business Intelligence Analyst, DCC Propane
- [DIVYA SOWJANYA GUDAPATI](https://himalayas.app/@divyasowjanyagudapat): Supply Chain Analyst, Kroger
- [Efrain Plaza](https://himalayas.app/@efrainplaza): Sr. Data Analyst, Cisco Systems TEKsystems
- [Aaron Mirza](https://himalayas.app/@aaronmirza): Senior Supply Chain Analyst, Fresenius Medical Care
- [Bhanu Putta](https://himalayas.app/@bhanuputta): Data Analyst, Paycom
- [Anyi Xu](https://himalayas.app/@anyixu): Senior Supply Planner, Atkore
- [Ganesh Panja](https://himalayas.app/@ganeshpanja1): BI Developer, DHL
- [Shrusti HC](https://himalayas.app/@shrustihc): Assistant Manager Supply Chain, Deloitte Touche Tohmatsu Limited
- [Swathi Mandapati](https://himalayas.app/@swathimandapati): Supply Chain Analyst / Systems Analyst, Caterpillar
- [Cassie Cole](https://himalayas.app/@cassiecole): Logistics/Supply Chain Data Scientist, Kroger
