PURUSHOTTAM KUMAR
Mob: 092******** / E-mail : ***********.***@*****.***
Middle level assignments in Distribution Management /Supply chain/Mis Executive/ IT with
an organization of repute
Professional Experience:
3 2003-04 : As a Computer Operator in ‘Digital Photo’.
4 2004-05 : As a Sr. Computer Operator in Online/Offline Voter ID Card Job at Saran District of
Bihar for six months.
5 Feb’05-Apr’09 : Worked in ‘Tata Ryerson Ltd.’ designated as ‘Associate-Supply Chain’.
Notable Job Profile:
Inventory management, ensure minimum level of outstanding and ensure after sales service to
the Tata Motor’s Ancillary.
To co-ordinate with logistics, production for better service to the ancillary
Physical Inventory reconciliation with system monthly basis.
Planning & executing Materials delivery to the ancillaries along with transportation
monitoring.
Preparation of processing schedule as per vendors requirement on daily basis
Reporting to Manager-Sales.
5 June’11-May’13: Worked in Pushkar Techno Pvt. Ltd (an auto ancilliary co.).
Job Profile:
Inventory Maintain of Sheet Metal & Bell kit forging Lever Item.
Every month to do the reconciliation of Iron Steel, Bell Kit Item.
Reconciliation of fast moving item of store on monthly basis.
Preparation of Analysis Report for Sales & Purchase.
Preparation of Raw Material Costing.
Bill adjust as per Hundis Details.
Entry of Debit Note, Credit Note.
Preparation of Supplementary bill & Debit Note for Tata Motors Limited.
Interest Calculation on Excise Amount of Supplementary Bill based on no. of days.
Preparation of Pending rejection material list as per SRM Data (Primary & Line Rejection).
Preparation of Price Impact Report, check with INCIDENCE as sheet metal price increase or
decrease.
Preparation of Vat Report
Preparation of various report as and when required by the Directors.
5 June’13-Jan’14: Worked at Chinar Engineering (Contractor of Tata Pigments Ltd. In TGS) as a “Sr. Mis
Executive”
Location wise Data Collection & Data Compilation.
Prepare Daily & Monthly Report
Ensuring No duplicity data to be taken in fresh billing data.
Preparation of Bill on behalf of Tata Pigments Ltd. & Submitted to Concerned Department of
Tata Steel Growth Shop.
Build & Maintain Report.
Key Skill:
Good Command in Excel 2007 (Function like Index, Sumproduct, Sum, Vlookup, Offset, Pivot Tables,
Array Formula etc.).
Excel Automation report by using Excel vba.
Data Extraction, Data Consolidation, Data cleaning with the help of Excel.
Professional Qualification:
Diploma in Information Technology (DIT) from Sikkim Manipal University.
Academic Qualification:
Matriculation from Patna Board in 1996 with Second Division.
Intermediate from Patna Council in 1998 with First Division.
B.Com(H) from Ranchi University in 2002 with First Class.
Typing Speed:
English 45 w.p.m.
Hindi 35 w.p.m.
Personal Interface:
Father’s Name Sri Krishan Kumar
30th December, 1979
Date of Birth
Sex Male
Marital Status Married
Address H.No. C\260 B-Block,
Near Ram Mandir Rd., Sonari,
Jamshedpur, Jharkhand.
Place: Durg
Date: Signature of the Applicant