Title: Data Entry Analyst (Fabric Planning)
Company Name: Multifabs Limited
Vacancy: 1
Age: 23 to 27 years
Job Location: Gazipur
Salary: Negotiable
Experience:
Key Responsibilities
Enter and update fabric planning data, including fabric requirements, consumption, stock, purchase orders, and delivery information in the ERP system.
Maintain accurate records of fabric requirements against buyer orders, style numbers, colors, sizes, and order quantities.
Prepare and update fabric requirement sheets, booking reports, stock reports, and daily planning reports using Advanced Excel.
Analyze fabric consumption, wastage, available stock, and shortage quantities to support effective planning.
Cross-check ERP data against Excel reports, fabric inventory records, and purchase or booking information to identify discrepancies.
Monitor fabric booking status, supplier delivery schedules, and fabric availability according to production requirements.
Use advanced Excel functions such as XLOOKUP, VLOOKUP, INDEX-MATCH, SUMIFS, COUNTIFS, IF, and PivotTables for data analysis and reporting.
Develop automated Excel reports and dashboards to improve reporting accuracy and reduce manual work.
Prepare daily, weekly, and monthly reports on fabric requirements, stock status, pending bookings, and delivery updates.
Coordinate with Fabric Planning, Merchandising, Store, Procurement, and Production departments to ensure data accuracy and timely information sharing.
Identify data inconsistencies, missing information, and planning discrepancies and report them to the relevant team.
Maintain proper documentation and ensure data confidentiality and compliance with company procedures.