Manoj Kumar Email & Phone Number

Gurugram, Haryana, India

 Billing & Payments. Passing courier Freight Bills as per agreement and following up with SCM and Vendor for confirmations. Calculation of freight for COD and prepaid orders. Reconciliation of courier bill with dispatch master excel maintained by Finance and highlight and resolve differences. Take care all current and previous month lost and damage debited. Resolve the courier partner’s issue related to shipment status, weight & rate. Prepare dashboard for freight weekly. Merchant payout and refund check for every orders and highlight to related team.

Gurugram, Haryana, India

✓ Verification and reconciliation of Freight Invoice of 6 Logistic partners and of 2 lacs of monthly average shipment. This includes:✓ Recon of Invoice viz a viz Agreement viz a viz sales.✓ COD Recon , Loss and damage analysis and Load, Volume and weight Recon✓ Taking care of monthly Provision activity and Recon of Budgeted v/s actual.

✓ Updating Data Tracker and MIS Dashboard on daily and weekly basis.✓ Ensure deliverables (Daily, Weekly & Monthly MIS Reports & Dashboard) are prepared to satisfy the project requirements cost and schedule.✓ Excellent in MS Access, MS Excel (Hlookup, Vlookup, lookup, Pivot Table & PivotTable Chart, Charts, Macro, Forms and data validation)

Gurgaon, India

✓ Creating and updating agents’ productivity report in Dashboard and Share MIS Dashboard to the seniors. ✓ Handling multiple reports, working with formulae, pivot tables & pivot charts, and various other excel sheet components for accurate data.✓ Updating Data Tracker and MIS Dashboard on daily and weekly basis.✓ Creating Agent reports break and log in / log out report✓ Ensure deliverables (Daily, Weekly & Monthly MIS Reports & Dashboard) are prepared to satisfy the project requirements cost and schedule.✓ Excellent in MS Access, MS Excel (Hlookup, Vlookup, lookup, Pivot Table & PivotTable Chart, Charts, Macro, Forms and data validation)

Gurgaon, India

✓ Ensure deliverables (Daily, Weekly & Monthly MIS Reports) are prepared to satisfy the project requirements cost and schedule.✓ Handling multiple reports, working with formulae, pivot tables & pivot charts, and various other excel sheet components for accurate data.

Bachelor'S Degree(Bsc.It), Computer Software Engineering, C

Education record