SAHIL ALI - PORTFOLIO

Inventory Specialist & Cash Flow

Ekam Indian Groceries, Adelaide, Australia Dec 2023 – June 2025

Managed daily purchase entries, invoice verification, attendance tracking, and supplier coordination across dual store locations. Automated reporting processes and supported cash flow documentation during manager absence.

• Handled purchase data and fruit and vegetable invoices using ERP software and advanced Excel functions.
• Cross-checked supplier invoices and reconciled statements to prevent overbilling, ensuring financial accuracy.
• Maintained staff attendance and created daily cash reports. View Attendance Tracker Project
• Collaborated with the team to support inventory accuracy and operational flow, reducing stock issues significantly.

Highlights:

• Reduced billing errors and improved invoice match accuracy by 95%.
• Saved over 4 hours per week through structured Excel logs and automation. View Cash Flow Dashboard

GRN Officer

Bansal Supermarket, Surat, India Dec 2022 – Nov 2023

Responsible for goods receipt entries, invoice cross-checking, offer updates, and FIFO-based inventory flow. Maintained operational registers including Top 100/200 item reports.

• Managed GRNs, MRP/offer changes, and 10-item register maintenance with precision.
• Conducted regular floor walks and enforced FIFO practices across departments to reduce waste.
• Handled PI management, rate updates, and price accuracy for fast-moving items. View Sales Analysis Project

Highlights:

• Reduced stock discrepancies by 30% through enhanced GRN practices.
• Improved offer accuracy and register organization across 500+ SKUs.

Warehouse Supervisor

Arzt Health & Private Limited – Jaipur, India June 2022 – Nov 2022

Oversaw stock control, warehouse documentation, and physical inventory across training material storage. Ensured FIFO handling, audits, and timely replenishment.

• Led day-to-day warehouse operations and staff coordination with a strong focus on efficiency.
• Maintained accurate bin cards, stock logs, and conducted warehouse audits. View Automation System Project
• Implemented FIFO principles and organized material flow for training batches.

Highlights:

• Achieved 100% stock availability across training cycles.
• Streamlined warehouse layout and improved stock handling speed.

Data Analyst & Automation Specialist – Personal Portfolio & Projects

Self-Driven Projects & Automation 2024 – Present

Designed and developed a professional portfolio website to showcase data analytics, automation, and inventory management expertise. Utilized cutting-edge AI and creative tools to enhance productivity, insights, and workflow automation.

• Leveraged ChatGPT for code generation, SQL query optimization, and automating routine analysis tasks.
• Incorporated Perplexity AI for real-time data insights, quick research, and refining data narratives for reports and presentations.
• Used advanced Google Sheets formulas and Apps Script to automate dashboards, KPI tracking, and vendor reporting.
• Implemented dynamic data visualizations and streamlined reporting for personal and client projects.

Highlights:

• Created a fully automated portfolio site and project dashboards.
• Enhanced productivity through AI-driven research and process automation.

Skills

Languages

Education