Alaa Anwar

Experience

• 

  MTN Sudan

  Jan 2015 - Aug 2018

  Business Intelligence Specialist

   Built and maintained data models to support business intelligence needs, ensuring seamless integration of data from diverse sources like Billing system, MSCs and CRM into a centralized repository (Datamart). Identified and solved data quality issues to ensure data consistency and integrity as a part of a data governance process by performing the necessary activities. Designed and implemented interactive dashboards that provided real-time insights into key performance indicators using OBIEE. Conducted ad-hoc analyses in response to specific business inquiries, providing timely insights to support critical decision-making processes. Interacted with customer as needed to better define and understand reporting requirements delivery of projects, issues, and tasks within the expected time frame. Expertly leveraged PL/SQL for robust data analysis and reporting, executing complex queries and procedures to extract actionable insights as well as automating data specific requirements for offer campaigns. Utilized OWB (Oracle Warehouse Builder) proficiently to orchestrate and streamline complex data integration workflows, ensuring seamless extraction, transformation, and loading (ETL) processes. Expertly employed Oracle Business Intelligence Enterprise Edition (OBIEE) to develop and implement daily, weekly and monthly reports as well as interactive dashboards and various visualizations. Applied advanced SQL & PL/SQL techniques to streamline data transformation and manipulation processes, significantly enhancing the efficiency and accuracy of analytical tasks for comprehensive decision-making. Show less

• 

  MTN Swaziland

  Oct 2016 - Feb 2017

  Business Intelligence Expert

   Gathered all needed information from business and technical concerned parties. Successfully built a robust analytics infrastructure, including data models, ETL processes and dimensional Datamart (creating dimensional partition bases for all revenue streams and customers tracking performance that serve business to track, analyze, slice and dice data) Developed and implemented BI governance policies, ensuring data accuracy, consistency, and compliance with industry standards. Led the team in creating and optimizing interactive dashboards and reports using OBIEE, providing stakeholders with visually compelling and intuitive data representations. Conducted comprehensive training sessions for end-users, empowering them to navigate and extract valuable insights from BI tools effectively. Successfully positioned the BI department as a strategic asset within the organization, providing key decision-makers with the tools and insights necessary for informed and impactful choices. Show less

• 

  Zain Sudan

  Sept 2018 - Oct 2019

  HAC Churn Specialist

   Managed and executed HAC (High ARPU Customer) marketing plans and programs, both short and long range and coordinate at all stages with IT, Finance, Sales. Prepared and conducted data analysis to understand reasons behind churn as well as Identifying the HAC loyalty and retention issues at regional/local levels. Prepared monthly, quarterly and statistical reports on returnees/churn/revenue/usage. Monitored monthly, quarterly and statistical reports against business targets for the specific offers & promotions. Monitored competition in their overall activity along with possible internal/external factors that may affect (Customers/MOU/revenue) KPIs. Created and developed internal and external targeted campaigns for existing HAC products and services. Developed new plans and ideas to HAC segments ensuring churn reduction. Maintained the balance for all value propositions between all existing HAC products. Show less

• 

  MTN Sudan

  Oct 2019 - now

  Segments & CVM Manager

  Govern the CVM journey for the B2B customer from initial on-boarding to performing customer behavior analysis, segmentation, and creating, executing and monitoring marketing campaigns for retention, up-selling, cross selling and churn management Kick started the underlying layers of the data reporting system, including Data Models and Data Marts as well as the information presentation layer for B2B customers. Built business intelligence framework and automated periodic reports to support transforming data into meaningful information that support the organization and the department strategic initiatives using SQL and PL\SQL  Delivering comprehensive and visually compelling reports to the Board Presentation, finance reporting and group reporting showcasing key performance indicators and outlining actionable recommendations for further success using Power BI Software. Supporting sales staff – including top management – in their daily insights and information requirements, either through the existing reporting system or any other available data source. Monitoring the portfolio performance and profitability in accordance with the budget and target. Carry out traffic analysis and price sensitivity studies for churn and CVM activities. Provide complete customer assessment in terms of traffic, behavior, segmentation using Python machine learning models. Plan, Roll-out and maintain a Customer Lifetime Management Plan through the continuous launch of pilot campaigns testing the impact of some ideas based on the insights obtained from the customer base scan and business cases. Churn Management and retention program to ensure meeting or exceeding targets including the management of the Loyalty Programs. Leading a team of analysts and marketing specialists responsible of data reporting and executing the CVM plan. Budget planning and management for the CVM section. Show less