ABOUT US

Indepesca Overseas Pvt Ltd imports and distributes premium seafood under the Big Sam'S brand including fresh Atlantic salmon, Coho, Chilean Sea Bass, smoked salmon, shrimp, squid, tuna and specialty proteins. We serve HoReCa, modern trade, general trade, retail and D2C e-commerce customers across Mumbai, Delhi, Bangalore, Pune, Kolkata, Ahmedabad, Chennai, Hyderabad and Goa, backed by our processing facility in Kurla and a cold-chain network across key metros.

ROLE SUMMARY The MIS cum Sales Coordinator will be the single point of truth for sales data at Big Sam'S. The role owns daily, weekly and monthly sales reporting across channels, regions and species, coordinates with the sales team and operations on orders and dispatches, and converts large transaction datasets into clear, decision-ready reports for management.

KEY RESPONSIBILITIES

A. MIS & Reporting

- Prepare and circulate daily, weekly and monthly sales MIS — primary and secondary sales — by region, channel (HoReCa, Modern Trade, General Trade, Retail, D2C), sales manager, customer and species.
- Maintain and reconcile the Sales Master database (100,000 transaction rows), ensuring accuracy, consistent naming and clean customer/product classification.
- Build and maintain Excel dashboards and management review decks for the MD and leadership team.
- Prepare target vs. achievement reports, incentive working inputs and sales-manager scorecards.
- Monitor receivables and outstanding reports in coordination with Accounts; share ageing and collection follow-up lists with the sales team.

B. Sales Coordination

- Act as the link between the sales team, warehouse/cold storage, logistics and accounts for order processing, dispatch planning and delivery confirmation.
- Coordinate order entry and status tracking in the OMS; resolve order, pricing and invoicing discrepancies promptly.
- Maintain customer master, price lists, schemes and rate contracts; circulate updated price communication to the field team.
- Support key account and distributor coordination — order punching ,



follow-ups, secondary sales data collection and claims reconciliation.

C. Data Governance & Process

- Standardise data formats, templates and naming conventions across sales and operations files.
- Reconcile sales figures across SAP, OMS and Excel records; independently cross-check all numbers before circulation.
- Identify opportunities to automate recurring reports and reduce manual effort.

SKILLS & COMPETENCIES

Must-Have

- Advanced MS Excel — Pivot tables, VLOOKUP/XLOOKUP, INDEX-MATCH, SUMIFS/COUNTIFS, IF logic, data validation, conditional formatting, charts and dashboarding; comfortable handling large datasets.
- Solid communication — clear written and verbal communication in English and Hindi; able to present data confidently to senior management and coordinate with field teams.
- Accuracy — high attention to detail and a habit of cross-verifying figures.
- Ownership — ability to manage multiple deadlines and stakeholders in a fast-moving environment.

Added Advantage

- Power BI (or similar BI tools) — data modelling, DAX, interactive dashboards.
- Power Query / Excel macros (VBA) for report automation.
- Working knowledge of SAP and Google Sheets.
- Prior experience in FMCG, food, frozen / seafood, or cold-chain distribution.

QUALIFICATION & EXPERIENCE

- Graduate in Commerce, Business Administration, Statistics or a related field; MBA / PG preferred.
- Minimum 5 years of experience in Sales MIS, Sales Coordination or Sales Operations.

KEY PERFORMANCE INDICATORS

- On-time delivery of daily / weekly / monthly MIS reports.
- Data accuracy — zero material errors in circulated reports.
- Order-to-dispatch turnaround and query resolution time.
- Reduction in manual reporting effort through automation.
- Stakeholder feedback from sales and management teams.

WORKING CONDITIONS

Office-based role at Bandra, Mumbai. Working days and hours as per company policy; occasional extended hours may be required during month-end closing and management reviews.

_______________________

Firoz Premani

HR Manager

Indepesca Overseas Pvt Ltd

((phone hidden))

📌 Mis Cum Sales Coordinator (Mumbai)
🏢 Indepesca Overseas
📍 Mumbai