Dennis B

Enterprise BI Analyst

Airtel Africa

Dec 2023 - Present • 2 yrs 11 mos

Performing financial analysis and revenue projections based on history and current data, and reporting, focusing on crucial KPIs such as ARPU, Revenue by product, MoM, Mtd, Ytd metrics that help in determining the financial health of the OpCO, identifying key segments and products to push to enhance revenue generation of the OpCO in the Telco Industry. Analyzed customer data, identifying different behaviours among the Corporate, SME, and Public customers' sales pipeline channels, enabling customer segmentation, influencing implementations of better marketing strategies that resulted in net adds of 5%-10% month on a month-on-month basis. Analyzing customer data to determine churn rates and other KPIs that gave insights on ways to ensure customer retention, such as providing discounts on our products, and reducing churn rate to less than 2%. Using SQL in querying and analyzing the subscriber lifecycle, unearthing key insights on REC activity and status, helping track the usage of our products among customers in 30, 60, and 90 days since onboarding. Using SQL and the Fractal platform to analyze enterprise data that sheds light on new potential segments to tap into, and monthly gross adds into Airtel’s market share in the Telco industry. Built ad hoc dashboards summarizing the financial performance of the Opco, indicating KPI’s that are of major focus for Directors and MD in decision-making. Did ad hoc product analysis, which shed light on the best-performing products and those that had growth potential, especially FWA and 5G.