OGBAN, UTU SOLOMON

OGBAN, UTU SOLOMON

Data Analyst

Abuja, NG.

About

Highly analytical and detail-oriented Data Analyst with 2+ years of experience transforming complex datasets into actionable insights, specializing in data cleaning, statistical modeling, and dynamic visualization. Expertly leverages SQL, Excel, and Power BI to develop interactive dashboards and conduct in-depth churn analysis, consistently driving data-informed business decisions and supporting strategic growth within the fintech sector. Passionate about crafting compelling data narratives that empower senior leadership and optimize operational efficiency.

Education

Kaduna State University

Kaduna, Kaduna State, Nigeria
→
Masters Conflict, Peace & Strategic Studies Grade: 4.07

University of Calabar

Calabar, Cross River State, Nigeria
→
B.A. (Hons) History & International Studies Grade: 3.68

Samco De Best Cyber Link

Akamkpa, Cross River State, Nigeria
National Diploma Computer

Work

Institute Of Human Virology

|

Data Entry Assistant

Nigeria

→

Summary

- Accurately and efficiently input data from source documents into Excel sheets and online database. - Verify data accuracy by cross-checking information to ensure clean and accurate data.

Dayfigurez Consult Ltd

|

Data Analyst Intern

Abuja, FCT, Nigeria

→

Contract

Summary

Performed end-to-end data cleaning and validation, developed comprehensive visualizations, and translated complex technical findings into actionable Data Stories for client reports.

Highlights

Performed end-to-end data cleaning and validation on large datasets using SQL and Excel, ensuring 100% data integrity for critical client reports.

Developed a comprehensive suite of visualizations to uncover hidden patterns in consumer behavior and market trends, providing strategic insights.

Assisted in the preparation of business intelligence briefings by translating complex technical findings into actionable "Data Stories" for non-technical stakeholders, improving communication.

Daynetworks Telecom

|

Junior Data Analyst

Abuja, FCT, Nigeria

→

Contract

Summary

Engineered complex SQL queries and Excel DAX formulas to analyze telecom industry metrics, collaborating with Marketing teams to identify high-risk churn segments and automate billing data transformation.

Highlights

Engineered complex SQL queries and Excel DAX formulas to analyze telecom industry metrics, providing robust data for strategic planning.

Collaborated closely with simulated Marketing teams to identify high-risk churn segments, delivering insights that informed targeted retention strategies.

Utilized Power Query to automate the transformation of raw billing data into structured datasets for monthly performance reviews, significantly improving efficiency.

TechyJaunt

|

Junior Data Analyst

Abuja, FCT, Nigeria

→

Contract

Summary

Completed an intensive, hands-on residency focused on advanced data manipulation, built a comprehensive analytics dashboard, and refined data cleaning techniques to ensure temporal accuracy in financial reporting.

Highlights

Completed an intensive, hands-on residency focused on advanced data manipulation using PostgreSQL and SQL Server, enhancing technical proficiency.

Built the PathIQ Comprehensive Analytics Dashboard, a multi-visual grid system used to track project milestones and technical KPIs, improving project oversight.

Refined data cleaning techniques by resolving logic errors in historical invoice tables, ensuring temporal accuracy in financial reporting and data reliability.

Certificates

Data Analysis Internship Completion Certification

Dayfigurez Consult

TechyJaunt Data Analytics Certificate of Completion

TechyJaunt

Certificate of Completion: Data Analytics 1

LinkedIn Learning

AI Augmented Professional Development Skill

Certificate of National Service

National Youth Service Corps

Skills

Data Analysis & Business Intelligence

Data Cleaning, Data Validation, Statistical Modeling, Data Visualization, Churn Analysis, KPI Monitoring, Market Trend Analysis, Business Intelligence, Data Transformation, Data Storytelling, Trend Forecasting, Analytical Thinking, Problem-Solving.

Professional Skills

Diplomatic Skills, Interpersonal Skills, Creative Thinking, Integrity, Accountability, Cross-functional Collaboration, Strategic Decision-Making, Stakeholder Management.

Tools & Technologies

SQL (PostgreSQL, SSMS), Excel, Power BI, Google Analytics, Tableau, Python.

Interests

Personal Interests

Reading, Writing, Travelling, Researching, Learning New Trends, Problem Solving.

References

Available upon request

Available upon request

Languages

English

Native

French

Basic

Projects

Advanced Health Systems Analytics & Mobile Reporting

Advanced Health Systems Analytics & Mobile Reporting

Contract

Summary

Transformed a fragmented health dataset into a multi-layered analytical ecosystem, focusing on systemic risk factors and organ health stability. Managed a full ETL lifecycle in Power BI, converting raw patient records into a structured schema that supports deep cross-filtering between lifestyle behaviors and clinical conditions. Developed an AI-driven Risk Prediction Model to identify top-tier influencers. My analysis shows patients’ health category and their likelihood to face organ damage, providing clear targets for clinical intervention. Built a sophisticated "What-If" Scenario tool. Using DAX-integrated sliders for smoking and lifestyle reduction, I created a real-time simulation that calculates the immediate reduction in projected risk, turning data into a tool for patient advocacy. Then i engineered DAX measures to automatically compare individual patient metrics against moving population averages, identifying outliers through Anomaly Detection to prevent medical oversights. Finally, i analyzed the behavioural patterns such as smoking intensity funnel to visualize the tipping point where lifestyle habits move a patient from Moderate to Critical risk.

ZuriGlow Cosmetics – Market Expansion Analysis

ZuriGlow Cosmetics – Market Expansion Analysis

Freelance

→

Summary

Designed and built a two-page interactive Excel dashboard analyzing survey data from 5,000 respondents to support ZuriGlow Cosmetics' market expansion strategy into the Nigerian footwear category. Consolidated raw survey responses into pivot/aggregation tables and built an Executive Dashboard (KPI scorecards, budget price distribution, purchase frequency, and key purchase-factor charts) alongside a Respondents Preference Dashboard (demographic breakdowns, brand preference, and trust-by-brand analysis). Synthesized findings into a written key-insights panel highlighting customer segments, pricing sweet spots, and cross-category conversion opportunities, translating raw data into actionable business recommendations for stakeholders.

End-to-End Enterprise BI Solution: Telecommunications Operational & Financial Analytics

End-to-End Enterprise BI Solution: Telecommunications Operational & Financial Analytics

Contract

→

Summary

Developed an end-to-end business intelligence solution analyzing 10,000 active and inactive subscriber records for Daynetworks LTD, a regional telecommunications firm. Spanning Q4 2024 to Q1 2026 , the project builds a multi-dashboard architecture to uncover critical operational vulnerabilities, tracking an overall revenue base of ₦503.88M. The analysis successfully diagnosed an 80% single-month revenue collapse in March 2026 and highlighted structural weaknesses in customer service level agreements (SLAs) alongside aggressive subscriber churn. Business Problem & Core Objectives Daynetworks masked deep structural deterioration under a stable ₦40M–44M monthly baseline across 2025. This project was initiated to create data visibility in four core domains: Revenue Visibility: Mapping billing performance trends against historical benchmarks. Customer Intelligence: Assessing lifetime value, tenure distribution, and churn risk across tiered product offerings. Operational Excellence: Measuring support ticket workflows against strict SLA timelines. Strategic Recovery: Formulating an emergency 90-day intervention strategy to arrest a rapid subscriber drop down to 1,227 active accounts.

PathIQ Comprehensive Analytics Dashboard

PathIQ Comprehensive Analytics Dashboard

→

Summary

Developed a multi-visual grid system and comprehensive analytics dashboard designed to monitor and track project milestones, technical KPIs, and team performance metrics. Managed database operations using PostgreSQL and SQL Server to integrate various data pipelines, ensuring seamless data flow and clean reporting. Implemented advanced data cleansing procedures to resolve historical logic discrepancies in invoice tables, leading to highly reliable temporal reporting. The dashboard empowered cross-functional teams with dynamic tracking tools, dramatically improving overall project oversight and operational efficiency.