Business Data Analyst (Retail & Inventory Focus)
Kali LLC- Mobil Gas Station
Apr 2024 - Jan 2025 (10 months)
Developed and maintained automated daily and weekly sales reports using Excel, improving reporting efficiency and visibility into fuel and in-store KPIs (sales trends, peak hours, and customer purchasing patterns). Built and managed data pipelines by collecting, cleaning, and integrating structured sales and inventory data from POS systems, applying data wrangling best practices using Python (Pandas, NumPy). Designed and implemented inventory tracking dashboards in Power BI, reducing product stockouts and overstock by 25%, and enabling timely reorder decisions. Conducted data quality checks and streamlined data entry workflows, minimizing manual input errors by 40% through process automation and Excel macros. Supported price optimization an