Data Analyst – Petroleum Operations
Hi Zenith · Jan 2025 – Present
- Built Power BI dashboards tracking daily fuel sales across retail outlets, depot inventory, and tanker dispatch performance.
- Developed DAX measures and Power Query transformations to calculate outlet-level KPIs (sales volume, margin per litre, target achievement %) for reporting.
- Wrote optimized SQL queries joining retail sales, depot stock, and logistics data across operational systems, cutting monthly report prep time by ~40%.
- Automated daily and weekly sales, inventory, and dispatch reports via Power BI refreshes and Python / Excel macros, saving ~12-15 hours per week.
- Built short-term demand forecasts in Python and Excel for outlet-level fuel sales to support depot replenishment and reduce stock-outs.
- Conducted sales variance and freight cost analysis on outlet performance and tanker dispatch data, flagging under-performing routes and cost-saving opportunities.

