Ammar Azhar

I am a part of the Advanced Analytics-Data Engineering Team at Saudi Telecom Corporate Analytics and Data (CAD) sector. My job role covers designing, implementing and maintaining robust data solutions for clients both internal and external to STC. I am entrusted to perform the below tasks:

• Managing strategic, large-scale and complex data processing projects and initiatives for clients that include STC internal Business units, external business entities and government organizations.
• Enhanced system performance by designing and implementing scalable data solutions for high-traffic applications.
• Extensive interaction with client teams and subject matter experts, understanding of Business Applications, Business Data Flow, and Data Relations.
• Leveraging Teradata CLDM for analytics and data integrations/orchestration using Huawei Big Data Integration, Talend Open Studio, Talend Big Data, PBI and Tableau.
• Large scale subscriber intelligence for critical projects like Hajj analytics, COVID suspects profiling, Tourism analytics for Riyadh/Jeddah Season and complex event campaign management for frequent call drops and subscriber dormancy analysis.
• Revenue assurance and Fraud Management analytics to support fraud scoring, utilization spikes and resellers identification from CDRs and Customer profile data.
• Subscribers profiling for wealth, age, gender and household estimation from calling circle, data consumption patterns and Social Network Analysis techniques.

Assigned as Big Data Solution Architect on-site with client Saudi Telecom which is world leader in implementation of Customer Experience data solutions and best practices in mobile and fixed line domain. My job in Corporate Analytics consisted but not limited to the following:

• Led a team of 06 solution architects and data engineers for analytics project design and delivery.
• Leading detailed architectural dialogue with client to design end to end big data solutions, i.e. sourcing and integrations, creation of data pipelines and delivery of reports and dashboards.
• Worked closely with product teams to define and prioritize partner feature requests.
• Data integrations to and from sources such as Customer Care, CRM, Billing, Enterprise Data Warehouse, Regulatory Affairs, Mobile Functional Planning etc.
• Design and development of comprehensive and integrated solutions and features such as Call Center iframe, Roaming subscribers pop messaging, dormant user join back, ATL and BTL campaign support, Call Drop compensation using Complex Event Processing.

Assigned as a Big Data Developer with client on-site at Saudi Telecom under Corporate Analytics and Data sector for the development of Customer Experience Management Insights(CEM), reports and dashboards. My tasks included:

• Requirement gathering, elicitation, design and development for Big Data pipeline and data flows
• KPI, KQI and metrics mapping, harmonization and sourcing of Call Detailed Records
• Customer Journey mapping and Customer Experience Index development
• Use case development (COVID-19 subscriber movements and area profiling)
• Data visualization with Tableau

I worked as a Network Data Analyst with client on-site at Nokia-Telenor project for the purpose of SWAP reporting and analysis. My tasks included:

• Subscriber intelligence and Network Quality Analysis, identified coverage black holes, high traffic areas, capacity sites, low throughput and high latency analysis from network activity data analytics.
• Reporting and Visualization for data driven decision making using Tableau and MS Office tools.

I worked as a Data Analyst on Huawei-JAZZ project Mobile Customer Intelligence related roles and responsibilities which include but not limited to the following:

• Extraction and conversion of subscriber data(CDRs) into meaningful information used for data driven decision making
• Device data analytics and campaign for 4G upgrades as well as high latency low speed cases.
• Creation of detailed and interactive dashboards/reports for Customer Experience and network quality using Tableau, Excel such as Mobile merger project DESURR dashboard

I worked as a Performance Reporting Lead on Huawei-STC project and led a team of 03 Reporting engineers for Mobile Customer and Network Intelligence related roles and responsibilities which include but not limited to the following:

• Conversion of subscriber data(CDRs) into meaningful information used for data driven decision making
• Analyze OTT usage data, perform gap analysis and recommend changes for area/protocol-based campaigns and throttling/fair-usage actions
• Conduct subscriber profiling activities by user/usage segmentation and providing holistic insights into geo-located subscriber behavior
• Maintain agreed level of Network quality in terms of availability, reliability, integrity and usage by monitoring, analyzing and reporting predefined Key Performance indicators (KPIs), user plane Quality indicators, counters, measures and customer feedback for Voice and Data services.
• Creation of detailed and interactive dashboards/reports for Customer Experience and network quality using Tableau, Excel

• Deployment of Interfaces in Oracle Databases.
• Formulation, harmonization and detailed analysis of KPIs and counters.
• Provided remote support for global customers, navigating time zone differences to ensure prompt assistance when needed.

• Perform end to end analysis of statistical measurements of mobile network for software parameter tuning as well as hardware redesigning
• Traffic dimensioning and capacity analysis
• Development of management level reports and dashboards