Data Analysis and Insights Professional
National Water Company (NWC)
Total years of experience :17 years, 7 Months
Leading data analysis & insights unit, in-depth data analysis to generate insightful reports and Insights projects’ management:
Insightful report from internal database (CC&B), Tanker Management Service (TMS) using Excel & Power BI tool and present key findings in PowerPoint.
▪ Periodic and in-depth insights report which covers:
Email:
behramkhan_79@yahoo.com
Mobile: +966 549638603
o Overall customers’ profile, interactions with NWC, type of interactions, average time of closing ticket & avg. time of pending tickets, quality of closure ticket etc. analysis by clusters, cities and segmentation.
o Overall complaints, type of complaints, speed of closing complaints, quality of closure tickets etc. o Detail analysis & insights about New water connection, sewage connection, unit updates, tanker
request etc.)
▪ Quarterly report: Quarterly performance report of the company to the top management
▪ Developed online dashboards in Power PI for more demanding reports/ KPIs
▪ VOC: Gauging customer satisfaction for all services and link it with each service performance (e.g. avg.
closure time of water shortage complaint, closure quality of High bill complaint etc.), measuring reasons of
DSAT, Welcome call for new connection.
▪ Non-interacted customer Satisfaction Survey
▪ Developing Action Plan based on primary research (Internal & External research) and share it with each
service/product owner.
Responsible for all B2C market research projects. Business development through research proposals, project management, deep dive data analysis, Report writing & recommendation
Key Skills:
- Strong attention to detail and a strong analytical mind
- Ability to notice patterns within statistics
- Good organisational skills
- A methodical approach to work
- Have strong IT skills and have knowledge of statistical software packages
Working on Key accounts - Ufone (Etisalat), Zong (China Mobile) and British American Tobacco (BAT) accounts.
- Business development through research proposals
- Research design
- Project management
- Team recruitment, training & development
- Database management
- Data analysis & generate key insights
- Report writing & Recommendations to the clients
- Client satisfaction through quality reports
- Handling clients queries
Key strength: Data Analysis, Research design, project management
Computer Skills: Advance use of MS Excel, PowerPoint (MS Office), SPSS, Survey Reporter
Role / responsibility:
Leading a team of two executives, delivering research projects BAT (British American Tobacco) & Etisalat/Ufone.
Project Management:
- Independently executing variety of projects commissioned by the clients - understanding the research objectives, writing proposals
- Once the project is commissioned - well experienced in:
- Questionnaire development
- Monitoring field execution & data-processing activities
- Finalizing & delivering the presentations to the clients
- Handling client queries - after sales services
Major Studies Handled:
- Type of studies handled are:
- Large scale tracking studies - like high resolution Brand Health Trackers
- Program/Promotion Evaluation Measurement
- Brand Launch/Early Brand Evaluation
- Customer satisfaction studies
- Usage & Attitude Studies
- Ad post test
- Choice modeling (BPTOs)
Role and Responsibilities:
- Preparation data entry file
- Data processing & statistical analysis
- Draft reports in PowerPoint
- Update clients on project status during project execution stage
- Monitoring field and data processing activities
- to day client coordination and Handling their projects’ related queries.
- Responsible for projects execution within the stipulated timelines
Types of Major Studies Handled:
Retailer Census
National Readership Study - first ever conducted in Pakistan
Conjoint Studies
U&A Studies
Promotion Evaluation Test studies
Ad Post test
Clients Handled
Tetrapak, Nestle, Telenor, Tapal, Philip Morris International, Geo News Channel
Team leader in group assignments/projects
Economics, Education, statstic
Two years diploma in computer science. and hold B grade