sourcing the best hyper local Design with negotiated prices,

Define the Optimum Level of the branch by visiting branches, Hyperlocal designs, current market trends ETC.Find the gap of the stock level and then place the order by considering Best-Seller & New designs of the respective zone.My team monitor Fast moving category and reports to me for the Gap,Ageing Stock monitoring and making decisions for suffering the products. Periodically Branch visit to identify local tastes, find out the customer-based and other brand visits.Procurement planning Budget and track actual Metal Planning New Karigar and Vendor visit, visit various Jewellery exhibitions, identify the best vendor and karigar negotiate wastage, Design Selection.Apart from that I am also in charge of the MIS of Production team

Experience in Inventory Accounting,Experience in day to day Inventory maintain(use Advance Excel, macro(VBA)),Experience in Smith ledgers maintain (auto report generating with the help of Excel VBA),Experience in Reconciliation physical stock in every week,Accounts Reconciliation, BRS, Auditing.Experience in MIS management,Experience in order reconciliation,Working in ERP system for product query, product tracking, order tracking, pending status generate, Inwarding etc.Create various projects in Excel with the help of Advance Excel, macro, User Form & VBA.Data connection from SQL server 2005, Access 2013 etc. to Excel pivot Table Basic trouble shooting in SQL database

Maintain high value stock (raw gold, semi-finished, Finish stock, repair & sample stock) in Kolkata. Receive and acknowledge Gold Bullion, Repair form HO, Distribute bullion to the gold smith as per WIP & Order basis, checking Manufacturing Received form gold smith with loss labour & other charges, verify stone, Rodolite & kundan wt, Physical stock checking, Karigar balance confirmation• Experience in Inventory Accounting,• Distribute gold bullion with cupper calculation to gold jewellery manufacturers as per WIP & Order basis,• Knowledge of 22 KT, 24kt gold calculation. • Verify Manufacturing Received (process loss calculation, making charges & other charges as per quatation)• Verify stone, Rodolite etc.• Taking care of kundun stone fitting on semi finished product, like collet collecting, counting, issue to kundan kaigars, verify 24 KT gold weight, making jama after kiundan fitting, gala weight calculation etc. • Taking decision about repairing stock distribution,• Report to senior manager weekly despatch, Karigar WIP Stock, repair stock and physical stock movement.• Karigar payment handle,• Look after Dispatch of finish stock to HO,• Tally physical stock everyday basis.

• MIS management• Accounts Reconciliation• Cash Management• Funds Transfer / Fund Investigation• Maintenance of Daily labour book, Departmental Labour Book, checking of Sub contractor and supplier’s bill. • Preparing Liability Statement, • Preparing VAT Statement• Bank Reconciliation Statement. • Monthly Budget.• Knowledge of Service Tax , TDS etc.• Data management and updating (In ERP software)