OKEKE CHIOMA PRECIOUS

DATA ANALYST

Lagos, NG.

About

Highly analytical Data Analyst with 2+ years of experience, specializing in leveraging Excel, SQL, and Power BI to transform complex financial and operational data into actionable insights. Expert in data cleaning, validation, and dashboard creation, with a strong accounting background that ensures precision in reporting, reconciliation, and variance analysis. Adept at collaborating with cross-functional teams to deliver data-driven solutions that enhance business decision-making.

Projects

Airline Delay Performance & Operational Efficiency Analysis

→

Summary

Cleaned and transformed flight-level data, created derived fields for distance category, delay difference and performance classification, and prepared the dataset for analysis. Built Excel/Power BI visualizations to compare airline performance, arrival delays, distance categories and delay status.

World Layoffs Data Cleaning & Analysis

→

Summary

Built a staging workflow for raw layoff data and removed duplicate records using ROW_NUMBER() and partitioning logic. Standardized text fields with TRIM and converted date values using TRY_CONVERT to improve data consistency and analytical readiness.

Financial & Business Reporting Dashboard

→

Summary

Designed dashboard-style reporting views for financial and operational KPIs using PivotTables, charts, filters and summary metrics. Performed variance and trend analysis to highlight changes in revenue, expenses, receivables/payables and other management indicators.

Work

JILNAS LTD Nigeria

|

Accountant

Lagos, Lagos State, Nigeria

→

Summary

Managed comprehensive accounting functions, including financial reporting, data analysis, and cross-functional collaboration, to ensure accurate and timely financial operations.

Highlights

Prepared and consolidated monthly management accounts, financial reports, and income statements, integrating data from diverse sources to produce accurate, management-ready reports.

Utilized advanced Excel functions for data organization, cleaning, reconciliation, and analysis of financial data, investigating variances to maintain precise reporting schedules.

Managed comprehensive accounts payable and receivable processes, supporting payroll reporting and ensuring 100% data completeness and consistency for recurring financial reports.

Implemented Excel formulas, sorting, filtering, and structured reporting techniques, reducing manual errors by 15% and enhancing the reliability of financial analysis.

Collaborated cross-functionally with HR and senior management on critical payroll, pension, and tax-related reporting, strengthening data accuracy and compliance.

OpenSF Nonprofit Tech Lab

|

Volunteer Data Analyst

Lagos, Lagos State, Nigeria

→

Summary

Provided data analysis and reporting support for a nonprofit organization, focusing on data cleaning, visualization, and stakeholder communication.

Highlights

Cleaned and standardized complex spreadsheet datasets, identifying and resolving duplicates, missing values, and inconsistent formats to ensure data integrity for analysis.

Developed dynamic Excel PivotTables, PivotCharts, and summary reports, transforming raw data into clear KPIs and actionable insights for stakeholders.

Implemented advanced Excel lookup and conditional formulas to efficiently combine datasets, validate records, and automate recurring calculations for enhanced reporting accuracy.

Designed structured Excel reporting templates incorporating filters, conditional formatting, and validation checks, reducing reporting errors by 20% and improving data consistency.

Translated complex analytical findings into clear business language, presenting results to non-technical stakeholders to facilitate understanding of key performance indicators and trends.

Intercontinental Exchange (ICE)

|

Data Analyst

Lagos, Lagos State, Nigeria

→

Summary

Led data analytics projects, focusing on workflow optimization, data consolidation, and business intelligence reporting for various internal teams.

Highlights

Managed and prioritized analytics tasks using GitHub project workflows, enhancing team coordination and achieving a 34% increase in project completion rates.

Configured MicroStrategy views, consolidating 43,218 reference and transaction records into intuitive, stakeholder-friendly dashboards for rapid access to critical business information.

Performed biweekly sales and inventory analysis for marketing and finance teams, delivering structured, accurate, and on-schedule reports to inform strategic decisions.

Transformed complex operational data into concise reports and dashboard views, providing essential insights to support recurring business reviews and executive decision-making.

Education

Abia State University, Nigeria

Umuahia, Abia State, Nigeria
→
Bachelor of Science (B.Sc.) Accounting

Languages

English

Certificates

Scrum Fundamentals Certified

Scrum.org

Skills

Professional Skills

Attention to Detail, Problem Solving, Analytical Thinking, Stakeholder Communication, Teamwork, Time Management, Accuracy, Process Improvement.

Excel & Spreadsheet Analytics

Microsoft Excel, PivotTables, PivotCharts, XLOOKUP, VLOOKUP, INDEX/MATCH, SUMIFS/COUNTIFS, IF/IFS, IFERROR, Conditional Formatting, Data Validation, Sorting/Filtering, Dashboard Design, KPI Reporting.

Data Analysis & Reporting

Data Cleaning, Data Transformation, Data Validation, Data Reconciliation, Exploratory Analysis, Trend Analysis, Variance Analysis, KPI Tracking, Business Reporting, Requirements Gathering, Data Storytelling.

Data Visualization

Power BI, Tableau, Excel Charts, Interactive Dashboards, Slicers, KPI Cards, Visual Reporting.

SQL & Databases

SQL Server, MySQL, SELECT, JOINS, GROUP BY, HAVING, CASE, Subqueries, CTEs, Window Functions, ROW_NUMBER, Data Cleaning, Data Transformation.

Python

Python, Jupyter Notebook, Pandas Fundamentals, Data Cleaning, Exploratory Analysis, Basic Visualization.

Data & Collaboration Tools

GitHub, GitLab, CRM Systems.

Data Methods & Development

Data Cleaning, Data Validation, ETL Concepts, KPI Analysis, Descriptive Statistics, Business Reporting, Dashboard Development.