Wonder Akwei's Projects
Contact form with PHP backend & email notification. Features server-side validation, CSRF protection, & Google reCAPTCHA. MySQL storage & PHPMailer for email notifications. Styled with Bootstrap for responsive design.
Automated Traffic Data ETL: Python scripts convert, reformat, and upload traffic data to BigQuery via GCS. Terraform ensures efficient resource provisioning, and APScheduler automates daily cron jobs.
Optimize future bank marketing with Machine Learning analysis. Explore past campaign patterns, employ a data-driven approach to enhance effectiveness. Predict success in telemarketing for strategic development.
Designed an efficient banking database using PostgreSQL and pgAdmin. Focused on optimizing transaction management included key aspects like data modeling, database architecture, security, and performance.
Built a complete blog website using Laravel and Filament PHP. The project involved setting up a Laravel project, installing Filament, managing blog posts, customizing layouts, and adding features like user authentication, roles, likes, post views, search functionality, and a comments section. It's designed for scalability and user engagement.
Successfully connected HTML forms to MySQL using PHP. Featured a responsive signup system with validation, password hashing, and prevention of SQL injection. The interface was enhanced with Bootstrap and Font Awesome. Easy setup, customizable, and open for contributions.
Created a simple PDF to Word converter involved utilizing libraries that could handle PDF manipulation and text extraction. One popular library for working with PDFs in Python was PyPDF2, and for creating Word documents, python-docx was used.
Fraud Detection System for customer transactions. Leveraging exploratory data analysis, feature engineering, and advanced modeling techniques, the system provides a reliable solution to identify and prevent fraudulent transactions. Enhance security and safeguard financial transactions with this Fraud Detection model.
This Database Design and Optimization Project, utilizing PostgreSQL, encompassed a thorough initiative aimed at elevating data management. Through strategic enhancements to the database structure, performance improvements, and operational streamlining, the project has successfully transformed the system.
This project utilizes Diamonds Price Dataset from kaggle, featuring attributes like carat, cut, color, and clarity. Explore diverse diamond types and harness machine learning to predict prices. This project delves into diamond valuation through insightful data analysis.
I created this project to practice Docker containerization. It employs Express.js to build an HTTP server responding with 'Hello, I'm Wonder Akwei and I love data!' Containerizing the Node.js app ensures consistency and easy deployment in diverse environments.
A comprehensive data engineering pipeline, orchestrates data workflows with Apache Airflow, Python, Kafka, Zookeeper, Spark, and Cassandra. Containerized using Docker: to deploy and scale effortlessly. This Etsy API Data Pipeline extracts, processes, and analyzes Etsy marketplace dataβretrieving product listings, shop details, and reviews.
This project used Python for data analysis, constructing a model to distinguish real from fake news. Applying machine learning, it aimed to counter misinformation in the digital age. The process included data cleaning,EDA, preprocessing, feature engineering, model training, and evaluation.
Empower travel decisions! Elevate your journey with precise flight fare predictions using ML models. Uncover patterns, explore correlations, and benchmark algorithms for budget-friendly choices.
An implementation of the Grammar of Graphics in R
The Healthcare DBMS is a robust solution for managing patient records, appointments, staff, and medical supplies. Leveraging PostgreSQL, PgAdmin, and Docker, it ensures data integrity, HIPAA compliance, and offers a streamlined experience for healthcare professionals and administrators.
Built a Job Application System using PHP, MySQL, phpMailer, and reCAPTCHA. Streamlined the job application process with secure data submission, including personal details, resumes, and cover letters. Integrated advanced security measures like reCAPTCHA and CSRF protection for spam prevention and safeguarding against unauthorized form submissions.
This is a Laravel-based Task Manager application using Jetstream and Blade. The application includes two types of users: admins and normal users. Admins can manage all tasks, while normal users can only view and manage their own tasks.
This LibraryDBMS was developed using T-SQL and SQL Server, utilizing Microsoft SQL Server Management Studio for managing book loans, publishers, branches, borrowers, copies, and authors. The project included tailored stored procedures for efficient and organized operations in library management.
Free MLOps course from DataTalks.Club
Embarked on a database design journey with Northwind, MySQL, DBeaver, and Docker. Explored sample SQL queries and data analysis, with detailed documentation for installation, usage, and learning.
PDF Viewer with Streamlit: Upload and display PDF files. Utilizes #Streamlit for UI and interaction, #PyPDF2 for PDF processing. Enhance PDF experience with text extraction. Ideal for user-friendly PDF handling. #Python
This PHP script serves as a handy tool for quickly retrieving essential information about your PHP environment and server settings. When executed, the script displays details such as the PHP version, server software, server name, address, port, and various PHP configuration settings.
This project explores the various functionalities related to PostgreSQL database management using Python and Psycopg2. The objective is to understand how to interact with a PostgreSQL database using Python scripts and Psycopg2 library.
Analyzed a dataset comprising over 1,000 products to reveal consumer preferences and identify e-commerce trends. Employed rigorous data preparation and analysis techniques to delve into the extensive product landscape on Amazon. Developed a recommendation system and performed sentiment analysis using machine learning.
Robust and secure real-time chat application designed to facilitate instant communication between users. Built with Laravel, Vue.js, and Pusher, it leverages modern web technologies to provide a seamless and interactive messaging experience.
Ecommerce Sales Analytics Data Generation, developed a detailed system architecture using Apache Flink, Kafka, Elasticsearch, and Docker. Implemented real-time data streaming, established a robust, scalable data pipeline. Flink was set up, transactions were aggregated in Postgres and Elasticsearch, concluding with a dynamic streaming dashboard.
In this project, I developed a RESTful API using NodeJS and PostgreSQL. The API provides functionalities to perform CRUD operations on student records.
Efficiently managed retail employee data with a SQL-based solution. Streamlined HR processes, performed data analysis, and made informed decisions for optimized retail operations.
Built a strong data pipeline that effortlessly moves CSV data to PostgreSQL, combining the power of Airflow for task orchestration, Docker for containerized deployment, and Pandas for efficient data processing. Achieved seamless integration and reliable data workflows.