Lead MIS Analytics & Reporting

Job description

****Job Purpose**** - To prepare consolidated profitability statements, management reports & budgets of UTCL for perusal of management. To analyse in detail deviations in profitability & key performance indicators of the Business to enable Management decisions and interventions. - To prepare board meeting, audit committee & monthly review meeting presentations **Job Context & Major Challenges** - Job Holder has to collect data from large no. of sources (52 Plants, Marketing CMO, BW, Overseas, BPS, Mines, Treasury, RMC UBS etc.). Getting data from such a large no. ON TIME is a challenge. This warrants developing rapport, understanding, tactful handling and a lot of follow-ups . - Job Holder has to consolidate/review the data/ various MIS reports under stringent timelines and at the same time with total accuracy. 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. He/She has to be meticulous and at the same time very quick. **Key Result Areas** **KRA (Accountabilities) (Max 1325 Characters)** **Supporting Actions (Max 1325 Characters)** KRA1 Monthly Flash and Final Profitability Analysis (Grey Cement India) **Accountability 1:** Preparation/Consolidation, Review & detailed Analysis of Monthly Flash and Final Profitability Statement 1. Interactions and follow up with the units to provide in depth analysis on all operational parameters - To coordinate with cross functional teams of Marketing, Birla White, RMC, BPD, UKSC, UBS etc to collect their data - To Consolidate and analyse plant wise variable cost and fixed cost remarks w.r.t to Last month, Flash, Budget to highlight deviatons for perusal of management **Accountability :** KRA2 (2) Quarterly Reports: To prepare and ensure timely and accurate consolidation and preparation of monthly management reports e.g. Chairman Profitability Statements, At a Glance, Yellow sheet, Blue sheet, Outlook, PBIDT Tallies, MPS report etc for enabling effective management decisions 1. Taking procative steps for adhering deadlines e.g linking the format with base files in advance, through scrutiny to error free report submission - To timely prepare and submit quarterly performance summary, quantity tally, MPS report, Investors data , state wise dispatch growth, peer production report etc **Accountability :** KRA3 (3) Board Presentation and Other MIS presentation : To Prepare Board prsentation and other MIS presentation within prescribed timelines ensuring accuracy 1. Effectively coordinating with cross functional teams and MIS team members for collection of data required for board presenatation - To participate in preparation of board presentation on quarterly basis enlisting the detailed overview (Profitability of different Segments, businesses, capex proposals, competitors’ expansion plans) for persual of management. **Accountability :** KRA4 (4) Investor Relations : Timely preparation and submission of Investors Key Statistics, Investor data, Corporate dossier, Reports & inputs for preparing presentation to investors 1. Effectively coordinating with cross functional teams for collection of various input data - To prepare and submit Investor key statistics required for answering investor queries every quarter - To prepare and submit Manufacturing, Marketing, Birla White, Overseas investor data - To prepare and submit inputs for preparation of investor presentations ensuring accuracy - To prepare and submit corporate dossier KRA5 (5) Budgeting **Accountability :** To prepare and ensure timely & accurate consolidation and preparation of budget Budget in standardised P&B templates with appropriate comparision of variances between Budget vs LE & vice-versa at granular level. 1. To coordinate with plants and cross functional teams to collect their data for preparation of annual budget profitability statement - To do Analysis of variable cost and fixed cost as compared to previous year for budget preparation - To prepare the Consolidated Budget with Comaprison/Tallies of profit. **Accountability :** KRA6 (6) Automation : To identify areas of automation, to prepare projects proposals for automation of reports and to implement approved projects in coordination with IT and plant team achieving the objectives of the project, in order to save manhours and avoid human errors - Time frame for automation. UOM : No. days delayed Good Indicator : Less 1. To identify statements or various MIS repots where automation can be done for reducing time taken for preparation and ensuring higher accuracy - To prepare automation project proposal and seek approval - To provide inputs (logic of preparation, format, frequency of report and other inputs) to IT team for automation