index.html

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    
    <!--💡UPDATE: Change the title to your name-->
    <title>Omoga | Data and IT Portfolio</title>
      
    <!--💡UPDATE: Add your favicon here. You can generate one at realfavicongenerator.net-->
    <link rel="icon" type="image/png" href="/favicon.ico">
    <link rel="apple-touch-icon" href="/favicon.ico">
    
    <!-- Google Fonts for Elegant Typography -->
    <link rel="preconnect" href="https://fonts.googleapis.com">
    <link rel="preconnect" href="https://fonts.gstatic.com" crossorigin>
    <link href="https://fonts.googleapis.com/css2?family=Lato:wght@300;400;700&family=Playfair+Display:wght@500;700&display=swap" rel="stylesheet">
    
    <!-- Font Awesome for Icons -->
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.4.2/css/all.min.css">
    
    <!-- Your Stylesheet -->
    <link rel="stylesheet" href="assets/css/style.css">
</head>
<body>

<!-- HEADER SECTION -->
<header>
    <div class="container">
        <!--💡UPDATE: Change to your name and title-->
        <h1>Benard Onyango Omoga</h1>
        <p>Data Analyst | IT Specialist | Web Developer | Software Engineer</p>
        <div class="social-links">
            <!--💡UPDATE: Add your social media links and CV file-->
            <a href="https://www.linkedin.com/in/benard-omoga-870b77145/" target="_blank" title="LinkedIn"><i class="fab fa-linkedin"></i></a>
            <a href="https://github.com/Amollo1" target="_blank" title="GitHub"><i class="fab fa-github"></i></a>
            <a href="https://www.youtube.com/@DataWithOmoga" target="_blank" title="YouTube"><i class="fab fa-youtube"></i></a>
            <a href="assets/Benard_Omoga_CV_DataAnalyst.pdf" download title="Download CV"><i class="fas fa-file-arrow-down"></i></a>
        </div>
    </div>
</header>

<!-- NAVIGATION -->
<nav>
    <div class="container">
        <ul>
            <li><a href="#about">About</a></li>
            <li><a href="#projects">Projects</a></li>
            <li><a href="#skills">Skills</a></li>
            <li><a href="#contact">Contact</a></li>
        </ul>
    </div>
</nav>

<!-- ABOUT SECTION -->
<section id="about" class="section">
    <div class="container">
        <h2>About Me</h2>
        <div class="about-content">
            <!--💡UPDATE: Change the image to your own profile photo in assets/images/-->
            <img src="assets/images/Profile Photo.jpg" alt="Your Name" class="profile-photo">
            <div class="about-text">
                <!--💡UPDATE: Write your own 'About Me' text here-->
                <p> 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.</p>
                <p>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.</p>
            </div>
        </div>
    </div>
</section>

<!-- PROJECTS SECTION -->
<section id="projects" class="section">
    <div class="container">
        <h2>My Projects</h2>
        <div class="projects-grid">

            <!--💡UPDATE: Replace this with your own project. Add as many as you like!-->
            
              <!-- Project 1 -->
            <div class="project-card">
                <img src="assets/images/Executive_Overview.jpeg" alt="Portfolio Website">
                <div class="project-card-content">
                    <h3>Kenya Mobile Money & Agent Network Intelligence | Power BI</h3>
                    <p>
                        Kenya's mobile-money agent network processed approximately <strong>KSh 722.5 billion monthly in 2025</strong>, yet average agent commissions fell to ~<strong>KSh 112,244 annually</strong> as the network expanded, raising an important question: <strong>how profitable is the agent network, where is it performing well, and where is it facing financial or operational risk?</strong><br><br>

                        To answer this, I built an end-to-end analytics pipeline covering <strong>data modelling, synthetic data engineering, analysis, and business intelligence</strong>. Using <strong>Python and SQL</strong>, I designed and populated the analytical database, applied <strong>DAX</strong> for business metrics, and developed an interactive <strong>Power BI dashboard</strong> to uncover profitability, performance, geographic, and operational insights.<br><br>

                        The project was managed with <strong>Git for version control</strong>, with findings translated into actionable insights through <strong>professional report writing</strong>.<br><br>

                        <strong>Skills Demonstrated:</strong> Python • SQL • DAX • Data Modelling • Power BI • Git • Data Analysis • Report Writing
                    </p>
                    <div class="project-buttons">
                        <a href="https://github.com/Amollo1/kenya-mobile-money-agent-analytics/blob/master/README.md" target="_blank" class="btn">Documentation</a>
                        <a href="https://youtu.be/HYNL4RsWCZg" target="_blank" class="btn btn-secondary">View Project</a>
                    </div>
                    </div>
                </div>

             <!-- Project 2 -->
            <div class="project-card">
                <img src="assets/images/01_executive_overview.png" alt="Portfolio Website">
                <div class="project-card-content">
                    <h3>NorthPeak Retail - Profitability Decline Analysis | Power BI</h3>
                    <p>
                        NorthPeak Retail grew total sales by <strong>22% over three years</strong>, yet its profit margin fell from ~<strong>19% to ~12.5%</strong> in that same period, raising an important question: <strong>which products, regions, discount practices, or customer segments were driving profit down while revenue kept rising?</strong><br><br>

                        To answer this, I led an end-to-end Business Analyst engagement covering <strong>requirements gathering, data modelling, synthetic data engineering, statistical analysis, and business intelligence</strong>. I authored a full Business Requirements Document and stakeholder RACI map, designed a <strong>PostgreSQL star-schema database</strong>, and generated a 69,000+ row synthetic transaction dataset. Using <strong>SQL and Python</strong>, I identified and statistically validated three root causes of the margin decline (regression, correlation, and hypothesis testing), applied <strong>DAX</strong> for weighted business metrics, and developed an interactive 5-page <strong>Power BI dashboard</strong> surfacing profitability, discount, regional, and customer-segment insights.<br><br>

                        The project was managed with <strong>Git for version control</strong>, with findings translated into a quantified business recommendations report estimating over <strong>KES 60M</strong> in potential annual profit recovery through <strong>professional report writing</strong>.<br><br>

                        <strong>Skills Demonstrated:</strong> SQL • Python • DAX • Data Modelling • PostgreSQL • Power BI • Git • Business Analysis • Statistical Analysis • Report Writing
                    </p>
                    <div class="project-buttons">
                        <a href="https://github.com/Amollo1/NorthPeak-Retail-Profitability" target="_blank" class="btn">Documentation</a>
                        <a href="https://github.com/Amollo1/NorthPeak-Retail-Profitability" target="_blank" class="btn btn-secondary">View Project</a>
                    </div>
                </div>
            </div>
            
            <!-- Project 3 -->
             <div class="project-card">
                <!--💡UPDATE: Add a preview image of your project to assets/images/ -->
                <img src="assets/images/HR Dashboard Image.png" alt="Sales Trend Analysis">
                <div class="project-card-content">
                    <h3>HR Analytics Dashboard | Tableau Business Intelligence Project</h3>
                    <p>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.</p>
                    <div class="project-buttons">
                        <!--💡UPDATE: Add link to your project's code/documentation on GitHub-->
                        <a href="https://github.com/Amollo1/HR-Analytics-Python-Tableau/blob/master/README.md" target="_blank" class="btn">Documentation</a>
                        <!--💡UPDATE: Add link to your live dashboard (e.g., Power BI, Tableau Public)-->
                        <a href="https://public.tableau.com/app/profile/benard.omoga/viz/HRDashboard_17814835268860/HRDashboard" target="_blank" class="btn btn-secondary">View Dashboard</a>
                    </div>
                </div>
            </div>

            <!-- Project 4 -->
            <div class="project-card">
                <img src="assets/images/Sales_System_Dashboard.png" alt="Sales and Inventory anagement System">
                <div class="project-card-content">
                    <h3>Retail Sales & Profit Management System | Python, Streamlit & SQLite</h3>
                    <p>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.</p>
                    <div class="project-buttons">
                        <a href="https://github.com/Amollo1/retail-sales-profit-management-system/blob/master/Executive_summary.pdf" target="_blank" class="btn">Documentation</a>
                        <a href="https://omoga-digi-retail-system.streamlit.app/" target="_blank" class="btn btn-secondary">View Shop System</a>
                    </div>
                </div>
            </div>

            <!-- Project 5 -->
            <div class="project-card">
                <img src="assets/images/Sales_Dashboard.jpeg" alt="Project Four Preview">
                <div class="project-card-content">
                    <h3>FNP Sales Trends Analysis Dashboard | Excel Business Intelligence Project</h3>
                    <p>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.</p>
                    <div class="project-buttons">
                        <a href="https://github.com/Amollo1/fnp-sales-trends-analysis-excel-dashboard/blob/master/Executive_Summary.pdf" target="_blank" class="btn">Documentation</a>
                        <a href="https://github.com/Amollo1/fnp-sales-trends-analysis-excel-dashboard/blob/master/Excel%20Dashboard.xlsx" target="_blank" class="btn btn-secondary">View Dashboard</a>
                    </div>
                </div>
            </div>

            <!-- Project 6 -->
            <div class="project-card">
                <img src="assets/images/dbt.png" alt="Portfolio Website">
                <div class="project-card-content">
                    <h3>End-to-End dbt & Databricks Data Engineering Project | Modern Analytics Engineering Pipeline</h3>
                    <p>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.</p>
                    <div class="project-buttons">
                        <a href="https://github.com/Amollo1/end-to-end-dbt-databricks-data-engineering-project/blob/master/README.md" target="_blank" class="btn">Documentation</a>
                        <a href="https://notebooklm.google.com/notebook/3823f3b7-8063-4ce2-aef3-a923eba3c16a/artifact/670392ef-a53c-41db-85d1-f91c8e2f5dc1?utm_source=nlm_web_share&utm_medium=google_oo&utm_campaign=art_share_1&utm_content=&utm_smc=nlm_web_share_google_oo_art_share_1_&pli=1" target="_blank" class="btn btn-secondary">dbt Project Roadmap</a>
                    </div>
                    </div>
                </div>

        </div>
    </div>
</section>

<!-- SKILLS SECTION -->
<section id="skills" class="section">
    <div class="container">
        <h2>Technical Skillset</h2>
        <div class="skills-table">
            
            <!--💡UPDATE: Customize your skills in each category-->
            <!-- Column 1: Data Visualization -->
            <div class="skill-column">
                <div class="skill-header">
                    <i class="fas fa-chart-pie"></i>
                    <h3>Data Analysis and Visualization</h3>
                </div>
                <ul class="skill-list">
                    <li>Data Cleaning & Preparation</li>
                    <li>Statistical Analysis</li>
                    <li>Data Visualization & Reporting</li>
                    <li>Database & Querying</li>
                    <li>Tools & Technologies</li>
                </ul>
            </div>

            <!-- Column 2: Data Analysis -->
            <div class="skill-column">
                <div class="skill-header">
                    <i class="fas fa-search-plus"></i>
                    <h3>Software Engineering</h3>
                </div>
                <ul class="skill-list">
                    <li>Programming</li>
                    <li>Software Development</li>
                    <li>Database Development</li>
                    <li>Version Control</li>
                    <li>Cloud & Deployment</li>
                </ul>
            </div>

            <!-- Column 3: Data Modeling & ETL -->
            <div class="skill-column">
                <div class="skill-header">
                    <i class="fas fa-cogs"></i>
                    <h3>Web Development</h3>
                </div>
                <ul class="skill-list">
                    <li>Front-End Development</li>
                    <li>Back-End Development</li>
                    <li>Web Frameworks & Platforms</li>
                    <li>Full-Stack Concepts</li>
                    <li>Web Operations</li>
                </ul>
            </div>

        </div>
    </div>
</section>

<!-- CONTACT FORM SECTION -->
<section id="contact" class="section">
    <div class="container">
        <h2>Send me a message</h2>
        
        <!--💡UPDATE: Go to formsubmit.co and replace the email with your own-->
        <form action="https://formsubmit.co/benardomoga86@gmail.com" method="POST" class="contact-form">
            <p> 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.

</p>

            <!-- Form Fields -->
            <div class="form-group">
                <label for="name">Name</label>
                <input type="text" name="name" id="name" placeholder="Your name" required>
            </div>
            <div class="form-group">
                <label for="email">Email</label>
                <input type="email" name="email" id="email" placeholder="Your email" required>
            </div>
            <div class="form-group">
                <label for="subject">Subject</label>
                <input type="text" name="subject" id="subject" placeholder="Subject" required>
            </div>
            <div class="form-group">
                <label for="message">Message</label>
                <textarea name="message" id="message" rows="6" placeholder="Your message" required></textarea>
            </div>
            
            <!-- Submit Button -->
            <button type="submit" class="btn">Send Message</button>

        </form>
    </div>
</section>

<!-- FOOTER -->
<footer>
    <div class="container">
        <!--💡UPDATE: Change the year and your name-->
        <p>&copy; 2026 Benard Onyango Omoga. All rights reserved.</p>
    </div>
</footer>

<script src="assets/js/main.js"></script>

</body>
</html>