MIS Reporting & Analyst

Designation:

Location: India Maharashtra Birla Centurion, Worli

Organization: Cement

Job Description:

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

Explore More Jobs