Allen The Analyst Portfolio

This project involves designing and building ETL (Extract, Transform, Load) pipelines using SQL Server Integration Services (SSIS). The process includes extracting data from various sources, transforming it to meet business requirements, and loading it into target databases. SSIS is used to automate and streamline data integration, ensuring efficient and reliable data processing for reporting and analysis. The focus is on optimizing workflows, handling large datasets, and ensuring data quality throughout the pipeline.

• View Project

The Online Library Management System is a comprehensive project aimed at developing a fully functional library management system using Microsoft SQL Server. This project is designed to help students gain hands-on experience in database design, data manipulation, querying, and access control. It will encompass various phases and tasks that align with DML, DDL, DQL, and DCL operations.

• View Project

In this project, I meticulously clean and organize housing data in SQL Server.

• View Project

Data exploration in SQL Server enables efficient analysis of Covid-19 trends and patterns for better understanding of the pandemic's impact.

• View Project