riship1095 Goto Github PK

library-data-management-system

Created a library management system using SQL and PL/SQL in an Oracle RDBMS.

library-data-management-system-nosql-mongodb

rasa-chatbot

Developed a interactive chatbot for solving high drop rate issue for a sponsor.

shell

snowflake-data-warehouse

superstore-data-warehouse

Loaded Superstore’s raw data into an S3 bucket. Accessed raw data using a storage integration in Snowflake. Prepared data into a Star Schema using SnowSQL for analytical purposes & visualized it using Tableau.

telecom-churn-rate-prediction

terraform

This repo is for the Terraform Project

tesla_stock_etl

● Extracted Tesla’s stock using yfinance API, simulated it as live streaming data using python, and sent it to Kinesis. ● Using a Lambda function & trigger, transformed the data received through Kinesis to JSON. ● Stored the data into S3 for further data analysis.

travel-package-purchase-prediction

Analyzed the purchase behavior of a Tourism Firm’s customers by analyzing factors to build a predictive model. Performed EDA & tested classification algorithms - Logistics Regression, Decision Tree, & Random Forest Regression achieving an accuracy of 85.91%.

truck-fleet-analysis

Used truck fleet data involving geographic data, vehicles, mileage, gas consumption, events, risk factors, and other information to analyze trucking movement to meet the organizational goal of better understanding risk. Identified risky truck drivers, poor-performing vehicles, unusual events, and accident-prone routes.

twitter_etl

Performed ETL on Elon Musk’s Tweets using Twitter API, Airflow, & Pandas and stored them in an S3 bucket. Created a new IAM role to access the S3 bucket from the EC2 instance hosting the dags & python files.

walmart-stores-sales-analysis

youtube-etl

Transformed YouTube’s raw JSON data to parquet & loaded it in an S3 bucket, used Glue Data Catalog for storing metadata & Athena to query the cleaned data. Developed an ETL process using a Lambda job that would be triggered when raw data is loaded into an S3 bucket, processed, and stored for analytical purposes in an S3 bucket.