Projects
A showcase of my technical projects spanning data engineering, cloud migration, database management, and web development.
Data Extraction/Analysis (on Eskom)
Conducted thorough data analysis on Eskom electrification & Twitter data using Python. Developed functions for metrics calculation, date parsing, trends detection, and preprocessing. Demonstrated proficiency in data manipulation and insights extraction.
Complex SQL Queries for Database Management
Transformed denormalized database for an Online Trading Store with the objective to optimize inventory management. Utilized SQL skills to achieve third normal form (3NF) and addressed data anomalies. Successfully delivered a well-structured and organized database.
On-Premise to Cloud Data Migration and Streaming Analytics
Built on premise source connection via AWS Cloud Formation. Created IoT data analytics streaming using Amazon Kinesis. Utilized AWS Lambda, Dynamo DB, EC2 Created IoT data analytics streaming using Amazon Kinesis. Utilized AWS Lambda, Dynamo DB, EC2, and other services for data processing. Ensured secure and efficient solution implementation by following best AWS practices.
Stock Data Cloud Migration with Automated Pipeline (ETL)
Migrated stock market data processing from on premise to AWS cloud using various AWS tools. Automated data ingestion, transformation, and loading. Enhanced stock market analysis with a scalable, secure, and event-driven data pipeline using Airflow. Utilized Docker containers for processing, integrating various AWS tools.
Data Processing Using Apache Spark
Focused on ingesting historical stock market data. Conducted comprehensive data quality analysis. Established an automated process for continuous data quality monitoring using Deequ. Ensured high-quality training datasets for trading robot development.
Intelligent Website Built on AWS Tools using NLP
Created an intelligent dynamic website using AWS services (Lambda, Dynamo DB, Comprehend, SES). Automated responses based on NLP analysis of visitor inquiries. Demonstrated serverless architecture and NLP skills for dynamic user interaction.
Personalized Website
Built a minimal coded robust, secure, scalable, and cost-effective website. Utilized advanced JavaScript and Bootstrap libraries for development. Implemented AWS Amplify for CI/CD automation, enabling hassle-free updates and deployments through Git. Employed a simplified data management approach to handle visitor requests. Facilitated immediate email notifications for efficient response management.
Medical Web App Development
Development of medical web app for patient portal. Incorporating a secure payment system. Implementing a transactional database to manage transactions and user data. Hosting the website on Google Cloud Platform. Leveraging Google's Big Query for business analytics to improve decision-making and business elements. Integrating useful analytics from Big Query to enhance business insights and strategies.
Want to Collaborate on a Project?
I'm always open to discussing new projects, creative ideas, or opportunities to be part of your vision.
Get in Touch