Key Responsibilities:
Data Management & Reporting:
Maintain and update inventory data using advanced Excel (H-Lookup, V-Lookup, Pivot Tables, Conditional Formatting).
Prepare and distribute MIS reports on inventory levels and stock movements.
Generate periodic reports for management (weekly, monthly, quarterly).
Monitor stock discrepancies, trends, and opportunities for optimization.
Data Analysis:
Analyze data to identify patterns and trends for decision-making.
Provide insights on inventory control, stock rotation, and demand forecasting.
Support ad hoc data requests and custom report generation.
System & Tool Expertise:
Use MIS tools and inventory management systems for automated reporting.
Stay updated on reporting tools and suggest system improvements.