: MIS & Commercial Operations Manager

Company: BNew Mobiles

Industry: Mobile Phones & Consumer Electronics

Department: MIS / Commercial Operations

Experience: 3- 5 Years

Job Location: Hyderabad.

Job Summary

We are looking for a highly analytical and detail-oriented professional with strong expertise in MIS Reporting, Advanced MS Excel, Dashboard Creation, Business Analytics, and Commercial Operations in the mobile retail industry.

The candidate will be responsible for developing automated MIS reports, interactive dashboards, and management reports to track business performance, sales, profitability, procurement, inventory, and commercial revenue. The role requires excellent Excel skills, the ability to analyze large datasets, and the capability to convert business data into actionable insights for management decision-making.

Key Responsibilities

1. MIS Reporting & Dashboard Creation Primary Responsibility

- Develop, maintain, and automate daily, weekly, and monthly MIS reports.
- Create comprehensive dashboards to monitor sales, turnover, Gross Profit (GP), procurement, inventory, swipe performance, and revenue generation.
- Prepare brand-wise, model-wise, store-wise, and category-wise performance reports.
- Develop management dashboards highlighting KPIs, targets versus achievements, variances, trends, and business performance.
- Consolidate data from multiple sources and ensure accuracy, consistency, and timely reporting.
- Automate repetitive reporting processes to reduce manual effort and improve reporting efficiency.
- Present business insights and performance summaries to senior management through structured reports and presentations.
- Identify business trends, performance gaps, and opportunities for revenue and profitability improvement.

2. Advanced MS Excel & Data Analytics

- Demonstrate strong hands-on expertise in Advanced MS Excel for large-volume data analysis and reporting.
- Use Pivot Tables, Pivot Charts, XLOOKUP, VLOOKUP, INDEX-MATCH, SUMIFS, COUNTIFS, IF formulas, and other advanced Excel functions.
- Develop dynamic dashboards, automated MIS templates, data trackers, and performance-monitoring tools.
- Use Power Query for data cleaning, consolidation, transformation, and automation.
- Build formula-driven reports to track targets, achievements, margins, stock ageing, and business KPIs.
- Perform variance analysis,



trend analysis, profitability analysis, and data reconciliation.
- Ensure data accuracy through validation, cross-checking, and reconciliation across multiple reports.
- Experience with Power BI and data visualization tools will be an added advantage.

3. Commercial Operations & Revenue Analysis

- Monitor sales versus swipe performance and track revenue generated through corporate card and virtual swipe activities.
- Analyze Gross Profit (GP), Merchant Discount Rate (MDR), cashback, affordability schemes, and promotional offers.
- Track turnover targets versus achievements and prepare performance reports.
- Monitor brand-wise and model-wise commercial performance and identify revenue optimization opportunities.
- Coordinate with Accounts and Finance teams for swipe transaction reconciliation and GP validation.

4. Purchase & Procurement Analysis

- Prepare and analyze Net Landing Cost (NLC) for mobile models across multiple brands.
- Conduct price benchmarking, product comparisons, and buying verdict analysis.
- Prepare procurement planning reports based on stock availability, sales trends, and inventory requirements.
- Analyze purchase costs, margins, and product-level profitability to support buying decisions.
- Coordinate with brand partners, distributors, and vendors regarding pricing and stock availability.

5. Inventory & Stock MIS

- Develop reports to monitor stock availability, stock movement, inventory ageing, and slow-moving products.
- Prepare model-wise, brand-wise, and colour-wise stock reports.
- Track activated versus non-activated devices and monitor IMEI-related data.
- Prepare inventory liquidation reports and recommend actions to reduce ageing stock.
- Coordinate with Warehouse, Purchase, Retail Operations, and MIS teams for stock reconciliation and reporting accuracy.

6. Brand Activation & Incentive Management

- Coordinate device activations with activation teams, promoters, and brand representatives.
- Monitor air activations,



activation uploads, and claim eligibility.
- Manage Samsung GMCS activities, promoter upload data, and incentive compliance.
- Track VBA and Non-VBA incentive programs and validate eligible claims.
- Coordinate with brand partners to ensure timely submissions and accurate claim processing.

7. Process Improvement & Automation

- Identify opportunities to automate repetitive reporting and operational activities.
- Develop and improve reporting tools, dashboards, and business tracking systems.
- Streamline procurement, reconciliation, activation tracking, and commercial processes.
- Train internal teams on reporting tools, procurement processes, and operational systems.
- Coordinate with Purchase, MIS, Accounts, Finance, Warehouses, Retail Operations, and brand teams to ensure smooth business operations.

Required Skills & Qualifications

- Bachelor's degree in Commerce, Finance, Business Administration, Statistics, or a related field.
- 3 - 5 years of relevant experience in MIS Reporting, Business Analytics, Commercial Operations, or Mobile Retail.
- Excellent proficiency in Advanced MS Excel is mandatory.
- Proven experience in creating automated MIS reports and management dashboards.
- Strong knowledge of Pivot Tables, advanced formulas, data analysis, and report automation.
- Hands-on experience with Power Query is preferred; Power BI knowledge is an added advantage.
- Solid analytical skills with the ability to interpret large datasets and present actionable business insights.
- Experience in mobile retail, electronics, distribution, or multi-store retail operations is preferred.

Key Performance Indicators (KPIs)

- Accuracy and timely submission of MIS reports.
- Quality and effectiveness of management dashboards.
- Reduction in manual reporting through automation.
- Accuracy of business data consolidation and reconciliation.
- Timely identification of business trends and performance gaps.
- Improvement in visibility of sales, GP, inventory, and commercial revenue.
- Reliability of management reports for business decision-making.

Important: Candidates must have practical experience in Advanced Excel, MIS automation, and dashboard creation. Candidates with only basic Excel skills or routine data-entry experience will not be suitable for this position.

📌 MIS/ Commercial Operations (Hyderabad)
🏢 B New Mobiles
📍 Hyderabad