Portfolio repository used to showcase my skills, projects, and ideas.
Technical Skills:
Active Directory, Windows & Linux administration, Python (Pandas, NumPy, GUI development, API integration), SQL (PostgreSQL & MySQL), Command Line (PowerShell & Bash), IT hardware setup and troubleshooting, C++, Microsoft Office Suite, Tableau.
Welcome!
This portfolio showcases my journey into IT, systems administration, and technical support. I’m currently pursuing a Master’s in Management Information Systems with a concentration in Cybersecurity at the University of Alabama at Birmingham.
Here, you’ll find projects that reflect my hands-on experience and growth in areas such as:
Linked below are my favorite projects. I include a brief explanation, skills used, and technology used.
Repository Link: cybersecurity-projects
Description: (IN PROGRESS) Hands-on cybersecurity projects including honeypots, honeyfiles, and detection tools.
Skills Used:
Repository Link: PowerShell Scripts Repository
Description: A collection of PowerShell scripts developed to automate key tasks in a Windows Server Active Directory environment. These scripts were designed and tested within my Active Directory lab and cover a range of real-world IT operations such as creating users, renaming users, assigning group memberships, and enforcing consistent naming conventions. Each script includes built-in validation, logic flow control, and integration with existing organizational structures.
Highlighted Scripts:
Skills Used: PowerShell scripting, Active Directory automation, user lifecycle management, scripting logic (loops, error handling), secure credential management, domain organization structure, real-world IT administration practices
Project Link: Fagan Systems
Description: This project simulates the design, deployment, and management of a professional Windows Server Active Directory environment for a fictional IT consulting company called Fagan Systems. It showcases best practices in infrastructure setup, user and group management, access control, and centralized policy enforcement using Group Policy Objects (GPOs). The lab includes a domain controller, Windows 10 clients, a dedicated print server, shared departmental folders with restricted access, mapped network drives, and GPO configurations for desktop environment settings. It reflects the type of structured, scalable IT environment used in real organizations.
Skills Used:
gpresult, RSoP, and system diagnosticsPython Code: calc2.py
kivy Code: calc2.kv
Screenshot of project: Calculator Screenshot
zip file download: Fagan_Calculator_2
Description: This project is a four-function calculator built with Python for functionality and Kivy for an intuitive and visually appealing design. Features include addition, subtraction, multiplication, division, percentage calculations, support for decimals, a clear button, and a backspace button.
To go beyond the project requirements, I utilized Kivy to add custom colors and design elements to enhance the user interface. During development, I learned how to create and manage a virtual environment, set up and use Visual Studio Code effectively, and leverage Neovim’s powerful shortcuts for editing large amounts of code efficiently.
This project earned an A grade, reflecting my commitment to learning new tools and exceeding expectations in practical applications.
Skills Used: kivy, Python, Visual Studio Code, Neovim
Presentation: Capstone Presentation
Presentation Script: Presentation Script
Python Data Preview: Analysis Using Python
Tableau Data Preview: Analysis Using Tableau
Link to Tableau Public Dashboard: Tableau Public - Customer Churn Analysis
Description: Capstone project for Auburn University Bootcamp Professional Certificate. Learned how to analyze data effectively using Excel, SQL, Python and Tableau. The purpose of the capstone is to demonstrate my ability to use Python and Tableau in two different business scenarios and present my findings to the capstone team for feedback and recommendations.
Skills Used: cleaning raw data, assisting a “business” with data-driven decisions, creating data visualizations in Tableau, creating a cohesive presentation
Technology Used: Microsoft Excel, Python, Tableau
Presentation: Video Game Sales Analysis
Excel Assignment: Video Game Sales Excel Assignment
Data Preview: Data
Tableau Dashboard: Tableau Public - Video Game Sales Analysis
Description: The dataset contains video game sales data from 2015-2020. Analyzed data to find information on market share and most popular games by geographical location. Included in this project is the raw data excel file, a presentation I made on the first 8 tasks of the analysis, and the last 5 tasks of the analysis.
Skills Used: clean data, sort data, learning data types, measures of central tendencies, box plots, skewness
Technology Used: Microsoft Excel, Canva, Tableau, Python, Pandas
Presentation: Automobile Sales Analysis
Excel Assignment: Automobile Sales Excel Assignment
Data Preview: Data
Description: The dataset contains car models and variants. I analyzed the data to find what specs affect gas mileage, made predictions on which car model would be the most family-friendly, found the most popular car bodytype, and visualized the manufacturers with the most car variants.
Skills Used: choosing the appropriate chart, using visualizations in Excel, cleaning data, determining what to do with missing/incorrect data, predicting
Technology Used: Microsoft Excel, Canva, Python
SQL Code: Managing Car Sales
PDF with Pictures: Managing Car Sales (with results)
Description: The raw data contained car company sales data. I used this data to create a database, created tables and inserted data into tables, updated tables based on calculations, and created a backup database.
Skills Used: creating and manipulating database objects, SQL constraints, understanding databases and elements in a database
Technology Used: MySQL, Microsoft Excel
SQL Code: Managing Employee Bonuses
Description: Database contains employee data. Used the data to run queries to pull reports with conditions and exported tables to Excel files.
Skills Used: filter data using queries, aggregate functions
Technology Used: MySQL, Microsoft Excel
SQL Code: Hybrid Work Model
Description: Database contains employee data. Used the data to pull reports and join tables together based on primary keys. SQL file includes comments about why I wrote the commands to explain my thought process.
Skills Used: retrieve data using joins, filter data, and export results for reporting, primary and foreign keys
Technology Used: MySQL, Microsoft Excel
Dashboard Link: KPI Dashboard
Data Preview: Data
Skills Used: creating dashboard, advanced formatting, calculated fields, percent change in year, key performance indicator analysis
Technology Used: Tableau Public, Pandas, Python
Dashboard Link: SuperStore Sales Insights
Data Preview: Data
Skills Used: creating dashboard, advanced formatting, calculated fileds, key performance indicator analysis
Technology Used: Tableau Public, Figma, Pandas, Python
Below each project name is a link to my code and a brief description.
Python Code: Assignment_5
Description: Writing a function to convert integers 0-6 into days of the week using indexing with lists. Using the previous function, I wrote another function that calculates n days after a given day of the week and returns the day name. Fifth assignment for my introductory Python course (CIS202) at Southern Union State Community College. Assignment from page 81 in textbook, How to Think Like a Computer Scientist: Learning Python 3 Documentation.
Skills Used: lists, define functions, debugging, delta
Technology Used: Python
Python Code: Assignment_4
Description: Writing a function to return the grade category as a string when given a list of marks. Fourth assignment for my introductory Python course (CIS202) at Southern Union State Community College. Assignment from page 68 in textbook, How to Think Like a Computer Scientist: Learning Python 3 Documentation.
Skills Used: iterating over lists, for loops, if statements with elif, f string, conditions
Technology Used: Python
Python Code: Assignment_3
Description: Writing a function to print a day of the week when given a number from user input. Assuming the days of the week are numbered 0-6, where Sunday is 0 and Saturday is 6. Third assignment for my introductory Python course (CIS202) at Southern Union State Community College. Assignment from page 67 in textbook, How to Think Like a Computer Scientist: Learning Python 3 Documentation.
Skills Used: define functions, user input, type casting, if statements with elif and else
Technology Used: Python
Python Code: Assignment_2
Description: Writing a function in Python to return the area of a circle when given a radius. Second assignment for my introductory Python course (CIS202) at Southern Union State Community College. Assignment from page 52 in textbook, How to Think Like a Computer Scientist: Learning Python 3 Documentation.
Skills Used: type casting, user input, define functions with calculations
Technology Used: Python
Excel File: Employee Practice
Data Preview: Data
Description: Analyzing employee data that includes satisfaction levels based on a survey. I was tasked with finding information about employees using XLOOKUP, analyzing employee satisfaction levels, filtering data on the employees that are working on too many projects at once, and finding the minimum, maximum, and average number of projects that each employee is currently working on.
Skills Used: XLOOKUP, filtering, sorting, pivot tables, COUNTA
Technology Used: Microsoft Excel, Python
Excel File: University Practice
Data Preview: Data
Description: Analyzing historical university placement data from to help a student determine their best option for college based on scholarships given and tuition fees. I was tasked with determining the major that provides graduates with the widest range in salary upon graduation, using measures of central tendency to compare compensation packages given to graduates in different age groups, finding the maximum age that graduates are recruited for employment, and the month in which the highest number of graduates received job offers.
Skills Used: XLOOKUP, filtering, sorting, pivot tables, COUNTA, measures of central tendency, outliers, box and whisker plots
Technology Used: Microsoft Excel, Python
SQL Code: HR Practice
Description: Database contains HR data. I was tasked with analyzing the data for the HR department. SQL file includes comments about why I wrote the commands to explain my thought process.
Skills Used: retrieve data using joins, filter data, and export results for reporting, primary and foreign keys
Technology Used: MySQL, Microsoft Excel
SQL Code: Movie Practice
PDF with Pictures: Movie Practice (with results)
Description: The Sakila database is a sample database provided by MySQL. It models a DVD rental store, which contains tables, such as films, actors, rentals, customers, addresses, payments, etc. The store manager, Eric, wants to organize the DVDs based on customer demand, movie types, actor names, running time of movies, etc.
Skills Used: select, filter, sort and group data
Technology Used: MySQL
SQL Code: Beginner Practice
Description: First challenge from Udemy’s Complete SQL Bootcamp course. Learned PostgreSQL commands and basics of retrieving information.
Skills Used: select, select distinct, order by, between, limit, as, like
Technology Used: PostgreSQL
SQL Code: CASE Practice
Description: From section 10 of Udemy’s Complete SQL Bootcamp course. Discussed the CASE statement and the difference between the general syntax and the expression syntax. Provided both examples in code.
Skills Used: case
Technology Used: PostgreSQL
SQL Code: Example 1
SQL Code: Example 2
Description: Third general challenge from Udemy’s Complete SQL Bootcamp course. Was tasked with creating a simple database from scratch. Learned the basics of adding columns to tables and the importance of data types. Included two files to demonstrate knowledge of creating a database from scratch.
Skills Used: primary keys, foreign keys, create table, insert, update, alter, delete, drop, check constraint
Technology Used: PostgreSQL
SQL Code: Import/Export Practice
Simple CSV File Created: Simple Table
Description: Learned and practiced the basics of uploading a csv file directly to an already existing PostgreSQL table and database. Created a csv file specifically for this demonstration.
Skills Used: import data, export data
Technology Used: PostgreSQL, Google Sheets
SQL Code: NULLIF Practice
Description: Practiced NULLIF functionality by creating a new database and table and deleting particular information to show what happens in a situation where the NULLIF function is needed.
Skills Used: create table, insert into, sum, case, nullif
Technology Used: PostgreSQL
emilygfagan