MIS Reporting & Analyst

Key Result Areas/Accountabilities

Supporting Actions

Regular Sales MIS reporting

• Prepare Monthly Customer Invoice level volume, gross sales, net sales and realization (NCR).
• Monthly Reconciliation of NCR with Trail balance – NCR Tally.
• Prepare Product-wise / sales area wise / segment wise contribution
• Prepare variance analysis against budget, forecast, and previous periods
• Present data related to sales volume performance, revenue trends, and other key metrics to seniors.
• Analyze sales trends, pricing impact, realization, discounts, and schemes.
• Prepare presentations for Business Head/CEO reporting
• Provide insight-driven analysis to support strategic and tactical decision-making.
  
  

Reports for Business review meeting/ Corporate finance cell – Quarterly reports

• Prepare details for pre-decided volume and revenue formats
• Arrange 2 players market share
• Prepare Urban and Rural performance report
• Prepare trade and non-trade performance
• Prepare presentations
  
  

Budget and latest estimate working

• Prepare revenue and logistic cost as per given volume
• Assist in budgeting process across departments. Coordinate with department heads to collect and consolidate budget data.
• Support management in revised forecasts and rolling budgets.
• Identify and explain price, volume, mix.
  
  

Additional various data preparation

Sales and Marketing reports-

• Prepare related party transaction details based on revenue model
• Arrange requisite sales data for govt statistical department
• Calculate and Maintain inter unit good transfer rate
• Identify the lower contribution areas and report
• Timely incorporation of changes in schemes and price circulars in NCR as implemented by management
• Arrange revenue related data to auditors
• Support in tax assessment related data preparation
• Track actual performance against approved budgets on a monthly/quarterly basis.
• Prepare supply and distributions reports to show logistic and depot effectiveness.
• Depot landing cost comparison for optimum plant supply allocation
• Work out imported cement contribution
• Provide ad-hoc analysis as required by leadership
  
  

Automated / BI report

• Improve reporting efficiency through Power BI, Excel automation, SAP reports, and analytical tools.
• Work with SAP/TM1 team on report automation
• BI based report