MIS Reporting & Analyst

Designation: Officer

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