Assistant Manager Data Analysis and Reporting

Purpose

To monitor and perform analysis of data extracted from different sources along with gap analysis

Education

BBA

Knowledge

• Business Analysis and Planning
• Number Crunching
• Forecasting
• Knowledge of relevant SAP Modules and other analysis tools like BEX, Qlick View etc
• Advance knowledge of MS Office
  
  

Experience

2-3 years’ relevant experience

Competencies

Builds High Performance Team > (Value = Respectful / Energized)

Accountable

BUILDS HIGH PERFORMING TEAM > Value (ENERGIZED + RESPECTFUL)

Customer Centric

DRIVES CHANGE > Value (ENERGIZED)

DRIVES RESULTS > Value (CUSTOMER CENTRIC + ENERGIZED)

Energised

INTERNAL & EXTERNAL STAKEHOLDER MANAGEMENT > Value (CUSTOMER CENTRIC + RESPECTFUL)

Leading Change

Leading People

Leading Results

Leading Self

MENTAL AGILITY > Value (ENERGIZED)

Respectful

SELF AWARENESS > Value (ACCOUNTABILITY)

Safe

Area Of Responsibilities

Business

Data Reporting

• Prepare and analyze daily Sales and Cash reports.
• Prepare various reports for DGMs, GM & Cluster Office.
• Prepare summaries/reports of pending SIRs, FMRs, RCDC, D-Loss, Recovery and other relevant reports.
• Prepare special projects reports i.e. ABC Reporting and coordinate with concerned departments.
• Ensure monthly reporting of IRB targets/UHC units in coordination with RPR.
  
  

Data Analysis

• Carry out Complaints Management Analysis.
• Perform Score Card Analysis on daily basis.
• Monitor Cycle days wise sales and revenue targets in coordination with CA department.
• Carry out analysis of HT & LT Mapping and also updating on SAP EDM (Energy Data Management).
• Perform analysis of unbilled revenue.
• Analyze feeder and PMT losses.
• Highlight billing related abnormalities w.r.t. feeders sent out.
• Analyze data related to back-feeding of feeders and sharing of feeders.
  
  

Area of Responsibility Continued

• Ensure daily sent out reports including timely updation of new feeders.
• Prepare projections w.r.t. DL & RR as and when required.
• Perform budget based analysis on the basis of ground realities.
• Carry out data analysis pertaining to aging wise defaulters with paying slabs
  
  

Follow-ups

• Ensure follow up on resolution of all pending technical, billing and service tickets as per TATs.
• Check with CA and RPR about all pending notifications.
  
  

Coordination

• Coordinate with compliance, Internal audit department, cluster team, RPR, CA, CM, PM and CS teams.
• Coordinate with all stakeholders as deemed necessary for routine matters and for other issues that may arise from time to time.
  
  

Health, Safety & Environment

Ensure that department operates in accordance with health, safety and environmental policies and procedures to ensure the safety and well-being of staff & public.