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.

Work

Fortera Digital
|

Data & Business Analyst (Remote)

Abuja, FCT, Nigeria

→

Summary

Led data-driven initiatives to define, monitor, and report key performance indicators, designing interactive dashboards to facilitate strategic decision-making and optimize data collection processes for senior leadership.

Highlights

Collaborated with cross-functional teams to define and monitor key performance indicators (KPIs) through automated reporting systems, enhancing transparency and accountability.

Designed and maintained interactive dashboards that effectively track business growth metrics, enabling data-driven decision-making for senior leadership.

Streamlined data collection processes from diverse digital service streams, establishing a "single source of truth" for company analytics and improving data reliability.

Dayfigurez Consult Ltd
|

Data Analyst Intern

Abuja, FCT, Nigeria

→

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
|

Data Analyst (Project-Based)

Abuja, FCT, Nigeria

→

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
|

Data Analyst (Project Based)

Abuja, FCT, Nigeria

→

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.

Education

Kaduna State University
Kaduna, Kaduna State, Nigeria

Masters

Conflict, Peace & Strategic Studies

University of Calabar
Calabar, Cross River State, Nigeria

B.A. (Hons)

History & International Studies

Samco De Best Cyber Link
Akamkpa, Cross River State, Nigeria

National Diploma

Computer

Certificates

Certificate of National Service
Data Analysis Internship Completion Certification

Issued By

Dayfigurez Consult

TechyJaunt Data Analytics Certificate of Completion

Issued By

TechyJaunt

Certificate of Completion: Data Analytics 1
AI Augmented Professional Development Skill

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.

Tools & Technologies

SQL (PostgreSQL, SSMS), Excel, Power BI, Google Analytics, Tableau, Python (Jupyter, Pandas, Seaborn), Power Query, DAX.

Professional Skills

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

Interests

Personal Interests

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

References

Available upon request

Available upon request

Languages

English

Native

French

Conversational

Spanish

Basic

Projects

Advanced Health Systems Analytics & Mobile Reporting
Advanced Health Systems Analytics & Mobile Reporting

Contract

Summary

In this project, I transformed a fragmented health dataset into a multi-layered analytical ecosystem, focusing on systemic risk factors and organ health stability. Some technical achievements in this project include: ▶️ Architecting the Data Model: 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. ▶️ Predictive Risk Modeling: 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. ▶️ Dynamic Simulation Engine: 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. ▶️ Comparative Benchmarking: Engineered DAX measures to automatically compare individual patient metrics against moving population averages, identifying outliers through Anomaly Detection to prevent medical oversights. ▶️ Behavioral Correlation Mapping: 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.