Welcome, I’m Mark McKenzie

Operational Manager transitioning to Data Analyst

I am a data driven professional leveraging my background in operations and logistics management to drive business decisions through analytics. I specialize in turning raw data into prosecutable insights to optimize processes, identify trends, and solve complex problems.

---

Tech Stacks

• Languages: [Python, SQL, DAX]
• Visualization Tools: [Power BI]
• Data Tools: [Power Query, Pandas, Numpy, Jupyter Notebooks, PostgreSQL, DBEAVER]

---

Featured Data Projects

Below are a few projects demonstrating my analytical skills:

1. APEX Fleet Health & Routing Operations

Designed an end-to-end data pipeline to resolve operational bottlenecks by cleaning 10,000+ records of messy logistics data. Establishing an SQL view to flag real world irregularities ( missing maintenance logs, impossible MPG) and modeled the data in Power BI to track fleet health KPIs.

• Tech Used: Python, Pandas, PostgreSQL, SQL, DBeaver, Power BI, DAX
• Links: View Repository & Dashboard Demo

2. APEX Logistics Network: End-to-End Pipeline & Analytics

Engineered a complete ELT data pipeline to analyze historical shipping data, identify delivery bottlenecks, and diagnose a spike in damaged packages. Transformed messy raw data into a clean SQL VIEW to provide an executive reporting dashboard for operations managers.

• Tech Used: Python, Pandas, PostgreSQL, SQL, DBeaver, Power BI, DAX
• Links: View Repository & Dashboard

---

Lets Connect!

• LinkedIn: Mark McKenzie
• Email: mckenziemark04@gmail.com