# Ekene Okoli Portfolio

> Ekene Okoli is a Data Analyst and Frontend Developer based in Lagos, Nigeria, turning complex data into clear business insights and building user-focused web applications.

Expertise includes Excel, SQL, Power BI, React, TypeScript, and Tailwind CSS. This is a personal portfolio showcasing data analysis and web development projects.

## Portfolio

- [Homepage](https://ekene-dev.com/): About Ekene, selected work, experience, and contact information.

## Projects

- [Sales Performance Dashboard](https://ekene-dev.com/project/sales-performance-dashboard/): Comprehensive Excel dashboard analyzing sales performance across multiple regions with KPIs, trend analysis, and forecasting. Enabled real-time monitoring of revenue metrics and identified underperforming segments. Tools: Excel, Pivot Tables, Charts, Conditional Formatting.
- [Customer Behavior Analysis](https://ekene-dev.com/project/customer-behavior-analysis/): SQL-based analysis of customer purchase patterns using complex joins, CTEs, and aggregations. Uncovered key insights about customer lifetime value, churn prediction, and purchasing trends. Tools: SQL, CTEs, Joins, Aggregations.
- [Business Intelligence Dashboard](https://ekene-dev.com/project/business-intelligence-dashboard/): Interactive Power BI dashboard providing executive-level insights into operational efficiency, financial metrics, and departmental KPIs. Features drill-down capabilities and automated data refresh. Tools: Power BI, DAX, Data Modeling, Visualization.
- [E-commerce Analytics Report](https://ekene-dev.com/project/ecommerce-analytics-report/): Story-driven data visualization project analyzing e-commerce performance, customer journey, and conversion funnels. Created compelling visual narratives for stakeholder presentations. Tools: Data Visualization, Excel, Storytelling, Charts.
- [Operational Efficiency Analysis](https://ekene-dev.com/project/operational-efficiency-analysis/): Analyzed operational data using SQL, identifying key performance metrics that guided executive planning and led to a 15% increase in efficiency. Delivered actionable insights for resource optimization. Tools: SQL, Performance Metrics, Data Analysis, Reporting.
- [Patient Data Validation Project](https://ekene-dev.com/project/patient-data-validation/): Successfully led the team in a data validation for patient medical records after migration of patient information, thus leading to accurate data integrity. Ensured 99.8% data accuracy post-migration. Tools: Data Validation, SQL, Quality Assurance, Healthcare Data.
- [Patient Data Monitoring Dashboard](https://ekene-dev.com/project/patient-monitoring-dashboard/): Built interactive dashboards in Excel that enabled real-time monitoring of patient data validation and reduced manual reporting hours by 20%. Streamlined quality assurance workflows. Tools: Excel, Dashboards, Real-time Monitoring, Automation.
- [Nurses Rota – Iwosan Lagoon Hospitals](https://ekene-dev.com/project/nurses-rota/): A workforce management system for nursing departments that automates rota generation, enforces ward safety rules, handles leave management, and provides a layered approval workflow. Built for Iwosan Lagoon Hospitals to ensure safer staffing. Tools: React, TypeScript, Tailwind CSS, Workforce Automation.
- [Jollof Station](https://ekene-dev.com/project/jollof-station/): A vibrant food platform celebrating African cuisine, featuring menu browsing, restaurant discovery, and an appetizing visual experience. Designed with a warm, inviting aesthetic and smooth, intuitive navigation. Tools: HTML, CSS, JavaScript, Responsive Design.
- [Iwosan Innovation Hub](https://ekene-dev.com/project/iwosan-innovation-hub/): A professional web presence for an innovation hub connecting entrepreneurs, startups, and tech enthusiasts. Features program listings, event showcases, and community engagement sections with a modern, clean design. Tools: HTML, CSS, JavaScript, Responsive Design.
- [Lagoon Hospitals – Website Redesign](https://ekene-dev.com/project/lagoon-hospitals/): A professional multi-page website for Iwosan Lagoon Hospitals featuring appointment booking, service listings, facility showcases, and career pages. Built with a clean, modern design focused on trust and accessibility for a world-class healthcare provider. Tools: React, TypeScript, Tailwind CSS, Responsive Design.
- [LocalDrive](https://ekene-dev.com/project/localdrive-app/): A full-featured driving platform that connects learners with certified instructors in their neighborhood. Features include instructor matching, secure online payments, lesson scheduling, and digital progress tracking for a modern driving education experience. Tools: React, TypeScript, Tailwind CSS, Responsive Design.

## Profiles

- [LinkedIn](https://linkedin.com/in/ekene-okoli): Ekene Okoli's professional profile.
- [GitHub](https://github.com/khennyyb): Ekene Okoli's code repositories.