– MIS EXECUTIVE

Designation: MIS Executive

Department: Sales Operations / MIS & Reporting

Monthly CTC: ₹18,000

Annual CTC: ₹2,16,000

Reporting To: Management / Business Head

Employment Type: Full-time

Probation Period: 2 months (if applicable)

1. Job Objective

To maintain accurate business data, prepare daily and monthly MIS reports, monitor sales and purchase transactions, track outstanding payments, and support management in making data-driven business decisions. The MIS Executive will help Dynesty Pharma Care improve reporting accuracy, sales follow-up, inventory visibility, and overall operational efficiency.
1. Key Responsibilities

A. Sales MIS & Customer Tracking Maintain daily sales reports covering inquiries, quotations, orders, dispatches, and sales value.

Maintain a customer database with company names, contact details, products, and purchase history.

Track pending quotations, follow-ups, customer conversions, and lost business.

Prepare salesperson-wise, customer-wise, and product-wise sales reports.

Monitor order status from inquiry to final delivery.

B. Purchase & Supplier MIS

Maintain purchase order records, supplier quotations, and purchase prices.

Compare supplier prices and maintain product-wise purchase history.

Track pending purchase orders, expected deliveries, and material availability.

Maintain supplier databases, including grades, manufacturers, and product specifications.

C. Outstanding & Payment Tracking

Prepare customer outstanding reports and ageing statements.

Track payment due dates and overdue invoices.

Maintain supplier payment schedules and purchase-related commitments.

Share daily or weekly collection follow-up lists with management and the sales team.





Coordinate with the accountant to reconcile discrepancies in sales and payment records.

D. Inventory & Dispatch Tracking

Maintain stock and material movement records based on available source data.

Track dispatches, delivery status, transport details, and pending deliveries.

Monitor batch details, quantities, and supporting documentation wherever applicable.

Coordinate with the logistics employee to update dispatch and delivery reports.

E. Management Reporting

Prepare daily, weekly, and monthly MIS dashboards in Microsoft Excel.

Report sales performance, inquiry conversion, pending orders, outstanding payments, and product profitability where data is available.

Highlight unusual price changes, delayed orders, missing records, and overdue payments.

Maintain a centralized and organized digital filing system for reports and business records.

F. Data Accuracy & Process Improvement

Ensure all reports are updated on time and figures are cross-checked.

Use Excel formulas, PivotTables, filters, lookup functions, and data validation.

Identify repetitive reporting tasks that can be standardized or automated.

Maintain confidentiality of company, customer, supplier, and pricing information.

1. Required Skills

Good working knowledge of Microsoft Excel. Knowledge of PivotTables, SUMIFS, COUNTIFS, IF, XLOOKUP/VLOOKUP, and basic dashboard creation.

Strong numerical ability and attention to detail.





Valuable communication and coordination skills.

Ability to manage multiple reports and meet daily deadlines.

Experience in trading, pharmaceuticals, chemicals, or distribution will be preferred.

1. Key Performance Indicators (KPIs)

Daily MIS submission on time. At least 98% accuracy in maintained reports.

100% recording of received sales inquiries, quotations, purchase orders, and dispatch updates.

Daily updating of outstanding and payment tracking records.

Weekly reporting of pending quotations and orders.

Monthly sales, purchase, and profitability reports completed by the agreed deadline.

No avoidable reporting discrepancies or unauthorized changes to records.

1. Working Relationship

The MIS Executive will coordinate with: Management for business analysis and decision support.

Sales and customer-handling personnel for quotation and order updates.

Accounts for invoices, collections, and payment reconciliation.

Logistics for dispatches and delivery status.

Purchase and suppliers for procurement records and pricing updates.

1. Expected Outcome

The employee should enable management to know, at any given time: How much business has been generated.

Which quotations are pending and which orders are confirmed.

How much money is outstanding from customers.

Which suppliers offer competitive purchase prices.

Which orders are pending dispatch or delivery.

Which products and customers are contributing to business profitability.

Job Type: Full-time

Pay: ₹11,951.90 - ₹18,000.00 per month

Application Question(s)

- Your Current CTC?
- Your expectec CTC?
- Notice Period.
- Location in mumbai

Location:
- Goregaon East, Mumbai, Maharashtra (Preferred)

Work Location: In person

📌 Mis executive (Goregaon)
🏢 FOREMOST MARBLES
📍 Goregaon