Aman Benare

Built Power BI dashboards for SKU movement, stock aging, and price variance; added DAX alerts to optimize restocking and reduce shortages. Queried 1K–10K SKUs in SQL to analyze sales, returns, and inventory; flagged anomalies to prevent stockouts. Automated data cleaning with Python (pandas) to fix missing values and reformat weekly exports, cutting report prep time significantly. Reconciled warehouse counts against system records, resolving discrepancies within 1–2 days. Streamlined recurring Excel reports with Power Query and formulas, reducing manual work by 60% and improving monthly reporting accuracy. Documented ETL processes and dashboards to support audits and enable business users to refresh reports independently.

Queried SQL databases to track daily course enrollments, payments, and refunds, identifying discrepancies that prevented revenue leakage. Built Power BI dashboards for HR and Finance to pinpoint payroll errors and department performance gaps, reducing exception resolution time. Automated monthly course sales and user data consolidation using Power Query and Excel macros, cutting manual reporting effort by 4+ hours per month. Performed data validation and QA checks prior to dashboard releases and coordinated fixes with IT/QA. Analyzed learner engagement and course completion trends using Python to inform course offerings and retention strategies. Documented ETL processes and dashboards on SharePoint to enable self-service reporting and reduce IT support tickets.