Database Analyst

Dear Candidate,

We need Data Analyst in Mumbai location to work in HPCL Project.

Working under the Company –

HPCL (Hindustan Petroleum Corporation Limited)

(Company is into Oil and Gas government Firm) on contract basis for 3 yrs. and it is renewal contract and there is 4 months of probationary period.

Payroll of Company –

Tristar Management Services Pvt Ltd

Profile: Senior Regional Sales Manager (Data Analyst)

Min Qualification: Graduation

Work Experience: Min 5 Years in Data Analyst experience.

Location – Mumbai

Salary structure is below for your reference.

CTC- 43,476 (with PF)

In hand salary- 34,026/- pm

Gross Salary- 38,776/-pm

Other Benefits: -

• Mediclaim Insurance: Company will provide a Mediclaim insurance cover of Rs. 5 lakhs p.a for you and 3 other dependent family members and

You will also be covered with life insurance benefit coverage of Rs. 20 lakhs. P.a

• Telephone Charges: Company will provide you fixed telephone charges of Rs.600 per month.

• Conveyance Expenses or Travel Expenses – Company will provide you the travel expenses according to the Tire cities, which will be based on the location where you are posted:

If you are posted under the tire 1 city, so company will provide you 100 Rs. per day it means will provide you Rs.3000 pm

Classification of City

Rate

X Class/ Area A/ Zone

I

Rs. 100/- per day

/3,000 pm

Y Class/ Area B/ Zone

II

Rs. 80/- per day

/2,400 pm

Z Class/ Area C/ Zone

III

Rs. 70/- per day /

2,100pm

Analyst Profile -

A detail-oriented and results-driven Analyst with strong expertise in data analysis, visualization, and reporting. Skilled in leveraging Power BI and other analytical tools to transform raw data into actionable insights for business decision-making. Adept at conducting detailed analysis, collaborating with cross-functional teams, identifying trends, and presenting findings through interactive dashboards and reports.

Key Skills & Expertise:

• Power BI (dashboard development, DAX, data modelling, Power Query)
• SQL for data extraction and transformation
• Advanced Excel (pivot tables, macros, VBA)
• Detailed analysis and problem-solving
• Business and financial analysis
• Requirement gathering and stakeholder communication

Professional Summary:

• Conduct detailed analysis of business data to identify trends, patterns, Data Corelation ships, variances, and improvement opportunities.
• Designed and deployed Power BI dashboards to monitor required parameters, operational performance, and financial metrics.
• Automated recurring reports, reducing manual effort and improving accuracy.
• Collaborate with stakeholders to gather requirements, ensuring dashboards and reports meeting business needs.
• Supported strategic decision-making by analyzing large datasets and highlighting key insights.

Analysis Examples

Highway Wise Industry Sales Analysis

1. Performance analysis of each important Highway
2. Periodic Performance of each OMC for each stretch of identified stretch of particular highway (e.g. on NH 48 which OMC has grown in which state, stretch and contributed what per cent of overall growth on that NH, what is TPO for each stretch/state and change in TPO for the month, Change in volume/mkt share/TOP based on expansion in DT customers transaction in that stretch, which Tier dominant at which stretch i.e. tier wise mix of each stretch, activation levels for each stretch, etc) Plotting of outlets on highway using coordinates.
3. Various parameters of Loyalty Performance of specified stretch on Highway (Enrolment level for important stretch, activation level for important stretch, what volumes are generated by new customer and what volumes were reduced by existing customers, volume contribution by each Tier in each stretch (district/state)
4. Analysis of key consumption areas on Highways. Monitoring of shift in volume in buying patterns (opening of new highways and speed of growth, )
5. Importing automation data to review Dealer activity

Customer Analytics

1. Churn Analysis – identifying inactive customers and predicting those likely to become inactive. (Identify customers which buy through the month but recharge and conduct sales periodically,
2. Tracking customers with declining transaction volumes (No. of customers with reduced buying 10% or 20%)
3. Identifying customers performing below potential (vol vs notional volumes based on count of cards issued)
4. Prioritizing customers based on upliftment trends (Key customer for each state, Aggregator generated sales vs DT Plus for each state/Region/Stretch etc. ) List of important customers for each stretch/trading area using historical data for engaging those customers)
5. Analyzing traveling customer behaviour and patterns
6. Monitoring customer activation trends
7. Comparing credit customers vs. others (per cent credit sales on each NH and each stretch, preferred credit partner for each stretch showing growth potential)
8. Trend analysis for newly acquired customers

Dealer Analytics

1. Identifying dealers with reducing DT Plus volumes or increasing volumes.(comparison of TPO vs industry TPO in that stretch/trading area, Important dealer for each NH, no of customers serviced by a Dealer, per customer sales of a Dealer)
2. Detecting dealers losing customers
3. Tracking dealers with declining customer volumes
4. Monitoring DT Plus contribution trends and setting alerts

Driver Analytics

1. Analyzing card movement
2. Inactive card analysis
3. Detecting reduction in card volumes
4. Spend pattern analysis
5. No. of cards with Driver details, Dealers recording vehicle number with each transaction,

Partner Analytics

1. Overall customer analysis
2. Customer-wise dealer performance analysis
3. Partner performance trend analysis

Job Location - Hindustan Petroleum Corporation Limited

Retail SBU, Marketing HQO, Hindustan Bhawan 

4th Floor, 8, Shoorji Vallabhdas Marg 

Ballard Estate, Fort ,Mumbai – 400001

Thanks & Regards

Nutan Pawar

9833564465

​TriStar Management Services Pvt Ltd.