MIS Executive

JOB DESCRIPTION – MIS EXECUTIVECompany: AB INFOTECH

Brand: GENOSUB | GENIEKART

Department: Operations & Management Information System (MIS)

Job Location: 22 Godam, Jaipur, Rajasthan

Job Type: Full-Time

1. Job SummaryWe are looking for a detail-oriented and analytical MIS Executive to manage daily business data, prepare sales and inventory reports, maintain Excel/Google Sheets records, and provide accurate business information to management.

The candidate will coordinate with the Sales, Accounts, Inventory, and Dispatch teams to ensure proper data management, reporting accuracy, and smooth business operations.

• 2. Key ResponsibilitiesA. Sales MIS & ReportingPrepare daily, weekly, and monthly sales reports.
• Track sales performance of individual sales executives.
• Monitor monthly sales targets versus actual achievements.
• Maintain customer-wise, product-wise, and salesperson-wise sales data.
• Track pending orders, quotations, payments, and follow-ups in coordination with the relevant teams.
• Prepare sales performance dashboards for management.
• B. Inventory & Stock ManagementMaintain accurate stock records for all products.
• Monitor stock inward, outward, transfers, and adjustments.
• Reconcile physical stock with the inventory software and Excel records.
• Prepare low-stock, fast-moving, and slow-moving product reports.
• Coordinate with the warehouse and inventory team to identify stock discrepancies.
• Maintain product codes, specifications, purchase prices, and selling prices.
• C. Billing & Order TrackingMonitor order status from booking to dispatch.
• Coordinate with the billing and accounts team for accurate sales entries.
• Track pending billing, cancelled orders, returns, and credit notes.
• Verify that order data matches billing and dispatch records.
• Maintain proper records of pending and completed orders.
• D. Data Management & ReportingMaintain structured Excel files and Google Sheets.
• Prepare daily operational reports for management.
• Create automated reports and dashboards using Excel formulas and Pivot Tables.
• Ensure data accuracy, consistency, and timely reporting.
• Maintain digital records of business transactions and operational activities.
• Identify data errors and coordinate with the concerned departments for corrections.
• E. Management SupportPrepare reports on sales, inventory, product performance, and operational efficiency.
• Provide data required for management decisions.
• Identify sales trends, stock shortages, and operational gaps.
• Assist management in tracking business targets and KPIs.
• Maintain confidentiality of company data, pricing, and business reports.
• 3. Required SkillsStrong knowledge of Microsoft Excel and Google Sheets.
• Working knowledge of Pivot Tables, VLOOKUP/XLOOKUP, SUMIF/SUMIFS, IF formulas, and data filtering.
• Ability to prepare professional MIS reports and dashboards.
• Good numerical, analytical, and problem-solving skills.
• High accuracy and attention to detail.
• Ability to coordinate with multiple departments.
• Good communication and time-management skills.

Preferred Skills:

• Knowledge of inventory or billing software.
• Experience with ERP, CRM, or accounting software.
• Knowledge of Power Query and basic Excel automation.
• Experience in wholesale, distribution, manufacturing, or e-commerce businesses.
• 4. Qualification & ExperienceGraduate in B.Com, BBA, BCA, or a related field.
• 1–3 years of relevant MIS or reporting experience preferred.
• Freshers with excellent Excel skills may also apply.

5. Key Performance Indicators (KPIs)The MIS Executive will be evaluated on:

1. Accuracy of daily sales and inventory reports.
2. Timely submission of daily, weekly, and monthly reports.
3. Accuracy of stock reconciliation records.
4. Timely identification and reporting of discrepancies.
5. Accuracy of salesperson-wise target tracking.
6. Timely updates of pending orders and dispatch status.
7. Reduction in data-entry errors and reporting delays.
8. Quality of management dashboards and actionable insights.

6. Daily Reporting ResponsibilitiesThe candidate must maintain and submit the following reports:

• Daily Sales Report
• Salesperson-Wise Performance Report
• Monthly Target vs Achievement Report
• Stock Inward & Outward Report
• Product-Wise Stock Availability Report
• Pending Orders & Dispatch Report
• Purchase and Sales Data Report
• Stock Discrepancy Report
• Monthly Business Performance Report

7. Candidate ProfileWe need someone who is systematic, responsible, proactive, and comfortable working with large amounts of business data.

The ideal candidate should not simply enter data but also identify mistakes, highlight discrepancies, and ensure that management receives accurate information on time.

Salary: As per experience and skill set.

Working Hours: As per company policy.

8. How to ApplyInterested candidates can share their updated resume along with details of their Excel skills, previous experience, current salary, and expected salary.