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 Performance analysis of each important Highway 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. 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) Analysis of key consumption areas on Highways. Monitoring of shift in volume in buying patterns (opening of new highways and speed of growth, ) Importing automation data to review Dealer activity Customer Analytics 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, Tracking customers with declining transaction volumes (No. of customers with reduced buying 10% or 20%) Identifying customers performing below potential (vol vs notional volumes based on count of cards issued) 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) Analyzing traveling customer behaviour and patterns Monitoring customer activation trends Comparing credit customers vs. others (per cent credit sales on each NH and each stretch, preferred credit partner for each stretch showing growth potential) Trend analysis for newly acquired customers Dealer Analytics 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) Detecting dealers losing customers Tracking dealers with declining customer volumes Monitoring DT Plus contribution trends and setting alerts Driver Analytics Analyzing card movement Inactive card analysis Detecting reduction in card volumes Spend pattern analysis No. of cards with Driver details, Dealers recording vehicle number with each transaction, Partner Analytics Overall customer analysis Customer-wise dealer performance analysis 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.