Benard Onyango Omoga

Data Analyst | IT Specialist | Web Developer | Software Engineear

About Me

Your Name

I am an IT professional specializing in data analysis, software development, and web applications. I focus on turning raw data and business requirements into practical digital solutions that improve efficiency and decision-making.

With strong experience in Python, SQL, Power BI, and modern web technologies, I build data-driven systems, interactive dashboards, and scalable web applications. This portfolio highlights my projects across data, IT systems, software engineering, and web development.

My Projects

Sales Trend Analysis

HR Analytics Dashboard | Tableau Business Intelligence Project

Developed an interactive Human Resources Analytics Dashboard in Tableau to analyze workforce demographics, employee attrition, performance, compensation, attendance, and recruitment trends. Data was generated using Python and Faker, then cleaned and transformed in Jupyter Notebook using Pandas and NumPy. The dashboard features KPI cards, interactive visualizations, and filters that provide actionable insights to support data-driven HR decision-making.

Documentation View Dashboard
Sales and Inventory anagement System

Retail Sales & Profit Management System | Python, Streamlit & SQLite

Developed a real-time retail sales and inventory management system for small businesses using Python, Streamlit, and SQLite. The application enables sales tracking, profit analysis, inventory management, transaction processing, and business performance reporting through an interactive dashboard. The project utilized Streamlit for the user interface, SQLite for data storage, Pandas for data processing and reporting, and Python for business logic and system automation.

Documentation View Shop System
Portfolio Website

Professional Data & IT Portfolio Website | HTML, CSS, JavaScript & FormSubmit

The website you are currently on was designed and developed by me to serve as a centralized digital portfolio showcasing my expertise in data analysis, IT systems, software engineering, and web development. The platform highlights my technical projects, professional skills, and career achievements while providing visitors with easy access to my GitHub repositories, LinkedIn profile, YouTube content, and direct contact channels. The project was built using HTML for structure, CSS for responsive and modern design, JavaScript for interactivity, and FormSubmit for contact form functionality.

Documentation View Portfolio
Project Four Preview

FNP Sales Trends Analysis Dashboard | Excel Business Intelligence Project

Developed an interactive sales analytics dashboard for Ferns and Petals (FNP) using Microsoft Excel to analyze revenue trends, customer behavior, product performance, delivery efficiency, and occasion-based sales patterns. The project utilized Power Query for data cleaning and transformation, Power Pivot for data modeling, Pivot Tables for analysis, and Excel dashboards for visualization and reporting.

Documentation View Dashboard
Portfolio Website

End-to-End dbt & Databricks Data Engineering Project | Modern Analytics Engineering Pipeline

Developed an end-to-end analytics engineering pipeline using dbt Core and Databricks, implementing the Medallion Architecture (Bronze, Silver, Gold) to transform raw data into clean, analytics-ready models. The project involved ingesting multiple datasets into Databricks, performing modular SQL transformations with Jinja, building reusable dbt macros, implementing data quality tests, seeds, and snapshots for historical tracking, and managing the complete development lifecycle using Git, GitHub, Visual Studio Code, Python, and uv. The project was structured following modern data engineering best practices and prepared for CI/CD deployment.

Documentation dbt Project Roadmap
Portfolio Website

End-to-End Data Pipeline with Apache Airflow | Modern Data Orchestration Project (Coming Soon)

🚧 Coming Soon This upcoming project will demonstrate the development of a production-ready end-to-end data pipeline using Apache Airflow as the workflow orchestration engine. The pipeline will automate data ingestion, transformation, validation, and delivery by integrating Apache Airflow, Databricks, dbt Core, Apache Spark, and Power BI. It will showcase automated DAG scheduling, task dependencies, data quality testing, monitoring, and end-to-end orchestration while leveraging Python, SQL, Git, GitHub, Visual Studio Code, Docker, and CI/CD best practices to build a scalable, maintainable, and enterprise-grade data engineering solution.

Documentation View Project

Technical Skillset

Data Analysis and Visualization

  • Data Cleaning & Preparation
  • Statistical Analysis
  • Data Visualization & Reporting
  • Database & Querying
  • Tools & Technologies

Software Engineering

  • Programming
  • Software Development
  • Database Development
  • Version Control
  • Cloud & Deployment

Web Development

  • Front-End Development
  • Back-End Development
  • Web Frameworks & Platforms
  • Full-Stack Concepts
  • Web Operations

Send me a message

Thank you for your interest in my work. Whether you have a question, a project proposal, or would like to explore potential collaboration opportunities, I would be pleased to hear from you. Feel free to get in touch through the contact form, and I will respond as soon as possible. Alternatively, you can connect with me on LinkedIn for professional inquiries, networking opportunities, or direct communication.