Manager Back Office

CURRICULUM VITAE

Deewan Singh

House No ** Block No 16 Kalyan Puri near Mayur Vihar Ph -2 Delhi-110091

E-Mail: ************@*****.*** Mobile: 098********,

SUMMARY

Currently designated as MIS & Service Coordinator with Sony India Private Limited Since Dec 2013,

A competent professional with an experience of 5.8 year in managing Hug range of Database.

Maintain different kind of MIS Reports with use of Pivot Table, Vlookup, Hlookup, Count, Countif, Sum, Sumif and Etc.

ACADEMICS QUALIFICATION

10th Passed from NIOS Board Noida

12th Passed from NIOS Board Noida

B.A Passed From Dr Ram Manohar Lohiya, University.

SOFTWARE EXPOSURE

Application Software: MS- Office (Word, Excel, Power Point), MS Outlook, Emailing, SAP, GARATA, APNeWSIS, etc.

Advance Excel: Pivot Table, Vlookup, Hlookup, Count, Countif, Sum, Sumif, index match, datedif, Filter, Etc.

Knowledge of SAP:- SRN, VA03, VF03, MB51,MB52 Etc.

WORK EXPERIENCE

Presently working with Sony India Private Limited (off role Position) as a “Service Coordinator” since Dec 2013.

JOB PROFILE

Download Daily Order List through Software.

Arrange different state e- way bills for dispatch the material

Handling dispatch of Order products to Sony ASC’s.& SSC

Coordinate with Courier vendor for get any damaged goods replaced / compensated

Co-ordinate with pick/pack supervisors & dispatch manager for maintain fill rate and Accuracy

Fully responsible from dispatch to submission of POD to finance.

Coordinate with commercials for insurance claim for any damage to goods during in transit

Inspection & checking of all components/material as per specifications

Emailing to SSC & SSC with Copy Area Service In-charge for Mismatch cases of warranty & out of Warranty Part

Prepare Service Reports Region Wise through Excel function count if, concatenate, v lookup, pivot table, graphs. Etc.

Worked with IDBI BANK PVT. LTD. (offrole position As a “MIS Executive” since Oct 2010 to Nov 2013.

JOB PROFILE

I collect all the applications send by all the branches of IDBI BANK compile them.

Data entry in Excel sheet for bank customer information.

Maintain the MIS Reports of Different type as per Management Requirement.

Uploading data from Bank internal website then after tallying the excel sheet report. I send all the application to the concerned authority

I do the operational activities pertaining to back office and providing all kind of operational stimulation to enhance the sales coordination with major clients like ONGC, REC, NHAI, JAI PRAKASH ASSOCIATE etc. and resolve their queries with optimum solution

Maintain daily MIS Sheet through MS-Excel Sheet on daily basis.

PERSONAL DETAILS:

Father’s name: Lt. Shri Laxman Singh

Date of Birth: 10th September1984

Nationality: Indian

Marital Status: Married

Hobbies Reading Book

Language knowledge: Hindi & English.

Place: - New Delhi

Date: (Deewan Singh)

Contact this candidate