TM MIS Analytics & Reporting

Designation: Deputy Manager

Location: India Maharashtra Altimus Worli

Organization: Cement

Job Description:

1) Job Purpose:

Prepare a suite of management reports that translate financial and operational data into actionable business insights for leadership.

Build and maintain analytical Power BI dashboards with trend and variance analysis that support faster, evidence-based operational decisions.

Develop and maintain a centralized database integrating information from diverse source systems, ensuring data integrity, accuracy, and accessibility for swift and reliable retrieval.

2) Job Context & Major Challenges:

Context:

To prepare insightful and data-driven analytical reports in Power BI that go beyond static reporting by incorporating comprehensive trend analysis, enabling stakeholders to clearly identify patterns, performance drivers, and anomalies over time.

Managing a centralized database that consolidates information from diverse sources (TM1, Cognos, Plants, Marketing, RMC, BPD, HO, UKSC) poses challenges due to the varying formats, structures, and data quality issues from these sources.

Coordinating and aligning inputs from different functions for budget phasing at multiple levels (Company, Zonal, Plant) requires effective communication and collaboration across various departments.

Challenges:

Generating detailed analytical reports at a granular level demands a comprehensive understanding of operational data and involves analyzing trends for strategic decision-making.

Participating in the adoption and utilization of Power BI, TABLEAU and Cognos, requiring skill development and transitioning from traditional reporting methods.

Coordinating inputs from different departments for budget phasing can be challenging due to varying priorities, timelines, and methodologies.

Preparing monthly reports under stringent timelines and at the same time with total accuracy.

Preparing on time, consistent and accurate MIS for supporting management decisions.

Transparency, speed of information & data availability is crucial and poses a big challenge.

A time bound detailed analysis for 70+ number of plants requires intensive efforts.

This is really a challenge as there can’t be a compromise on either of the parameters and both the goals need to be achieved. Job Holder has to be meticulous and at the same time very quick.

3) Key Result Areas:

Key Result Areas

Supporting Actions

Accountability - 1

Discussion with plant team to get the reasons for increase or decrease in variable cost and fixed cost.

Twice a month preparation of Plantwise Variable cost and fixed cost reasons for variances as compared to last month, budget and Flash

Detailed Analysis of Operational paramentrs which are contributing majorly for positive/negative performance.

Highlighting the Key areas of deviation/ improvement for controlling the cost.

Accountabiity – 2

Development of Analytical Reports in Power BI

To prepare new analytical models in Power BI for data analysis at Granular level

To prepare trend analysis In Power BI for the plant,zone and depot wise data.

To analyze granuler level data at segment and grade level in power BI

To facilitate comparison of elemet wise Profitability in Power BI.

To prepare and analyse data for the month, last month, last year and budget. Preparing comparison of cost element wise.

Accountability – 3

Preparation of various MIS reports

To upload and validate the data in various reports/dashboards in TABLEAU.

To Prepare Selling Price to NCR Bridge

To upload plant wise monthly volume details on Govt website for statutory compliance.

Kiln Shutdown report preparation along with remarks for delay or preponement.

Preparation of new units Fixed cost data

To prepare Business segment wise and plant wise data for HR annual performance evaluation

Contact group modification and excel update for Team use for seamless communication with plants

To prepare plant wise LOP(loss of Profit data) for Insurance Team.

Prepare Adhoc reports as per Management requirement.

Accountability - 4

Budget Phasing including Zonal and Plant profitability

To collect and consolidate data from TM1 (for 70+ plants), Marketing, planning & budgeting cell, for preparation of budgeted Profitability.

To collect data from Head Office accounts, UKSC, RMC, BPD, BW, WWC and Treasury team for finalization of budget Profitability for review by manager.

To prepare month wise Budget P&L report for Kesoram, India Cements and for the Company(India Operations/CFS/other combinations) for review by manager.

To prepare Plant wise month wise Budget P&L report for KIL, ICL and for the Company level for review by manager.

To prepare Zone wise month wise Budget P&L report for KIL, ICL and for the Company level for review by manager and circulation to Zonal Team.