Usman Ali Khan

• Direct interface towards Customer Experience Head responsible for provisioning of Actionable insights using multiple datasets relating Contractual KPIs, Network Complaints, Sales, Capacity Analysis and Special Sales Optimization Projects Execution and its reporting.
• Weekly/Monthly/Yearly/Quarterly Reports and tracker of Sales
• Extracting Data from Multiple source systems & using different storage Modes for reporting purpose.
• Data Modeling as per Business Requirements.
• Creating Reports and Dashboards using BI Tools (Power Bl)
• Administration of BI Tools & Using Gateways (Power BI)
• Implementation of Object & Row Level Security
• Handling Customer related escalations, Compliance, and feedback of QoS related notices
• Responsible for KPIs target achievement, Acceptance & exclusions towards Internal & External Senior Management on Weekly/Monthly/Quarterly basis
• Nationwide delivery while enabling & interfacing with HQ/Regional Teams for project deliverable.
• Ensuring Planning & Smooth Execution of Special Management Assignments according to agreed timelines/PIP
• Creating High level view/Dashboards using Power Bi for customers

• Responsible for Zone/Cluster level KPIs Degradation and Performance.
• Managing team & assigning them with tasks
• Developing Power BI and Excel reports
• QA before moving into Production.
• Writing SQL queries & Creating underlying Views as per businesses Need
• Performance tuning of reports both on DB & Power BI Side
• Implementation of Organizational level Row Level security
• Fixing & Monitoring ETL jobs + Data Validation from source to destination
• Clearing bugs
• Documentation

• Gather data from various sources, including databases, spreadsheets, surveys, and more.
• Clean and preprocess data to remove errors, inconsistencies, or missing values.
• Transform data into a format suitable for analysis.
• Use statistical methods and analytical techniques to analyze data.
• Create visual representations of data, such as charts, graphs, and dashboards using Excel and Power BI.
• Generate regular reports summarizing key metrics and insights.
• Provide actionable recommendations based on analysis results.