Store Executive

Job Title:

Department:

Reporting To:

Job Summary:

The Stores Executive will be responsible for efficient handling of all material movements, including issuing materials to the production department, transferring materials between warehouses, and maintaining accurate records in SAP. The role also requires advanced Excel skills to prepare and analyze inventory reports using VLOOKUP and Pivot Tables.

Key Responsibilities:

Material Issue:

Issue materials from Warehouse 2 (or other designated warehouses) to the Production Department as per production plans and material requisitions.

Ensure proper documentation and timely posting of material issue entries in SAP.

Material Transfer:

Coordinate and execute material transfer from one warehouse to another.

Prepare stock transfer documentation and update records in SAP.

Monitor stock levels across warehouses to ensure accuracy.

SAP Process:

Perform all material transactions in SAP (Issue, Transfer, Goods Receipt, and Stock Adjustments).

Ensure timely and error-free entries and generate relevant stock and issue reports.

Excel Reporting:

Prepare and maintain daily, weekly, and monthly inventory reports.

Use VLOOKUP to match and verify stock data across multiple sheets.

Create and analyze Pivot Tables for consumption, stock movement, and variance reports.

Reconcile stock differences and assist in physical stock audits.

Coordination:

Coordinate with Production, Purchase, and Accounts departments for smooth material flow.

Follow up with vendors, transporters, and internal teams for timely material availability.

Compliance & Housekeeping:

Ensure proper stacking, labeling, and storage of materials.

Maintain 5S and safety standards in the warehouse area.

Key Skills & Requirements:

Graduate in any stream (preferably B.Com, BBA, or B.Sc.).

24 years of relevant experience in stores or warehouse management.

Working knowledge of SAP MM Module (Material Management).

Strong command over MS Excel (VLOOKUP, Pivot Table, Data Validation).

Good communication and coordination skills.

Attention to detail and accuracy in documentation.

Additional Requirements:

Ability to work in a fast-paced production environment.

Willingness to perform physical stock checks and handle manual documentation when required.

Should be flexible with work timings as per production schedules.