• Smaila Amoanu

    Statistician | MS Access Instructor | Author & Blogger | 14K+ on YouTube

    Section image

    Career Objective

    Statistician specializing in time series, calibration, and interpretable ML. I build models that are not only accurate but diagnosable and deployable—linking theory to production-quality decisions in health and risk.

    Interest Areas

    • Information Technology (I.T)
    • Education & Research
    • Writing and Blogs
    • Entrepreneurship

    Research Interest

    • Probability & Measure

    • Statistical Inference (GLR/likelihood)

    • Time Series (ARMA/GARCH, VAR)

    • Biostatistics & Epidemiology
    • Financial Mathematics

    • Computational Statistics

    Join my Youtube page

    Welcome to my YouTube journey! Back in 2018, I embarked on an extraordinary adventure on YouTube, driven by my passion for sharing knowledge about Database Management with the world. It's been an incredible ride, filled with moments of genuine connection and joy, especially when I receive heartfelt testimonials from viewers whose lives have been positively impacted by my tutorials.

    My channel is a dedicated space where I freely share tutorials on essential topics such as Microsoft Access databases, Microsoft Excel, and SQL. I firmly believe that empowering individuals with the skills to understand, store, manage, and analyze data is pivotal for informed decision-making and making a real difference in the world.

    If you're eager to dive into the world of data management and unlock its potential, I invite you to explore my playlists by clicking the Tube placeholder.

    EXPLORE MY SAMPLE PROJECTS

    School Management Database System

    This system is a game-changer, offering robust functionality to streamline various aspects of school administration. From managing student records, handling school fees, facilitating examinations, and maintaining staff information to tracking attendance, processing payroll, and generating efficient reports with insightful visualizations – we've got it covered.

    Curious to explore more about this transformative solution? Click on the placeholder to experience the full demo firsthand.

    Church Management Database

    Designed as a multi-user database, this system is ideal for churches of all sizes, offering robust features to support various aspects of church management. Whether it's tracking member information, managing contributions, organizing events, or overseeing volunteer coordination, this system has you covered.

    Built to be shared over a LAN or Extranet, it ensures seamless collaboration among church staff and volunteers.

    Inventory Management Database

    The sysem is designed to simplify inventory management, this system empowers you to efficiently store and track products across multiple locations within your warehouse.

    Versatile in its application, this inventory system isn't limited to warehouses alone. It's equally effective for businesses of all kinds that deal with inventory management.

    Whether you're overseeing a bustling warehouse operation or managing inventory for your business, this system provides the tools you need for seamless tracking and organization.

    POS System (Older version)

    The system is designed with simplicity in mind, our POS software is a versatile solution suitable for a wide range of businesses, including shops, supermarkets, pharmacies, and both retail and wholesale operations.

    With its intuitive interface and robust functionality, our POS system streamlines transactions and enhances efficiency in your business operations. Whether you're processing sales, managing inventory, or tracking customer data, our POS software is equipped to handle it all.

    For information on the latest versions, do not hesistate to reach out.

    Section image

    Insurance technical price prediction using machine learning.

    In this project, I utilized the freMPL3 dataset to train predictive models for insurance technical price estimation. I employed KNN, Random Forest, and XG Boost algorithms for regression tasks, evaluating performance with RMSE and R-squared metrics. Preprocessing techniques like scaling and target encoding were applied, and model interpretation was facilitated through Partial Dependence Plot (PDP) and SHAP. Benchmarking revealed Random Forest and KNN as superior in explaining variability and predicting technical price, with contributions varying between genders. This comprehensive approach ensures accurate and interpretable insurance pricing decisions.

    Section image

    Simulating the impacts of malaria internvetion strategies in geita, tanazania using openmalaria.

    Controlling malaria in Geita is challenging due to widespread antimalarial drug resistance, exacerbated by economic constraints limiting the efficient deployment of interventions like case management, bednets, indoor residual spraying, and vaccines. The study aims to optimize intervention strategies by identifying the most cost-effective combination through OpenMalaria simulations, utilizing historical data from the region to evaluate effectiveness compared to VecNet baseline models.

    Access report here

    Section image

    Retrospective Impact Quantification of Malaria Interventions in Ghana—with an Emphasis on Indoor Residual Spraying (IRS).

    I quantified how much IRS contributed to reducing malaria transmission across Ghanaian districts by building complementary deterministic and stochastic transmission models. Parameterized with Malaria Atlas Project geospatial prevalence inputs, the models compared counterfactual scenarios (with/without IRS) and ran sensitivity analyses on key entomological and operational parameters. The results informed district-level targeting and cost-effectiveness guidance for malaria control.

    Section image

    Statistical Analysis of Government Expenditure Impacts on GDP using VAR and VECM

    I modeled the short- and long-run relationships between Ghana’s government expenditure and GDP using Vector Autoregression (VAR) and Vector Error-Correction Models (VECM). The workflow included stationarity testing (ADF/KPSS), lag selection (AIC/BIC), Johansen cointegration, estimation of VAR/VECM, and policy-oriented interpretation via impulse response functions (IRFs) and forecast error variance decomposition (FEVD)—clarifying how spending shocks propagate to output over time.

  • Research works

    In this section, explore a curated collection of my research endeavors, spanning from academic pursuits during college to personal projects.

    Essays

    1. Statistical analysis on the impacts of government expenditure on economicgrowth in Ghana using Vector Auto-regression (VAR) and cointegration Analysis.
    Thesis: KNUST-GHANA

    Click here to access report

     

    2. Detecting Counterfeit Banknote and its control prevalence in Sweden using the binary logistics regression algorithm.

    Description
    • Build a regression model in R to determine the status of a banknote as counterfeit or genuine
    using features of the bank note.
    • Determine those characteristics of banknotes such as Length, Left, Right, Bottom, Top and
    Diagonal measurements which has significant effects on its genuineness.

     

    3. Analyzing the impacts of financial status on students’ academic performance in the Kwame Nkrumah University of Science and Technology (KNUST).
    Description
    • Describe and explore the academic performance of students in the various income categories.
    • Use one-way ANOVA and the two-sample t test to compare the academic performances of
    students who owe fees and those that do not owe fees.

     

    4. Ghana crime distribution and forecasting analysis using time series and visualizations.

    Description
    • Build dashboard to summarize Ghana’s crime data from 2010 to 2021.
    • Use visualizations to spot the less stable cities in the country.
    • Use visualizations to identify the most pressing offences in the country.
    • Use ARIMA (2,1,1) to obtain a five-year forecast for Ghana’s crime rate.

     

    5. Predictive Modeling for Insurance Technical Price Estimation using the freMPL3 dataset in the freMPL (FrenchMotor Personal Line datasets) R package.

    Description

    •Training a predictive model to estimate the technical price, which represents the conditional expectation of claimAmount conditioned on Exposure=1.

    •Globally interpret the model, and locally interpret estimates of examples in the data.

    •Ascertaining predictive accuracy with the use of appropriate regression metrics such as the R-squared, and RMSE.

    •Benchmarking to choose the best performing machine learning model among (KNN, Random Forest and XG Boost).

    •Estimating some rows of the test data.

     

    Click here to access project report

     

    Workshops

    Academic and Business Symposium,(Learning strategies, how to write Project Work, Secret of success, CV writing-(OMEGABRAINS INTERNATIONAL), March 2020

     

    Starting a career in Data Science
    5th May, 2021 by KNUST SCISA


    Jobberman soft-skills seminar (zoom)
    23rd April, 2022 by Jobberman


    Modern Statistics and Machine Learning for Global Health
    22nd-24th February, 2024, Rwanda by AIMS Research & Innovation


    Multilateral Initiative of Malaria Conference
    22nd to 26th April, 2024, Rwanda

     

    Relevant Leadership Roles

    • Founder and Leader of Arkos Datateks, Christ Walk online ministry
    • Men ministry Leader (PIWC Reno, Nevada US)
    • Academic Board Head, Science Students Association, KNUST (2021 – 2022).
    • Deputy Electoral Commissioner, Ghana Association of Statistics Student, KNUST (2020-2021).
    • Boys’ Head Prefect, Obrachire Senior High Technical School , Ghana
  • My Top Programming Languages

    Section image

    R for Data Analytics

    Heavily used in my daily analytical and statistical routines.

    Section image

    Python for Data Analytics and visualization

    Used quite a lot for huge data science tasks that require appreciable level of automations nad visualizations.

    Section image

    SQL for Database handling

    Used in interacting with databases

    Section image

    Microsoft Visual Basic (VBA)

    I use VBA mostly in Microsoft Access Database development to enhance functionalities and automations.

    Section image

    Microsoft PowerBI

    For data visualization, analysis, modeling, and reporting, enabling me to derive insights and make data-driven decisions effectively.

  • Contact me

    Leave a message or email me for inquiries.

    525 SADLEIR WAY
    +233246635752