Automated VAS Transaction Intelligence Dashboard

Developed a real-time BI solution to monitor and analyse Value-Added Services (VAS) across major
telecom providers (MTN & Airtel). I engineered a pipeline that converted millions of raw SQL rows
into a high-level strategic tool for monitoring liquidity and transaction health.
Key Technical Contributions:
• ETL & Data Engineering: Leveraged SQL for complex data extraction and used Power Query
to standardize inconsistent date formats and status logs from multiple telecommunications
transaction in databases.
• Multi-Channel Analysis: Visualized “Account-to-Wallet” flows and utility payments (TV, URA,
Electricity, Water), providing a 360-degree view of digital revenue.
• Failure Rate Monitoring: Designed a “Root Cause” tracker to identify peak failure hours,
allowing technical teams to reduce “Pending” transactions and improve user experience.
• Stakeholder Impact: Enabled leadership to identify “Top N” revenue drivers and peak
service hours, shifting the team from manual daily reporting to automated, actionable
insights.
VAS Reporting Project
• Automated Daily Reporting: Developed a SQL-to-Power BI pipeline to track daily VAS
transactions, reducing reporting time by 95%.
• Transactional Integrity: Standardized status tracking for MTN & Airtel (Wallet-to-Account,
Airtime, Utilities), ensuring 100% data accuracy for successful vs. pending transactions.
• Operational Insights: Identified peak transaction windows and failure trends, providing a
“why” behind system downtime to support technical infrastructure upgrades.
• Revenue Growth: Built “Top N” product visualizations that helped stakeholders prioritize
high-margin services like ATW, Airtime top-ups, URA and Electricity payments.